Need "reverse" amortization; calculate loan amount
I have fixed interest rate and monthly payment. How do I calculate loan
amount? |
Look at Help on PV function
"MLSanders" wrote in message ... I have fixed interest rate and monthly payment. How do I calculate loan amount? |
You also need the number of payments.
Look in HELP for the PV() function -- Kind regards, Niek Otten Microsoft MVP - Excel "MLSanders" wrote in message ... I have fixed interest rate and monthly payment. How do I calculate loan amount? |
All times are GMT +1. The time now is 09:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com