Đ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.


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á)

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

(833 Nhận xét)
(507 Nhận xét)
(551 Nhận xét)
(1140 Nhận xét)
(151 Nhận xét)

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)
(302 Nhận xét)

"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)
(253 Nhận xét)
(127 Nhận xét)
(137 Nhận xét)
(183 Nhận xét)
(43 Nhận xét)

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)

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)
(89 Nhận xét)

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)
(71 Nhận xét)

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)

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)