use excel funtion to fill all the form

use excel function to fill all the form

You are starting to plan for your eventual retirement, and you've decided you would like to retire in 35 years. Your goal is to be able to provide yourself with an $85,000 real annual income for 25 years at that point. To achieve this goal you plan to make equal sized deposits at the end of each month until you retire, starting today. You assume that you will be able to earn a 10.7% return until retirement, and an 8.8% return during retirement. You also assume that inflation will be 6.1$ per year. How much will you need to save each month to reach your goal? During retirement you will withdrawal your income at the start of the year. (20 points total) . w = 882 = = You are starting to plan for your eventual retirement, and you've decided you would like to retire in 35 years. Your goal is to be able to provide yourself with an $85,000 real annual income for 25 years at that point. To achieve this goal you plan to make equal sized deposits at the end of each month until you retire, starting today. You assume that you will be able to earn a 10.7% return until retirement, and an 8.8% return during retirement. You also assume that inflation will be 6.1% per year. How much will you need to save each month to reach your goal? During retirement you will withdrawal your income at the start of the year. (20 points total) \begin{tabular}{|l|l|l|} \hline A B & C & P \\ \hline 6 & D \\ \hline 7 & \\ \hline 8 & \\ \hline 9 \\ \hline 10 \\ \hline 11 \\ \hline 12 \\ \hline 13 \\ \hline 14 \\ \hline 15 \\ \hline 16 \\ \hline 17 \\ \hline 18 \\ \hline 19 \\ \hline 20 \\ \hline 21 \\ \hline 22 \\ \hline 23 \\ \hline 24 \\ \hline 25 \\ \hline \end{tabular} You are starting to plan for your eventual retirement, and you've decided you would like to retire in 35 years. Your goal is to be able to provide yourself with an $85,000 real annual income for 25 years at that point. To achieve this goal you plan to make equal sized deposits at the end of each month until you retire, starting today. You assume that you will be able to earn a 10.7% return until retirement, and an 8.8% return during retirement. You also assume that inflation will be 6.1$ per year. How much will you need to save each month to reach your goal? During retirement you will withdrawal your income at the start of the year. (20 points total) . w = 882 = = You are starting to plan for your eventual retirement, and you've decided you would like to retire in 35 years. Your goal is to be able to provide yourself with an $85,000 real annual income for 25 years at that point. To achieve this goal you plan to make equal sized deposits at the end of each month until you retire, starting today. You assume that you will be able to earn a 10.7% return until retirement, and an 8.8% return during retirement. You also assume that inflation will be 6.1% per year. How much will you need to save each month to reach your goal? During retirement you will withdrawal your income at the start of the year. (20 points total) \begin{tabular}{|l|l|l|} \hline A B & C & P \\ \hline 6 & D \\ \hline 7 & \\ \hline 8 & \\ \hline 9 \\ \hline 10 \\ \hline 11 \\ \hline 12 \\ \hline 13 \\ \hline 14 \\ \hline 15 \\ \hline 16 \\ \hline 17 \\ \hline 18 \\ \hline 19 \\ \hline 20 \\ \hline 21 \\ \hline 22 \\ \hline 23 \\ \hline 24 \\ \hline 25 \\ \hline \end{tabular}