Get instant live expert help on I need help with future value calculator with payments
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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