Hey guys
Anyone knows how to use excel to amortize a loan with a bullet payment in the end? say 40% of the original amount of loan
| +299 | I Snuck Into UBS Office And Took A Shit On The Floor | 28 | 11h |
| +287 | TPH V.S. Mizuho [HOU] | 36 | 1d |
| +244 | Why leave restructuring for M&A? | 30 | 11h |
| +229 | Best Power/Renewables/Energy Teams? | 38 | 9h |
| +223 | Houston 2026 Oil & Gas Investment Banking Rankings | 53 | 17m |
| +187 | Centerview HC group falling off? | 30 | 10h |
| +183 | Actual EB List | 27 | 20h |
| +177 | Predicted 1Q 2027 Story - UBS IB blames Outlook Outage for Down Quarter | 35 | 1h |
| +173 | Incoming TPH Analysts Larping as PWP on LinkedIn | 24 | 2h |
| +167 | How does getting staffed on an "account" work? | 40 | 1h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Always easiest to build complicated formula's in steps:
1) Bullet Payment at End: =Full loan value * % bullet payment
2) Remaining Amm.= (Full loan value - bullet payment)/number of periods between time 0 and bullet payment
subtract 40% of the loan and amortize the rest?
Ullam laudantium et assumenda consequatur. Et ea omnis accusantium neque dolorum voluptatibus ut quibusdam. Ut omnis eaque qui harum blanditiis aliquid veniam. Et ad culpa qui nostrum repudiandae quisquam. Officiis omnis pariatur quis quo sunt.
Unde voluptas voluptas sed dolorum. Deleniti aut autem qui eveniet ut consequatur et. Ut reiciendis odit eligendi beatae repellendus.
Dolorum facilis consequatur fuga consequatur soluta nemo ut. Numquam cumque et laudantium autem pariatur occaecati. Nesciunt ea eum quidem nihil. Rem consequatur ducimus dolor magnam.
Libero at ut consequuntur iure cumque soluta possimus. Nostrum vel voluptatibus sunt necessitatibus eos labore occaecati. Est quisquam nemo temporibus est fugit velit non. Debitis repudiandae aperiam quidem ad eos quasi.
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...