В работе

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.

Навыки: Excel, Бухгалтерия, Финансы, Обработка данных, Бизнес-анализ

О клиенте:
( 1 отзыв ) Perth, Australia

ID проекта: #33976967

Поручен:

(82 отзывов(-а))
6.9

51 фрилансеров(-а) готовы выполнить эту работу в среднем за $512

(833 отзывов(-а))
8.5
(507 отзывов(-а))
8.4
(551 отзывов(-а))
8.5
(1140 отзывов(-а))
8.4
(151 отзывов(-а))
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 Больше

$250 AUD за 1 день
(331 отзывов(-а))
7.4
(302 отзывов(-а))
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 Больше

$250 AUD за 1 день
(220 отзывов(-а))
6.8
(253 отзывов(-а))
6.9
(127 отзывов(-а))
7.1
(137 отзывов(-а))
6.9
(183 отзывов(-а))
7.0
(43 отзывов(-а))
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 Больше

$750 AUD за 3 дней(-я)
(11 отзывов(-а))
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 Больше

$700 AUD за 7 дней(-я)
(48 отзывов(-а))
6.6
(89 отзывов(-а))
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 Больше

$500 AUD за 7 дней(-я)
(24 отзывов(-а))
5.9
(71 отзывов(-а))
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 Больше

$250 AUD за 7 дней(-я)
(32 отзывов(-а))
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 Больше

$250 AUD за 1 день
(67 отзывов(-а))
5.7