Our complete collection of Investment Calc Excel workbooks.
Includes a 30 page Guide fully explaining all the calculations and equations required for time based value of investing.
Ready to use Excel templates provide Present values and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments. ROIC, EBITDA, after tax NPV & IRR of any irregular or periodic cash flows.
Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years.
Present value of any monthly recurring amount for up to 50 years applying annual rate of increase if required.
Present value of any amount received in the future. Time value of money calculators.
Annual rate of return of investments when price changes are known on a monthly basis.
Annual rate of return of a portfolio with buy/sell transactions on any date. Yield to maturity of bond calculations.