Please show excel formula

0 ezto.mheducation.com C M Account Activation - dhashoen@gmail.com - G.. 2021-2022 APIA Scholarship Application Microsoft Office Home Mail - Dhashoen, Tenzing - Outlook A Assignments - RELS 301-50 Introduction to Re. M Connect (16) Latest Released 2018 Full Hindi Dubbed. Your Orders HW 5 i Saved Save & Exit Submit 20 Calculating profitability index and NPV - Excel ? 5 - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial - 12 - A" A' % 10 Paste BIU- - - A Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing points Clipboard Font Styles D20 v ! X v fx eBook E F G H 2 Print 3 The Sloan Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is 10 percent, what is the profitability index for each project? What is the NPV for each project? References Annual cash flows: Year 0 GA GA GA GA (51,000) (14,400) Year 1 24,800 7,800 Year 2 24,800 Year 3 24,800 7,800 7,800 Required return 10% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Profitability index (1) Profitability index (II) NPV (1) NPV (11) Sheet1 ... + READY Attempt(s) 9/10 # 3 0 -- 100% Hint Show Me