Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel formula
Does anyone have an excel formula for working out a loan
that has a balloon payment at the end? |
#2
|
|||
|
|||
If you just need the monthly payments, use the PMT function. To deal with
the balloon payment, NPER should be the number of months until the balloon payment, and the FV will be the amount of that payment. For example, if your initial loan is for $350,000, the balloon payment is $300,000 due in five years (60 months) and the interest rate is 6% (.5% per month), the monthly payment is calculated as =PMT(0.5%,60,-350000,300000). "Angie" wrote: Does anyone have an excel formula for working out a loan that has a balloon payment at the end? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |