Dear All,
I am facing issue I cannot overcome, would appreciate help on the below. Also, please see attached file, I hope it reinforces the description below.
1)I am after a formula that will allow to 'drop' into the equity row (row no 7) the expenditure amounts up to total equity of 41 300 (as per example) and thereafter show zero. Between month 1 -8 total is 58 800; I do not know how to get some clever formula to show only required balance to get to 41 300 in Equity row.
2) For the loan I am after formula that starts dropping to loan row amounts only when equity amount is reached.
I would very much appreciate help on this. Thank you!
Equity Total: 41 300
Month1 Month2 Month3 Month4 Month5 Month6 Month7 Month8 Month9 Month10 Month11 Total
Expenditure 2 100 2 100 2 100 7 100 2 100 9 100 12 100 22 100 2 100 2 100 2 100 65 100
Equity
Loan
Kind regards
Bookmarks