Chapter 6: Feasibility Study Data
Chapter 6: Feasibility Study Data
-887,470.24
887,470.24 -0.439684340093407
733,669.80 0
0.452564111075444
0.675452961244915
1
1,700,000 1.42
2,065,401.01 365,401.01
2,300,064.51 2,665,465.52
2,558,607.35
0.959910128569212
1.57
620,000
1,400,746.22
2,838,505.83 4,239,252.05
1,834,492.54 0.43
0.14625221446788
ROA
32% 32.3055557350594
28% 28.1868644572456
26% 26.4347567785573
25% 24.8636242407354
23% 23.4261186945442
ROE
34% 34.3629849083153
30% 29.7258065039809
28% 27.771138922764
26% 26.034367118891
24% 24.4574314946241
ROR
25% 25.3147631542605
27% 27.097106803248
30% 30.4771505522315
34% 33.5892166935882
36% 36.3223642858469
Current ratio
8.84 884.381448204879
13.95 1394.91762393759
17.43 1743.30621607077
20.24 2024.47989459224
22.64 2264.28237057077
Quick
Asset ratio
7.66 765.628510791529
12.82 1282.28508612812
16.46 1646.02434985208
19.39 1938.96319276803
21.88 2187.53680488238
Asset Turnover
Ratio
1.28 5.98734125904773
1.04 5.17712461907214
0.87 4.81212581134482
0.74 4.49691314872071
0.64 4.21676659017355
6.36865432722798
Equity ratio 5.45978446474471
94.01% 5.05539791949503
94.82% 4.70865738164408
95.19% 4.40240576566395
95.50%
95.78%
106.368654327228
105.459784464745
Debt to
Equity ratio 105.055397919495
6.37% 104.708657381644
5.46% 104.402405765664
5.06%
4.71%
4.40%
Equity Multiplier
1.00
1.00
1.05
1.05
1.04
Present value
1,220,638.57 1.12
1,292,362.91 1.2544
1,436,675.65 1.404928
1,580,370.58 1.57351
1,718,121.07 1.762
7,248,168.78
2,100,785.00
5,147,383.78
-887,470.24
-0.44
887,470.24
479,644.96
0.30
-2,100,785.00
#REF!
0.675452961244915
0.675452961244915
-365,401.01
0.703013910470892
NET INCOME
1,461,016.00
1,883,959.30
2,577,581.62
3,409,460.33
4,384,230.95
1,226,968.72
1095507.79 1 12% ($1,095,507.79)
1168893.18 1 1,466,259.61 12% ($1,309,160.37)
1305755.55 1 1,834,492.54 12% ($1,637,939.77)
1441324.33 1 2,267,938.24 12% ($2,024,944.86)
1571001.83 1 2,768,105.22 12% ($2,471,522.52)
$0.00
1.05 2568279.1047619 $0.00
2,696,693.06 2,567,251.79 2,696,693.06 2,065,401.01 12% ($17,211,675.08)
129,441.27 2 2,300,064.51 80% ($3,580,011.41)
3 2,558,607.35 12% ($6,145,343.14)
4 2,843,438.10 12% ($8,636,514.86)
6,582,169.51 $0.00
1,833,788.72
4,748,380.79
2,696,693.06 2,988,255.24
5,593,198.07
8,489,639.92
37,451,097.20 11,386,015.81
42,447,869.63 14,282,322.78
-4,996,772.42 4,996,772.43 42,447,869.64
4,996,772.44
8.495057589615
1.13342125608
16,424,671.20 2.584396918704
TOTAL ASSETS owners equity net revenue cash
3,488,571.00 4,893,018.60 5,690,400.00 1885625
5,929,438.30 6,485,662.45 6,543,960.00 3926151.3
9,079,042.52 8,673,521.85 13,982,263.50 6676232.923
13,076,013.86 11,578,183.50 16,079,603.03 10257282.451
18,063,625.25 15,312,614.51 18,491,543.48 14810257.629
1,226,968.72
1,351,766.22
1,226,968.72
($1,043,400.81) ($265,759.55)
($1,043,400.81)
0.3042235901806
0
Roselicious Bakery
Projected Income Statement
for the year ended Dec. 31, 20A, 20B, 20C, 20D, 20E
20A 20B 20C
Sales 4,344,600.00 4,996,290.00 5,745,733.50
Cost of Sales 1,368,549.00 1,710,686.25 1,980,974.68
GROSS PROFIT 2,976,051.00 3,285,603.75 3,764,758.82
Operating Expenses
Salaries and Wages 756,000.00 756,000.00 756,000.00
SSS/PHIC/HDMF 9,749.00 9,749.00 9,749.00
Utilities Expense 204,000.00 214,200.00 224,910.00
Rent Expense 360,000.00 360,000.00 360,000.00
Depreciation 267,290.00 267,290.00 267,290.00
Operational Supplies Expense 46,500.00 46,500.00 46,500.00
Advertising Expense 10,300.00 10,300.00 10,300.00
Repairs and Maintenance Expense 10,000.00 10,500.00 11,550.00
Permits and Licenses 18,300.00 18,300.00 18,300.00
Total Operation Expenses 1,682,139.00 1,692,839.00 1,704,599.00
Net income before tax 1,293,912.00 1,592,764.75 2,060,159.82
Provision for Income Tax 194,086.80 238,914.71 309,023.97
Net Income 1,099,825.20 1,353,850.04 1,751,135.85
FORECASTS
SALES 15% 651,690.00 749,443.50
PURCHASES 35% 1,520,610.00 1,748,701.50 2,011,006.72
tax 44,827.91 70,109.26
756,000.00 756,000.00
9,749.00 9,749.00
236,155.50 247,963.28
360,000.00 360,000.00
267,290.00 267,290.00
46,500.00 46,500.00
10,300.00 10,300.00
12,705.00 13,975.50
18,300.00 18,300.00
1,716,999.50 1,730,077.78
2,611,104.60 3,247,105.08
391,665.69 487,065.76
2,219,438.91 2,760,039.32
861,860.03 991,139.03
2,312,657.73 2,659,556.39
82,641.72 95,400.07
Roselicious Bakery
Comparative Balance Sheet
for the year ended Dec. 31, 20A, 20B, 20C, 20D, 2
20A 20B
Assets
Current assets
Cash 1,560,625.00 3,188,577.70
Inventory 152,061.00 190,076.25
Prepaid Rent 90,000.00 90,000.00
Total Current Assets 1,802,686.00 3,468,653.95
Fixed Assets
Leasehold Improvement 714,700.00 714,700.00
Equipments 751,600.00 751,600.00
Furniture and fixtures 227,500.00 227,500.00
Kitchenware & Tableware 175,250.00 175,250.00
Less: Acc Depreciation 267,290.00 534,580.00
Total Fixed Assets 1,601,760.00 1,334,470.00
Total Assets 3,404,446.00 4,803,123.95
Liabilities and Owner's Equity
Current Liabilities
Income Tax Payable 194,086.80 238,914.71
SSS/PHIC/HDMF Payable 9,749.00 9,749.00
Total Liabilities 203,835.80 248,663.71
Owner's equity
Pasaje, Capital 1,600,305.10 2,277,230.12
Total Capital 3,200,610.20 4,554,460.24
Adjustments:
Add: Depreciation 267,290.00
Increase in Prepaid Rent 90,000.00
Increase in Inventory 152,061.00
Increase in Income tax Payable 194,086.80
Increase in SSS/PHIC/HDMF 9,749.00
Cashflow provided by operating activities 1,328,890.00
Cashflow from investing activities
Leasehold Improvement -714,700.00
Equipment -751,600.00
Furnitures and Fixtures -227,500.00
Kitchentool and Utensils -175,250.00
Net Cash used in Investing Activities -1,869,050.00
Cashflow from financing activities
Capital 2,100,785.00
1,560,625.00
3,188,577.70
5,247,080.76
7,783,283.08
10,868,005.78
oselicious Bakery
d Statement of Cash flow
d Dec. 31, 20A, 20B, 20C, 20D, 20E
20B 20C 20D 20E
20a
- - - - 714,700.00
- - - - 751,600.00
- - - - 227,500.00
175,250.00
- - - -
- - - -
3,200,610.20
4,554,460.24
6,305,596.09
8,525,034.99
11,285,074.31
15653
y
ners Equity
B, 20C, 20D, 20E
20D 20E
6,305,596.09 8,525,034.99
6,305,596.09 8,525,034.99
2,219,438.91 2,760,039.32
2,219,438.91 2,760,039.32
8,525,034.99 11,285,074.31
S
No. of
Particulars
Employees
Manager 1
Baker 2
Service crew 2
Cashier 1
TOTAL 6
UTILITIES EXPENSE
Rent
Particulars Amount
Rent 30,000.00
ADVERTISING EXPENSE
Particulars Qty
Social Media Promotion 1
Tarpaulins (1m x .5m) 20
Flyers 300
Total
Particulars/Items Quantity
Office Table 1
Office Chair 1
Dining Chairs 32
Dining Tables 8
Cabinets 2
Lightings 10
Locker 1
Total Cost
INSTALLATION COST
Particulars Quantity
Fire Extinguisher 5
CCTV Camera 5
Total Cost
EQUIPMENT
Particulars/Items Quantity
Air Conditioner 2
Computer Set 1
Water Dispenser 1
Refrigerator 1
Oven 2
Generator Set 2
Kitchen Scale 1
Stand Mixer 1
Bread Slicer 1
Proofer 1
Total Cost
LEASHOLD IMPROVEMENT
COST ESTIMATE
PROJECT RESTAURANT BUILDING RENOVATION
NO. DESCRIPTION
I GENERAL REQUIERMENTS
II MASONRY WORKS
III TILE WORKS
IV HARDWARE
V PAINTINGS
VI PLUMBING WORKS
VII CEILING
TOTAL MATERIAL COST
LABOR COST (35% OF MATERIAL COST)
CONTINGENCY COT (5% OF MATERIAL COST)
GRAND TOTAL
NSE
Cost No. of months Total Cost
3,000.00 3 3,000.00
65.00 1 1,300.00
20.00 3 6,000.00
10,300.00
Cost Total
5,000.00 5,000.00
3,500.00 3,500.00 DEPRECIATION-LEASING
3,500.00 112,000.00
4,000.00 32,000.00 Particulars
5,000.00 10,000.00 Leasing Improvements
6,000.00 60,000.00
5,000.00 5,000.00 DEPRECIATION-FURNITURE
227,500.00
Particulars
Furnitures and Fixtures
Cost Total Cost
1,000.00 5,000.00 DEPRECIATION-EQ
5,990.00 29,950.00
34,950.00 Particulars
EQUIPMENT
Cost Total
90,000.00 180,000.00
30,000.00 30,000.00
5,000.00 5,000.00
50,000.00 50,000.00
150,000.00 300,000.00
70,000.00 140,000.00
600.00 600.00
4,000.00 4,000.00
30,000.00 30,000.00
12,000.00 12,000.00
751,600.00
AMOUNT
30,000.00
20,500.00
200,000.00
150,00.00
50,000.00
90,000.00
120,000.00
510,500.00
178,675.00
25,525.00
714,700.00
Cost Total
200.00 20,000.00
50.00 5,000.00
50.00 5,000.00
100.00 10,000.00
290.00 29,000.00
750.00 37,500.00
100.00 500.00
150.00 750.00
9,100.00 45,500.00
250.00 1,250.00
1300.00 13,000.00
500.00 5,000.00
100.00 500.00
200.00 1,000.00
250.00 1,250.00
175,250.00
Cost Total
100.00 10,000.00
220.00 22,000.00
140.00 14,000.00
25.00 500.00
46,500.00
HDMF SUMMARY
Total Deduction Yearly Pay
TOTAL
ER EE
260 260 2,920.00 10,080.00
200 200 2,860.00 7,140.00
150 150 1,984.50 5,515.50
150 150 1,984.50 5,515.50
760 760 9,749.00 28,251.00
10,000.00
120,000.00
60,000
5000
8 4 32
DEPRECIATION-LEASING IMPROVEMENTS
DEPRECIATION-EQUIPMENT
total 267,290.00
TOTAL ANNUAL TOTAL TOTAL TOTAL
ER EE
BASIC SALARY MONTHLY ANNUAL ANNUAL ER
756,000.00 5,429.00 4,320.00 9,749.00 116,988.00 65,148.00
PROJECTED SALES INCOME - BREAD
ESTIMATED NO.
PRODUCTS PRICE OF ORDERS.
Loaf Bread 60.00 250
Fiber Loaf Bread 80.00 200
Whole Wheat loaf Bread 100.00 190
Pandesal 5.00 550
Garlic Pandesal 5.00 520
Pandesal with egg 10.00 340
Ensaymada 10.00 240
Pan De Coco 5.00 210
Monay 5.00 180
Spanish Bread 10.00 150
Cheese Bread 10.00 190
Choco Lanay 10.00 200
Banana Bread 10.00 160
Stone Bread 5.00 170
Ube Cheese Bread rolls 15.00 195
Pastel Bread rolls 15.00 175
Choco Bread rolls 15.00 220
TOTAL
NCOME - PASTRIES
126,717.50
380,152.50
253,435.00
OTAL SALES
ANNUAL SALES
957,600.00
2,834,400.00
552,600.00
4,344,600.00
1,520,610.00
INVESTMENT COST month 3x
Particulars Cost
Leashold Improvement 714,700.00
Equipment 751,600.00
Furnitures and Fixtures 227,500.00
Prepaid Rent 90,000.00 30,000.00 90,000.00
Working Capital 316,985.00
Total Investment Cost 2,100,785.00
1,050,392.50
12x
360,000.00