Corporate Finance Payback Method IRR and NPV Discussion

Corporate FinanceThe purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Format of SubmissionStudents can submit this assignment in Word, using tables and appropriate white space for problem presentation.If Word is used, you can copy/paste your work from Excel, or create a table.The memo does not require APA format to the extent of title page or a formal paper, but do use proper business format, syntax, grammar, spelling, etc.Students can submit this assignment in Excel, you can copy/paste your memo from Word to a sheet in Excel as a picture.Students are to submit just ONE document, in Word or Excel.In either case, students are to show your work–formulas/inputs/answer.If you submit in Excel, the formulas can be used to solve in Excel, thus showing your work.Assignment Steps Create a 350-word memo to management including the following:Calculate the following time value of money problems: Calculate the project cash flow generated for Project A and Project B using the NPV method.Calculate the project cash flow generated for Project A and Project B using the NPV method (Show your calculations): .Project A: Invest $10k today and receive $5k at the end of this year and for another 2 years (in 12 mos, in 24 mos, in 36 mos), for total cash inflows of $15k.Project B: Invest $55k today and receive $20k at the end of this year and for another 2 years (in 12 mos, in 24 mos, in 36 mos), for total cash inflows of $60k.Sample Template for Project A and Project B:“Table showing investments and returns for Project A and Project B. Project A has $10,000 initial investment with $5,000 returns in each of the first 3 years. Project B has $55,000 initial investment with $20,000 in each of the first 3 years.”Show all work.