Business plan

profiler.godoy94
AQua.xlsx
Home>Business & Finance homework help>Economics homework help>Business plan

Sheet1

Managerial Budget Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Annual
Revenue (forecast) 1st Qtr 2nd Qtr 3rd Qtr 4Qtr
Initial Start Up Capital $0
Revenue Stream 1 $3,000 $3,000 $3,000 $3,000 $5,000 $5,000 $6,000 $6,000 $7,000 $7,000 $8,000 $56,000
Est. Monthly Revenue $0 $3,000 $3,000 $3,000 $3,000 $5,000 $5,000 $6,000 $6,000 $7,000 $7,000 $8,000 $56,000
Expenses (forecast) Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Annual
CEO $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $39,960
Accountant $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $7,200
Employee 1 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000
Employee 2 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000
Insurance $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $18,000
Marketing $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600
Rent of bodega $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $5,400
Rent of Machinerary $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $10,800
Platic bottle $150 $150 $150 $150 $150 $250 $250 $300 $300 $350 $350 $400 $2,950
Cost of water $300 $300 $300 $300 $300 $600 $600 $900 $900 $1,050 $1,050 $1,200 $7,800
Est. Monthly Expenses $8,530 $8,530 $8,530 $8,530 $8,530 $8,930 $8,930 $9,280 $9,280 $9,480 $9,480 $9,680 $107,710
Monthly Net Revenue -$8,530 -$5,530 -$5,530 -$5,530 -$5,530 -$3,930 -$3,930 -$3,280 -$3,280 -$2,480 -$2,480 -$1,680 -$55,100
Cash On Hand $41,470 $35,940 $30,410 $24,880 $19,350 $15,420 $11,490 $8,210 $4,930 $2,450 -$30 -$1,710 -$3,390

Sheet2

Managerial Budget Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Annual
Revenue (forecast) 1st Qtr 2nd Qtr 3rd Qtr 4Qtr
Initial Start Up Capital $0
Revenue Stream 1 $8,000 $10,000 $10,000 $10,000 $11,000 $12,000 $12,000 $13,000 $13,000 $14,000 $14,000 $14,000 $141,000
Est. Monthly Revenue $8,000 $10,000 $10,000 $10,000 $11,000 $12,000 $12,000 $13,000 $13,000 $14,000 $14,000 $14,000 $141,000
Expenses (forecast) Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Annual
CEO $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $39,960
Accountant $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000
Employee 1 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Employee 2 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Employee 3 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Employee 4 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Insurance $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $18,000
Marketing $800 $800 $800 $800 $800 $800 $800 $800 $1,000 $1,000 $1,000 $1,000 $10,400
Rent of bodega $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $5,400
Rent of bodega 2 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $5,400
Rent of Machinerary $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $10,800
Platic bottle $400 $500 $500 $500 $550 $600 $600 $650 $650 $700 $700 $700 $7,050
Cost of water $1,200 $1,500 $1,500 $1,500 $1,650 $1,800 $1,800 $1,950 $1,950 $2,100 $2,100 $2,100 $21,150
Est. Monthly Expenses $12,830 $13,230 $13,230 $13,230 $13,430 $13,630 $13,630 $13,830 $14,030 $14,230 $14,230 $14,230 $163,760
Monthly Net Revenue -$4,830 -$3,230 -$3,230 -$3,230 -$2,430 -$1,630 -$1,630 -$830 -$1,030 -$230 -$230 -$230 $4,250
Cash On Hand $45,170 $41,940 $38,710 $35,480 $33,050 $31,420 $29,790 $28,960 $27,930 $27,700 $27,470 $27,240 $27,010

Sheet3

Managerial Budget Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Annual
Revenue (forecast) 1st Qtr 2nd Qtr 3rd Qtr 4Qtr
Initial Start Up Capital $0
Revenue Stream 1 $14,000 $15,000 $15,000 $16,000 $11,000 $12,000 $12,000 $13,000 $13,000 $14,000 $14,000 $14,000 $163,000
Est. Monthly Revenue $14,000 $15,000 $15,000 $16,000 $11,000 $12,000 $12,000 $13,000 $13,000 $14,000 $14,000 $14,000 $163,000
Expenses (forecast) Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Annual
CEO $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $3,330 $39,960
Accountant $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000
Employee 1 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Employee 2 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Employee 3 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Employee 4 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $8,400
Insurance $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $18,000
Marketing $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000
Rent of bodega $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $5,400
Rent of bodega 2 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $5,400
Rent of Machinerary $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $10,800
Platic bottle $700 $750 $750 $800 $550 $600 $600 $650 $650 $700 $700 $700 $8,150
Cost of water $2,100 $2,250 $2,250 $1,500 $1,650 $1,800 $1,800 $1,950 $1,950 $2,100 $2,100 $2,100 $23,550
Est. Monthly Expenses $14,230 $14,430 $14,430 $13,730 $13,630 $13,830 $13,830 $14,030 $14,030 $14,230 $14,230 $14,230 $168,860
Monthly Net Revenue -$230 $570 $570 $2,270 -$2,630 -$1,830 -$1,830 -$1,030 -$1,030 -$230 -$230 -$230 $38,050
Cash On Hand $49,770 $50,340 $50,910 $53,180 $50,550 $48,720 $46,890 $45,860 $44,830 $44,600 $44,370 $44,140 $43,910