ENTREP Income Analysis

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 5

10.

3 Projected Income Analysis


This projected income statement, also known as a profit and loss statement, provides a
projection of the sources of revenue and different types of costs for the business's operations. In
other words, it will reveal the source and purpose of the money. This projected income
statement can demonstrate a business's profitability for a given time frame.

Table. 1 Projected Income


PROJECTED INCOME STATEMENT

Description Monthly Yearly

Sales 232,500 2,790,000

Sales Return, Allowances, 23,250 279,000


Discounts ( Approx. 10% of
sales)

Net sale 209,250 2,511,000

Cost of Goods 135,000 1,620,000

Gross profit 74,250 891,000

General Expenses 104,800 1,257,600

Net Income Before Taxes Php 337,300 Php 4,047,600

Taxes 10,119 121,428

Net Income After Taxes Php 327,181 Php 3,926,172

Table 2. Estimated sales


Products Sale Price Monthly Yearly

Quantity Sold Amount Quantity Sold Amount

Spicy 75 1,500 112,500 18,000 1,350,000


Chicken
Pastil

Chili 15 3,000 45,000 36,000 540,000


Pandesal

Chili Cookies 25 3,000 75,000 36,000 900,000

Total 7,500 232,500 90,000 2,790,000

Table 3. Estimated Cost of Goods


Products Cost Monthly Yearly

Quantity Sold Amount Quantity Sold Amount

Spicy 50 1,500 75,000 18,000 900,000


Chicken
Pastil

Chili 5 3,000 15,000 36,000 180,000


Pandesal

Chili Cookies 15 3,000 45,000 36,000 540,000

Total 7,500 135,000 90,000 1,620,000

10.4 Projected Expenses Analysis


The projected expenses analysis is based on the set pricing of our products, forecasts
revenues, and balances those results against costs and cash on hand. This projection takes into
account both predicted growth in costs and sales.

Table 4. Projected Expenses


PROJECTED EXPENSES STATEMENT

Description Monthly (Php) Yearly (Php)

Product Ingredients 44,500 534,000

Packaging 10,300 123,600

Salaries 45,000 540,000

Rent 1,000 120,00

Loan Payment 2,000 24,000

Repair & Maintenance 500 6,000

Depreciation 500 6,000

Miscellaneous 1,000 12,000

Total Expenses: Php 104,800 Php 1,257,600

Table 5. Product Ingredients and Packaging Expenses

Product Ingredients and Packaging Expenses


Raw Materials Quantity Unit Cost Amount

INGREDIENTS

Chili 5 kgs 200.00 1,000.00

Flour 10 kgs 200.00 2,000.00

Chocolate chips 4 kgs 180.00 720.00

Rice 1 bag 2,000.00 2,000.00

Eggs 10 trays 250.00 2,500.00

Chicken 5 kgs 200.00 1,000.00

Baking powder 5 kgs 150.00 750.00

Condiments (salt, pepper, 3 kgs 100.00 300.00


sugar etc.)

PACKAGING
MATERIALS

Banana Leaves 20 pcs 30.00 600.00

Parchment Paper 4 reams 200.00 800.00

Abaca Packaging 20 pcs 50.00 1,000.00

Total Amount Php 12,670.00


Total Amount Monthly Php 54,800

Table 6. Tools, Materials, and Equipment Cost

STAR-UP TOOLS AND EQUIPMENT COST

Production Quantity Unit Cost Amount


Materials/Machine

EQUIPMENTS:

Oven 1 pc 5,000.00 5,000.00

Stove (Single burner) 1 pc 899.00 899.00

Mini Refrigerator (3.2 cu.ft) 1 pc 5,499.00 5,499.00

Rice cooker (5L capacity) 1 pc 2,299.00 2,299.00

Microwave 1 pc 3,650.00 3,650.00

KITCHEN TOOLS:

Measuring Cups 4 pcs 33.00 132.00

Mixing Bowl 2 pcs 90.00 180.00

Rolling Pin 1 pc 40.00 40.00

Half Sheet Pans 2 pcs 444.00 888.00

Cookie Scoops 3 pcs 14.00 42.00

Spatula 2 pcs 61.00 122.00


Total Amount Php 18,751.00

Booth/Stall Materials Quantity Unit Cost Amount


and Equipment

EQUIPMENTS:

Tent 1 pc 2,800.00 2,800.00

Table 2 pcs 1,000.00 2,000.00

Chair 4 pcs 300.00 1,200.00

Display Racks or Shelves 1 pcs 1500.00 1,500.00

MATERIALS:

Tablecloth 4 yd 60.00 240.00

Tarpaulin 2 pcs 500.00 1,000.00

You might also like