| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Effective interest paid - need formula/function
I would like to calculate the effective interest paid on a lease. If the
asset value is $55k, and the lease payments are $2,519 for 2 years with a residual asset value of $1 at the end of the lease, what is the effective interest rate? Note that the first payment is double ($5,038), with 22 monthly payments thereafter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Effective Annual Interest Rate | Excel Worksheet Functions | |||
| How do I calc interest when using multiple dates within a given ye | Excel Worksheet Functions | |||
| Function help with Calculating Interest for two different investme | Excel Worksheet Functions | |||
| How do I calculate APR for interest-only loans | Excel Worksheet Functions | |||
| Effective rate of Interest and Copounding Interest | Excel Worksheet Functions | |||
Threaded Mode
