PLEASE COMPLETE IN EXCEL WITH FORMULAS!!! Thanks!

Connch Republic Electronics is a midsized electronics manofactarer located in Key West, Florida. The company president is Shelley Couts, who inherited theccompany. When it was founded ever $70$ years ago, the company originally nepaired radios and ocher houschold appliances. Over the ycark, the company expanded into manulacturing and is now a repatable manubactarer of varions electronic iteme. Jay McCanless, a recent MBA gradaate, bas been hired by the company's finance department.

One of the major revenueprodacing items manufactured by Coesh Repulbic is a smartphone. Conch Republic currently has one smariphone model on the market, and sales have been eccellent. The smariphone is a unique item in that is comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with ary electronic item, technology chaages rapidly, and the current smartphone has limited featares in comparison with newer models. Conch Republic spent $$950,000$ to develop a prototype for a ncw smartphone that has all the featurcs of the evisting smartphone but adds now featates such as WhFi tetherine. The company has spent a further $$250,000$ for a marketing study to determine the expected sales flgures for the new smariphone.

Conch Republic can mamulacture the new smartphones for $$295$ each in variable costs. Fiwed costs for the operation are cstimated to ruas $$6\mathrm{.}9$ million per ycar. The estimated sales volume is $160,000,170,000,130,000,105,000,$ and $30,000$ per ycar for the neat flive years. respectively. The unit price of the new smartphone will the $$650.$ The necessary equipetent can be purchaved for $$49\mathrm{.}5$ millioen and will be depreciated on a seven$-$year MNCRS seliedule. It is helieved that the valae of the equipment in live years will be $$6\mathrm{.}8$ million.

As previously stated. Conch Republic currently manufactures a smariphone, Prodaction of the ecisling model is expected to be termisated in two years. If Conch Republic does not introduce the new semartphone, sales will be $95,000$ units and $65,000$ units for the sext two ycars, respectively. The price of the existing smartphone is $$595$ per unit, with variable costs of $$235$ cach and flixed costs of $$6\mathrm{.}9$ million per year. If Conch Republic does introduce the new smartphoees, sales of the existing smartphoee will fall by $30\mathrm{.}000$ units per ycar, and the price of the cxisting units will have to be lowerd to $5195$ cach. Net working capital for the smartphoses will be $20$As previously stated, Conch Republic currently manufactures a smartphone. Production of the existing model is expected to be termintalod in two years. If Concti Republic does not introduce the new smartphonc, sates with he $95,000$ units and $65,000$ units for the next two years, respectively. The price of the existing smartphone is $$595$ per unit, with variable costs of $$235$ cach and hised costs of $$6\mathrm{.}9$ million per year. If Conch Republic does introduce the new smartphone, sales of the existing smartphone will fall by $30,000$ units per year, and the price of the existing units will have to be lowered to $$325$ cach. Net working capital for the smartphones will be $20$ percent of sales and will occur with the timing of the cash flows for the year; for ecample, there is no initial outlay for NWC$,$ but changes in NWC will first occur in Year $1$ with the first year's sales. Conch Republic has a $21$ percent corporate tax rate and a required return of $12$ percent.EXCEL MASTER IT$!$ PROBLEM

For this Master Itt assignment, refer to the Conch Republic Electronics minicase below. For your convenience, we have entered the relevant values in the case such as the price and variable cost. For this project, answer the following questions:

a$.$ What is the profitability index of the project?

b$.$ What is the IRR of the project?

c$.$ What is the NPV of the project?

d$.$ At what price would Conch Republic Electronics be indilferent to accepting the projoct?

e$.$ At what level of variable costs per unit would Conch Republic Electronics be indifferent to accepting the project?