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

3-Statement Model: Blank-Sheet Capstone

Rebuild the linked three-statement model with no line labels. Assumptions, Year-0 balances and year headers are given; column A is empty and the statements aren't laid out for you. Name every line, link it to its drivers, and finish on the balance check, using the same answer key as the guided build but none of the scaffolding.

IB · Advanced · about 100 minutes · 46 guided steps

Lesson outline

Income Statement

  1. Step 1: Customers
  2. Step 2: ARPU
  3. Step 3: Revenue
  4. Step 4: Gross Margin %
  5. Step 5: Gross Profit
  6. Step 6: SG&A
  7. Step 7: EBITDA
  8. Step 8: D&A
  9. Step 9: EBIT
  10. Step 10: Term Debt Interest Expense
  11. Step 11: Revolver Interest Expense
  12. Step 12: Cash Interest Income
  13. Step 13: Net Interest Expense
  14. Step 14: Pre-Tax Income
  15. Step 15: Taxes
  16. Step 16: Net Income

Cash Flow Statement

  1. Step 17: Cash Flow: Net Income
  2. Step 18: Add Back D&A
  3. Step 19: CapEx
  4. Step 20: Change in NWC
  5. Step 21: Free Cash Flow

Balance Sheet

  1. Step 22: Cash
  2. Step 23: Net Working Capital
  3. Step 24: PP&E
  4. Step 25: Total Assets
  5. Step 26: Term Debt
  6. Step 27: Revolver Opening Balance
  7. Step 28: Revolver Draw / (Paydown)
  8. Step 29: Revolver Ending Balance
  9. Step 30: Equity
  10. Step 31: Total Liabilities + Equity

Working Capital Build-Up (AR / Inventory / AP)

  1. Step 32: Accounts Receivable
  2. Step 33: Inventory
  3. Step 34: Accounts Payable
  4. Step 35: NWC from Build-Up
  5. Step 36: Working Capital Tie-Out

Interest Circularity (Average Balance) — memo

  1. Step 37: Average Term Debt Balance
  2. Step 38: Average Revolver Balance
  3. Step 39: Average Cash Balance
  4. Step 40: Term Debt Interest (Average Balance)
  5. Step 41: Revolver Interest (Average Balance)
  6. Step 42: Cash Interest Income (Average Balance)
  7. Step 43: Net Interest Expense (Average Balance)
  8. Step 44: Δ vs Opening-Balance Convention
  9. Step 45: Net Income (Average Balance, 1st Pass)

Balance Check

  1. Step 46: Balance Check