Sep07

Tagged in:, Comments: YourThoughts?

Real NPV Calculator With Interest Inflation Rates Built In

This Excel download is a spreadsheet that is a real NPV calculator with interest rate and inflation rates built into it's functionality.

Do you have places you put your assets that you hope will return a profit? Is that investment really going to pay you back? Will your project, business and the like return positive value over time.

I mean, in tomorrow's dollars, will you actually have, or possess the buying, trading value that you now command? Or, will whatever you are considering set you back? Will it cost you to move forward?

If that investment pays ten percent per year, but inflation is stealing some of that gain, will you still have an increase, or is it time to move to your next option?

That's what this Excel NPV (Net Present Value) calculator is for. Over a given period of time, will a venture return a profit considering expense, receipts (returns) and inflation into account? If it does, go for it!

The issue is the calculation.

\mathrm{NPV}(i, N) = \sum_{t=1}^{N} \frac{R_t}{(1+i)^{t}}

Ouch! (And thank you Wikipedia for the equation). That's why we have Excel.

The NPV Calculator comes with three worksheets. The "Real Rate Of Interest Calculator", the "Inflation Calculator" and the, of course, NPV calculator.

Here is a screenshot of "Real Rate Of Interest Calculator"...

 

npvcalculatorpic

 

 

Here is a screenshot of "Inflation Calculator"...

 

npvcalculatorpic

 

 

Here is a screenshot of "Real Rate Of Interest Calculator"...

 

npvcalculatorpic

 

Here's the download link for the NPV Calculator.

 

Thank you to EXINFM  for the template.

Share

No comments

This article has no comments. Be the first and add your own comment!

Leave a comment

(required)

(required)

 me

Help

Some things to think about...

  • Please keep comments related to topic. Please be nice. Please don't spam!
  • Basic HTML tags are allowed:
    <a href> <abbr> <acronym> <blockquote> <code> <em> <strike> <strong>
  • Add your comment and click "Preview". If you're satisfied, click "Submit"
  • Just A Note: un-related or spam comments will be deleted.
  • Thanks!

Close

Back To Top

Download What?

Download Microsoft Excel of course! And all the stuff you need like worksheets and templates. How about discussion on formulas and cell tagging? Tutorials and lists of "how-to" for everything Excel. Oh yeah, there are Excel downloads too.

About