Determine the npv for fairways driving range

Reference no: EM131545865

The following information pertains to Fairways Driving Range, Inc.:

The company is considering operating a new driving range facility in Sanford, FL. In order to do so, they will need to purchase a ball dispensing machine, a ball pick-up vehicle and a tractor and accessories for a total cost of $100,000. All of this depreciable equipment will be 7-year MACRS property. The project is expected to operate for 6 years, at the end of which the equipment will be sold for 25% of its original cost. Fairways expects to have $30,000 of fixed costs each year other than depreciation. These fixed costs include the cost of leasing the land for the driving range.

Fairways expects to have sales for the first year of $100,000 based on renting 20,000 buckets of balls @ $5 per bucket. For years 2-6, they expect the number of buckets rented to steadily increase by 1,000 buckets per year, while the price will remain constant @ $5. Expenditures needed for buckets and balls each year are expected to be 20% of the gross revenues for the year.
Fairways will be in the 34% tax bracket for all years in question.

The company has a required capital structure of 40% debt and 60% equity. They can issue new bonds to yield 5%. With respect to equity, the company's beta is 1.60, the expected return on the market is 10% and the risk free rate is 4%. Use this information to compute the company's WACC and then use the WACC as the required return for this project.

Please complete the following tables to determine the NPV for Fairways Driving Range, Inc.'s proposed Sanford venture. PLEASE ROUND ALL FIGURES TO THE NEAREST WHOLE DOLLAR!

For each year of the project, compute the profit margin and EPS (assuming that the firm has 10,000 shares of stock outstanding). Besides the net value of the fixed assets, the company also expects to have $20,000 of other assets. Compute the total assets for each year, use the 40%/60% ratio to determine the total amounts of liability and equity for each year, and use those figures to compute ROA and ROE for each year.

Based on your financial analysis, prepare a paragraph or so of a summary from the stand point of a consultant. In this summary, provide your ideas about this project and what you think would be the best course of action for the company to follow and why. Remember to justify your answers with facts from your calculations as well as provide meaningful insight for the company.

	0*	1	2	3	4	5	6
Sales		$100,000	$105,000	$110,000	$115,000	$120,000	$125,000
Variable Costs		-$20,000	-$21,000	-$22,000	-$23,000	-$24,000	-$25,000
Fixed Costs		-$30,000	-$30,000	-$30,000	-$30,000	-$30,000	-$30,000
Depreciation		-$14,290	-$24,490	-$17,490	-$12,490	-$8,930	-$8,920
EBIT		$55,710	$50,510	$62,510	$72,510	$81,070	$97,690
Taxes		-$18,941	-$17,173	-$21,253	-$24,653	-$27,564	-$33,215
Net Income		$36,769	$33,337	$41,257	$47,857	$53,506	$64,475
EBIT		$55,710	$50,510	$62,510	$72,510	$81,070	$97,690
Depreciation		$14,290	$24,490	$17,490	$12,490	$8,930	$8,920
Taxes
OCF		$51,059	$57,827	$58,747	$60,347	$62,436	$61,785
Net Capital Spending	-$100,000
Cash Flow From Assets	-$100,000
Present Value	-$100,000
NPV (just put overall NPV in Year 0 column)
Profit Margin
EPS
Total Assets	$120,000
Total Liabilities
Total Equity
ROA
ROE

WACC Computation: (.4 X .033) + (.6 X .136) After taxCost of equity

.0132 + .0816 .05 X (1-.34) .04 + 1.6 X (.1-.04)

.0948 = 9.48% .05 X .66 = .033 .04 + 1.6 X .06

.04 + .096

.136

*The only amounts that you will have for year 0 will be Net Capital Spending, Cash Flow from Assets, Present Value and the overall NPV.

Reference no: EM131545865

Questions Cloud

Market capitalization of southwest airlines : During the early years of the recovery from the 2008 recession, the market capitalization of Southwest Airlines was $5.4 billion.

Define difficulties encountered by early jamestown colony : Popular history has imbued King James and John Smith with larger than life status for their roles establishing a wilderness settlement in Virginia.

How two english land grants dominated central part of coast : By the 1620s, the French, the Dutch, the English, and the Spanish all had settlements in North America. For your initial post, discuss how the English people.

A frim with fix rate debt that expects interest rates : A frim with fix rate debt that expects interest rates to fall may engage in a swap agreement to:

Determine the npv for fairways driving range : Based on your financial analysis, prepare a paragraph or so of a summary from the stand point of a consultant - provide your ideas about this project

Balance sheet shows the outstanding common stock amount : Zedtel Corporation’s Balance sheet shows the outstanding common stock amount to be AED 54,758,000.

Discuss about the financial condition ratio : Examine your findings and determine whether your company outperforms its competition based on financial ratios. Identify where your firm seems to lag.

Appropriate balance between government efforts : What is the appropriate balance between government efforts to improve health behaviors and reliance on individual responsibility?

Identify and explain the benefit and burden of the ed : Identify and explain the benefit and burden of the ED in terms of reimbursement and nonreimbursable services. Identify a potential solution to the problem.

User Account

All Pages