Altitude Inc. hires you as a consultant, manufacturers of fine personalized drone. The market for

drones is growing quickly. The firm purchased some land three years ago for $$1\mathrm{.}58$ million

expecting to use it as a toxic waste dump site. Few months ago Altitude Inc. hired another firm to

dispose of all toxic materials. Based on a recent appraisal, the firm believes the current market

value of the land for $$1\mathrm{.}75$ million on an after$-$tax basis. In four years, the land could be sold for

$$1\mathrm{.}98$ million after taxes. The land will be utilized for the project.

The firm also hired a marketing firm to analyze the personalized drone market, at a cost of

$$298,000.$ An excerpt of the marketing report is as follows:

The flying car industry will have a rapid expansion in the next four years. With the brand name

recognition that Altitude brings to bear, we feel that the company will be able to sell $5,800,6,500,$

$6,700,$ and $5,600$ units each year for the next four years, respectively. Again, capitalizing on the

name recognition of Altitude, we feel that a premium price of $$840$ can be charged for each

personalized drone. Because these drones appear to be a fad, we feel at the end of the four$-$year

period, sales should be discontinued.

Altitude believes that fixed costs for the project will be $$560,000$ per year, and variable costs are

$10$ percent of sales. The equipment necessary for production will cost $$6\mathrm{.}9$ million and will be

depreciated according to a three$-$year MACRS schedule. At the end of the project, the equipment

can be sold at a salvage value of $$2,650,000.$ Net working capital of $$264,000$ will be required

immediately. Altitude Inc. has a $21$ percent tax rate, and the required return on the project is $16$

percent.

Three vear MACRS Schedule

$1.33\mathrm{.}33\%$

$2.44\mathrm{.}45\%$

$3.14\mathrm{.}81\%$

$4.7\mathrm{.}41\%$

What is the NPV of the project? Based on the NPV would you accept or reject this project?

What is the IRR of the project? Based on the IRR would you accept or reject this project?

What is the discounted payback? Based on the discounted payback would you accept or reject

this project if the required payback is $3$ years.

Using the different criteria above, would you recommend selecting or rejecting the project?

SHOW ALL YOUR CALCULATION IN AN EXCEL SHEET.