ACCOUNTING-Microsoft Excel calculation for Net Present Value

QUESTION

Hello!I am struggling with a Microsoft Excel calculation for Net Present Value. I know how to calculate NPV with a fixed investment and regular cash inflows but for the LIFE of me cannot seem to get the right formula for NPV with a fixed investment and a one time cash inflow at the end of a period:E.g.: Project A Project Binvestment Required $24000 $24000Annual Cash Inflows $5000 $0Single Inflow end of 13 years. $0 $44000 13yrs 13yrsQuestion: Please calculate using Microsoft Excel and show me how you complete the Net Present Value computation for Project B.Thank you in advance.

ANSWER:

REQUEST HELP FROM A TUTOR