Finance Tools

Amortization Schedule with Balloon Payment

Generate an amortization schedule for a loan with a balloon payment and see the remaining balance due at the balloon date.

Inputs

This schedule is generated up to the balloon date. The remaining balance at that time is your balloon payment.

$
%
years
years
Balloon date: 60 months

Summary

Monthly Payment (Amortized)
$1,663.26
Balloon Payment (Remaining Balance)
$235,328.97
Interest Paid (Before Balloon)
$85,124.35

Amortization Schedule (to Balloon)

Showing first 24 months.

MonthPaymentInterestPrincipalBalance
1$1,663.26$1,458.33$204.92$249,795.08
2$1,663.26$1,457.14$206.12$249,588.96
3$1,663.26$1,455.94$207.32$249,381.64
4$1,663.26$1,454.73$208.53$249,173.11
5$1,663.26$1,453.51$209.75$248,963.36
6$1,663.26$1,452.29$210.97$248,752.39
7$1,663.26$1,451.06$212.2$248,540.19
8$1,663.26$1,449.82$213.44$248,326.75
9$1,663.26$1,448.57$214.68$248,112.07
10$1,663.26$1,447.32$215.94$247,896.13
11$1,663.26$1,446.06$217.2$247,678.94
12$1,663.26$1,444.79$218.46$247,460.48
13$1,663.26$1,443.52$219.74$247,240.74
14$1,663.26$1,442.24$221.02$247,019.72
15$1,663.26$1,440.95$222.31$246,797.41
16$1,663.26$1,439.65$223.6$246,573.81
17$1,663.26$1,438.35$224.91$246,348.9
18$1,663.26$1,437.04$226.22$246,122.68
19$1,663.26$1,435.72$227.54$245,895.14
20$1,663.26$1,434.39$228.87$245,666.27
21$1,663.26$1,433.05$230.2$245,436.07
22$1,663.26$1,431.71$231.55$245,204.52
23$1,663.26$1,430.36$232.9$244,971.62
24$1,663.26$1,429$234.26$244,737.37

How to use this amortization schedule with balloon payment

  1. Enter the loan amount, APR, and amortization term.
  2. Enter when the balloon payment is due (in months or years).
  3. Click Calculate to generate the amortization schedule up to the balloon date.
  4. Review the remaining balance at the balloon date (this is your balloon payment).

Example

For example, a $250,000 loan at 7% APR amortized over 30 years with a balloon due in 5 years will show:

More tools in Finance Tools

← Back to Finance Tools

← Back to ToolPhi Home