please provide an answer using excel formulas!

thanks:)

3 2 10 11 12 AR D 11 Management of BMTC Ld has $250 to investment and we viable ptions Project A requires initial cash flow of $250 and will return cash innows of S1000 every year from you to 5 There is no salvage value for the equipment at the end of 5 years Project B requires initial cash outflow of $20.000 today,cash outflow of $500 in year 1. und cash inflows of $10,000 in year 2, 515,000 in year 3,520,000 in year 4. In year 5, the equipment can be sold for S4300. BMTC Lad uses a 6% discount rate Calculate the NPV for each project. Project A Years Net cash Cash outflows Cash inflows flows PV factor Present value 74 15 16 8 . 25 Net present value Project B Years Cash outflows Cash inflows Net cash flows PV factor Present value 1 2 3 4 5 Net present value