Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
if i know the loan amount say 22,000, the APR 10.49%, the loan is for 36
months, but on month 36 i have a balloon amount of 14,500 left to pay. how do i calculate the monthly payment and the amount of interest i have paid over the period before the balloon amount is to be paid |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Revolving Loans | Excel Discussion (Misc queries) | |||
Loans aren't always an even number of years | Excel Discussion (Misc queries) | |||
Can Excel calculate the effect of extra principal on loans? | Excel Worksheet Functions | |||
Interest Only Loans & Payments | Excel Discussion (Misc queries) | |||
How do I calculate APR for interest-only loans | Excel Worksheet Functions |