Budget Vs Actual spreadsheet with flags/triggers
$240-2000 HKD
Dibayar saat pengiriman
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.
Conditions:
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?
ID Proyek: #29050885
Tentang proyek
35 freelancer rata-rata menawar $1364 untuk pekerjaan ini
Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sa Lebih banyak
Hi Can you accept ms Access app? If so, let discuss about details in private chat. About Price And time also there. Best, Zurab
Hi! I'm very pleased to meet you. I'm Diego Ramirez and I'm CFO of a fintech (Backed by Y Combinator). Y-Combinator is a start up accelerator that have helped grow Dropbox, Airbnb, among others. I am also associate (Ma Lebih banyak
Hi there, I am expert in excel, excel VBA, excel modelling and financial modelling. I have fully read and understood your project requirements and will surely deliver on them in one day. I have previously completed sim Lebih banyak
❤ Hello Mate ❤ Assalamo-o-Alaikum Greetings I have been working here since the last year ,Thanks for posting and sharing your project.I have experience in this work ,let be handle this task to me ,i am willing to sta Lebih banyak
Hoping Sir you are having a grateful day! I have read your project and understand fully the requirements. I am a chartered accountant and have great and vast expe Lebih banyak
This is easy in vba and excel. I have over 10 years of experience in VBa and excel automation. I have worked on many such projects in my last 10 years. we can discuss more over chat. if quality is what you are looking Lebih banyak
All of your requirements can be done.. This task will be done in 4 days.. bidding for more days. As I don't want to fall my commitment at any circumstances.. I can do every possibility in Excel and VBA, Google Shee Lebih banyak
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.
I will be able to help you implement a robust system of budgetary controls whereby your budget vs. actual monthly comparison will provide a realtime recommendation of appropriate action of any adverse variance. I am a Lebih banyak
i am professional qualified financial person to handle this project. i have experience of 6 year with excel and VBA. I create automated report for my clients
Hello, I have good experience in creating dashboards with advanced excel functions please do consider me for the same. Regards
Hello I'm CA Deepanshi. I can make this sheet for you. I make such sheets in my day-to day work. Based on the requirement, I will apply conditional formating or symbols or macros also. I assure you I will deliver you w Lebih banyak
I have great experience in corporate environment with Audit, Finance and Budget experience therefore I am the best person for this job. Hire me!
I have 19 years experience in accounting and finance, having budgiting vs actual, and it's variances also perparing profit and loss account balance sheet etc. Regards
I am a CA /CPA. I had good hand on experience in Budgeting analysis. I can complete your work with great precision and even I can help after completion of job like some consultancy or changes..
Hi, Hope you are doing well !! I am certified ERP financial consultant and i have been doing these kind tasks for last 12 yers. I create such report for my clients. Lets talk to discuss your requirement in detail...
Hi, I have gone through your requirement and attached screen shot of the requirement. I can ful fill your requiremnet within your budget. Let dicuss this opportunity in more detail. Regards Mansoor
Hello! We have seen that you are a new member of the portal and so are we ;) We will be doing your project at a nominal fee to gain experience and confidence from the portal. We understand all the needs the project re Lebih banyak
MY FINANCE AND ACCOUNTS EXPERTISE Finance and accounts are my functional areas of expertise for sixteen years in East Africa, Somalia and South Sudan. With additional projects management around Kenya for fifteen years Lebih banyak
