Skip to main content
/1 min read

3 Statement Financial Modeling: Step 6

Explore the technological landscape with our immersive video content designed to provide a comprehensive understanding of front-end, back-end, and full-stack developments.

Explore this video tutorial on building a 3-statement financial model in Excel, walking through the key inputs, formulas, and assumptions for this step of the analysis.

Video Transcript5 sections

1Full Video Transcript

So we already completed all historical numbers for all three statements: income statement, balance sheet, and cash flow statement. We completed historical and forecasted years for assumptions and supporting schedules, and now we're gonna complete our three statement model by filling up income statement, balance sheet, and cash flow statement for the forecast period.

2Revenue and Cost of Goods Sold

Let's go ahead and start with the income statement first. My revenue in the cell J4 will be equal to the revenue in the previous year multiplied by 1 plus my revenue growth in my assumptions down below in row 62. My COGS is equal to my revenue multiplied by COGS by revenue assumption we have down below as well in row 65.

My gross profit formula is already calculated here, so I'm going to take it from the previous year and check it. It's revenue minus COGS, all perfect. So I can move on to the next line item which is SG&A.