MRP Finance Internship Unit 08

Unit 08 · Case

The Fourth Outlet

Project Valuation · Nigeria · ₦

This is the student brief. The instructor guide is distributed separately.

Downloads

A Lagos quick-service restaurant group runs three outlets — Ikeja, Surulere, and Victoria Island. Nigerian food, fast service, mostly office workers at lunch. The business is profitable and has been for nine years.

The family that owns it wants to open a fourth outlet in Lekki. A landlord has offered a five-year lease on a good corner site. The operations director has spent three months on the proposal and is presenting it to the family this week.

Mountain River has been asked for a view.

Exhibit 1 · The commitment and the assumptions

THE COMMITMENT₦ millions
ItemAmount
Fit-out and equipment85.0
depreciated straight-line over 5 years, so17.0 a year
Initial working capital5.6
Total Year 0 outlay90.6
THE OPERATING ASSUMPTIONS
ItemValue
Year 1 revenue₦140.0m
Revenue growth, Years 2–510%
Food cost38% of revenue
Year 1 operating expenses₦62.0m
Operating expense growth12%
Working capital4% of revenue
Tax rate30%
Discount rate22%
Long-run growth after Year 58%
Terminal return on invested capital14%

The plan assumes NO cannibalisation of the Victoria Island outlet.

Exhibit 2 · Free cash flow — Years 1 to 5 supplied

FREE CASH FLOW · YEARS 1 TO 5 SUPPLIED₦ millions. Explicit-period present value at 22% is ₦66.92m.
LineY1Y2Y3Y4Y5
Revenue140.00154.00169.40186.34204.97
Food cost(53.20)(58.52)(64.37)(70.81)(77.89)
Operating expenses(62.00)(69.44)(77.77)(87.11)(97.56)
Depreciation(17.00)(17.00)(17.00)(17.00)(17.00)
EBIT7.809.0410.2611.4312.53
Tax at 30%(2.34)(2.71)(3.08)(3.43)(3.76)
After-tax EBIT5.466.337.188.008.77
Add depreciation17.0017.0017.0017.0017.00
Less increase in working capital0.00(0.56)(0.62)(0.68)(0.75)
FREE CASH FLOW22.4622.7723.5624.3225.02

Exhibit 3 · Discount factors at 22%

DISCOUNT FACTORS AT 22%
YearFactorYearFactor
10.819740.4514
20.671950.3700
30.5507

Question 1 · 15 minutes

The present value of Years 1 to 5 is supplied as ₦66.92 million. Compute the terminal value twice:

(a) by growing Year 5 free cash flow at 8 percent and applying the perpetuity formula; (b) by rebuilding Year 6 free cash flow with the supplied terminal reinvestment bridge below, then applying the same formula.

Terminal reinvestment rate = g / ROIC
                           = 8% / 14%
                           = 57.1% of NOPAT

Maintenance capex equals depreciation. Total reinvestment
also includes growth net capex and the increase in working capital.

Report the project NPV under each.

Question 2 · 13 minutes

The two answers differ enormously. Explain why, and say which is right.

Your explanation should describe, in plain language, what business the incorrect version is actually describing.

Question 3 · 9 minutes

What do you tell the family?

The plan assumes no cannibalisation of the Victoria Island outlet, fifteen minutes away. Name the evidence you would want on that — and state what else would change your recommendation.