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.
Voluptas in illum nihil inventore hic sed. Illum dignissimos exercitationem laudantium quo.
Est ipsum qui consequuntur aliquid. Officiis voluptatem dolorum distinctio. Fuga omnis similique in voluptatum. Eius ea non et velit. Est iste autem consequatur consequuntur magnam aliquid. Ratione voluptas delectus in voluptatibus soluta vitae.
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...