Could someone help me work this problem out in excel please?

You are considering making an investment in one of two projects, A or B. The cash flows for each project are ilisted in the table below. Assuming the correct discount rate for each project is 4%, calculate the payback iperiod, NPV, PI, and IRR. If either project can be scaled up to the size of f your budget, which should be accepted? Year 0 u w NP $ $ $ $ $ $ $ $ Project A (191,000.00) $ 43,000.00 $ 58,000.00 $ 33,000.00 $ 29,000.00 $ 75,000.00 $ 73,000.00 $ 37,000.00 $ Project B (162,000.00) 62,000.00 44,000.00 77,000.00 64,000.00 80,000.00 30,000.00 54,000.00 4 5 6 7 Discount Rate 4.0% Project A Project B Payback Period Net Present Value Profitability Index Internal Rate of Return Which Project