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 15,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 45%/55% 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
Variable Costs
Fixed Costs
Depreciation
EBIT
Taxes
Net Income
EBIT
Depreciation
Taxes
OCF
Net Capital Spending
Cash Flow From Assets
Present Value
NPV (just put overall NPV in Year 0 column)
Profit Margin
EPS
Total Assets
Total Liabilities
Total Equity
ROA
ROE

WACC Computation:

*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.