Đang Thực Hiện

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.

Kĩ năng: Excel, Kế toán, Tài chính, Xử lí dữ liệu, Phân tích kinh doanh

Về khách hàng:
( 1 Nhận xét ) Perth, Australia

ID dự án: #33976967

Được trao cho:

(82 Đánh Giá)
6.9

51 freelancer chào giá trung bình$512 cho công việc này

(833 Nhận xét)
8.5
(507 Nhận xét)
8.4
(551 Nhận xét)
8.5
(1140 Nhận xét)
8.4
(151 Nhận xét)
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 Thêm

$250 AUD trong 1 ngày
(331 Nhận xét)
7.4
(302 Nhận xét)
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 Thêm

$250 AUD trong 1 ngày
(220 Nhận xét)
6.8
(253 Nhận xét)
6.9
(127 Nhận xét)
7.1
(137 Nhận xét)
6.9
(183 Nhận xét)
7.0
(43 Nhận xét)
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 Thêm

$750 AUD trong 3 ngày
(11 Nhận xét)
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 Thêm

$700 AUD trong 7 ngày
(48 Nhận xét)
6.6
(89 Nhận xét)
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 Thêm

$500 AUD trong 7 ngày
(24 Nhận xét)
5.9
(71 Nhận xét)
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 Thêm

$250 AUD trong 7 ngày
(32 Nhận xét)
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 Thêm

$250 AUD trong 1 ngày
(67 Nhận xét)
5.7