Description Create a function that estimates how much money you need today, in order to retire in number of years, taking into account: Inflation (1) Amount needed to live, monthly (PMT) Rate of return of your money (RR) Number of years expected to live after retirement (NPMT) Assume there will be no money left after death. . . . . . Requirements Create the function first in MS Excel Test your function in MS Excel Develop your function in R Test your function in R . . Deliverable Upload the assignment to Canvas. Upload your R work in Word using RMarkdown, and in a separate file the MS Excel file. Testing Use the below scenarios for testing: Input Scenario 1 Scenario 2 Scenario 3 Y 10 15 20 1 1% 39 RR 5% 10% 5% PMT 12% $10,000 $7,500 NPMT $8,200 30 years 20 years 40 Years Description Create a function that estimates how much money you need today, in order to retire in number of years, taking into account: Inflation (1) Amount needed to live, monthly (PMT) Rate of return of your money (RR) Number of years expected to live after retirement (NPMT) Assume there will be no money left after death. . . . . . Requirements Create the function first in MS Excel Test your function in MS Excel Develop your function in R Test your function in R . . Deliverable Upload the assignment to Canvas. Upload your R work in Word using RMarkdown, and in a separate file the MS Excel file. Testing Use the below scenarios for testing: Input Scenario 1 Scenario 2 Scenario 3 Y 10 15 20 1 1% 39 RR 5% 10% 5% PMT 12% $10,000 $7,500 NPMT $8,200 30 years 20 years 40 Years