a template for loan imortization with balloon payment

S

stevep

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

Is there a loan amortization schedule with balloon at final pmt? 4
FV Function (Excel) 3
loan amortization schedule 6
Calculate the annual payment for a $4,000 loan, 3%, 3 years, 2
Loan calculator with extra payments 2
Looking for Compounding Interest Loan Template 1
identifying the next working day after weekends and/or holidays 2
Calculating interest due on late loan payments 1

Top