| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to calc. semi-annual int. only pmt. with balloon in 10 yr
Does anyone know the formula to calculate semi-annual interst only payments
with a balloon in 10 years? I thought it was IPMT, but it does not appear correct. I thought the interest payment would remain the same for each semi-annual payment until the principal balloon payment is made in year ten. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Monthly Mortgage payments for a Semi annual compounding rate | Excel Worksheet Functions | |||
| Seeking excel formula that calculates lease and balloon payments | Excel Discussion (Misc queries) | |||
| Semi Annual Counter | Excel Worksheet Functions | |||
| IRR calc Monthly vs Annual | Excel Worksheet Functions | |||
| How do you calc half day annual leave on a xls spread sheet using. | Excel Worksheet Functions | |||
Threaded Mode
