buss599assignment 4

assignemt321foreverFINANCIALS.xlsx

21 ForEver

		YEAR ONE FINANCIAL FOR 21 ForEver
	Pre-operational Cost					Working Capital
						Current Assets		Value
Item	Cost ($)					Cash balances		$7,500
License	$120					Debtors		$4,000
Premise Rent	$300					Inventory		$3,500
Advertisement	$80					Fixed Assets		$1,500
Equipment	$3,790					Total Current Assets		$16,500
Starting stock	$5,000
Electricity	$400					Current Liabilities
Total	$9,690					Creditors		$5,500
						Tax		$4,700
						Total Current Liabilities		$10,200
						Working Capital		$6,300
		Cash Flow Statement
Cash Inflow	Jan	Feb	March	April	May	June	July	August	Sep	Oct	Nov	Dec	Totals
Total sales	$3,000	$3,200	$3,500	$4,000	$3,100	$3,300	$3,000	$4,200	$3,700	$3,500	$3,800	$4,500	$42,800
Debts collected	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$9,600
Injected Capital	$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
Total Cash Inflow													$64,400
Cash Outflow
Total Purchases	$1,000	$950	$800	$900	$870	$910	$860	$1,200	$950	$750	$980	$900	$11,070
Credit repaid	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$1,050	$12,600
Electricity	$200	$200	$200	$200	$200	200	$200	$200	$200	$200	$200	$200	$2,400
Rent	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$300	$3,600
Transportation	$60	$47	$70	$36	$50	$30	$41	$87	$55	$35	$40	$100	$651
Maintainance	$150	$150	$150	150	$150	$150	$150	$150	150	$150	150	$150	$1,800
Salaries	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$1,200	$14,400
Total Cash Outflow													$46,521
Net Cash Balances													$17,879