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,
| +190 | Just One More Year | 15 | 4h |
| +172 | Piper Sandler in talks to acquire PWP | 74 | 5d |
| +123 | UBS Appears to be Exploring Sale | 19 | 2d |
| +87 | Paradise Is Paradise | 8 | 1h |
| +77 | Drunk VP. How to manage? | 27 | 21h |
| +38 | How do I take my foot off the gas? (AN1) | 4 | 1d |
| +38 | Lazard US Views 2026/2027 | 13 | 1d |
| +32 | M&A is Paradise | 1 | 5d |
| +25 | Why did EVR succeed vs GHL or PWP that ended up getting acquired? | 7 | 2d |
| +24 | HR is starting to worry me, do I throw a hail mary during an upcoming chat with an MD? | 3 | 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.
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.
Sint blanditiis corrupti recusandae ut autem minus cumque expedita. Nihil ea quasi omnis consequatur quae. Vero vel enim atque quas laudantium eum. Quam sit perspiciatis et. Pariatur omnis laboriosam et sunt delectus. Et quod ut atque quas enim.
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...