Golden Delta Rice Business Plan — Financial Plan

Five-year projections: revenue building to N1.75bn and EBITDA to N403m at a 23.1% margin, with the full cost stack by line.

Financial Plan

Jump to section
On this page

  • 9.1 Basis of preparation
  • 9.2 Revenue build
  • 9.3 Projected income statement
  • 9.4 Projected cash flow statement
  • 9.5 Projected balance sheet
  • 9.6 Working capital and the cash cycle

9.1 Basis of preparation

All figures are in Nigerian Naira and exclude VAT.

Revenue is built from hectares, yield, milling recovery and price per kilogram. It is not a growth rate applied to an assumed base.

Production costs are built per hectare per crop from current input prices, and multiplied by two crops a year.

Prices escalate at 11.5% a year and input costs at 13.5%. Input costs are assumed to rise faster than output prices, which is the pattern Nigerian farmers have experienced.

Depreciation is straight-line over asset lives from 6 to 20 years, giving a charge of ₦58 916 667 a year.

Interest is charged on the outstanding balance. With a two-year capital moratorium no principal is repaid before Year 3, so Year 3 interest is charged on the full ₦713 653 000.

Companies income tax is 30%, with an assumed three-year agricultural relief period, after which the Year 1 assessed loss is set off before tax is charged.

The ₦60 000 000 grant is credited to shareholders’ funds as a capital contribution at inception rather than released to income, so it does not flatter EBITDA in any year.

Pre-operational costs of ₦54 000 000 are charged against reserves at day zero and are reflected in the opening balance sheet rather than in the Year 1 income statement.

Working capital assumes 30 debtor days, 21 creditor days and 45 days of inventory, with paddy purchases paid within seven days of delivery.

No revenue is assumed from land appreciation, carbon credits, or any activity not described in Section 2.

9.2 Revenue build

Year 1

Year 2

Year 3

Year 4

Year 5

Hectares cropped

60

85

100

100

100

Paddy yield, t/ha per crop

4.30

4.70

5.00

5.15

5.25

Own farm paddy, t

516

799

1 000

1 030

1 050

Outgrower paddy, t

217

434

620

744

868

Total paddy processed, t

733

1 233

1 620

1 774

1 918

Milled rice at 62%, t

454

764

1 004

1 100

1 189

Rice bran at 8%, t

59

99

130

142

153

Husk at 20%, t

147

247

324

355

384

Ex-mill price, ₦ per kg

920

1 026

1 144

1 275

1 422

Price per 50 kg bag, ₦

46 000

51 300

57 200

63 750

71 100

Total revenue, ₦

432 176 800

810 579 132

1 187 468 845

1 449 892 130

1 747 855 588

9.3 Projected income statement

Year 1

Year 2

Year 3

Year 4

Year 5

Revenue

432 176 800

810 579 132

1 187 468 845

1 449 892 130

1 747 855 588

Farm production costs

(148 320 000)

(238 486 200)

(318 449 220)

(361 439 865)

(410 234 246)

Paddy purchased from outgrowers

(76 123 600)

(169 755 628)

(270 396 465)

(361 790 470)

(470 629 103)

Milling costs

(40 754 800)

(77 809 698)

(116 033 002)

(144 216 845)

(176 972 930)

Fixed cash costs

(176 000 000)

(198 880 000)

(224 734 400)

(253 949 872)

(286 963 355)

EBITDA

(9 021 600)

125 647 606

257 855 758

328 495 078

403 055 953

EBITDA margin

-2.1%

15.5%

21.7%

22.7%

23.1%

Depreciation

(58 916 667)

(58 916 667)

(58 916 667)

(58 916 667)

(58 916 667)

Operating profit / (loss)

(67 938 267)

66 730 939

198 939 091

269 578 411

344 139 286

Finance costs

(64 228 770)

(64 228 770)

(64 228 770)

(55 691 496)

(46 385 867)

Profit / (loss) before tax

(132 167 037)

2 502 169

134 710 321

213 886 915

297 753 419

Taxation

(24 515 963)

(89 326 026)

Profit / (loss) after tax

(132 167 037)

2 502 169

134 710 321

189 370 952

208 427 393

Net margin

-30.6%

0.3%

11.3%

13.1%

11.9%

Cost per tonne of milled rice

1 101 575

973 623

984 591

1 073 012

1 180 586

Cost structure as a percentage of revenue
Figure 13. Cost structure as a percentage of revenue.

The pattern is characteristic of a capital-intensive agricultural venture with a long establishment period: a punishing first year at 60 per cent of area and 4.30 tonnes per hectare, then rapidly improving margin as area and yield both rise against a fixed cost base that grows only with inflation. Between Year 1 and Year 3 revenue rises 175 per cent while total operating costs rise 98 per cent.

9.4 Projected cash flow statement

Year 1

Year 2

Year 3

Year 4

Year 5

Profit / (loss) after tax

(132 167 037)

2 502 169

134 710 321

189 370 952

208 427 393

Add back: depreciation

58 916 667

58 916 667

58 916 667

58 916 667

58 916 667

(Increase) / decrease in working capital

(47 212 770)

(49 694 076)

(49 668 653)

(35 835 868)

(41 371 424)

Cash generated from operations

(120 463 140)

11 724 760

143 958 335

212 451 751

225 972 636

Debt capital repaid

— (moratorium)

— (moratorium)

(94 858 602)

(103 395 876)

(112 701 505)

Net movement in cash

(120 463 140)

11 724 760

49 099 733

109 055 875

113 271 131

Opening cash

307 653 000

187 189 860

198 914 620

248 014 353

357 070 228

Closing cash

187 189 860

198 914 620

248 014 353

357 070 228

470 341 359

Cash flow — the two-year moratorium carries the ramp
Figure 14. Cash flow — the two-year moratorium carries the ramp.

Opening cash after capital expenditure, capitalised land and outgrower costs, and the pre-operational charge is ₦307 653 000. Cash generated from operations is negative ₦120 471 000 in Year 1 as the working capital cycle builds alongside the loss, turns positive in Year 2, and reaches ₦226 018 000 by Year 5. Closing cash never falls below ₦187 189 860, and the two-year moratorium is what makes that true: had capital been repayable from Year 1 the position would be materially tighter.

9.5 Projected balance sheet

₦, at year end

Year 1

Year 2

Year 3

Year 4

Year 5

Property, plant and equipment

623 083 333

564 166 666

505 249 999

446 333 332

387 416 665

Land, community and outgrower establishment costs

50 000 000

50 000 000

50 000 000

50 000 000

50 000 000

Inventory

32 695 693

59 924 161

86 902 852

106 945 543

130 418 171

Trade receivables

35 521 381

66 622 942

97 600 179

119 169 216

143 659 363

Cash

187 189 860

198 914 620

248 014 353

357 070 228

470 341 359

Total assets

928 490 267

939 628 389

987 767 383

1 079 518 319

1 181 835 558

Share capital and capital contribution

380 000 000

380 000 000

380 000 000

380 000 000

380 000 000

Retained earnings / (accumulated loss)

(186 167 037)

(183 664 868)

(48 954 547)

140 416 405

348 843 798

Total equity

193 832 963

196 335 132

331 045 453

520 416 405

728 843 798

Term debt — non-current

713 653 000

618 794 398

515 398 522

402 697 017

279 852 377

Term debt — current

0

94 858 602

103 395 876

112 701 505

122 844 640

Trade payables

21 004 304

29 640 257

37 927 532

43 703 392

50 294 743

Total liabilities

734 657 304

743 293 257

656 721 930

559 101 914

452 991 760

Total equity and liabilities

928 490 267

939 628 389

987 767 383

1 079 518 319

1 181 835 558

Balance sheet — asset composition
Figure 15. Balance sheet — asset composition.

Property, plant and equipment falls from ₦623 083 333 to ₦387 416 665 across the projection as depreciation of ₦58 916 667 a year runs against no replacement capital in the first five years. Total equity opens at ₦326 000 000 — ₦320 000 000 of promoter equity plus the ₦60 000 000 grant, less the ₦54 000 000 pre-operational charge — falls to ₦193 832 963 after the Year 1 loss, and recovers to ₦728 832 963 by Year 5. The Year 5 current portion of term debt is ₦122 844 640, representing the Year 6 amortisation on a facility with three years still to run.

9.6 Working capital and the cash cycle

Year 1

Year 2

Year 3

Year 4

Year 5

Inventory at 45 days

32 695 693

59 924 161

86 902 852

106 945 543

130 418 171

Trade receivables at 30 days

35 521 381

66 622 942

97 600 179

119 169 216

143 659 363

Trade payables at 21 days

(21 004 304)

(29 640 257)

(37 927 532)

(43 703 392)

(50 294 743)

Net working capital

47 212 770

96 906 846

146 575 499

182 411 367

223 782 791

Movement in the year

(47 212 770)

(49 694 076)

(49 668 653)

(35 835 868)

(41 371 424)

Net working capital rises from ₦140 million in Year 1 to ₦283 million by Year 5, absorbing cash in every year of the projection. Two features of the rice cycle drive it. Land preparation begins roughly five months before the first bag is sold, so a full production cycle must be funded before any revenue arrives. And paddy is bought from outgrowers in a short harvest window, in cash, within seven days of delivery, while the resulting rice is sold across the following months.