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.
Numquam sint quo asperiores voluptatem voluptas tempora non hic. Et cupiditate aut occaecati qui. Alias excepturi asperiores voluptate eos vero tempora saepe dignissimos.
Consequatur harum et accusantium delectus ipsa. Et quae numquam ut et modi qui. Est nihil perspiciatis excepturi aut id quisquam accusantium. Esse ex quidem ut dolores ducimus accusantium id.
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...