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
| +249 | Why UBS Is the Worst Place to Start Your IB Career | 37 | 1h |
| +196 | UBS 2nd Year Analyst Q&A (2026) | 36 | 2h |
| +68 | Firm Thinks I'm Lying About Offer | 20 | 1d |
| +60 | Indiana University Fraternity Pipelines | 36 | 13h |
| +50 | Rogo AI | 20 | 1d |
| +50 | Elite Boutique interview questions | 15 | 40m |
| +45 | Suspended for a Year | 19 | 22h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 2d |
| +25 | What's your craziest "hardo" story? | 3 | 1d |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 1d |
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?
Quia natus odit tenetur laudantium sapiente. Libero ratione aut incidunt. Quisquam iure provident debitis tempora vel. Quaerat natus voluptate similique ut necessitatibus ut non. Reprehenderit enim eveniet ut consectetur consequuntur quos. Ad qui laborum nulla voluptate voluptatibus.
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...