Part 1 (2 points) What annual compounded interest rate would be required to achieve a $400,000 per year salary by year 40, assuming the first year of salary is year 5 with $.67,370 Part 2 (2 points) Using the values above, create a cash flow stream, years 1-40 with the same tuition outflows for years 1-4 (as per the slide present in class), but for each year 5-40 show the difference between a high school salary (held flat) and your year over year increase. (note that the positive cash flow stream will be only 35 years, not 40) What is the XIRR under this assumption? *This needs to be submitted in an excel file, so I need help with those steps in the answer! I will rate and comment for a quick answer!