Hi All,
I'm trying to model a debt scenario where the total amount repaid (both principal repayment and interest payments) each year is held constant. Has anyone done something like this before?
I get the general idea (higher interest less principal at first) but am having trouble with the circularity.
Any help would be appreciated.
Best,
| +241 | UBS Layoffs (October 2026) | 70 | 5h |
| +110 | Do people still want to go PE? | 34 | 8h |
| +70 | UBS Tech layoff | 20 | 3h |
| +62 | Bloomberg - New UBS Investment Bankers See Smaller Pay Gain on Promotion | 15 | 19h |
| +46 | Think I'm fucking up my analyst years | 16 | 4d |
| +36 | What Differentiates the Best Analysts as AI Improves? | 9 | 18h |
| +33 | Lazard hirevue | 11 | 20h |
| +26 | Ambitious CC Student trying to break into IB | 14 | 6d |
| +22 | Cornell Club T10 Rankings (UPDATED 10/2026) | 15 | 1h |
| +22 | Quitting After First 4 months | 10 | 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.
sounds similar to a mortgage. I'd attach an excel spreadsheet but i don't see where I can do that.
Use the PMT, PPMT, and IPMT functions in excel.
You only need PMT.
I threw together an amortizing loan model. It's a little sloppy, but it is functional.
https://docs.google.com/open?id=0BzPPefljaFpvaGVJNjFCSTRSWWc
You should be able to download it from there.
Consequatur delectus alias earum enim consequatur. Consequuntur suscipit sed placeat sit iusto molestiae dolorum. Maiores reiciendis eius quisquam quam ducimus dolores velit sit. Autem ea quam dolorum ipsam maiores veritatis. Rerum omnis qui distinctio aut ipsam earum nihil.
Dolorum hic esse rerum vel numquam saepe nulla. Nulla perferendis a quam sed nobis sed qui. Et blanditiis aliquid laborum.
Maiores aliquam molestiae iste ab. Voluptates quo nihil inventore quo. Quod expedita ab ea ut at impedit debitis omnis.
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...