Balloon mortgage payments

  • Thread starter Thread starter Peter Beyer
  • Start date Start date
P

Peter Beyer

We have a 10 year baloon mortgage. Is there a way to
create an amortization schedule in excel with a final
baloon payment?
 
Peter

The easiest way is to break the loan into two parts. The portion that gets
paid off and the balloon amount.

The monthly payment is calculated using the PMT function with the amortized
portion of the loan as the principle PLUS the interest on the Balloon
payment. Assuming your balloon payment is 40,000 and the total loan is
100,000, your stated annual interest rate is 6% and the term is 10 years

=PMT(0.06/12,10*12,60000)+(40000*.06/12)

Then use the following formulae to calculate the amortization

Remaining Balance = 100000 for the first period and the Prior Period
Remaining Balance less Principle paid for the remaining periods

Interest = Remaining Balance * Annual Interest Rate/12
Principle = Payment - Interest

HTH

PC
 

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

Calculate Loan Term 1
Current Mortgage Balance 6
Function to establish mortgage bond size. 2
Vehicle finance spreadsheets 1
APR calculation for Mortgages with a balloon payment. 6
amortization of a mortgage 1
mortgage payment calculation 12
Amortization Calculation in Excel worksheet 4

Back
Top