P4

fs_examples.xls

Inc St - Table 1


PROJECTED INCOME STATEMENTS
For The Period Ending:
		Year 1	Year 2	Year 3
GROSS REVENUES
	Beer	$77,500
	Liquor	$21,250
	Food	$18,750
	Soda/Snacks	$2,500
	Other Sales	$5,000
TOTAL GROSS REVENUES
COST OF GOODS
	Beer
	Liquor
	Food
	Soda/Snacks
TOTAL COST OF GOODS
GROSS PROFIT
CASH PAID OUT
	Wages	$6,000
	Payroll Taxes
	Equipment Rental	$200
	Insurance	$4,600
	Water Test/Other License	$250
	Music/Entertainment	$15,000
	Office Supplies/Postage	$250
	Legal/Accounting	$600
	Building/Equipment Repairs	$1,500
	Janitorial/Tap Cleaning	$1,000
	Supplies	$2,000
	Property Tax	$2,180
	Cable	$480
	Heat/Coal	$1,000
	Electric	$6,000
	Propane	$1,440
	Pest Control	$216
	Telephone	$960
	Security System	$216
	Septic Service	$250
	Snow Plowing	$175
	Trash	$648
	Depreciation
	Amortization	$200	$200	$200
	Interest Expense	$10,013	$9,757	$9,483
	Miscellaneous
TOTAL EXPENSES
NET INCOME


PROJECTED ANNUAL CASH FLOW STATEMENT
For the Period Ending:
	LOAN CLOSING	End Year 1	End Year 2	End Year 3
CASH FLOWS FROM OPERATING ACTIVITIES
Net Income
Add: Depreciation & Amortization
(Inc) Dec in Inventory
(Inc) Dec in Prepaid Expenses
(Inc) Dec in Other Assets		$200	$200	$200
NET CASH FLOWS FROM OPERATING ACTIVITIES
INVESTING ACTIVITIES
Purchase of fixed assets	($147,500)
Sale of fixed assets		$0	$0	$0
TOTAL FROM INVESTING
CASH FLOWS FROM FINANCING ACTIVITIES
Receipt of Long Term Debt	$150,000
Payment of Long Term Debt		($3,674)	($3,930)	($4,203)
Net Receipt (Decrease) in Line of Credit
Equity Injection
Proprietor's Withdrawals
TOTAL FROM FINANCING ACTIVITIES
NET INCREASE (DECREASE) IN CASH
CASH BALANCE BEGINNING	$1,200
CASH BALANCE ENDING


PROJECTED BALANCE SHEETS
For the Period Ending:
	At Closing	End Year 1	End Year 2	End Year 3
ASSETS
CURRENT ASSETS
Cash
Accounts Receivable
Inventory	$4,000	$4,000	$4,000	$4,000
Prepaid Expenses
TOTAL CURRENT ASSETS
Fixed Assets
Less Accumulated Depreciation	$0
NET FIXED ASSETS
Other Assets	$2,000	$1,800	$1,600	$1,400
TOTAL ASSETS
LIABILITIES AND OWNER'S EQUITY
CURRENT LIABILITIES
Accounts Payable
Credit Line
CMLTD - New SBA loan	$3,674	$3,930	$4,203	$4,496
TOTAL CURRENT LIABILITIES
LONG-TERM LIABILITIES
New SBA loan
TOTAL LONG-TERM LIABILITIES
TOTAL LIABILITIES
PROPRIETOR'S CAPITAL
TOTAL LIABILITIES AND EQUITY


STATEMENT OF PROPRIETOR'S CAPITAL
For the Period Ending:
	At Closing	End Year 1	End Year 2	End Year 3
Proprietor's Capital - Beginning	$ - 0
Add: Capital injections by proprietor	$ 38,200
Net Income (Loss)
Less: Withdrawals by proprietor
Net Change in Propreitor's Capital
Proprietor's Capital - Ending

Assumptions

Yearly increase of 10%

Costs of goods = industry average

Rent property versus buy

Wages = one part time individual working at 8.50 for 10 hours a week

etc…