Calculate the total interest from the first blank to the last blank in the 'Interest Expense' column

AtzdGr8
AtzdGr8
in Modeling

I have a sample where there are loan dates. For each loan date, the nominal interest will be calculated from the first non-blank 'Date of Loan' entry to the last non-blank 'Date of Loan.' The total interest will then be inserted in every non-blank 'Interest Expense' line item.

{E597670E-D982-4D69-9861-6BDBFF933AAB}.png

Tagged:

Best Answer

  • Dikshant
    Dikshant
    Answer ✓

    @AtzdGr8

    I tried to break down the solution, but it's not fully complete yet. Let me share my approach so far.

    image.png

    I set up the same structure as yours and used the MOVINGSUM function for the interest nominal logic. Additionally, I created two more line items: FNB Dol and LNB Dol. While the values for these line items are coming out correctly, I still need to figure out the logic behind them, as currently I kept it manual.

    I'll try to think of the logic and share any insights I come up with!

Answers

Categories