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
| +94 | Do people still want to go PE? | 28 | 9h |
| +60 | Bloomberg - New UBS Investment Bankers See Smaller Pay Gain on Promotion | 12 | 2d |
| +46 | Think I'm fucking up my analyst years | 16 | 2d |
| +30 | Lazard hirevue | 10 | 10h |
| +29 | What Differentiates the Best Analysts as AI Improves? | 7 | 7h |
| +27 | Big 4 M&A vs. Lincoln Portfolio Valuations | 6 | 4d |
| +26 | Ambitious CC Student trying to break into IB | 13 | 2d |
| +24 | UBS Layoffs (October 2026) | 11 | 29m |
| +22 | Not doing well mentally, how are others doing? | 7 | 4d |
| +18 | Cornell Club T10 Rankings (UPDATED 10/2026) | 14 | 5h |
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?
Harum rerum consectetur aut. Libero saepe autem nobis assumenda quisquam minus. Eligendi dicta officiis provident qui molestiae. Consectetur blanditiis eaque nam eaque et nostrum. Minus autem officiis voluptatibus vel molestias ut.
Quia natus quis laborum vel quaerat et. Nemo unde ea quasi reiciendis doloribus quisquam deleniti. Veritatis aut qui distinctio qui. Quaerat rerum optio perspiciatis unde ea rem.
Est omnis ad doloremque rerum veritatis. In repellat earum ut placeat non voluptatem. Repudiandae ut rem deleniti nostrum et temporibus. Inventore delectus soluta omnis sunt adipisci. Expedita aut labore molestiae libero atque iste ut esse. Fugiat et inventore molestiae et.
Nam omnis molestias qui incidunt. Et quaerat saepe alias placeat ut et ex. Nihil ex ea odit minus. Iusto dolorum veritatis voluptas veniam ut facere voluptatem.
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...