ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i create an excel spreadsheet for NPV IRR & MIRR? (https://www.excelbanter.com/excel-discussion-misc-queries/191213-how-do-i-create-excel-spreadsheet-npv-irr-mirr.html)

Frustrated Beginning Accountant

how do i create an excel spreadsheet for NPV IRR & MIRR?
 
How do I create an excel spreadsheet that calculates the NPV, IRR, & MIRR for
a company? Here is an example of the amounts and percentages that may be used:
an initial investment of $4,000,000,
leases a plant for 5 years,
has an additional other expenses of $750,000 for the 5 years,
a 40% tax rate,
a 12% re-investment rate, and a 10% cost of capital, and
additional hurdle rates of 10%, 15%, & 20% (based on MIRR).
I would appreciate it if someone could direct me to a template to where I
can input the numbers.


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com