Hi guys, hope you can help me out. I am trying to build an emergency fund simulation.
Total monthly expenses value is equal to the value of P28 on "Cash Flow" tab, Cash on Bank is equivalent to F8 on "SALN" tab. Recommended funding multiplies the value of the monthly expenses by 3 and 6 respectively.
Input will be on the monthly allocation for savings each month which is required, while additional savings will be optional while start date is incrementing monthly. Now here's what I want to happen.
If there is a value on M5 it should also reflect on column M12, whatever value entered on M6 should be added to whatever value M3 has and sum should reflecy on the "balance" column. If the value on the balance column is equal to the values of minimum and maximum it the cell where the value is equal to should reflect the same color as the minimum and maximum cell.
Simulation should stop if value is equivalent to the maximum value. For the additional savings, any value entered on it should also add on the balance column
As for the date column, it should increment by 30 days but it should only increment up to where the maximum value stops.
https://www.dropbox.com/s/hojlz68gr99ycze/Financial Worksheet Tool.xlsm?dl=0
Total monthly expenses value is equal to the value of P28 on "Cash Flow" tab, Cash on Bank is equivalent to F8 on "SALN" tab. Recommended funding multiplies the value of the monthly expenses by 3 and 6 respectively.
Input will be on the monthly allocation for savings each month which is required, while additional savings will be optional while start date is incrementing monthly. Now here's what I want to happen.
If there is a value on M5 it should also reflect on column M12, whatever value entered on M6 should be added to whatever value M3 has and sum should reflecy on the "balance" column. If the value on the balance column is equal to the values of minimum and maximum it the cell where the value is equal to should reflect the same color as the minimum and maximum cell.
Simulation should stop if value is equivalent to the maximum value. For the additional savings, any value entered on it should also add on the balance column
As for the date column, it should increment by 30 days but it should only increment up to where the maximum value stops.
https://www.dropbox.com/s/hojlz68gr99ycze/Financial Worksheet Tool.xlsm?dl=0
