| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel calculate a loan payment with a balloon at the end?
Im trying to use excel to calculate a loan payment under the flowing
parameters; some number of equal consecutive monthly payments followed by a residual or balloon due at the end of the term. Will excel do this and if so how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can excel calculate a loan payment with a balloon at the end?
Yes it will. Use the PMT function, as in:
=pmt(intrate/12,years*12,loan,-balloon) -- Regards, Fred "Darren @ Vermeer" <Darren @ wrote in message ... I'm trying to use excel to calculate a loan payment under the flowing parameters; some number of equal consecutive monthly payments followed by a residual or "balloon" due at the end of the term. Will excel do this and if so how? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can excel calculate a loan payment with a balloon at the end?
"Fred Smith" wrote: Yes it will. Use the PMT function, as in: =pmt(intrate/12,years*12,loan,-balloon) -- Regards, Fred "Darren @ Vermeer" <Darren @ wrote in message ... I'm trying to use excel to calculate a loan payment under the flowing parameters; some number of equal consecutive monthly payments followed by a residual or "balloon" due at the end of the term. Will excel do this and if so how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
| need a function to calculate a mortgage payment | Excel Worksheet Functions | |||
| need a function to calculate a mortgage payment | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Hybrid Mode
