Forum Discussion
Knowing the adjusted Blended Interest rate how do i calculate Debt service.
Hello all! I'm an intern at a financial institution and i'm inquiring to learn how to calculate debt service when i know the newly adjusted blended interest rate. I'm in the process of entering functions into an excel spread sheet and need to know how to calculate this.
2 Replies
There is a host of Financial functions available in Excel. You should use Excel Help to read up on them (or maybe order a basic Excel manual for use at home (I'm assuming you're working from home these days)). You probably need one called PMT, (into which you'd enter things like rate, number of periods, etc.).
Here's a link to an excellent on-line source for further info on not only PMT but other related functions. https://exceljet.net/excel-functions/excel-pmt-function
Come back with further questions after you tried this and other functions out... once you've been working on a sheet and wondering if what you're doing is correct, it always helps to upload a sample of your actual spreadsheet.
mathetes Thank you i will definitely take a look at this!
