maturity

Hi Everyone, I work for a retailer and want to know how many weeks it took each store to reach 80% and 90% of their highest recorded weekly sales. To find the 80% and 90% mark for each store I used the '=percentile' function. My data is laid out like the example below. The grey side is the...

I have a spreadsheet with a list of loans. Sometimes a loan has a late payment. I want to calculate the number of months that a loan interest payment is late if it's not yet reached maturity, or the number of months interest was unpaid if the maturity date has already passed. And, if there's...

I have a spreadsheet with a list of loans. I want to calculate the number of months that a loan interest payment is late if it's not yet reached maturity, or the number of months interest was unpaid if the maturity date has already passed. And, if there's nothing late, then leave the cell...

eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).

Hello community, I have a question and wondered if someone can help me with it. I have Excel file with multiple tabs (with different loans and their maturity dates). I want to set up “pop-up” message in VBA warning me when due date in column “R” (always this column in each tab) is getting...

Hello Forum, I'm stuck and require your help. I'm currently trying to produce a macro which fills cells down by row and then move onto column. As the macro moves onto the next column, the number of rows decreases (It'll look like stairs when complete) The general jist of the spreadsheet is...

Hi all, I need to generate date series in columnar form for many of Bond series from the date of purchase till Maturity date. I do not want to use fill handle as for all bond series i can not use. Following is the required sheet; <tbody> Name Buy Date Maturity Date Year Left Year 1 Year 2...

hi, i want to calculate the weighted average maturity of a list of contracts as at a certain date for multiple dates. In col A, i have the day the contract started, colum b the maturity in years, and column c the amount of the contract. I want to calulcate month end weighted average maturities...

Hi All, Could someone advise what formula can be applied in order to remove the #div/0! value but still perform the underlying calculation? (Bond price @0% yield). The formula works for all values (%) from 1 to 20. (not sure how to add excel file or screen shot) The below list is how my s/s...

Hi All, I have an issue that I am unable to shake off. I require an array to give me the earliest maturity date based on two criteria. Going forward, I also want to be able to get 2nd earlist maturity and 3rd earliest maturity. <tbody> Entity Name Pay or Receive Maturity date APPLE RECEIVE...