Nothing Special   »   [go: up one dir, main page]

Business Plan (Bigasan)

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

SECTION 2.

FINANCIAL DATA

a. Source and Application for funding

b. Capital Equipment list

Item Amount Expected life Cost Depreciation


EIGHTSYS Electronic cash register 1 pc. 5 years PHP 10,500.00 PHP 2,100.00
WORLD STANDARD weighing scale 1 pc. 5 years 3,000.00 600.00
Metal scoop 1 pc. 5 years 500.00 100.00
Wooden rice storage box 1 set 5 years 8,000.00 1,600.00
Yale brass padlocks 2 pc. 5 years 500.00 100.00
Metal trolley 1 pc. 5 years 300.00 60.00
Total Equipment PHP 22,500.00 PHP 4,560.00
c. Balance Sheet

Bigasan ni Buday Balance Sheet


   
Assets
Current assets: Beginning of First Year
Cash ₱ 174,500.00
Inventories -
Pre-paid expenses 3,000.00
Other -
Total current assets ₱ 177,500.00

Fixed assets: Beginning of First Year


Equipment ₱ 22,500.00
Accumulated depreciation -
Total fixed assets ₱ 22,500.00

Total assets ₱ 200,000.00


 
Liabilities and owner's equity
Current liabilities: Beginning of First Year
Accounts payable -
Accrued wages -
Accrued compensation -
Income taxes payable -
Other -
Total current liabilities -

Long-term liabilities: Beginning of First Year


Loans Payable ₱ 100,000.00
Interest Payable
Total long-term liabilities ₱ 100,000.00

Owner's equity: Beginning of First Year


Investment capital ₱ 100,000.00
Accumulated retained earnings -
Total owner's equity ₱ 100,000.00

Total liabilities and owner's equity ₱ 200,000.00

d. Break-even Analysis
BREAKEVEN ANALYSIS
VARIABLE COSTS COST % FIXED COSTS COSTS
Salaries (Includes Payroll
Cost of Goods Sold 90.0% ₱ 21,600.00
Taxes)
Sales Returns, Allowances, and
2.0% Marketing and Advertising 1,000.00
Discounts
Total 92.0% Rent 15,000.00
Insurance 250.00
Utilities 100.00
Interest 1,000.00
Depreciation 380.00

Total ₱ 39,330.00

 
BREAKEVEN SALES LEVEL/month ₱ 491,625.00

BREAKEVEN SALES LEVEL/year ₱ 5,899,500.00


e. Income Projection

The first year of operation

Income Projection            
Bigasan ni Buday Rice Trading PHP
             

REVENUE 1st Month 2nd Month 3rd Month 4th Month 5th Month 6th Month
300,000.0 400,000.0 460,000.0 465,000.0 490,000.0 500,000.0
Estimated Product Sales
0 0 0 0 0 0
(6,000.00 (8,000.00 (9,200.00 (9,300.00 (9,800.00 (10,000.00
Less Sales Returns & Discounts
) ) ) ) ) )
Service Revenue - - - - - -
Other Revenue - - - - - -
294,000.0 392,000.0 450,800.0 455,700.0 480,200.0 490,000.0
Net Sales
0 0 0 0 0 0
270,000.0 360,000.0 414,000.0 418,500.0 441,000.0 450,000.0
Cost of Goods Sold
0 0 0 0 0 0
24,000.0 32,000.0 36,800.0 37,200.0 39,200.0 40,000.0
Gross Profit
0 0 0 0 0 0
             

EXPENSES 1st Month 2nd Month 3rd Month 4th Month 5th Month 6th Month
21,600.0 21,600.0 21,600.0
Salaries & Wages 21,600.00 21,600.00 21,600.00
0 0 0
Marketing/Advertising 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
15,000.0 15,000.0 15,000.0
Rent 15,000.00 15,000.00 15,000.00
0 0 0
Insurance expense 250.00 250.00 250.00 250.00 250.00 250.00
Utilities expense 100.00 100.00 100.00 100.00 100.00 100.00
Depreciation expense 380.00 380.00 380.00 380.00 380.00 380.00
Interest expense 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
39,330.0 39,330.0 39,330.0 39,330.0 39,330.0 39,330.0
Total Expenses
0 0 0 0 0 0
(15,330.00 (7,330.00 (2,530.00 (2,130.00 (130.00
Income Before Taxes 670.00
) ) ) ) )
(2,299.50 (1,099.50 (379.50 (319.50 (19.50
Income Tax Expense 100.50
) ) ) ) )
             

(17,629.5 (6,230.5 (2,150.5 (1,810.5 (110.5 569.5


NET INCOME
0) 0) 0) 0) 0) 0
             
The first year of operation (continuation)

Income Projection              
Bigasan ni Buday Rice Trading PHP
 
             

REVENUE 7th Month 8th Month 9th Month 10th Month 11th Month 12th Month YTD
500,000.0 500,000.0 450,000.0 530,000.0 660,000.0 745,000.0 6,000,000.0
Estimated Product Sales
0 0 0 0 0 0 0
(10,000.0 (10,000.0 (9,000.0 (10,600.0 (13,200.0 (14,900.0 (120,000.0
Less Sales Returns & Discounts
0) 0) 0) 0) 0) 0) 0)
Service Revenue - - - - - - -
Other Revenue - - - - - - -
490,000.0 490,000.0 441,000.0 519,400.0 646,800.0 730,100.0 5,880,000.0
Net Sales
0 0 0 0 0 0 0
450,000.0 450,000.0 405,000.0 477,000.0 594,000.0 670,500.0 5,400,000.0
Cost of Goods Sold
0 0 0 0 0 0 0
40,000.0 40,000.0 36,000.0 42,400.0 52,800.0 59,600.0 480,000.0
Gross Profit
0 0 0 0 0 0 0
 
             

EXPENSES 7th Month 8th Month 9th Month 10th Month 11th Month 12th Month YTD
259,200.0
Salaries & Wages
21,600.00 21,600.00 21,600.00 21,600.00 21,600.00 21,600.00 0
12,000.0
Marketing/Advertising
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 0
180,000.0
Rent
15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 0
Insurance expense 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
Utilities expense 100.00 100.00 100.00 100.00 100.00 100.00 1,200.00
Depreciation expense 380.00 380.00 380.00 380.00 380.00 380.00 4,560.00
12,000.0
Interest expense
1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 0
39,330.0 39,330.0 39,330.0 39,330.0 39,330.0 39,330.0 471,960.0
Total Expenses
0 0 0 0 0 0 0
(3,330.0 13,470.0 20,270.0 8,040.0
Income Before Taxes
670.00 670.00 0) 3,070.00 0 0 0
(499.50 1,206.0
Income Tax Expense
100.50 100.50 ) 460.50 2,020.50 3,040.50 0
 
             

569.5 569.5 (2,830.5 2,609.5 11,449.5 17,229.5 6,834.0


NET INCOME
0 0 0) 0 0 0 0
 
             
The Second Year of Operation

Income Projection          
Bigasan ni Buday Rice Trading PHP
           

REVENUE Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Estimated Product Sales 1,350,000.00 1,590,000.00 1,980,000.00 2,235,000.00 7,155,000.00
(27,000.00 (31,800.00 (39,600.00 (44,700.00 (143,100.00
Less Sales Returns & Discounts
) ) ) ) )
Service Revenue - - - - -
Other Revenue - - - - -
Net Sales 1,323,000.00 1,558,200.00 1,940,400.00 2,190,300.00 7,011,900.00
Cost of Goods Sold 1,215,000.00 1,431,000.00 1,782,000.00 2,011,500.00 6,439,500.00
Gross Profit 108,000.00 127,200.00 158,400.00 178,800.00 572,400.00
           

EXPENSES Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Salaries & Wages 21,600.00 21,600.00 21,600.00 21,600.00 86,400.00
Marketing/Advertising 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Rent 15,000.00 15,000.00 15,000.00 15,000.00 60,000.00
Insurance expense 250.00 250.00 250.00 250.00 1,000.00
Utilities expense 300.00 300.00 300.00 300.00 1,200.00
Depreciation expense 1,140.00 1,140.00 1,140.00 1,140.00 4,560.00
Interest expense 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Total Expenses 40,290.00 40,290.00 40,290.00 40,290.00 161,160.00
Income Before Taxes 67,710.00 86,910.00 118,110.00 138,510.00 411,240.00
Income Tax Expense 10,156.50 13,036.50 17,716.50 20,776.50 61,686.00
           

57,553.5 86,449.5 116,089.5 135,469.5 410,034.0


NET INCOME
0 0 0 0 0
           

The Third Year of Operation


Income Projection          
Bigasan ni Buday Rice Trading PHP
           

REVENUE Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Estimated Product Sales 1,552,500.00 1,828,500.00 2,277,000.00 2,570,250.00 8,228,250.00
(31,050.00 (36,570.00 (45,540.00 (51,405.00 (164,565.00
Less Sales Returns & Discounts
) ) ) ) )
Service Revenue - - - - -
Other Revenue - - - - -
Net Sales 1,521,450.00 1,791,930.00 2,231,460.00 2,518,845.00 8,063,685.00
Cost of Goods Sold 1,397,250.00 1,645,650.00 2,049,300.00 2,313,225.00 7,405,425.00
Gross Profit 124,200.00 146,280.00 182,160.00 205,620.00 658,260.00
           

EXPENSES Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Salaries & Wages 21,600.00 21,600.00 21,600.00 21,600.00 86,400.00
Marketing/Advertising 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Rent 15,000.00 15,000.00 15,000.00 15,000.00 60,000.00
Insurance expense 250.00 250.00 250.00 250.00 1,000.00
Utilities expense 300.00 300.00 300.00 300.00 1,200.00
Depreciation expense 1,140.00 1,140.00 1,140.00 1,140.00 4,560.00
Interest expense 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Total Expenses 40,290.00 40,290.00 40,290.00 40,290.00 161,160.00
Income Before Taxes 83,910.00 105,990.00 141,870.00 165,330.00 497,100.00
Income Tax Expense 12,586.50 15,898.50 21,280.50 24,799.50 74,565.00
           

71,323.5 105,529.5 139,849.5 162,289.5 495,894.0


NET INCOME
0 0 0 0 0
           

The Fourth Year of Operation


Income Projection          
Bigasan ni Buday Rice Trading PHP
           

REVENUE Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Estimated Product Sales 1,782,500.00 2,102,200.00 2,618,550.00 2,955,780.00 9,459,030.00
(35,650.00 (42,044.00 (52,371.00 (59,115.60 (189,180.60
Less Sales Returns & Discounts
) ) ) ) )
Service Revenue - - - - -
Other Revenue - - - - -
Net Sales 1,746,850.00 2,060,156.00 2,566,179.00 2,896,664.40 9,269,849.40
Cost of Goods Sold 1,604,250.00 1,891,980.00 2,356,695.00 2,660,202.00 8,513,127.00
Gross Profit 142,600.00 168,176.00 209,484.00 236,462.40 756,722.40
           

EXPENSES Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Salaries & Wages 21,600.00 21,600.00 21,600.00 21,600.00 86,400.00
Marketing/Advertising 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Rent 15,000.00 15,000.00 15,000.00 15,000.00 60,000.00
Insurance expense 250.00 250.00 250.00 250.00 1,000.00
Utilities expense 300.00 300.00 300.00 300.00 1,200.00
Depreciation expense 1,140.00 1,140.00 1,140.00 1,140.00 4,560.00
Interest expense 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Total Expenses 40,290.00 40,290.00 40,290.00 40,290.00 161,160.00
Income Before Taxes 102,310.00 127,886.00 169,194.00 196,172.40 595,562.40
Income Tax Expense 15,346.50 19,182.90 25,379.10 29,425.86 89,334.36
           

86,963.5 127,425.5 167,173.5 193,131.9 594,356.4


NET INCOME
0 0 0 0 0
           
The Fifth Year of Operation

Income Projection          
Bigasan ni Buday Rice Trading PHP
           

REVENUE Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Estimated Product Sales 2,049,875.00 2,417,300.00 3,010,700.00 3,250,150.00 10,728,025.00
(40,997.50 (48,346.00 (60,214.00 (65,003.00 (214,560.50
Less Sales Returns & Discounts
) ) ) ) )
Service Revenue - - - - -
Other Revenue - - - - -
Net Sales 2,008,877.50 2,368,954.00 2,950,486.00 3,185,147.00 10,513,464.50
Cost of Goods Sold 1,844,887.50 2,175,570.00 2,709,630.00 2,925,135.00 9,655,222.50
Gross Profit 163,990.00 193,384.00 240,856.00 260,012.00 858,242.00
           

EXPENSES Quarter 1 Quarter 2 Quarter 3 Quarter 4 YTD


Salaries & Wages 21,600.00 21,600.00 21,600.00 21,600.00 86,400.00
Marketing/Advertising 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Rent 15,000.00 15,000.00 15,000.00 15,000.00 60,000.00
Insurance expense 250.00 250.00 250.00 250.00 1,000.00
Utilities expense 300.00 300.00 300.00 300.00 1,200.00
Depreciation expense 1,140.00 1,140.00 1,140.00 1,140.00 4,560.00
Interest expense 1,000.00 1,000.00 1,000.00 1,000.00 4,000.00
Total Expenses 40,290.00 40,290.00 40,290.00 40,290.00 161,160.00
Income Before Taxes 123,700.00 153,094.00 200,566.00 219,722.00 697,082.00
Income Tax Expense 18,555.00 22,964.10 30,084.90 32,958.30 104,562.30
           

105,145.0 152,633.5 198,545.5 216,681.5 695,876.0


NET INCOME
0 0 0 0 0
           
Notes of Explanation

You might also like