You ask, we answer!

FINANCIAL PLAN

Regarding point 7.) FINANCIAL PLAN:

To create a monthly financial plan for a Kenyan African street restaurant over three years, we assume that it is a restaurant that offers both average meals and special African specialities. The financial plan includes income, expenses (including staff costs, energy costs, food costs) and reserves applied to the projected profit.

Assumtion:

  1. Average price per meal: KES 500
  2. Number of meals per day: 50 (in the first year), 80 (in the second year), 120 (in the third year) – with an annual increase due to the growing number of customers.
  3. Monthly Opening days: 30
  4. Staff costs: KES 150,000 per month for a total of 4 employees (including cooks, waiters and cleaning staff).
  5. Energy costs: KES 30,000 per month (electricity, gas and other operating costs).
  6. Food costs: 40% of sales.
  7. 50% savings on monthly profit.
  8. Inflation and annual adjustments: Expenses (especially food and personnel costs) increase by 5% each year.

First year:

Second year:

Third year:

Monthly financial plan (in ksh):Turnover (ksh)Personnel costs (ksh)Energy costs (ksh)Food
costs (KES)
Total costs (ksh)Profit (ksh)50% reserves (ksh)Available profit (ksh)
Year third
Januar1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
Februar1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
March1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
April1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
May1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
june1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
july1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
August1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
September1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
Ocrober1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
November1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
December1.800.000 ksh165,375 ksh33,075 ksh360,000 ksh558,450 ksh841,550 ksh420,775 ksh420,775 ksh
Total / Annual total21.600.000 ksh1.984.500 ksh396.900 ksh4.320.000 ksh10.801.350 ksh10.798.650 kshs5.399.325 ksh5.399.325 ksh