This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
INVESTMENT ANALYSIS CALCULATOR
Operating assumptions (1)
Cash income from the investment
project for the next five years
Year 1
Year 2
Year 3
Year 4
Year 5
Operating assumptions (2)
Cash expense from the investment
project for the next five years
Year 1
Year 2
Year 3
Year 4
Year 5
Investment assumptions
Initial investment amount
Annual depreciation (5 years)
Income tax rate
Annual tax savings related to depreciation
Annual investment in maintenance capex
Annual investment in working capital
Operating results
Initial investment (year 0) and
expected net cash flows
from the project for the
next five years
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Financial information
Cost of equity
Cost of debt before tax
Proportion of equity in relation to
permanent sources of financing
Proportion of debt in relation to
permanent sources of financing
Weighted average cost of capital
NPV and IRR
NPV
Net present value of the project
IRR
Internal rate of return
https://www.financial-simulation.com