Improvement of financial forecast model and automation of data input for actuals
Bütçe $250-750 AUD
I need to upgrade my current Excel consolidated monthly cashflow forecast model (18 month horizon) to include:
a) forecast Profit / loss
b) Forecast balance sheet
c) automated update of prior month forecast with actuals, once month end is finalised
d) Summary reports including Variance Analysis; YTD and updated FY forecasts.
e) design of fit for purpose input sheets which can be distributed to each department and then included in the consolidated plan.
I also need to be able to update assumptions on a monthly basis, for future periods. Currently this is done manually via direct input to feeder excel tabs. I would like to streamline these inputs without impacting past periods.
CURRENT STATUS OF THE MODEL
I have a very manual excel cashflow forecast model for a consolidated group of entities (two entities in the group). On a monthly basis, forecast inf is manually replaced in feeder excel tabs with actual information from our accounting system. This requires two steps:
1. Consolidate the two entities into one dataset from our ERP
2. Input this data into the feeder excel tabs in the forecast model, over-writing the previous forecast with actuals.
Once this is done, I manually amend a summary output sheet to report on the revised Financial Year forecast.
FRUSTRATIONS / areas for improvement
1. The process is very manual, disjointed and subject to human error; it also takes a lot of time
2. There is not currently an easy way to do a variance analysis of monthly / periodic actuals v previous budget on a consolidated basis.
3. The summary reports are very basic and can be improved with visualisation / graphs etc.
Seçilen:
Bu iş için 51 freelancer ortalamada $512 teklif veriyor
Hello, I will be glad to assist you with that. I am an experienced Financial Analyst and Excel expert holding years of experience in Financial Analysis, Financial Modeling and Corporate Finance. Lets discuss your proje Daha Fazla
"Sir, Your project needs skills of both Excel and Accounting and I am expert in both these fields. there is nothing in excel that I cant do and I am an experienced accountant from PWC having degree in Accounting and Fi Daha Fazla
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Daha Fazla
Hello, I am an experienced business writer with an MBA in Business and Finance. I will be glad to assist you with accomplishing your project. I have created business plans, proposals, investors pitch decks, feasibilit Daha Fazla
Hi there, I can help you improve the financial model by incorporating all the listed points including forecasted income statement and balance sheet. Please drop me a message to discuss in details. May i know when do Daha Fazla
Hey there! With the right financial model, you can explore different alternatives, isolating key factors, and running best, base, and worst-case scenarios. But to do so you need someone who knows what they are doing w Daha Fazla
I am a post graduate in Finance with more than one year of experience as a Financial Analyst. My work included: • Writing annual credit review reports for corporate and banks with a focus on competitive industry analys Daha Fazla
