please read instruction carefully. page 1 to 3

Instructions: Return this cover sheet with the final answers and attach excel solutions for each problem and highlight in yellow your final answer at the end of each solution. You will get partial credit. Make sure to submit complete and readable tables. Just providing the correct final number would not give you a full score! You can work with up to two fellow students (groups of three students). Each student, or group of students, submits his (their) own assignment and answers the questions in their wording. If you work in a group, you should complete a fair share of the work! Late submissions carry a 20% penalty if submitted within 24 hours of the deadline. I will grade generously so using the late submission option is usually not advisable. Your maximum score is 100 points. I will give the maximum points for each question if your answers are correct, complete, and presented. Please, keep a copy of the files you submit (a word file and an excel file) and make sure the files you upload are complete by doublechecking after you've done the submission. Please, do not submit the original excel sheet as it has mistakes. Rather, use the original file to modify to a mistake-free version. Short Answers (please also provide spreadsheets and longer explanations and complete Pro-forma analysis tables in a separate file): 1. Net Cash Flow in Year 0: Net Cash Flow in Year 1: Net Cash Flow in Year 2: Net Cash Flow in Year 3: Net Cash Flow in Year 4: 2. NPV: IRR: Start project (Yes/No): 3. Bid price (in \$) that makes financial sense: Bid price that adds $1 million to the value of the company: Questions are based on the following mini-case: CGX Transmitters is developing a 2at 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 bodget 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 FIN305W 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.5 million on R\&D last year to research the technology behind the 2et gencration transmitter. - If you undertake this project, operating income before tax of the 1 generation optical transmitter will decline by an annual amount of $1.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.5%. Assume that the firm's other projects yield a positive income before tax. The transmitter is expected to sell for $11.50 with a per-unit variable cost of $4.20. The following sales information is compiled by the marketing department (in $ million) and net working capital by the accounting department: Hence, the sales in year one will be worth $18.40 million ( 1.6 million units * $11.50 sale price) and the COGS in year one will be $6.72 million (1.6 million units * $4.20 per unit cost). Similarly, you need to compute the dollar amount of sales and COGS in years two to year four. 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