“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How do you calculate the present value of future payments that do no start for 3 years?

Solved by I. S. in 29 mins

I am creating a Fixed Rate Mortgage calculator, and I'm calculating the terminal value for a prepayment value. The terminal value needs to show up the cell after the final period, but that is contingent upon the value i put in for # of payments. Is there a way that I can make the references in that formula change in unison with the the value of # of payments?

Solved by M. B. in 22 mins

I require Column H to start payments from a loan calculator built into spreadsheet, after Column G is completed payments from a separate loan calculator based on the payback period set, and for Column H to end after the payback period endsas set in the loan calculator. I have a file but it won't load.

Solved by T. L. in 20 mins

In a labeled blank Excel cell, calculate the future value of 30 monthly payments of $200 each if the monthly interest rate is 0.2%. Use the FV() function in Excel.

Solved by X. J. in 20 mins

Internal Rate of Return (IRR) Calculator I need a calculator to determine an Internal Rate of Return (IRR). calculates the IRR on an annual basis of an irregular stream of 15 payments.

Solved by M. E. in 25 mins