Seller financing balloon and sale proceeds · Calculation guide

Calculate the balloon owed after scheduled instalments and the seller’s total gross receipts.

Calculation guide

End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.

Principal = price−down; regular instalment amortizes over full term; balloon = outstanding principal immediately after the last regular instalment.

Inputs

Purchase price

Example entry 200000 (in the selected currency). Minimum 0.01.

Cash down payment

Example entry 40000 (in the selected currency).

Nominal annual interest rate

Example entry 5 %. Allowed range 0 to 100.

Original term in months

Example entry 240. Allowed range 1 to 600. Use whole numbers.

Regular payments before balloon

Example entry 60. Allowed range 1 to 600. Use whole numbers.

Worked example

InputValue
Purchase price200,000
Cash down payment40,000
Nominal annual interest rate5%
Original term in months240
Regular payments before balloon60
ResultValue
Balloon due after regular instalment133,527.781085
Regular monthly instalment1,055.929183
Seller gross cash receipts236,883.532049

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Purchase price200,000220,000Balloon due after regular instalment133,527.781085150,218.75372
Cash down payment40,00044,000Balloon due after regular instalment133,527.781085130,189.586558
Nominal annual interest rate5%6%Balloon due after regular instalment133,527.781085135,839.357515
Original term in months240264Balloon due after regular instalment133,527.781085137,300.75685
Regular payments before balloon6066Balloon due after regular instalment133,527.781085130,499.003799
Seller financing balloon and sale proceeds →

Sources