Firm Ghatotkach has 75,000 shares each valued at $5. The preferred stock is valued at $375,000 and it has 375000 of these shares outstanding. The debt of Ghatotkach has a book value of $250,000 and the YTM equals the coupon rate of 12%. You are also given the following information: the tax rate is 18%; the of the firm is 2; the market risk premium is 5%; the risk free rate of return is 5%; the dividends paid on each preferred stock are 15 cents. It is a 7 year MACRS project (14.29%; 24.49%; 17.49%; 12.49%; 8.93%; 8.93% 8.93%; 4.45%). The firm, however, decides to depreciate the asset starting in Year 2. Unit sales in Year 1 are 1900 units; in Year 2 are 2600 units; Year 3 are 2900 units; in Year 4 are 2300 units; Year 5 are 1100 units and Year 6 are 1800 units. The price per unit is $195 in Year 1 and Year 2 and $ 160 in Years 3-6. Variable costs are 12% of Sales in Years 1, 2 and 3; and 15% of Sales in Years 4 and 5 and 8% of Sales in Year 6; Fixed Costs are $120,000 each Year; the initial NWC is $125,000 and the NWC is 12% of Sales in Years 1 and 2 and 0% of Sales thereafter. The Salvage Value is 2.5% of the cost of the project. Find the NPV and IRR? Also find the NPV if the FLTC of E = 3%; the FLTC of PS is 5%; and the FLTC of D is 4%?use this template to answer question

C D E F G H J K 1 Cost of Project 2 Number of Years 3 Cost of Capital CF each Year 6 Option 1 7 NPV 9 Option 2 10 CF if revised upward 11 CF if Revised downward 12 Number of years left 13 PV of upward revision of CF 14 PV of down ward revision of CF 1s Scrap value 16 CF at date 1 = PV of Expected Future CF's + CF at Date 1 17 PV of CF at date O 18 NPV at Date O for option 2 19 ACCEPT or REJECT the Project 20