Genesis Capital Plan Report

capital_budget.xls

Sheet1

Genesis WACC
Item	Amount ($000)	%	Interest	Weighted
		Total	Rate	Rate
Accounts Payable	300,000	7.50%
Short-term Note Payable	100,000	2.50%
Total Current Liabilities	400,000
Long-term Note Payable	400,000	10.00%
Mortgage Payable	1,200,000	30.00%
Total Liabilites	1,600,000
Common Stock Equity	1,500,000	37.50%
Operating Equity	500,000	12.50%
Total Liabilities and Equity	4,000,000	100.00%
Genesis Captial Projects
	Initial Investment	Cash Flow	Cash Flow	Cash Flow	Cash flow	Cash Flow	Cashflow
		Y1	Y2	Y3	Y4	Y5	Y6-10
Project A: 25-emp facility	2000	-200	-300	-400	200	400	1000
Project B: 40-emp facility	2500	-200	-200	100	400	400	1500
Project C: 75-emp facility	3000	-300	-400	-100	600	700	2000
Equipment 1 - fully automatic	1500	-100	100	200	400	200	800
Equipment 1 - semi-automatic	1000	-50	-100	200	200	300	600
Equipment 1 - manual	750	150	150	150	150	150	750
Equipment 2 - Standard	800	-175	200	250	250	300	700
Equipment 2 - top of line	1500	-100	275	325	325	325	1500
Equipment 3 - 3-man machine	700	-200	-150	250	300	350
Equipment 3 - 2-man machine	600	-175	-100	175	175	175
Equipment 3 - 5-man machine	750	-300	-200	300	400	400
In-house inspection	1800	100	500	500	300	300	800
Contract inspection		200	200	200	100	100