Scribd
Upload
29 views13 pages

8-Step Financial Modeling Guide

The document outlines a comprehensive 8-step guide for financial modeling, detailing the processes of mapping accounts, inputting raw data, creating budget schedules, and consolidating actuals. It emphasizes the importance of linking budget forecasts to detailed schedules and maintaining a structured 3-statement model. Additionally, it highlights the need for a dedicated admin section to track errors and ensure accuracy in the financial model.

Uploaded by

Kwevi Lelo Freddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views13 pages

8-Step Financial Modeling Guide

The document outlines a comprehensive 8-step guide for financial modeling, detailing the processes of mapping accounts, inputting raw data, creating budget schedules, and consolidating actuals. It emphasizes the importance of linking budget forecasts to detailed schedules and maintaining a structured 3-statement model. Additionally, it highlights the need for a dedicated admin section to track errors and ensure accuracy in the financial model.

Uploaded by

Kwevi Lelo Freddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Guide: A Comprehensive

Financial Modeling Layout


in 8 Steps

© Chris Reilly
Mapping
• List of all the chart of
accounts

• Add an adjacent column


to group into buckets

• Example, I might classify


Salary, Bonus, Payroll
Taxes, and Benefits into
"Labor"
© Chris Reilly
Raw Data
• Copy/paste monthly P&L
and Balance Sheet data
from system directly into
model, often exported as
a CSV

• A more sophisticated
approach is to use
PowerQuery

© Chris Reilly
Budget Schedules
• Separate tabs/schedules
where detail is needed to
build a forecast

• Example: Revenue,
Headcount, Capital
Projects, Known Contracts

• Eventually link to 3-
Statement Model
© Chris Reilly
Actuals
• Consolidation of Raw Data
into time series format

• Often grouped into


buckets from the Mapping
tab

© Chris Reilly
Budget
• Duplicate of Actuals tab
with forecast functionality

• Forecast either:
• links to Budget Schedules
(built earlier)

• Has growth assumption


next to line (YoY Growth,
% of Revenue, etc.)

© Chris Reilly
Budget (example)

Capex example: too much


detail for one line, so it gets its
own tab.
© Chris Reilly
Financial Model
• 3-Statement Model where
it all comes together

• Same layout as Budget &


Actuals tab

• Model pulls Actuals if


available, else, pulls
Budget

• Balance Sheet and SCF


update automatically
© Chris Reilly
Summaries
• Pulling 3-Statement info
into print-friendly view(s)

• Build model first,


summaries last (everyone
has their preferences)

• Pro tip: don’t print where


you model or model
where you print (keep
them separate)
© Chris Reilly
Summaries (example)

Pulls all the high points so


someone can easily print.
© Chris Reilly
Admin
• Last section but most
important

• Consolidates all possible


errors in one place

• Holds “Latest_Actuals”
cell mentioned earlier

© Chris Reilly
Admin (example)

Consolidate all errors in one


place to easily audit/trace.
© Chris Reilly
Thank You.
© Chris Reilly

You might also like