Pastil Verde

Major Financial Assumptions

● Sales will increase by 7% each year

● All other operational expenses will also see a 7% increase.
● Raw materials equal to 7% of the total direct materials purchased for the year.
● Working capital will be 3 weeks of production cost.
● Based on the annual change in the Philippines' inflation rate, production capacity will increase by 7% in 2025 and 2026.
● All business transactions are on a cash basis only.
● After accounting for interest and taxes, the owner plans to withdraw 30% of the business's net income.
Contigency funds is 15% of the total estimated cost.
pacity will increase by 7% in 2025 and 2026.

f the business's net income.

Appendix A
Bananabites Bliss
List of Pre Operating Expenses
Permits and Licenses Units Unit Cost Total
Local Tax
Cedula 1 35.00 35.00
Purok Clearance 1 20.00 20.00
Barangay Business Clearance 1 150.00 150.00
Registration Fee
Relation To Anti-Smoking Campaign 1 110.00 110.00

Municipal assessor Certification 1 80.00 80.00

Tax Clearance 1 150.00 150.00
Tax Clearance Assessment 1 1,350.00 1,350.00
MPDO Clearance 1 80.00 80.00
MENRO
Solid Waste Clearance 1 60.00 60.00
Fire Safety Inspection Certificate 1 122.00 122.00
Documentary Stamp 1 15.00 15.00
Bureau of Fire Protection Clearance 1 500.00 500.00
DTI Registration 1 215.00 215.00
Total Local Permit 1 2,887.00 2,887.00
BIR Registration 1 500.00 500.00
Total Permits 3,387.00

Marketing Expense Units Unit Cost Total

Load 4 50 200.00
Tarpaulin (2x3) 1 120 120.00
Tarpaulin (2x8) 1 150 150.00
-
Total Marketing Expenses 470.00

Supplies Expense Units Unit Cost Total

Record Book 1 50 ₱ 50.00
Ballpen 1 80 ₱ 80.00
Calculator 1 120 ₱ 120.00
Broomstick 1 50 ₱ 50.00
Dustpan 1 95 ₱ 95.00
Trash Can 1 100 ₱ 100.00
Apron 2 35 ₱ 70.00
Hair net 4 35 ₱ 140.00
Mask 1 45 ₱ 45.00
Gloves 1 25 ₱ 25.00
Sweeper 1 60 ₱ 60.00
Table 1 350 ₱ 350.00
Total Supplies Cost ₱ 1,185.00

Other Tools and Equipments Units Unit Cost Total

Small Bowl 5 ₱ 45.00 ₱ 225.00
Knife 2 ₱ 35.00 ₱ 70.00
Measuring Cups Set 1 ₱ 85.00 ₱ 85.00
Ladle /Spoon Set 1 ₱ 85.00 ₱ 85.00
Chopping board 1 ₱ 95.00 ₱ 95.00
PPE Set 1 ₱ 250.00 ₱ 250.00
Frying Pan 1 ₱ 350.00 ₱ 350.00
Stainless Steal Wok Pan 1 ₱ 350.00 ₱ 350.00
₱ -
₱ -
₱ -
Total Other Equipments Cost ₱ 1,510.00
Total Expenses ₱ 2,695.00

List of Capital Expenditures

Production Equipment Units Unit Cost Total
Gas Stove Set 1 1,200.00 1,200.00
-
-
-
-
Total List of Capital Expenditures 1,200.00

Office and Selling Equipment Units Unit Cost Total

Laptop 1 5000 5,000.00
-
Total Office and Seling Equipment 5,000.00
Stall Units Unit Cost Total
Stall 1 3500 3,500.00
-
Total Stall 3,500.00
Bananabites Bliss
Total Project/Business Cost
(See Appendix A for details)

Pre Operating Expenses

Permits and Licenses 3,387.00
Marketing Expense 470.00
Supplies Expense 1,185.00 5,042.00

Capital Expenditures
Production Equipment 1,200.00
Stall 3,500.00
Office and Selling Equipment 5,000.00 9,700.00

Working Capital
Production Cost (Weekly Cost) Total Total
Contingency 1,474.20

TOTAL STARTUP COST 16,216.20 14,742.00

Capitalization 16,216.20
PRODUCTION CAPACITY Year 1 Year 2 Year 3
% Est. Increase 5% 5%
Production Capacity 90 95 99
Production Schedule (in days/month) 22 22 22
Monthly Production 1,980 2,079 2,183
Months of Operation 12 12 12
Annual Production 23,760 24,948 26,195

PRODUCTION COST Year 1 Year 2 Year 3

Direct Materials ### 1,267,081.20 1,330,435.26
Direct Labor 66,728.00 69,588.00 72,591.00
Factory Overhead 50,228.00 52,587.40 55,064.77
Total Production Cost ### 1,389,256.60 1,458,091.03

Annual Production 23,760 24,948 26,195

Cost per Unit 55.71 55.69 55.66
% Mark Up (65%+10% increment) 4.56 4.94 5.35
Selling Price ₱ 60 ₱ 61 ₱ 61

SALES PROJECTION Year 1 Year 2 Year 3

Sales/Revenue ### 1,512,499.72 1,598,236.42

COST OF GOODS SOLD Year 1 Year 2 Year 3

Raw Materials, Beg 60,337.20 66,370.92
Add: Purchases - Raw Materials ### 1,267,081.20 1,330,435.26
Less: Raw Materials, End 60,337.20 66,370.92 69,840.31
Direct Materials Used in Production ### 1,261,047.48 1,326,965.87
Direct Labor 66,728.00 69,588.00 72,591.00
Factory Overhead 50,228.00 52,587.40 55,064.77
Total Manufacturing Cost ### 1,383,222.88 1,454,621.64
Add: WIP, Beg. 0 60,337.20 63,354.06
Less: WIP, End 60,337.20 63,354.06 66,521.76
Cost of Goods Manufactured ### 1,380,206.02 1,451,453.94
Add: Finished Goods, Beg 0 60,337.20 63,354.06
Less: Finished Goods, End 60,337.20 63,354.06 66,521.76
Cost of Goods Sold ### 1,377,189.16 1,448,286.23
 Qty needed per Production
Direct Materials Unit Cost Total Cost Qty Yield
Banana (karnaba) 30 35 1,050.00 90
Ube Condensed 3 43 129.00 90
Powdered Milk 10 15 150.00 90
Cheese 5 90 450.00 90
Oil 4 95 380.00 90
Egg 40 9 360.00 90
Bread Crumbs 30 58 1,740.00 90
Flour 6 52 312.00 90
- 90
- 90
- 90
- 90
- 90
- 90
- 90
Total Direct Materials

Direct Labor No. of Employees Rate per Day Days Wage/month Year 1
Production Staff 1 200.00 22 4,400.00 52,800.00
13 Month Pay 4,400.00
SSS, PHIC, Pag-Ibig 9,528.00
Total Direct Labor 66,728.00

SSS, PHIC, Pag-Ibig SSS and EC Contributions PAG-IBIG

Employee Monthly Summary EE Share (4.5%)ER Share (8.5%) Total EE Share
Production Staff 4,400.00 198.00 374.00 572.00 200.00
Factory Overhead
Indirect Materials Qty Needed in a Year Unit Cost Year 1 Year 2 Year 3
Sticker 400 35.00 14,000.00 14,700.00 15,435.00
Paper Box 500 55.00 27,500.00 28,875.00 30,318.75
- - -
- - -
- - -
- - -
Total Indirect Materials 41,500.00 43,575.00 45,753.75

Other Tools and Equipments Qty Unit Unit Cost Total

Small Bowl 5 pcs ₱ 45.00 ₱ 225.00
Knife 2 pcs ₱ 35.00 ₱ 70.00
Measuring Cup 1 pcs ₱ 85.00 ₱ 85.00
Ladle/Spoon 1 pcs ₱ 85.00 ₱ 85.00
Chopping board 1 pcs ₱ 95.00 ₱ 95.00
PPE set 1 pcs ₱ 250.00 ₱ 250.00
Frying Pan 1 pcs ₱ 350.00 ₱ 350.00
Stainless Steal Work Pan 1 pcs ₱ 350.00 ₱ 350.00
₱ -
₱ -
₱ -
₱ -
₱ -
₱ -
₱ -
₱ -
Total Other Equipments Cost ₱ 1,510.00
Depreciation - PPE (Product Acquisition Cost Est. Useful Life Year 1 Year 2 Year 3
Gas Stove 1,200.00 4 400.00 400.00 400.00
- -
- -
- -
-
Total Depreciation (PPE) 400.00 400.00 400.00

Repairs and Maintenance Total Cost Year 1 Year 2 Year 3

Gas Stove 1,200.00 120.00 126.00 132.30
0 - - - -
0 - - - -
0 - - - -
0 - - - -
Total Repairs and Maintenance 120.00 126.00 132.30

Freight-In Monthly Allowance Year 1 Year 2 Year 3

Fare Allowance 200.00 2,400.00 2,520.00 2,646.00
Total Freight-In 2,400.00 2,520.00 2,646.00

Utilities Expense Source Basis Rate Total Cost Year 1

Light NORDECO kw/h 12.00 264.00 3,168.00
Water Water District Cu/M 10.00 220.00 2,640.00
Total Utilities Expense 5,808.00

Summary Year 1 Year 2 Year 3

Indirect Materials 41,500.00 43,575.00 45,753.75
Depreciation - PPE (Productio 400.00 400.00 400.00
Repairs and Maintenance 120.00 126.00 132.30
Freight-In 2,400.00 2,520.00 2,646.00
Utilities Expense 5,808.00 5,966.40 6,132.72
Total Factory Overhead 50,228.00 52,587.40 55,064.77
 Monthly
Direct Materials Production
Cost/Unit Cost Year 1 Year 2 Year 3
11.67 23,100.00 277,200.00 291,060.00 305,613.00
1.43 2,838.00 34,056.00 35,758.80 37,546.74
1.67 3,300.00 39,600.00 41,580.00 43,659.00
5.00 9,900.00 118,800.00 124,740.00 130,977.00
4.22 8,360.00 100,320.00 105,336.00 110,602.80
4.00 7,920.00 95,040.00 99,792.00 104,781.60
19.33 38,280.00 459,360.00 482,328.00 506,444.40
3.47 6,864.00 82,368.00 86,486.40 90,810.72
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
1,206,744.00 1,267,081.20 1,330,435.26

Year 2 Year 3
55,440.00 58,212.00
4,620.00 4,851.00
9,528.00 9,528.00
69,588.00 72,591.00

PAG-IBIG PhilHealth (5%) Total ER Share Yearly

ER Share Total EE Share ER Share Total
200.00 400.00 220.00 220.00 440.00 794.00 9,528.00
Year 2 Year 3
3,326.40 3,492.72
2,640.00 2,640.00
5,966.40 6,132.72
Pastil Verde
Notes to Financial Statements
NOTE 1 - CASH AND CASH EQUIVALENTS Year 1 Year 2
Cash #DIV/0! #DIV/0!
Petty Cash
Total Cash #DIV/0! #DIV/0!

NOTE 2 - RAW MATERIALS INVENTORY Year 1 Year 2

Provision for Ending Raw Materials:
5% of the total raw materials purchased for the year 60,337.20 66,370.92
Total Raw Materials Inventory 60,337.20 66,370.92

NOTE 3 - PROPERTY, PLANT AND EQUIPMENT Year 1 Year 2

Particulars Total Cost Depreciation
Gas Stove Set 1,200.00 400.00 800.00 400.00
0 - - - -
0 - - - -
0 - - - -
Laptop 5,000.00 1,250.00 3,750.00 2,500.00
0 - 1,000.00 (1,000.00) (2,000.00)
Stall 3,500.00 #DIV/0! #DIV/0! #DIV/0!
Total Property, Plant and Equipment, net #DIV/0! #DIV/0!

NOTE 4 - MARKETING EXPENSES Year 1 Year 2

Particulars Cost Qty
Load 50.00 4 200.00 210.00
Tarpaulin (2x8) 150.00 1 - 150.00
Tarpaulin (2x3) 120.00 1 - 120.00
Flyers 20.00 100 2,000.00 2,100.00
Total Marketing Expenses 2,200.00 2,580.00

NOTE 5 - SALARIES AND WAGES Year 1 Year 2

Position Rate per day Days Monthly Rate
Production Staff 200.00 22 4,400.00 52,800.00 55,440.00
- - -
Total Salaries and Wages 52,800.00 55,440.00

NOTE 6 - 13th Month Pay Year 1 Year 2

Production Staff 4,400.00 4,620.00
 - -
Total 13th Month Pay 4,400.00 4,620.00

NOTE 7 - SSS, PHIC, Pag-Ibig Year 1 Year 2

SSS
ER Share 418.00
Pag-Ibig
ER Share 400.00
PhilHealth
ER Share 220.00
Total Monthly Contributi 1,038.00 12,456.00 12,456.00
Total SSS, PHIC, Pag-Ibig 12,456.00 12,456.00

NOTE 8 - DEPRECIATION EXPENSE (Period Cost) Year 1 Year 2

Particulars Total Cost Est. Useful Life
Laptop 5,000.00 4 1,250.00 1,250.00
Stall 3,000.00 3 1,000.00 1,000.00
#DIV/0! #DIV/0!
Total Depreciation Cost (Period Cost) #DIV/0! #DIV/0!

NOTE 9 - REPAIRS AND MAINTENANCE Year 1 Year 2

Provision: 10% of the total cost
Total Cost Allowance
Laptop 5,000.00 500.00 500.00 525.00
Stall 3,000.00 300.00 300.00 315.00
0 - - - -
Total Repairs and Maintenance 800.00 840.00

NOTE 10 - ADMIN AND SUPPLY EXPENSES Year 1 Year 2

Particulars Qty Unit Cost
Record Book 1 50.00 50.00 52.50
Ballpen Set 1 80.00 80.00 84.00
Calculator 1 120.00 120.00 126.00
Broomstick 1 50.00 50.00 52.50
Dustpan 1 95.00 95.00 99.75
Trash Can 1 100.00 100.00 105.00
Apron 2 35.00 70.00 73.50
Hair net 4 45.00 180.00 189.00
Mask 1 45.00 45.00 47.25
Gloves 1 25.00 25.00 26.25
Sweeper 1 60.00 60.00 63.00
Table 1 350.00 350.00 367.50
Total Admin and Supply Expenses 1,225.00 1,286.25

NOTE 11 - UTILITIES EXPENSE Year 1 Year 2

Particulars Monthly Cost
Electricity 400.00 4,800.00 5,040.00
Water 150.00 1,800.00 1,890.00
- -
Total Utilities Expense 6,600.00 6,930.00

NOTE 12 - RENT EXPENSE Year 1 Year 2

Particulars Monthly Cost
Chairs 400.00 4,800.00 5,040.00
Total Rent Expenses 4,800.00 5,040.00

NOTE 13 - BOOKKEEPING FEE Year 1 Year 2

Particulars Monthly Cost
Bookkeeper's Fee 500.00 6,000.00 6,300.00
Total Bookkeeping Fee 6,000.00 6,300.00

NOTE 14 - PERCENTAGE TAX Year 1 Year 2

Sales ### 1,512,499.72
* Percentage Tax (3%)
Total Percentage Tax 42,961.37 45,374.99

NOTE 15 - OTHER INCOME Year 1 Year 2

particulars charge #of delivery p Monthly Income
- -

Total Other Income - -

Year 3
#DIV/0!

#DIV/0!

Year 3

69,840.31
69,840.31

Year 3

-
-
-
-
1,250.00
(3,000.00)
#DIV/0!
#DIV/0!

Year 3

220.50
157.50
126.00
2,205.00
2,709.00

Year 3

58,212.00
-
58,212.00

Year 3
4,851.00
 -
4,851.00

Year 3

12,456.00
12,456.00

Year 3

1,250.00
1,000.00
#DIV/0!
#DIV/0!

Year 3

551.25
330.75
-
882.00

Year 3

55.13
88.20
132.30
55.13
104.74
110.25
77.18
198.45
49.61
 27.56
66.15
385.88
1,350.56

Year 3

5,292.00
1,984.50
-
7,276.50

Year 3

5,292.00
5,292.00 4620

Year 3

6,615.00
6,615.00

Year 3
###

47,947.09

Year 3

-
 Jane Doe, Ph.D.
Pastil Verde
Prk 10 Poblacion, Compostela, Davao de Oro

PROJECTED STATEMENT OF FINANCIAL POSITION

As of the year ending Y1, Y2 and Y3

ASSETS Notes Year 1 Year 2 Year 3

Current Assets
Cash and Cash Equivalents 1 P #DIV/0! #DIV/0! #DIV/0!
Raw Materials Inventory 2 60,337.20 66,370.92 69,840.31
Total Current Assets P #DIV/0! #DIV/0! #DIV/0!
Non Current Assets
Property, Plant and equipment, ne 3 #DIV/0! #DIV/0! #DIV/0!
Total Non Current Assets P #DIV/0! #DIV/0! #DIV/0!
TOTAL ASSETS P #DIV/0! #DIV/0! #DIV/0!

LIABILITIES AND OWNER'S EQUITY

Current Liabilities
Accrued Taxes P 3,580.11 3,781.25 3,995.59
Total Current Liabilities P 3,580.11 3,781.25 3,995.59
TOTAL LIABILITIES P 3,580.11 3,781.25 3,995.59

Owner's Equity
Doe, Capital P #DIV/0! #DIV/0! #DIV/0!
Total Owner's Equity P #DIV/0! #DIV/0! #DIV/0!
TOTAL LIABILITIES AND OWNER'S EQUITY P #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
See attached Notes to Financial Statements
 Jane Doe, Ph.D.
Pastil Verde
Prk 10 Poblacion, Compostela, Davao de Oro

PROJECTED STATEMENT OF FINANCIAL PERFORMANCE

For the year ending Y1, Y2 and Y3

REVENUE Notes Year 1 Year 2 Year 3

Sales P 1,432,045.60 1,512,499.72 1,598,236.42
Cost of Goods Sold 1,142,688.40 1,377,189.16 1,448,286.23
Gross Income P 289,357.20 135,310.56 149,950.18
Other INcome - - -
NET INCOME 289,357.20 135,310.56 149,950.18
Less: OPERATING EXPENSES
Pre-operating Expense P 5,042.00
Marketing Expenses 4 2,200.00 2,580.00 2,709.00
Salaries and Wages 5 52,800.00 55,440.00 58,212.00
13th month pay 6 4,400.00 4,620.00 4,851.00
SSS. PHIC, Pag-Ibig 7 12,456.00 12,456.00 12,456.00
Depreciation Expense (Period Cost) 8 #DIV/0! #DIV/0! #DIV/0!
Repairs and Maintenance 9 800.00 840.00 882.00
Admin and Supply Expenses 10 1,225.00 1,286.25 1,350.56
Utilities Expenses 11 6,600.00 6,930.00 7,276.50
Rent Expenses 12 4,800.00 5,040.00 5,292.00
Bookkeeping Fee 13 6,000.00 6,300.00 6,615.00
Percentage Tax 14 42,961.37 45,374.99 47,947.09
TOTAL OPERATING EXPENSES P #DIV/0! #DIV/0! #DIV/0!
NET INCOME BEFORE TAX P #DIV/0! #DIV/0! #DIV/0!
Less: INCOME TAX - - -
NET INCOME AFTER TAX P #DIV/0! #DIV/0! #DIV/0!

See attached Notes to Financial Statements

 Jane Doe, Ph.D.
Pastil Verde
Prk 10 Poblacion, Compostela, Davao de Oro

PROJECTED STATEMENT OF CASH FLOWS

As of the year ending Y1, Y2 and Y3

CASH INFLOW Year 1 Year 2 Year 3

OPERATING ACTIVITIES
Net Income After Tax P #DIV/0! #DIV/0! #DIV/0!
Depreciation #DIV/0! #DIV/0! #DIV/0!
Increase in Inventory (60,337.20) (6,033.72) (3,469.39)
Increase in income tax 3,580.11 201.14 214.34
Total Cash Inflows from Operating Activities P #DIV/0! #DIV/0! #DIV/0!

FINANCING ACTIVITIES
Cash received from Owner P 16,216.20
Withdrawal #DIV/0! #DIV/0! #DIV/0!
Total Cash Inflows from Financing Activities P #DIV/0! #DIV/0! #DIV/0!
TOTAL CASH INFLOWS P #DIV/0! #DIV/0! #DIV/0!

CASH OUTFLOW
INVESTING ACTIVITIES
Purchase of PPE 9,700.00
Total Cash Outflows from Investing Activities P 9,700.00 - -
TOTAL CASH OUTFLOWS P 9,700.00 - -

TOTAL CASH FLOWS P #DIV/0! #DIV/0! #DIV/0!

Add: Cash, Beg. - #DIV/0! #DIV/0!
CASH, ENDING BALANCE P #DIV/0! #DIV/0! #DIV/0!
Pastil Verde
Financial Ratios
Year Ended 2xxx - 2xxx

PROFITABILITY RATIO Year 1 Year 2 Year 3

Profit Margin Net Income #DIV/0! #DIV/0! #DIV/0!
Sales 1,432,046 1,512,500 1,598,236
Total Profit Margin #DIV/0! #DIV/0! #DIV/0!

Return on Capital Net Income #DIV/0! #DIV/0! #DIV/0!

Average Capital #DIV/0! #DIV/0! #DIV/0!
Total Return on Capital #DIV/0! #DIV/0! #DIV/0!

Return on Investment Net Profit #DIV/0! #DIV/0! #DIV/0!

Cost of Investment #DIV/0! #DIV/0! #DIV/0!
Return on Investment #DIV/0! #DIV/0! #DIV/0!

LIQUIDITY RATIO Year 1 Year 2 Year 3

Current Ratio Current Assets #DIV/0! #DIV/0! #DIV/0!
Current Liabilities 3,580 3,781 3,996
Total Current Ratio #DIV/0! #DIV/0! #DIV/0!

Acid Test Ratio Quick Assets #DIV/0! #DIV/0! #DIV/0!

Current Liabilities 3,580 3,781 3,996
Total Acid Test Ratio #DIV/0! #DIV/0! #DIV/0!

SOLVENCY RATIO Year 1 Year 2 Year 3

Debt Ratio Total Debt 3,580 3,781 3,996
Total Assets #DIV/0! #DIV/0! #DIV/0!
Total Debt Ratio #DIV/0! #DIV/0! #DIV/0!

Debt-to-Equity Ratio Total Debt 3,580 3,781 3,996

Total Equity #DIV/0! #DIV/0! #DIV/0!
Total Debt-to-Equity Ratio #DIV/0! #DIV/0! #DIV/0!

Equity Ratio Total Equity #DIV/0! #DIV/0! #DIV/0!

Total Assets #DIV/0! #DIV/0! #DIV/0!
Total Equity Ratio #DIV/0! #DIV/0! #DIV/0!

PAYBACK PERIOD Net Cash Flows %

Initial Investment 16,216.20 1.00
Year 1 #DIV/0! #DIV/0!
Year 2 #DIV/0! #DIV/0!
Year 3 #DIV/0! #DIV/0!

Payback Period #DIV/0! years

BREAK-EVEN POINT Year 1 Year 2 Year 3

In units: Fixed Costs 50,228 52,587 55,065
Selling Price - Variable Cost per unit 6.67 7.05 7.45
Break Even Point in Units 7,526 7,461 7,389

In peso: Fixed Costs 50,228 52,587 55,065

Contribution Margin Ratio 0.11 0.12 0.12
Break Even Point in Peso 453,599 452,358 450,830
 Jane Doe, Ph.D.
Pastil Verde
Prk 10 Poblacion, Compostela, Davao de Oro

PROJECTED STATEMENT OF CHANGES IN OWNER'S EQUITY

As of the year ending, Y1, Y2 and Y3

Year 1 Year 2 Year 3

Doe, Capital Beg. P 16,216.20 #DIV/0! #DIV/0!
Add: Net Income #DIV/0! #DIV/0! #DIV/0!
Less: Doe, Drawing #DIV/0! #DIV/0! #DIV/0!
Doe, Capital Ending P #DIV/0! #DIV/0! #DIV/0!