Skip to content
SheetRank
Deal FlowAcademyInterview PrepFor ProfessorsResourcesPricingSign InCreate account
Deal FlowAcademyInterview PrepFor ProfessorsResourcesPricing
Sign InCreate account

Building the Three Statements: Blank-Sheet Capstone

Rebuild the same income statement, balance sheet, and cash flow statement across the same three years, with no line labels. Assumptions and every roll-forward's Year-0 base are given; column A is empty from the first calculation row down. Name every line, link it to its drivers, drag the formula across Year 2 and Year 3, and finish on the balance check, using the same answer key as the guided build but none of the scaffolding.

CF · Advanced · about 65 minutes · 34 guided steps

Lesson outline

Income Statement

  1. Step 1: Revenue
  2. Step 2: Cost of Goods Sold (COGS)
  3. Step 3: Gross Profit
  4. Step 4: SG&A
  5. Step 5: EBIT (Operating Income)
  6. Step 6: Interest Expense
  7. Step 7: Pre-Tax Income (EBT)
  8. Step 8: Taxes
  9. Step 9: Net Income

Balance Sheet: New Balances

  1. Step 10: Depreciation & Amortization
  2. Step 11: CapEx
  3. Step 12: Accounts Receivable
  4. Step 13: Inventory
  5. Step 14: PP&E, net
  6. Step 15: Accounts Payable
  7. Step 16: Debt
  8. Step 17: Common Stock
  9. Step 18: Retained Earnings

Cash Flow Statement

  1. Step 19: Cash Flow: Net Income
  2. Step 20: + Depreciation & Amortization
  3. Step 21: (Increase) in Accounts Receivable
  4. Step 22: (Increase) in Inventory
  5. Step 23: Increase in Accounts Payable
  6. Step 24: Cash Flow from Operations
  7. Step 25: Cash Flow from Investing
  8. Step 26: Cash Flow from Financing
  9. Step 27: Net Change in Cash
  10. Step 28: Ending Cash

Completing the Balance Sheet

  1. Step 29: Cash
  2. Step 30: Total Assets
  3. Step 31: Total Liabilities
  4. Step 32: Total Equity
  5. Step 33: Total Liabilities & Equity

Balance Check

  1. Step 34: Balance Check