If you could show me on Excel and shiw the formulas that would help alot. (Re-Sent)

Like most fema in da industry, Culinary Cele unes a subjective risk assessment tool of is own design. The tool is a simple noek by which projects are ranked by evel of perceived risk on a scale of 0-10 The scale is recreated in the following table Risk Index Required return 40% (current risk free rate) 45 50 55 60 6.5 (current IRR) 7,0 75 + 2 3 4 5 . 7 B The NPV for project Pa) Round to the newest cert) 2 5.0 3 55 4 60 5 6.5 (current IRR) 6 70 2 7.5 8 80 0 10 00 The frm is analyzing to projects based on their PADRE Project Pta mequires an initial vestment of 812,600 and is assured ark index of 6. Project Gripe Leat requires an in investment of $7.500 and is assigned a risk index of. The two projects have 7-year lives. Pitais projected to generale cash inflows of $5,500 per year rape Leafs projected to generate hindows of $4.000 per year Use cach projects RADR to let the better project The NPV for project Pite la $(Round to the nearest cent)