using the XIRR spreadsheet, Determine what annual compounded rate of salary increase that would be required to achieve a $400,000 per year by year 40, assuming the first year of salary is year 5 with $49,875.

Create a cash flow stream, years 1-40 with the same tuition outflows for years 1-4, but for each year 5-40 show the difference between a high school salary (held flat) and your year over year increase. What is the XIRR under this assumption?

2% 2% Freshman 28,166 28,166 Sophmore $28,729 28,729 sJunior $29,304$29,304 Senior$29,890$29,890 30,488 116,089 S 146,577 5th year Student loan 116,089 rate 120 120 120 120 $1408 Fayment $1,231 $1289$1,348 Total interest $31,668 $38,570 $45,658 $52,929 rate 60 120 180 240 Fayment $2,244 $1289$980 $832 Total interest $18,571 $38,570 $60,244$83,519 2% 2% Freshman 28,166 28,166 Sophmore $28,729 28,729 sJunior $29,304$29,304 Senior$29,890$29,890 30,488 116,089 S 146,577 5th year Student loan 116,089 rate 120 120 120 120 $1408 Fayment $1,231 $1289$1,348 Total interest $31,668 $38,570 $45,658 $52,929 rate 60 120 180 240 Fayment $2,244 $1289$980 $832 Total interest $18,571 $38,570 $60,244$83,519