Sales
Startups
Productivity
Presentations
Spreadsheets
Book Summaries
Operations
Management
Human Resources
Project Management
Strategy
Marketing

NPV vs discount rate

NPV vs discount rate serves as an important model in the Capital Budgeting Spreadsheet. This model presents insights into the effects of the discount rate on the Net Present Value (NPV) of an investment. With an illustrative bars chart, it visualizes the capital budgeting process and the cumulative cash flow of an investment. Furthermore, the model also provides a clear understanding of the Internal Rate of Return (IRR) and the adjusted basis. Thus, it is a valuable tool for anyone aiming to evaluate investments and make informed financial decisions efficiently.

Download sheet

Capital Budgeting Spreadsheet

Excel

9 Sheets

Capital Budgeting Spreadsheet

Google Sheets

9 Sheets

To continue, enter your email:

OR
Already have an account? Log in

Preview

NPV vs discount rate Sheet preview

Full preview (9 Sheets)

Cashflow over time Sheet preview
NPV vs discount rate Sheet preview
Break-even point Sheet preview
Present value and breakeven analysis Sheet preview
Real estate analysis Sheet preview
Asset analysis Sheet preview
Net cash flow and payback Sheet preview
IRR analysis Sheet preview
CAPM Sheet preview
Capital Budgeting Spreadsheet Spreadsheet preview

Trusted by top partners