FINANCIAL PLAN

COSTING

EQUIPMENT
ITEM QUANTITY PRICE
Freezer 1 pc ₱ 22,500
Refrigerator 1 pc ₱ 20,000
Stove 3 pcs ₱ 4,500
Frying pan 10 pcs ₱ 3,500
Pots 5 pcs ₱ 1,750
Turner 10 pcs ₱ 400
Motorcycle 1 pc ₱ 68,000
TOTAL ₱ 120,650

FURNITURE
ITEM QUANTITY PRICE
Tables 15 pcs ₱ 45,000
Air-conditioner 2 pcs ₱ 40,000
Electric fan 4 pcs ₱ 22,000
Bench 30 pcs ₱ 57,000
Mirror 2 pcs ₱2,600
Sink 3 pcs ₱ 12,000
Faucet 3 pcs ₱ 1,000
Toilet bowl 2 pcs ₱ 8,000
TOTAL ₱ 187,600

SCHEDULE 2: UTILITY EXPENSES

DESCRIPTION SOURCE MONTHLY DUES ANNUAL COST
Light Meralco ₱ 20,000 ₱ 240,000
Water Manila Water ₱ 5,000 ₱ 60,000
telephone w/ Internet PLDT ₱ 7,000 ₱ 84,000
TOTAL ₱ 32,000 ₱600,000

SUPPLIES
ITEM QUANTITY UNIT COST ACTUAL TOTAL
ANNUAL
Plates 100 pcs ₱ 20.00 ₱ 2,000 ₱24,000
Spoon 100 pcs ₱ 10.00 ₱ 1,000 ₱12,000
Fork 100 pcs ₱ 10.00 ₱ 1,000 ₱ 12,000
Cups 100 pcs ₱ 20.00 ₱ 2,000 ₱ 24,000
Plastic Gloves 50 box ₱ 100.00 ₱ 5,000 ₱ 60,000
Ball Pen 10 pcs ₱ 10.00 ₱ 100.00 ₱ 1,200
Paper 2 packs ₱ 20.00 ₱ 40.00 ₱ 480.00
Bulbs 6 pcs ₱ 200.00 ₱ 1,200 ₱14,400
Tissue 5 packs ₱ 85.00 ₱ 425.00 ₱ 5,100
Gasoline tank 1pc ₱ 3000 ₱ 3000 ₱ 36,000
Chicken Wings 10 box/47 kg ₱ 2,000 ₱ 20,000 ₱ 240,000
per box
Rice 10 Sack/ 50 kg ₱ 2,000 ₱20,000 ₱ 240,000
per sack
Fries 15 packs / 1kg ₱ 145.00 ₱ 2,175 ₱ 26,100
per pack
Mojos 15 packs/ 1kg ₱ 360.00 ₱ 5,400 ₱ 64,800
per pack
Nachos 15 packs/ 500g ₱ 62.00 ₱ 930.00 ₱ 11,160
per pack
Cheese Stick 15 packs/ 50 ₱ 50.00 ₱ 750.00 ₱ 9,000
pcs per pack
CHICKEN WINGS
FLAVORS:
Spicy 8 pcs/1L gal ₱ 870 ₱ 6,960 ₱83,520
buffalo
Teriyaki 8 pcs/ 1L gal ₱ 870 ₱ 6,960 ₱ 83,520
Cheese & 8 pcs/ 1L gal ₱ 870 ₱ 6,960 ₱ 83,520
Jalapeno
Sweet Sour 8 pcs/ 1L gal ₱ 870 ₱ 6,960 ₱ 83,50
Lemon 8 pcs/ 1L gal ₱ 870 ₱ 6,960 ₱ 83,520
Glaze
MILKTEA
Okinawa 10 packs /500g ₱ 173 ₱ 1,730 ₱ 20,760
Wintermelon 10 packs/500g ₱ 173 ₱ 1,730 ₱ 20,760
Hokkaido 10 packs/500g ₱ 173 ₱ 1,730 ₱ 20,760
FRENCH FRIES
Cheese 8 packs/1kg ₱ 520 ₱ 4,160 ₱ 49,920
Barbeque 8 packs/1kg ₱ 520 ₱ 4,160 ₱ 49,920
Sour Cream 8 packs/1kg ₱ 520 ₱ 4,160 ₱ 49,920
TOTAL ₱ 119,220 ₱ 1,430,640
 SCHEDULE 3: SALARIES AND WAGES
POSITION QUANTITY COST PER COST PER TOTAL TOTAL
MONTH ANNUAL COST PER COST PER
MONTH ANNUAL
Manager 1 ₱ 14,651 ₱ 175,812 ₱ 14,651 ₱ 175,812
Cook 3 ₱ 13,800 ₱ 165,600 ₱ 41,400 ₱ 496,800
Dishwasher 3 ₱ 12,351 ₱ 148,212 ₱ 37,053 ₱ 560,628
Cashier 2 ₱ 12,351 ₱ 148,212 ₱ 24,702 ₱ 296,424
Maintenance 2 ₱ 12,351 ₱ 148,212 ₱ 24,702 ₱ 296,424
Waitress 4 ₱ 12,351 ₱ 148,212 ₱ 49,404 ₱ 595,848
TOTAL ₱ 77,855 ₱ 934,260 ₱ 191,912 ₱ 2,302,944

SCHEDULE 9: TAXES AND LICENSE

Mayor’s Permit ₱ 5,000
SEC (Secretary and Exchange Commission) ₱ 5,000
Baranggay Permit ₱ 5,000
BIR (Bureau of Internal Revenue) ₱5,000
DTI (Department of Trade and Industry) ₱ 5,000
TOTAL ₱ 25,000

Fixed Asset/Start-up Expense List

Fixed Asset Description: Cost:

Land/Building ₱ 14,000×12 = ₱ 168,000
Equipment and/or Vehicles ₱ 120,650
Leasehold Improvements ₱ 15,000
(Other)
Furniture ₱187,600
Start-up Expense Description:
Initial Marketing & Promotion ₱ 9,000
Licenses and Permits ₱ 30,000
Beginning Inventory ₱ 400,000
(Other)
Supplies ₱ 119,220
Total Fixed Asset and Start-up Expenses: ₱ 1,049,470
 Projected Income Statement
For the 12 Months beginning
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total Year

Admini 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 252,000
Salaries
Insurance 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 144,000
Business
Insurance 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 54,000
Health
Interest 26,500 26,500 26,500 26,500 26,500 26,500 26,500 26,500 26,500 26,500 26,500 26,500 26,500 318,000

Rent/Utilities/ 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 552,000
Telephone
Equipment 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000
Rental
Taxes-Payroll 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% 12.4% -

Taxes-Other 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% 2.9% -
Postage 500 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Office 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 19,200
supplies
Repairs & 12,350 12,350 12,350 12,350 12,350 12,350 12,350 12,350 12,350 12,350 12,350 12,350 12,350 148,200
maintenance
Contract 13,100 13,100 13,100 13,100 13,100 13,100 13,100 13,100 13,100 13,100 13,100 13,100 13,100 157,200
Labor
Marketing/ 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 108,000
Advertising
Dues & 950 950 950 950 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 13,400
subscription
Miscellaneous 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000

Licenses 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,000
Auto Expense 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 84,000
Other 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 60,000

Total 167,500 167,500 167,500 167,500 167,750 167,750 167,750 167,750 167,750 167,750 167,750 167,750 167,750 ₱2,012,000
Expenses

A. (Cont.) Optional Method to Calculate Needed Capital

Total Required Capital = Six Months of Fixed Expenses + Asset Purchases + Start-up
Expenses

Monthly Fixed Expenses Column 1 Column 2

Salaries (include owner) ₱ 77,855 ₱ 467,130
Payroll Taxes at 12% ₱ 68,512.4 ₱ 411,074.4
Rent ₱ 14,000 ₱ 84,000
Marketing and Advertising ₱ 9,000 ₱ 54,000
Supplies ₱ 119,220 ₱ 715,320
Telephone & Utilities ₱ 32,000 ₱ 192,000
 Insurance ₱ 12,000 ₱ 72,000
Maintenance ₱ 12,350 ₱ 74,100
Legal and Accounting
Miscellaneous ₱ 3,000 ₱ 18,000
Other
Monthly Fixed Expense ₱ 347,937.4×6 = ₱ 2,087,624
Sub-total
Asset Purchases
Purchase of Land and
Building
Decorating and Remodeling ₱ 2,000
Fixtures and Equipment (plus ₱ 325,250
installation)
Deposits on Rental Property ₱ 24,000
and Utilities
Beginning Inventory ₱ 400,000
Asset Purchase Sub-total ₱ 751,250
Start-up Expense You Pay
Once
Legal and Accounting
Organization Costs
Licenses and Permits ₱ 30,000
Initial Advertising and ₱ 9,000
Promotion
Other
Start-up Expense Sub-total ₱ 39,000
Total Estimated Cash ₱ 2,877,874.4
needed to start (Add
Column 2)

B. Break Even Analysis

Monthly sales price: ₱50,000 Monthly Fixed Expenses:

Rent ₱14,000

less Cost of Goods Sold: Utilities ₱50,000

Material & Labor 15,000 Salary ₱83,000

less Other Variable Exp: Other ₱10,000

Commissions 30,000

Total Fixed Exp. ₱517,000

Monthly Contribution Margin = ₱5000

(₱50,000 – 15,000 – 30,000)

CM % (5,000 ÷ 50,000) = 10%

B/E = Fixed Expense ÷ CM %

B/E = ₱157,000 ÷ .1

Monthly B/E Sales = ₱1,570,000

C. Sources and Uses of Funds

Sources:

Term Loan ₱370,650

Line of Credit ₱1,000,000

Personal Equity ₱150,000

Outside Equity ₱500,000

Other

Total Sources: ₱2,020,650

Uses:

Purchase Building ₱250,000

Purchase Equipment ₱120,650

Renovations ₱100,000
Inventory ₱50,000

Working Capital ₱500,000

Cash Reserve ₱ 1,000,000

Other

Total Uses: ₱2,020,650