Consultancy

Feasibility study for phase one of the College's five-year (2023-2027) expansion strategy

Al Nahda College

Al Nahda College, established in 2014 in Khartoum, offers Medicine, Engineering, Humanitarian and Information Technology programs and is working toward full university recognition. Novel Consultancy & Training assessed phase one of the College's 2023-2027 strategic plan, covering the capital needed for new buildings, equipment and staff, and forecasting five years of revenue, profit, cash flow and breakeven enrollment. The study found the expansion is feasible, with a positive NPV and payback in a little over three years.

Sector
Higher education
Location
Khartoum, Sudan
Established
2014
Total capital required
US$15,220,713
Funding structure
8% owners (US$1,220,713) / 92% loan (US$14,000,000)
First-year revenue (2023)
US$3,674,814
First-year profit before tax & Zakat
US$1,971,401
Net present value (NPV, 31% discount rate)
US$4,296,806
Internal rate of return (IRR)
42.97%
Discounted payback period
approximately three years and three months
Breakeven point
US$23,504,897 revenue / 13,679 students

Background

Al Nahda College established in 2014 and located in Khartoum the capital of Sudan. The College is established on a total area of 1,040 square meters at No.452, Block No.37 Khartoum (3).

The College offers a diversity of programs from Medicine, Engineering and other Humanitarian and Information Technology programs. The market for education in Sudan is growing and the gap between supply and demand is wide despite the fact that there are over 100 university and educational institute in the country.

Al Nahda College is working towards qualifying into a full University recognition by The Ministry of Higher Education. For this purpose they prepared their second strategic plan from 2023 to 2027. The five year strategy among other objectives calls for completing the infrastructure of the college, building qualified and skillful academic staff and updating its curricula to match international research and science.

Past financial performance (2015-2022)

The past financial performance indicators of the College from 2015 to 2022 show average growth rate on total Assets of 19%, (table 1).

Revenue increased on average by 36%, while expenses grow approximately by 20% on average, (Table 2).

Cash flows on average increased by 1.42%, return on equity by 31%, and average return on Assets was 23% (Table 3).

Resources needed

To implement phase one of its strategy the College requires fixed assets amounts to US$14,750,222, and working capital of US$470,490 (US$235,144 general & administrative cost and US$195,921 human resource cost plus US$39,425, repairs & maintenance costs) i.e. total capital of US$15,220,713, (table 4).

8% of this capital is to be funded by the owners of the business i.e. US$1,220,713, and 92% i.e. US$14,000,000 to be funded by a long term loan, (table 5).

Based on the above mentioned financial indicators for 2015-2022, revenue, expenses, profits and cash flows were forecasted for the five year strategy as follows.

Revenue forecast

The expansion project using 36% growth rate is expected to generate revenue of US$3,674,814, in the first year of implementation, US$4,997,747, US$6,796,936, US$9,243,833 and US$12,571,612 respectively in the rest of the plan period, (table 6).

Revenue also forecasted by calculating the tuition & registration fees per student per program, (table 7, 8 and 9), producing similar result with minor differences.

Expenses forecast

The main categories of expenditure as classified in the financial reports of the College are general and administrative costs, human resources cost and repair & maintenance costs. Using the average rate of increase of 20% from the past performance, the general & administrative costs for the five year strategic plan is as follows: US$470,490 for the first year of implementation, US$564,589, US$677,506, US$813,007, and US$975,609 respectively over the rest of the strategic plan period, (table 10).

Expenses details for the 1st. year of implementation are as follows: General & administrative Costs amounts to US$235,144, Human resource costs US$195,921 and Repairs & Maintenance amounts to US$39,425 as shown on (tables 11, 12 & 13).

Details of the Assets required for the expansion are shown on (table 14) which amounts to US$14,750,222.

A proforma income statement and a proforma balance sheet were also prepared for the first year of the strategic plan, profits for the first year of implementing the plan amounts to US$1,971,401, (tables 15 & 16).

Profit plan

Phase one of the five year strategy gives the following profits for each year of the plan: US$1,971,401, US$3,235,236, US$4,956,507, US$7,302,903 and US$10,503,081 respectively, (table 17).

This projection generates a stream of cash flows of US$1,924,814, US$4,642,973, US$9,082,402, US$16,778,227, and US$26,764,230 respectively over the five year plan, (table 15).

Breakeven point

The business breakeven at a revenue (different programs) of US$23,504,897, a breakeven quantity of 13,679 students. The contribution at breakeven point amounts to US$23,504,897, and the total fixed costs are US$23,504,897, (table 19).

Feasibility of the expansion project

The feasibility of the business is measured by the NPV, IRR, and discounted payback period. The discount rate used is Return on Equity (ROE) of 31% to compensate for inflation & the risk of the future cash flows.

The result of the study is a positive NPV at 31% of US$4,296,806, an internal rate of return (IRR) of 42% and a discounted payback period of approximately three years and three month.

A sensitivity analysis of the NPV was conducted using higher discount factors of 35%, and 41% to accommodate for unforeseen risk in the future and the result is still positive NPV and IRR of 42% (i.e. NPV = 0), (table 20).

The expansion's Net profit margin is 54%, Return on Assets (ROA) 14% and Return on invested capital (ROI) is 13%.

Resources needed

ItemAmount
Fixed assetsUS$14,750,222
General & administrative expenseUS$235,144
Human resource costUS$195,921
Repairs & maintenanceUS$39,425
TOTAL CAPITAL REQUIREDUS$15,220,713
Financed by: owner's shareUS$1,220,713
Financed by: loanUS$14,000,000

Funding structure

SourceShareAmount
Owners8%US$1,220,713
Loan92%US$14,000,000

Fixed assets summary (strategic plan implementation costs)

ItemValue
Buildings (extension & new building)US$12,000,000
Vehicles (new)US$593,503
Furniture (for extension & new building)US$298,946
Office equipments (new)US$233,060
Books & references (new)US$132,742
Tools (new)US$100,012
Control equipments (new)US$16,166
Library units (new)US$58,542
Lab equipments (new)US$631,295
Air conditions (new)US$165,687
Electricity generator (new)US$275,269
Implementation costs (quality assurance, curricula development, assessment, restructuring, infrastructure, magazine, statistical unit, training, job descriptions)US$245,000
TOTALUS$14,750,222

Revenue forecast 2023-2027

20232024202520262027
US$3,674,814US$4,997,747US$6,796,936US$9,243,833US$12,571,612

Expenses forecast 2023-2027

Item20232024202520262027
General & administrative expense235,144282,173338,608406,330487,596
Human resource cost195,921235,105282,127338,552406,262
Repairs & maintenance39,42547,31056,77268,12681,751
Total470,490564,589677,506813,007975,609

Profit plan 2023-2027 (values in US$)

Item20232024202520262027
Revenue3,674,8144,997,7476,796,9369,243,83312,571,612
General & administrative expense235,144282,173338,608406,330487,596
Wages & salaries195,921235,105282,127338,552406,262
Repairs & maintenance39,42547,31056,77268,12681,751
Interest on loan350,000315,000280,000245,000210,000
Depreciation & amortization costs882,923882,923882,923882,923882,923
Cost before tax & Zakat1,703,4131,762,5111,840,4291,940,9302,068,531
Profit before tax & Zakat1,971,4013,235,2364,956,5077,302,90310,503,081

Breakeven analysis (totals)

MetricValue
Sales quantity at breakeven (students)13,679
Sales value at breakevenUS$23,504,897
Direct cost at breakevenUS$1,360,528
Contribution at breakevenUS$23,503,604

Feasibility analysis (cash flow, NPV, IRR)

YearCash flowDiscounted paybackDiscount factorNPVIRR
0(US$15,220,713)31%US$4,296,80642.97%
1US$1,924,814US$1,469,32441%US$544,045
2US$4,642,973US$3,544,254
3US$9,082,402US$6,933,131
4US$16,778,227US$12,807,807
5US$26,764,230US$20,430,710

Profitability ratio analysis

RatioValue
Net profit margin54%
Return on assets14%
Return on investment13%

Selected work

  • Industrial manufacturing (steel bars, tubes, screws & nails)

    Konoz Complex for Steel Shaping & Production

    Konoz Complex is a steel bars, tubes, screws and nails factory established in 2019 on a 64,000 square-metre site in the Safola industrial area of Khartoum. Novel Consultancy & Training assessed the capital required to build and operate the complex's three production plants and modelled five years of revenue, profit and cash flow. The study found the project generates a positive NPV, a high internal rate of return, and pays back its investment in roughly two years.

  • Medical education, business administration and technology

    Riyada University

    The feasibility study proposes establishing a higher education institution for medical sciences, business administration and artificial intelligence in Sudan, to address the critical gap between supply and demand in Sudan, the region and the Gulf states for highly qualified professionals in the medical, business administration and technology fields. The study estimates the project's total cost at US$12,095,913, and the financial indicators show that the project is largely viable but will only begin generating profits after the sixth year.

  • Education and training

    Novel Consultancy & Training Co. Ltd.

    Novel Consultancy & Training Co. Ltd. was established in 2014 with the vision of becoming a strategic Centre of Excellence in education, research, and training. Since 2015 the centre has trained and provided internationally accredited professional certificates in accounting and finance to over 500 participants from government and private commercial bodies, as an approved centre for ICBC, CIMC and Edexcel BTEC (Pearson). This study sets out the capital, revenue and profitability case for resuming normal operations: a total capital requirement of US$141,302 is projected to generate US$131,500 in first-year revenue and US$86,121 in net profit, growing 15% annually over a five-year plan, with a positive NPV of US$202,532, an IRR of 47%, and a payback period of two years and seven months.