Creating an excel file to track budget Vs actual for next financial year on an excel file.
Have split it into 3 columns per month (budget, actual, difference %).
Want to add flags / triggers to this excel file (macros / conditional formatting / formulas) so that when actuals are updated, if any condition is met and a trigger activated, this prompts an action to be taken either by user or automatically done by macro. (i.e. conditional formatting, pop-up window, or other means to highlight to user to take appropriate action.
1) Need to set clear (revenue, cost, profit) targets on a rolling 1m, 3m, 6m basis with triggers for cost reductions if these targets are missed by x amount.
For example - need a positive cash balance 3 or 6 months out else we need to cut cost by x% with the % defined by the shortfall.
In the event we miss our targets and a trigger is hit, this is where management will then make decisions on where to cut costs.
2) want to do the same for loans, ie forward projections should have a minimum buffer and we scale the loan repayments according to the size of the buffer
3) The bonus plan should also follow the same logic as well as any investments or cost increases.
Can you see if you are able to put something together that achieves the above?
37 freelanceria on tarjonnut keskimäärin $1356 tähän työhön
I will be able to do the job perfectly as I am a data analyst and have prior experience of handling excel documentation, research and content writing.