Thanks for your valuable Input
Thanks for the reply Riny. The early settlement amount should be calculated only if we repay no later than the 22nd day of the month. If paid ...
Thanks for all your input I have amended my spreadsheet showing the rebate, the int saving by paying early, the int earned if invested ...
If I invested the funds , the int would be for the entire month eg 100,000*(6%/12) = 500
I am trying to determine whether it is better to pay early and take the early settlement discount or rather invest the funds
From an investment point of view, I think that one would have to compute the int to the last working day to see what Int one could have earned in orde...
Thanks Riny. Thanks for the updated formula Please check my formula for my second requirement where I need to compute the int earned if those ...
Hi Riny This is perfect Mny thanks for the help
Hi Mynda Thanks for all your effort in amending my cash flow This is brilliant and is of great help Regards Howard
Hi Mynda thanks for the reply. the Closing Balance should be Opening Balance + Deposits - O/s Cheques - (to) frm Savings Regards ...
Hi Mynda Sorry for not being clear in post # 1 I have a buffer in Cell E1 as well as an increased buffer in Cell F1 I have a f...