This is what I have done so far. I do not know how to get the discount rate (@11%), that is the only step I am missing. Please help, if possible.Thank you!

(Related to Checkpoint 12.1) (Comprehensive problem-calculating project cash flows, NPV, PI, and IRR) Traid Winds Corporation, a firm in the 33 percent marginal tax bracket with a required rate of return or discount rate of 11 percent, is considering a new project. This project involves the introduction of a new product. The project is expected to last 5 years and then, because this is somewhat of a fad product, it will be terminated. Given the following information, B , determine the free cash flows associated with the project, the project's net present value, the profitability index, and the internal rate of return. Apply the appropriate decision criteria. a. Determine the free cash flows associated with the project. The FCF in year 0 is $ 15140000. (Round to the nearest dollar.) The FCF in year 1 is $ 3200000. (Round to the nearest dollar.) Year 1 Year 2 Year 3 Year 4 Year 5 Year o --(14800000+180000) - - 160000 125000 =D5*44.8 =C6-D6 320 320 100 100 =D8-D9 - 125000 =E5 44.8 =E6-D6 320 100 100 =E8-E9 *E8-E9 Cost of Equipment Sale in Units Working Capital Recovered Change in Working Capital Sale Price Sale Price Less: Variable Cost per Unit Contribution margin per unit Total Less: Fixed Costs Less: Depreciation Operating Profit Less: Tax @ 33% NOPAT Add: Depreciation Change in Working Capital Working Capital Recovered olar Contribution 75000 =C5 44.8 =C6+B6 320 320 100 100 =C8-C9 Co-9 =C5 C10 -600000 =$B4/5 =C11+C12+C13 =C14*0.33 C14+C15 --$B$4/5 =C7 =D5 D10 =E5*E10 85000 =F5*44.8 =E6-F6 320 100 - =F5 F10 -600000 =$B4/5 =F11+F12 F13 =F14*0.33 =F14+F15 --$B$4/5 =F7 - 600000 =$B4/5 =D11+D12+D13 D14*0.33 =D14+D15 --$B$4/5 =D7 -600000 =$B4/5 =E11+E12+E13 =E14*0.33 =E14+E15 - $B$4/5 =E7 75000 =G5*44.8 =G6-F6 270 100 4 - =G5*G10 -600000 =$B4/5 =G11+G12+G13 + =* =G14+G15 --$B$4/5 =G7 =G6 =G16+G17+G18 =C16+C17+C18 =D16+D17+D18 016+ D17+ D18 =E16+E17+E18 =B4 1 =F16+F17+F18 Discount Rate @11% NPV Working Note Working Capital A B D E F G 1 Year 2 2 3 Year o Year 1 Year 3 Year 4 Year 5 4 Cost of Equipment $ (14,980,000.00) 5 Sale in Units $ 75,000.00 $ 125,000.00 $ 125,000.00 $ 85,000.00 $ 75,000.00 6 Working Capital Recovered $ (160,000.00) $ 3,360,000.00 $ 5,600,000.00 $ 5,600,000.00 $ 3,808,000.00 $ 3,360,000.00 7 Change in Working Capital $ 3,200,000.00 $ (2,240,000.00) $ $ 1,792,000.00 $ (448,000.00) 8 Sale Price $ 320.00 $ 320.00 $ 320.00 $ 320.00 $ 270.00 9 Less: Variable Cost per Unit $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 10 Contribution margin per unit $ 220.00 $ 220.00 $ 220.00 $ 220.00 $ 170.00 11 Total Contribution $ 16,500,000.00 $ 27,500,000.00 $ 27,500,000.00 $ 18,700,000.00 $ 12,750,000.00 12 Less: Fixed Costs $ (600,000.00) $ (600,000.00) $ (600,000.00) $ (600,000.00) $ (600,000.00) 13 Less: Depreciation $ (2,996,000.00) $ (2,996,000.00) $ (2,996,000.00) $ (2,996,000.00) $ (2,996,000.00) 14 Operating Profit $ 12,904,000.00 $ 23,904,000.00 $ 23,904,000.00 $ 15,104,000.00 $ 9,154,000.00 15 Less: Tax @ 33% $ 4,258,320.00 $ 7,888,320.00 $ 7,888,320.00 $ 4,984,320.00 $ 3,020,820.00 16 NOPAT $ 17,162,320.00 $ 31,792,320.00 $ 31,792,320.00 $20,088,320.00 $ 12,174,820.00 17 Add: Depreciation $ 2,996,000.00 $ 2,996,000.00 $ 2,996,000.00 $ 2,996,000.00 $ 2,996,000.00 18 Change in Working Capital $ 3,200,000.00 $ (2,240,000.00) $ $ 1,792,000.00 $ (448,000.00) 19 Working Capital Recovered $ 3,360,000.00 20 $ (14,980,000.00) $ 23,358,320.00 $ 32,548,320.00 $ 34,788,320.00 $ 24,876,320.00 $ 14,722,820.00 21 Discount Rate @ 11% 22 23 NPV 24 Working Note 25 Working Capital 26