Download the files for the course

Enter your information to receive the files you need to complete this resource in your inbox.

Equity and Retained Earnings

Your starting point

Open your completed CP13 workbook. Compare with the matching cumulative reference only after attempting the exercise.

Your objective

  • Roll retained earnings with provisional NI less explicitly declared shareholder distributions.
  • Do not treat owner distributions as operating expenses or auto-issue equity.
Source evidence / new releaseWhere to find it
Student source workbookD06 share capital and equity + D07 distributions
Forecast years / unit2026–2030 in H:L; USD thousands unless row says units, days, ratios, $/unit or headcount
Current control stageBase selected (scenario 1). Preserve 2022–2025 history and opening balances.

Why this step matters

Closing retained earnings = opening retained earnings + net income − distributions. Dividends/distributions are financing cash flows, not operating costs.

Build instructions

  • 1. Build only the cells and schedules authorized for Step 14. Work in the named worksheet and start from the prior cumulative checkpoint.
  • 2. Use the source-data identifiers and the central Assumptions sheet; derived outputs are formulas rather than typed constants.
  • 3. Enter the seed formulas in the next table. For year-based rows, H corresponds to 2026 and the same formula pattern extends right through L (2030); explicitly except noted loan support in M/N.
  • 4. Use the verification values only after the calculation. Review the business interpretation and troubleshoot issues before accepting the comparison workbook.

Cell-by-cell examples from the corresponding workbook

For rows in H, continue the formula pattern through L unless the source year or fixed absolute address requires a different copying direction. Historical E:G rows cover 2023–2025. Do not put forecast formulas into an unbuilt stage.

DestinationExact formula or fixed input (selected examples)
Tax_Equity!H13=Assumptions!H66
Tax_Equity!H14=G14
Tax_Equity!H15=G16
Tax_Equity!H16=H15+Income_Statement!H22-H13

Verify after the exercise

Verification itemReference after the exercise
2026 distributions430.00000
2026 provisional retained earnings4,324.16519

Common mistakes and repairs

  • Distributions are not payroll, supplier expense, or interest.
  • Retained earnings are not a balancing amount to zero out the balance sheet.

Interpretation questions

  • 1. Why does a distribution affect cash and retained earnings but not EBITDA?
  • 2. Can management simply issue balancing shares without approval?

Before moving to the next checkpoint

Confirm the intended cells for this stage, retain their formulas, restore Base assumptions and save a distinct working copy. Use the matching cumulative reference to review your work only afterward. A mathematically equivalent transparent formula is acceptable when signs, timing, controls and input response agree.

Next: Chapter 15 - Balance Sheet Framework

How to get started

1
arrow-down-blue

Tell us about your project

2
arrow-down-blue

Interview candidates

(We’ll provide bios within 48 hours on average)

3

Select your consultant and start work

Find a Consultant in Our Retail Practice

or email us at: [email protected]