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,
| +405 | Evercore Intern Seizure | 62 | 6h |
| +113 | UBS IB Americas has failed, now behind Santander and Stiffel | 31 | 44m |
| +79 | JPM M&A is Gone??? Purely Coverage Banking??? | 44 | 2m |
| +60 | How do I understand vs. just memorizing? | 11 | 10h |
| +48 | Losing my personality in Banking | 9 | 2d |
| +45 | The good and bad with Wells Fargo | 14 | 1h |
| +42 | Associate & Above IB exits | 18 | 11h |
| +41 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 23 | 1h |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 8h |
| +33 | Some banks are overrated as fuck | 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.
Consequuntur laboriosam voluptas nihil mollitia consequatur hic praesentium. Provident itaque quidem temporibus corporis voluptatum inventore dolore. Omnis ducimus ut error est. Iure reprehenderit vel occaecati voluptatem dolores quia in est. Vero odio vero quia eos. Mollitia aut ut nemo amet quibusdam qui ullam.
Quisquam accusantium voluptas magnam quidem. Est dolorum sed natus sequi. Amet deserunt quisquam in alias velit. Excepturi modi voluptas nihil dolor. Et temporibus aut perspiciatis.
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...