Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Life of Lease Payment calcuation
I saw someone posted this before but the person who answered it didn't
go into real detail of the numbers they chose for the answer. I have a lease the payment is $10,000 a year, there is a 5% increases every 5 years and the Lease lasts for 30 years. What would be the formula in Excel that would show what the full amount of lease payments that would have been made at the end of 30 years?? Also I want to be able to change the 5 years for every increase to any number of years from 1-10 years. Does anyone know a formula in excel that would do this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Life of Lease Payment calcuation
This kind of problem can be solved with a financial function (FV in this case).
However, to do any kind of financial calculation, the payment and the interest rate must be for the same period. In your case, the trick is to understand that your period is 5 years. (It might be easier to understand that "$50,000 per year for 6 years increasing at 5% per year" is the same problem). Answer: =fv(5%,6,50000) or $340,095.64 To generalize for any multi-year period: =fv(5%,30/n,10000*n) -- Regards, Fred wrote in message ups.com... I saw someone posted this before but the person who answered it didn't go into real detail of the numbers they chose for the answer. I have a lease the payment is $10,000 a year, there is a 5% increases every 5 years and the Lease lasts for 30 years. What would be the formula in Excel that would show what the full amount of lease payments that would have been made at the end of 30 years?? Also I want to be able to change the 5 years for every increase to any number of years from 1-10 years. Does anyone know a formula in excel that would do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If And Calcuation | Excel Worksheet Functions | |||
Starting payment when increase rate is known & total payment is kn | Excel Worksheet Functions | |||
IRR&NPV Financial lease | Excel Discussion (Misc queries) | |||
calculate payment with first payment due date variable? | Excel Worksheet Functions | |||
how do you get a positive number payment with a mortgage payment . | Excel Worksheet Functions |