Question

		Vapor Trails Income Statement 2015				Vapor Trails Balance Sheet
		Sales	$18,750,000				2015	2014			2015	2014
		COGS	$15,375,000			Cash	$970,000	$840,000		A/P	$790,000	$610,000
		Depr	$1,100,000			A/R	$625,000	$595,000		Accruals	$216,000	$195,000
		EBIT	$2,275,000			Inventory	$1,650,000	$1,390,000		CurrentNotes Pay	$600,000	$400,000
		Interest	$120,000			Net Fixed Assets	$8,320,000	$8,100,000		LT Debt	$3,200,000	$3,200,000
		EBT	$2,155,000							Preferred	$500,000	$500,000
		Taxes	$797,350							Common Equity	$6,259,000	$6,020,000
		Net Income	$1,357,650
						Total Assets	$11,565,000	$10,925,000		Total Debt & Equity	$5,306,000	$4,905,000
		Information about Vapor Trails Securities
		Bonds				Preferred Stock
		3,200 5.4% Cpn, 22 yr maturity, priced @ 102.365				Shares Outstanding	5,000			WACC
		5,400 4.20% Cpn, 27 yr maturity, priced @ 99.856				Current Price	$96.48				Par Amount	Pmt	PV	FV	Nper	Value
						Coupon Rate	5.20%			Bonds
		Common Equity
		Shares Outstanding	216,000			Other Market Data
		Current Price	$72.15			Tax rate	37.00%			Pfd's
		Expected Dividend next yr	$1.70			Risk Free Rate of Return	1.00%
		Expected Dividend Growth	13.80%	For yr 2		Expected Market Return	11.60%			Common Stock
			12.10%	for yr 3 and 4		Beta	0.87
			10.90%	for yr 5		ROE	16.10%
			9.10%	for yr 6		Plowback	52.00%
			Constant after this
	Questions about Vapor Trails Corporation
										Points
1	Calculate the following Ratios for 2015
	Market Capitalization
	Debt to Equity
	Current ratio
	Days in Inventory
	Average Collection Period
2	Calculate each of the three components of DuPont and then provide ROE for the Company for 2015
			Profit Margin		Asset Turnover		Rquity Multiplier		Dupont
3	Calculate the Weighted Average Cost of Capital
		Show your calculations in the WACC Template beginning in Cell k18
4	Calculate the Value of a share of the Company's Stock, based on the expected dividend and CAPM information.
		NPV
	Calculate the NPV of the following 7yr project
5
		Project Life in yrs	7		Year		1	2	3	4	5	6	7
		Sales Forecast	$ 8,250,000		Growth Rates for Sales			17.25%	15.80%	13.45%	14.20%	11.60%	10.90%
		COGS as % of Sales	52.50%		Sales
		Cap Invest	$ 9,000,000		Cogs
		Salvage Value	$ 1,750,000		Depr
		Beg NWC	$ 470,000		EBIT
		NWC as % of Sales	1.05%		Taxes
		WACC	10.75%		Net Income
		Tax Rate	41.00%
		Rental Option/yr	$ 55,000
					Year	0
					OCF
		Life for Depr	9.00		Cap Invest
		Depr per yr			NWC
		Book Value at End			Salvage Value
					Opportunity Cost
					FCF
					NPV
6. Find the Expected Returns, Variance and Standard Deviations for the following Stock, Bond and combined Portfolio consisting of 63% stock and 37% bonds										13
		Scenario	Probability	Stocks	Bonds	Portfolio
		Recession	0.09	-12.10%	9.64%
		Weak Growth	0.21	-2.16%	6.10%
		Normal	0.56	9.75%	4.15%
		Boom	0.14	21.12%	-6.37%
			Exp Ret				Weights:
			Var				stocks
			Std Dev				bonds
7. You are going to buy a new home. Your new home will cost $275,000 and you have a down payment of $30,000. If the rate on the 30yr mortgage is 4.25%, what will be your monthly payment?
8. You will begin saving for retirement in a 401k account earning 9.93% with annual contributions of $8,500 for 35yrs. What will be the value of your 401k in 35 years? This is copy from excel template please calculate it for me and show me how to calculate. you can e-mail to [email protected]