Käynnissä

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.

Taidot: Excel, Kirjanpito, Rahoitus, Tietojenkäsittely, Liiketoiminta-analyysi

Tietoa asiakkaasta:
( 1 arvostelu ) Perth, Australia

Projektin tunnus: #33976967

Myönnetty käyttäjälle:

(82 Arvostelua)
6.9

51 freelanceria on tarjonnut keskimäärin $512 tähän työhön

(833 arvostelua)
8.5
(507 arvostelua)
8.4
(551 arvostelua)
8.5
(1140 arvostelua)
8.4
(151 arvostelua)
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 Lisää

$250 AUD 1 päivässä
(331 arvostelua)
7.4
(302 arvostelua)
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 Lisää

$250 AUD 1 päivässä
(220 arvostelua)
6.8
(253 arvostelua)
6.9
(127 arvostelua)
7.1
(137 arvostelua)
6.9
(183 arvostelua)
7.0
(43 arvostelua)
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 Lisää

$750 AUD 3 päivässä
(11 arvostelua)
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 Lisää

$700 AUD 7 päivässä
(48 arvostelua)
6.6
(89 arvostelua)
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 Lisää

$500 AUD 7 päivässä
(24 arvostelua)
5.9
(71 arvostelua)
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 Lisää

$250 AUD 7 päivässä
(32 arvostelua)
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 Lisää

$250 AUD 1 päivässä
(67 arvostelua)
5.7