a template for loan imortization with balloon payment

G

Guest

I am trying to set up a spreadsheet to calculate a loan that has a balloon
payment at the end. Is there an excel spreadsheet template that already has
this. I have tried the loan imortization with extra payments but this does
not fit.
 
M

Myrna Larson

I believe you can calculate the payment (PMT function), and/or interest and
principal components payments (IPMT and PPMT), by setting the future value of
the loan not to 0 (as in the usual case) but to the amount of the balloon
payment due at the end.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CUMIPMT 0
Is there a loan amortization schedule with balloon at final pmt? 4
Loan calculator with extra payments 2
loan amortization schedule 6
identifying the next working day after weekends and/or holidays 2
Calculate the annual payment for a $4,000 loan, 3%, 3 years, 2
loan calculator with residual balance 1
need a vehicle loan amortization 6

Top