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 release | Where to find it |
|---|---|
| Student source workbook | D06 share capital and equity + D07 distributions |
| Forecast years / unit | 2026–2030 in H:L; USD thousands unless row says units, days, ratios, $/unit or headcount |
| Current control stage | Base 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.
| Destination | Exact 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 item | Reference after the exercise |
|---|---|
| 2026 distributions | 430.00000 |
| 2026 provisional retained earnings | 4,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.