I gang

Improvement of financial forecast model and automation of data input for actuals

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.

Evner: Excel, Regnskab, Finans, Databehandling, Forretnings Analyse

Om klienten:
( 1 bedømmelse ) Perth, Australia

Projekt ID: #33976967

Tildelt til:

(82 bedømmelser)
6.9

51 freelancere byder i gennemsnit $512 timen for dette job

(833 bedømmelser)
8.5
(507 bedømmelser)
8.4
(551 bedømmelser)
8.5
(1140 bedømmelser)
8.4
(151 bedømmelser)
7.7
daniyal3214

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 Flere

$250 AUD på 1 dag
(331 bedømmelser)
7.4
(302 bedømmelser)
7.1
AccountantArman

"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 Flere

$250 AUD på 1 dag
(220 bedømmelser)
6.8
(253 bedømmelser)
6.9
(127 bedømmelser)
7.1
(137 bedømmelser)
6.9
(183 bedømmelser)
7.0
(43 bedømmelser)
6.7
liveexperts123

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 Flere

$750 AUD in 3 dage
(11 bedømmelser)
6.2
zohaab85

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 Flere

$700 AUD in 7 dage
(48 bedømmelser)
6.6
(89 bedømmelser)
6.3
faisalpk77

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 Flere

$500 AUD in 7 dage
(24 bedømmelser)
5.9
(71 bedømmelser)
5.9
moizdzo3l

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 Flere

$250 AUD in 7 dage
(32 bedømmelser)
5.9
kushalparwani27

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 Flere

$250 AUD på 1 dag
(67 bedømmelser)
5.7