| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
car loans
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
car loans
=PMT(10.49%/12,36,22000,14500) and
=IPMT(10.49%/12,36,36,22000,14500) -- Kind regards, Niek Otten "Monty" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
