Can someone peer review my work please?
5) Jeremy would like to retire in 25 years. He would like his retirement income to be 250,000, and this figure should grow at the same rate as inflation, expected to be 2 percent annually. He expects to live 30 years after he retires and plans to leave $3 million to WSU after he dies. Jeremy currently has $1,000,000 in his retirement fund. The fund is expected to earrn 6 percent annually. Assuming that Jeremy increases his annual retirement savings by 2 percent per year (the inflation rate), how much must he save this year in order to have enough funds for his retirement goals HINTS: Both Jeremy's retirement income AND his annual retirement savings are growing annuities (each at the 2 percent inflation rate). Also, you may assume that all payments are made or received at the end of each year, so that they are ordinary growing annuities. Period Curr. Beg Per-Retirement Bal Return Curr End Per. Retirement Bal contributions Inflation Retirement Income 1,000,000.00 3.245,796.97 3.440.544.79 3,646,977.48 3,865,796.13 4,097,743.89 4,343,608.53 4,604,225.04 4,880,478.54 3,245.796.97 2,062,072.62 3,440,544.79$2,103,314.07 3,646,977.48$ 2,145,380.35 3,865.796.13$2,188,287.96 4,097,743.89 $ 2,232,053.72 4,343,608.53 2,276,694.79 4,604.225.04 2,322,228.69 4,880,478.54$ 2,368,673.26 5,173,307.26$ 2,416,046.72 5.483,705.69 2,464,367.66 5,812,728.03$ 2,513,655.01 5,483,705.69 5,812.728.03 6,161,491.71 6,531,181.22 6,923,052.09 7,338.435.22 7,778,741.33 8,245,465.81 8,740,193.76 9.264,605.38 9,820.481.70 10,409,710.61 11,034,293.24 11,696,350.84 12,398,131.89 13,142,019.80 12,892.019.80 12,637,019.80 12,376,919.80 6,161491.71 2,563,928.11 6,531,181.22 $2,615,206.67 6,923,052.09 2,667,510.81 7,338,435.22 $ 2,720,861.02 7,778,74133 $ 2,775,278.24 8,245,465.81 $2,830,783.81 8,740,193.76 $2,887,399.49 9,264,605.38 2,945,147.48 9,820,481.70 $ 3,004,050.43 10,409,710.61 $ 3,064,131.43 11034.293.24$ 3,125,414.06 11696,350.84 $ 3,187,922.34 12,398,131.89 3,251,680.79 13,142,019.80$3,316,714.41 12,892.019.80 12,637,019.80 12,376,919.80 11,841,009.76 11,564,989.56 11,283.448.96 10,996,277.54 10,703,362.69 10,404,589.55 10,099,840.95 9,788,997.37 250,000.00 255,000.00 260,100.00 265,302.00 270,608.04 276,020.20 281,540 287,171.42 292.914.85 298,773.14 304,748.60 310,843.5 11,841,009.76 11,564,989.56 11,283.448.96 10,996,277.54 10,703,362.69 10,404,589.55 10,099,840.95 9,788,997.37 9,471936.92 9,148,535.26 8,818,665.57 8.482,198.49 8,139,002.06 7.788,941.71 7.431,880.14 7,067,677.35 6,696,190.50 6,317.273.92 5,930,779.00 5,536,554.18 5,134,444.87 4,724.293.37 4,305,938.84 3,879.217.22 3 443961 17 9,148,535.26 8,818,665.57 8.482,198.49 8,139,002.06 7.788,941.71 7.431,880.14 7,067,677.35 6,696,190.50 6,317.273.92 5,930,779.00 323,401 329,869.69 336.467.0 343,196.43 350,060.35 357,06156 364,202.79 371486.85 378,916.59 386,494.92 394.224.82 5,134,444.87 4,724.293.37 4,305,938.84 3,879.217.22 410,151.50 426.721.62 435,256.05 443 961 17 000 00O 00 5) Jeremy would like to retire in 25 years. He would like his retirement income to be 250,000, and this figure should grow at the same rate as inflation, expected to be 2 percent annually. He expects to live 30 years after he retires and plans to leave $3 million to WSU after he dies. Jeremy currently has $1,000,000 in his retirement fund. The fund is expected to earrn 6 percent annually. Assuming that Jeremy increases his annual retirement savings by 2 percent per year (the inflation rate), how much must he save this year in order to have enough funds for his retirement goals HINTS: Both Jeremy's retirement income AND his annual retirement savings are growing annuities (each at the 2 percent inflation rate). Also, you may assume that all payments are made or received at the end of each year, so that they are ordinary growing annuities. Period Curr. Beg Per-Retirement Bal Return Curr End Per. Retirement Bal contributions Inflation Retirement Income 1,000,000.00 3.245,796.97 3.440.544.79 3,646,977.48 3,865,796.13 4,097,743.89 4,343,608.53 4,604,225.04 4,880,478.54 3,245.796.97 2,062,072.62 3,440,544.79$2,103,314.07 3,646,977.48$ 2,145,380.35 3,865.796.13$2,188,287.96 4,097,743.89 $ 2,232,053.72 4,343,608.53 2,276,694.79 4,604.225.04 2,322,228.69 4,880,478.54$ 2,368,673.26 5,173,307.26$ 2,416,046.72 5.483,705.69 2,464,367.66 5,812,728.03$ 2,513,655.01 5,483,705.69 5,812.728.03 6,161,491.71 6,531,181.22 6,923,052.09 7,338.435.22 7,778,741.33 8,245,465.81 8,740,193.76 9.264,605.38 9,820.481.70 10,409,710.61 11,034,293.24 11,696,350.84 12,398,131.89 13,142,019.80 12,892.019.80 12,637,019.80 12,376,919.80 6,161491.71 2,563,928.11 6,531,181.22 $2,615,206.67 6,923,052.09 2,667,510.81 7,338,435.22 $ 2,720,861.02 7,778,74133 $ 2,775,278.24 8,245,465.81 $2,830,783.81 8,740,193.76 $2,887,399.49 9,264,605.38 2,945,147.48 9,820,481.70 $ 3,004,050.43 10,409,710.61 $ 3,064,131.43 11034.293.24$ 3,125,414.06 11696,350.84 $ 3,187,922.34 12,398,131.89 3,251,680.79 13,142,019.80$3,316,714.41 12,892.019.80 12,637,019.80 12,376,919.80 11,841,009.76 11,564,989.56 11,283.448.96 10,996,277.54 10,703,362.69 10,404,589.55 10,099,840.95 9,788,997.37 250,000.00 255,000.00 260,100.00 265,302.00 270,608.04 276,020.20 281,540 287,171.42 292.914.85 298,773.14 304,748.60 310,843.5 11,841,009.76 11,564,989.56 11,283.448.96 10,996,277.54 10,703,362.69 10,404,589.55 10,099,840.95 9,788,997.37 9,471936.92 9,148,535.26 8,818,665.57 8.482,198.49 8,139,002.06 7.788,941.71 7.431,880.14 7,067,677.35 6,696,190.50 6,317.273.92 5,930,779.00 5,536,554.18 5,134,444.87 4,724.293.37 4,305,938.84 3,879.217.22 3 443961 17 9,148,535.26 8,818,665.57 8.482,198.49 8,139,002.06 7.788,941.71 7.431,880.14 7,067,677.35 6,696,190.50 6,317.273.92 5,930,779.00 323,401 329,869.69 336.467.0 343,196.43 350,060.35 357,06156 364,202.79 371486.85 378,916.59 386,494.92 394.224.82 5,134,444.87 4,724.293.37 4,305,938.84 3,879.217.22 410,151.50 426.721.62 435,256.05 443 961 17 000 00O 00
