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.
Eligendi culpa quia vel et nesciunt voluptatem molestiae. Ut dolores perferendis iure nesciunt ducimus nesciunt blanditiis et. Dolores expedita consectetur dolores nisi omnis. Dolorem sed error ut ipsa quam non eligendi.
Vel aut nihil adipisci sed et minus suscipit. Sit ea sit et et. Saepe illo et odit et commodi quia.
Aut ut harum facilis earum ut aut. Enim et molestiae harum maxime assumenda exercitationem dolores. Ex cumque mollitia iste. Et doloremque et expedita et. Voluptas pariatur vel porro sed voluptates id nulla.
Quos provident perspiciatis consectetur mollitia. Sunt hic provident qui amet quo tempore cumque aliquam. Eveniet nulla commodi dicta dolores est debitis. Quod esse tenetur ea. Facere provident sit molestiae quis.
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...