doublepax.blogg.se - Amortization schedule with balloon payment and extra payments excel

When introducing extra payments into the interest-only cash flow, theĬalculator's main window shows the amount of the first interest-only payment.

The calculator will always calculate the regular payment amount since it is the interest due.

Or looked at in a different way, the user cannot provide a periodic payment amount.

Therefore, it isn't possible to solve for the balloon payment.

First, the balloon payment will always be equal to the loan amount.

(In that case, set the number of extra payments to "Unknown.") Payments can be for 2 or any number up until the loan is paid-in-full.

You can, therefore, schedule extra payments between the regular due dates if doing so is better for your cash flow.Īs mentioned elsewhere, the calculator allows for a one-time extra payment or for multiple extra payments. First, you'll notice the calculator prompts you for "Extra Payments Start?" date. The calculator's support for extra payment is very flexible. Example 2: Pick the balloon payment amount and calculate the periodic payment: Amount of Loan?:Įxample 3: Pick any periodic payment amount: Amount of Loan?:Įxample 4: Pick your payments and see what you can borrow: Amount of Loan?:īalloon Amortization Schedule with Extra Payments