pleade help

A4 fr Year F G H B D E 1 Chapter 10 Case Assignment 2:00 2 Remember the only one you are allowed to use excel for is MIRR 3. Cost of the project is 11% 4 Year Franchise Franchises Franchise z 5 0 -1000 -10000 -5000 6 1 600 5000 1000 7 2 300 3000 1000 8 3 200 3000 2000 9 4 100 3000 2000 10 5 500 3000 2000 Cost of the Project is 11% Year Project T Project F 0 -50000 100000 1 20000 30000 2 20000 35000 20000 25000 4 20000 25000 5 30000 6 20000 12 1. Payback 13 2. Discounted Payback 14 3. Net Present Value (NPV) 15 4. Profitability Index 16 5. Internal Rate of Return 17 6. MIRR 18 19 20 21 22 23 Sheet1 O BD E # 2 3 4 5 6