Financials For Small business

Please help with cash flow and balance sheets

2

>Sheet

1

1

1 1 1 2 2

0

$ 200,000

$ – 0

$ – 0

$ 3,000 $ 3,000

$ 6,000

$ 4,000 $ 6,000

$ 5,000 $ 1,000

$ 1,000

$ 110,000

$ 3,600

$ 6,000 $ 6,000

$ 360 $ 360 $ 500 $ 500

$ 600 $ 600 $ 600 $ 600

$ 2,000 $ 2,000 $ 4,000 $ 4,000

$ 1,000 $ 1,000 $ 1,000 $ 2,000 $ 2,000

$ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000

0 $ – 0 $ – 0 $ – 0 $ – 0

$ (11,133) $ 19,940 $ 37,640 $ 28,100 $ 45,400

% of Revenues

8%

Cassandra’s Pantry
YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5

Current Assets

Depreciation
Other

Cassandra’s Pantry
YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5

Depreciation

AR

USED IN

INVESTING ACTIVITIES

CASH

																																																																																																																								Income Statement
		Cassandra’s Pantry
		YE	AR			YEAR 2			YEAR 3			YEAR 4			YEAR 5
# of Company Concession Trucks
Product Revenue	$ 185,5	0		$ 200,000	$ 222,000	$ 341,000	$ 350,000
Service Revenue	$ 37,100	$ 40,000	$ 44,400	$ 68,200	$ 70,000
TOTAL REVENUE	$ 222,600	$ 240,000	$ 266,400	$ 409,200	$ 420,000
COST OF GOODS SOLD	$ 75,250	$ 85,000	$ 98,000	$ 180,000
GROSS PROFIT	$ 147,350	$ 155,000	$ 168,400	$ 229,200	$ 220,000
OPERATING EXPENSES
Vehicle Cost	$ 24,000							$ – 0	$ 28,000
Appliances	$ 4,123	$ 1,500						$ 1,000	$ 8,000			$ 500
Insurance			$ 3,000					$ 6,000
Repairs/Maintenance	$ 10,000									$ 4,000		$ 5,000
Marketing costs	$ 900	$ 5,500
Salaries	$ 104,900		$ 110,000	$ 130,500	$ 145,000
Gas		$ 3,600	$ 3,800
Internet			$ 360
Cell					$ 600
Licenses/other					$ 2,000
		Depreciation
TOTAL OPERATING EXPENSES	$ 154,483	$ 131,060	$ 126,760	$ 197,100	$ 170,600
	% of Revenues	69%	54.61%	47.5	8%	48%	41%
OPERATING INCOME	$ (7,133)	$ 23,940	$ 41,640	$ 32,100	$ 49,400
-3.85%	12%	18.76%	9.41%	14.11%
Interest Expense
Profits Before Taxes		$ (11,133)		$ 19,940		$ 37,640		$ 28,100		$ 45,400
Income Tax
Net Profits
-5%	14%	6.87%	10.81%
Balance Sheets
ASSETS
CURRENT ASSETS
Cash
Accounts Receivable
Inventories
	Other
Total Current Assets
PROPERTY/EQUIPMENT
TOTAL ASSETS
LIABILITIES & EQUITY
Accounts payable
Long-term liabilities
TOTAL LIABILITIES
Ownership Equity
Retained earnings
TOTAL EQUITY
TOTAL LIABILITY + EQUITY
Cash Flow Statement
OPERATING ACTIVITIES
NET Earnings
Inventory
Other Current assets
Accounts Payable
Other Current Liabilities
Net Cash Provided/
Used by Operating activities
	INVESTING ACTIVITIES
PROP/EQUIP
NET	CASH
FINANCING ACTIVITIES
Short Term Debt
Current LTD
Equity
NET CASH PROVIDED/
USED BY FINANCING
INCREASE/DECREASE IN
CASH AT BEGINNING OF YR
CASH AT END OF YR

Sheet2

Sheet3