home *** CD-ROM | disk | FTP | other *** search
-
- Problem Internal ROR calculator. You input 20 yrs of projected cash
- flow data and guess what the IRR is, and it calculates the
- IRR and NPV. Also calculates the discounted ROR which
- corrects a theoretical flaw ? in the IRR calculation.
-
- Block Diagram
- ___________________
- | |
- | Inputs |
- |___________________|
- | |
- | IRR & NPV |
- |___________________|
- | |
- | Instructions |
- |___________________|
-
- Tips
- Future value of inflow at Input Rate" formulas H17-H36
- "PV" calcs G17-G36
-
- F49 - @IRR
- G51 - @DRR
- G53 - @NPV
-
-
-
-
-
-
-
-
-
-
-
-
-