ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Financial Reporting
3
Three Statement Model
4
5
6
How to use this template:
7
8
This is template is designed to help finance professionals establish financial reporting best practices. The template contains formulas to prepopulate value on the Balance Sheet and Cash Flow based on input from other tabs.

To use the model:

1. Replace the chart of accounts in each tab with the chart of accounts for your organization.

2. Update the 'Model Start Date' value within this tab to the month on which you'd like to start the model.

3. Enter or copy the appropriate historical values into the report.

4. Validate that the calculations are working appropriately and utilize the 'checks' built into the report to ensure every account is accounted for appropriately.

5. Happy reporting!

9
10
11
Model Start Date
12/1/2021
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Model Components (aka spreadsheet tabs)
29
30
Income Statement2nd TabUse this tab to report on your Income Statement values.
31
32
33
34
35
36
Balance Sheet3rd TabUse this tab to report on your Balance Sheet values.
37
38
39
Cash Flow Statement4th TabUse this tab to report on your Statement of Cash Flows.
40
41
42
43
44
Model Legend
45
46
Inputs ABC These cells are where you'll input/update data (input roster file and new hire assumptions).
47
48
49
CalculationsABCThese cells are formulas that produce model data, and are used in outputs. Don't modify the formulas in these cells.
50
51
52
Outputs ABC These cells remain black, and are linked to the inputs and sub-calculations. The formulas in these cells should remain unchanged.
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100