Knowing the adjusted Blended Interest rate how do i calculate Debt service.

andrew2045 

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.