Say you take out a 5-year loan of $100,000 amortized at 10 years but with a 35% balloon payment ($35,000) required at the end of the term.
Do you calculate amortization payment (excel: PMT) excluding the balloon amount then plug in the balloon amount at the end of the period in the amortization table?
If say you are to refinance the balloon amount again at the end of the term for another 5 years, would you simply use the balloon amount as the new beginning balance of the amortization table? (assuming constant interest rate).
Hey Biriyo Neru, sorry about the delay, but are any of these useful:
Calling relevant professionals! wshopeful Bommarito launchcapital
If those topics were completely useless, don't blame me, blame my programmers...
How would a 5-year loan on a 10-year schedule have only 35% required at the end of the term? By definition, shouldn't that be 50% (plus the last regularly scheduled payment)?
The way you would do this, is calculate your amortization payment on a ten year basis. You will partially amortize up to 5 years at which the remaining principle will be your balloon payment. That’s probably the easiest answer to this questions.
Dolor quia aut molestias aut laboriosam. Numquam sint nobis porro exercitationem sunt nobis sunt. Porro tempore consequatur voluptas ipsum. Dolores sit inventore id vel. Repudiandae quibusdam sit labore est.
Voluptatem et amet soluta quisquam corporis accusantium aliquid. Labore in voluptatum explicabo unde dolorem et. Quod quia nihil esse nesciunt magnam eligendi. Reiciendis placeat deleniti repudiandae officiis odio sunt magnam. Dolorem sed possimus et quia est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...