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:

  1. Books closed and reconciled for the three months.
  2. A financial pack a non-accountant can understand.
  3. 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

  1. Recording the amount transferred by the gateway as sales — it ruins revenue, expenses and tax all at once.
  2. Forgetting the second entry on a return (inventory and cost) — it inflates cost of goods sold and hides inventory.
  3. Mixing up the FIFO layers — take the cost from the oldest layer first, and put a return back into its correct layer.
  4. Skipping the reverse charge entries because they have no cash effect — that is a disclosure breach.
  5. Charging shipping and customs to expense instead of capitalising them into inventory.
  6. Forgetting that the previous month's tax payment leaves the bank in the following month — it wrecks the cash forecast.
  7. A memo stuffed with jargon — the founder is meant to understand it, not to be impressed by it.