Most mortgage lenders don't offer balloon mortgages. They're best for borrowers with unusual credit and financial circumstances.
If there is a "balloon payment" (final balance), enter it into B4 as a positive value, and use the formula =PMT(B2, B3, -B1, B4). Those formulas also assume that payments are at the end of the period (i.e. end of month). That is typical. However, for car leases and such, the payment is at the beginning of the period.
The formula to be used will be =IPMT( 5%/12, 1, 60, 50000). In the example above: As the payments are made monthly, it was necessary to convert the annual interest rate of 5% into a monthly rate (=5%/12), and the number of periods from years to months (=512).
Pull out the modification agreement. When they modified, they should have gotten docs containing the terms. Usually, when the mortgage is modified, they do away with the balloon.
Balloon mortgages are short-term loans that begin with a series of fixed payments and end with a final, lump-sum payment. That one-time payment is called a balloon payment because it's often at least twice as much as the previous ones, leaving many borrowers with a final bill for tens of thousands of dollars (or more).
Potential Downsides of Balloon Mortgages for Homebuyers Foreclosure can result in the loss of the home, emotional distress, and impact the borrower's credit negatively, generally for seven years. The first balloon mortgage payments primarily cover the interest rather than the principal.
The downside of balloon payments Although a balloon-payment option can make your monthly payments more affordable, you're taking on extra debt to buy an asset that is depreciating – the value of your vehicle may end up less than the amount still owed.
The traditional mortgage is only for stationary property. It's suited for long-term real estate investments. Chattel loans are for property that can be easily moved. They're also an option for borrowers who want their loans approved faster and with shorter repayment times.
In some states and under certain circumstances, the owners of manufactured homes can refinance their chattel loans into conventional manufactured home loans even if they don't own the lot underneath their homes.