Questions are based on the following mini$-$case: CGX Transmitters is developing a $2$nd generation optical transmitter. Somebody in your department worked on it and prepared a Pro$-$forma analysis but then he left the firm last week. You suspect that he was fired. The CEO needs the capital budget on his desk Wednesday morning because he senses that one of our major customers might be interested in an exclusive contract. She knows that you are taking FIN$305$W and that you can complete and correct the budget that the finance group started and she asks the CFO to assign you. You collect the following information:

$-$ The project will last for four years.

$-$ The initial investment in equipment is $$25$ million. The firm will use a straight$-$line depreciation schedule in years one to four, with the book value of the equipment going down from $$25$ million in year zero down to a book value of $$5$ million in year four. $($A colleague reminds you to not forget to use any remaining book value to reduce taxes on a potential re$-$sale at the end. He believes that the previous guy got canned for mistakes like this!$)$

$-$ The firm estimates that it will be able to sell the equipment $($and license the technology$)$ to another firm for $$10$ million in year four. This number does not include any potential taxes on this transaction.

$-$ The firm spent $$12\mathrm{.}5$ million on R&D last year to research the technology behind the $2$nd generation transmitter.

$-$ If you undertake this project, operating income before tax of the $1$st generation optical transmitter will decline by an annual amount of $$1\mathrm{.}2$ million for each of the next four years.

$-$ The accounting department will assign $$1$ million in administration costs per year for years one to four. You check with them, and they give you the following breakdown: $$175,000$ a year for accounting services to produce paperwork necessary to run the project and comply with federal and state regulations, and $$825,000$ towards the overall costs of maintaining the firm$$s headquarters. Even though the headquarters will not be involved with running this project, they argue that the cost of the headquarters has to be spread over all existing projects.

$-$ The tax rate is $34\%.$ The cost of capital is $9\mathrm{.}5\%.$ Assume that the firm$$s other projects yield a positive income before tax.

The transmitter is expected information is compiled by accounting department:

Year Units Sold

$00$ units

$11\mathrm{.}6$ million units

$22\mathrm{.}4$ million units

$32\mathrm{.}9$ million units

$40\mathrm{.}8$ million units

to sell for $$11\mathrm{.}50$ with a per$-$unit variable cost of $$4\mathrm{.}20.$ The following sales the marketing department $($in $ million$)$ and net working capital by the

Net working capital $$1\mathrm{.}1$ million

$$2\mathrm{.}7$ million

$$4\mathrm{.}4$ million

$$2\mathrm{.}5$ million $$0$

Hence, the sales in year one will be worth $$18\mathrm{.}40$ million $(1\mathrm{.}6$ million units $*$ $$11\mathrm{.}50$ sale price$)$ and the COGS in year one will be $$6\mathrm{.}72$ million $(1\mathrm{.}6$ million units $*$ $$4\mathrm{.}20$per unit cost$).$ Similarly, you need to compute the dollar amount of sales and COGS in years two to year four.

$2$

Extra Credit Project For FIN$305$W$,$ Fall $2023$

Question $1(60$ points$)$

Take the completed Pro$-$forma analysis and correct all mistakes.

Carefully read the case. Use the provided Pro$-$forma analysis and correct all the mistakes your colleague made. For your answer, provide the completed Pro$-$forma analysis with the project OCF, taxes, capital investment, side effects, and project net cash flow in years $0,1,2,3,$ and $4.$ Provide all columns and highlight in yellow your final net cash flow answers. The Pro$-$forma analysis should be performed in the same spreadsheet, with well$-$organized, complete, and readable printouts so that it can be passed by to the CFO$$s desk tomorrow COB, and sent to the CEO shortly.

Question $2(20$ points$)$

What is the NPV of the project? What is the project$$s IRR? Should the project be started?

Question $3(30$ points$)$

The firm was also approached by a military agency. They are proposing a government contract that will give the exclusive rights of the product to the military. They want to know at what price you can deliver the same quantities to the military and not sell any on the open market.

$($A$)$ The CEO asks for the contract bid price $($i$.$e$.$ the price per unit$)$ that will guarantee the project makes sense financially.

$($B$)$ The CEO also wants to know at what bid price the project will bring in $$1$ million in present value to the company.