excel mortgage calculator with extra payment

You want the monthly payment calculated based on a 30-year loan, but you'll pay the balance after 72 months. If you do not know the amount of the regular loan payment, then we must calculate it before we can calculate the final balloon amount.Įxample: Assume you are considering a mortgage for $146,500. See 'Doing the Two-Step' belowĪs mentioned, a balloon loan is a loan that has its regular periodic payment calculated using one term (say 30 years) when the last payment is due sooner (say in 7 years). Or do you want to calculate the periodic payment using say a 30-year term while the balloon is computed using a 7-year term? Yup, you can do that calculation too.Or do you want to lower the periodic payment even further? Then select interest-only payments.Or do you have a budget for both the periodic payment and the balloon payment and you want to know how much you can borrow? This calculator can use your inputs to calculate the loan amount.Or do you need to set the regular payment to an agreed upon, but nontraditional amount before calculating the balloon? This calculator is capable of doing that calculation as well.Want to know what periodic payment will result in a specific final balloon amount? This calculator will calculate the regular payment.This Balloon Loan Calculator will not only calculate the final balloon payment, it will also help you structure a loan to meet your exact needs.Ĭheck out these additional loan scenarios: The final payment is called a balloon payment because of its large size.' Wikipedia defines a balloon loan or mortgage as a loan 'which does not fully amortize over the term of the note, thus leaving a balance due at maturity. Balloon loan - a whimsical name don't you think for a potentially risky financial product?

Excel mortgage calculator with extra payment