The final project — close a full quarter
Duration: 6–10 hours · To be done after you finish the modules on your track · Weight in the final assessment: 40%
1. The scenario
You are the finance lead at Nuwa Trading LLC. The first quarter of 2026 has ended, and the founder wants three things from you before Sunday's investor meeting:
- Books closed and reconciled for the three months.
- A financial pack a non-accountant can understand.
- One recommendation backed by numbers: do we order the fourth shipment in cash at a discount, or on credit?
2. The data
The full January data is in case-study.html. February and March follow.
February 2026
| # | Transaction | Details |
|---|---|---|
| F1 | Second shipment | 800 units · supplier invoice 48,000 on 30-day credit · shipping and customs 11,200 in cash |
| F2 | Card sales | 480 units × 199 across 300 orders |
| F3 | Cash-on-delivery sales | 220 units × 199 across 200 orders |
| F4 | Returns (from card sales) | 30 sound units returned to inventory |
| F5 | Payment gateway fees | 3% of card sales + VAT on it |
| F6 | Delivery company fee on cash-on-delivery orders | 15 dirhams per order + VAT (deducted from the transfer) |
| F7 | Shipping on card orders | 15 dirhams per order + VAT, paid from the bank |
| F8 | Advertising (non-resident supplier) | 18,000 |
| F9 | Salaries | 12,000 |
| F10 | Software and subscriptions | 1,200 + VAT |
| F11 | Payment to the supplier | 30,000 |
| F12 | Payment of the professional fees accrued in January | 2,500 |
| F13 | Payment of the January VAT return | 2,421.60 |
| F—A | Month-end adjustments | Depreciation 500 · rent 3,000 out of prepaid · professional fees accrued 2,500 |
March 2026
| # | Transaction | Details |
|---|---|---|
| M1 | Third shipment | 1,000 units · supplier invoice 62,000 on credit · shipping and customs 13,000 in cash |
| M2 | Card sales | 560 units × 199 across 350 orders |
| M3 | Cash-on-delivery sales | 240 units × 199 across 240 orders |
| M4 | Returns (from card sales) | 32 sound units returned to inventory |
| M5 | Payment gateway fees | 3% of card sales + VAT on it |
| M6 | Delivery fee on cash-on-delivery orders | 15 dirhams per order + VAT |
| M7 | Shipping on card orders | 15 dirhams per order + VAT, from the bank |
| M8 | Advertising (non-resident supplier) | 22,000 |
| M9 | Salaries | 12,000 |
| M10 | Software and subscriptions | 1,200 + VAT |
| M11 | Payment to the supplier | 48,000 |
| M12 | Payment of the professional fees accrued in February | 2,500 |
| M13 | Payment of the February VAT return | ? (calculate it) |
| M—A | Month-end adjustments | Depreciation 500 · rent 3,000 out of prepaid · professional fees accrued 2,500 |
Binding accounting policies
- Inventory method: FIFO · Inventory system: perpetual.
- VAT tax period: monthly · paid in the following month.
- All returns are sound and go back into inventory at their original cost, in the layer they were issued from.
- Advertising and imports fall under the reverse charge mechanism.
3. What is required
Part One — The books (30%)
- [ ] A journal for the three months, every entry with a date, a reference and a memo, and all of them balanced.
- [ ] An automated ledger (formulas, not copy-paste).
- [ ] A trial balance as at 31 March 2026.
- [ ] A layered FIFO inventory card showing the cost of every sale and the balance.
Part Two — The financial pack (25%)
- [ ] An income statement for the quarter in the stepped format + the three monthly columns.
- [ ] A balance sheet as at 31 March.
- [ ] A cash flow statement (indirect) for the quarter.
- [ ] All three check cells ✓.
Part Three — Compliance (20%)
- [ ] The monthly VAT register and three returns (January, February, March), reconciled to the books.
- [ ] A corporate tax estimate for 2026 based on the first quarter annualised, with a tax bridge and a justified decision on Small Business Relief.
Part Four — The decision (25%)
- [ ] A dashboard: unit economics · break-even point · LTV/CAC · the trend of the indicators across the three months.
- [ ] A 13-week cash flow forecast for the second quarter.
- [ ] The fourth-shipment decision: the cost is 150,000 dirhams. The two options: (a) cash payment within 10 days at an 8% discount, (b) 60-day credit with no discount. Analyse both options on cash and on profit, and give a recommendation.
- [ ] A one-page memo for the founder: three governing numbers · the biggest risk · the recommended decision · the number that, if it changed, would flip the recommendation. No unexplained accounting jargon.
4. Check figures
Compare your results against these figures. A difference is not necessarily a mistake — but you have to know where every difference comes from and be able to explain it.
Reveal the check figures after you have finished your work
**Trial balance as at 31 March 2026:** 675,841.60 on each side **Income statement — Q1:** | Item | Amount (dirhams) | % of net revenue | |-------|---------------|-------------------| | Gross sales | 398,000.00 | 104.3% | | Sales returns | (16,318.00) | (4.3%) | | **Net revenue** | **381,682.00** | **100.0%** | | Cost of goods sold | (137,050.00) | (35.9%) | | **Gross profit** | **244,632.00** | **64.1%** | | Fulfilment costs (gateway 8,596.80 + shipping 17,850.00) | (26,446.80) | (6.9%) | | **Contribution margin** | **218,185.20** | **57.2%** | | Marketing | (55,000.00) | (14.4%) | | Fixed costs (salaries 36,000 · rent 9,000 · software 3,600 · professional fees 7,500 · depreciation 1,500) | (57,600.00) | (15.1%) | | **Net profit** | **105,585.20** | **27.7%** | **Balance sheet as at 31 March 2026:** | Assets | Amount | Liabilities and equity | Amount | |--------|--------|---------------------------|--------| | Bank | 279,407.14 | Suppliers | 62,000.00 | | Inventory (882 units @ 75) | 66,150.00 | Accrued expenses | 2,500.00 | | Prepaid expenses | 9,000.00 | VAT payable | 6,971.94 | | Equipment (net) | 22,500.00 | Related-party loan | 50,000.00 | | | | Paid-in capital | 150,000.00 | | | | Retained earnings | 105,585.20 | | **Total** | **377,057.14** | **Total** | **377,057.14** | **Cash flow — Q1:** operating 103,407.14 · investing (24,000.00) · financing 200,000.00 · **net change 279,407.14** **VAT:** January 2,421.60 · February 6,088.22 · March 6,971.94 · **quarter total 15,481.76** **Operating indicators for the quarter:** 1,440 orders · 1,918 net units sold · average order value 265.06 · return rate 4.1%5. Submission
| File | Format |
|---|---|
| The complete workbook (every sheet) | .xlsx |
| The memo for the founder | .pdf, one page |
| A note on the accounting policies and assumptions | Text, inside the file |
6. Assessment matrix
| Criterion | Weight | Beginner (1) | Competent (2) | Proficient (3) |
|---|---|---|---|---|
| Accuracy of the books | 30% | Entries balance but the accounts are wrong | Balanced and the accounts are right, with minor errors | An exact match to the check figures, with complete document references |
| The financial statements | 25% | Complete statements but not linked | Linked, and the check cells work | Linked + ratio analysis + monthly comparison |
| Tax compliance | 20% | The VAT calculation is correct, and nothing more | + the reverse charge and the reconciliation | + a corporate tax estimate with a tax bridge and a justified relief decision |
| Quality of the decision | 25% | A recommendation with no numbers | A recommendation backed by one calculation | A recommendation with both options analysed on cash and on profit + a clear flip condition |
Pass: a weighted average ≥ 2.0 and no criterion scored 1.
Distinction: a weighted average ≥ 2.6 and Part Four scored 3.
7. Track versions
| Track | What is required |
|---|---|
| 🟢 Fast | Parts Two and Four only, with ready-made data from the attached trial balance |
| 🔵 Core | Parts One, Two and Four (without Part Three) |
| 🟣 Complete | All four parts in full |
8. Common mistakes that cost marks
- Recording the amount transferred by the gateway as sales — it ruins revenue, expenses and tax all at once.
- Forgetting the second entry on a return (inventory and cost) — it inflates cost of goods sold and hides inventory.
- Mixing up the FIFO layers — take the cost from the oldest layer first, and put a return back into its correct layer.
- Skipping the reverse charge entries because they have no cash effect — that is a disclosure breach.
- Charging shipping and customs to expense instead of capitalising them into inventory.
- Forgetting that the previous month's tax payment leaves the bank in the following month — it wrecks the cash forecast.
- A memo stuffed with jargon — the founder is meant to understand it, not to be impressed by it.