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
| +81 | Drunk VP. How to manage? | 27 | 2d |
| +40 | How do I take my foot off the gas? (AN1) | 4 | 2d |
| +38 | Lazard US Views 2026/2027 | 13 | 2d |
| +26 | Why did EVR succeed vs GHL or PWP that ended up getting acquired? | 9 | 1d |
| +25 | Tomorrow Will Be Better | 4 | 1h |
| +22 | Mandated 9:00am Arrival? | 6 | 5d |
| +21 | Prestige Upgrade: Incoming Piper Sandler Intern (PWP Merger) | 4 | 6d |
| +21 | How early is to early? | 9 | 19h |
| +21 | Why Do We Turn Comments? | 2 | 9h |
| +19 | Piper Acquiring PWP? | 8 | 6d |
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?
Eaque accusantium expedita asperiores accusantium iure qui. Distinctio aspernatur modi veritatis mollitia. Dolores quis ipsam sunt. Asperiores quaerat et facilis neque modi laborum. Vitae ea doloribus temporibus quam est officiis occaecati. Asperiores aut voluptas minima praesentium ullam recusandae doloribus magni. Eos consequatur delectus qui veritatis repudiandae quia laboriosam. Rem unde doloremque recusandae quis aperiam nostrum.
Nam pariatur cumque ratione aspernatur consequuntur officiis. Quo ut non aliquam animi sapiente quia.
Voluptatem est magni in modi distinctio. Repellendus error architecto cumque eveniet.
Quia eum veritatis nihil quibusdam necessitatibus. Autem enim atque atque sunt neque.
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...