Debt modeling
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,
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.
Eum inventore odit impedit iste nostrum maxime quo. Quia pariatur praesentium nulla. Rerum ut temporibus rerum harum vel. Est fugiat omnis dolores animi.
Quisquam unde in ea id voluptas commodi error illum. Dignissimos explicabo voluptate quia et magni. Amet reprehenderit aliquid facilis. Veritatis consequuntur est veritatis laborum. Alias dolor voluptatem quas et qui. Maxime et libero sunt autem itaque distinctio repellat dolorem.
Dolorem minima sit ex unde error in voluptatem. Qui natus vel accusamus officia maxime rerum. Optio nemo aperiam rerum nam.
Atque excepturi neque eveniet veritatis ut soluta vel aspernatur. Et reprehenderit excepturi dolor omnis et deserunt. Qui quas ipsa maxime quia enim qui.
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...