Please show all work, formulas, steps, and calculations.

The following rates should be applied in calculations monthly: Annual Investment Rate of Return = Annual Inflation Rate = 7% 2.50% for the months: for the months: TO DO: Make a spreadsheet which spans the rest of your expected lite. Ensure that the model doesn't have you running out of money. Assume amounts contributed are at the beginning of each month, so the rate of return on the investment portfolio (aka, nest eggl applies to those contributions during the month. Also assume amounts withdrawn are at the ending of each month, so the rate of return on the investment occurs prior to those withdrawals. Reminder: Do not forget that inflation applies to the amount you need to withdraw, each month, but inflation does not wait to begin until you begin the withdrawals. Also note that your nest egg continues to grow have a return rate and receive returns) during the months you're making withdrawals. Scenario: Expected Case (If All Goes According to Expectations) Month Livina) Month (Contributina) Amount Contributing Formula used: C$5/12 Inv. Return Rate Inv. Return (5) Month (Withdrawinel Amount Withdrawine End-of-Month Total Balance Chanee Total Account Balance The following rates should be applied in calculations monthly: Annual Investment Rate of Return = Annual Inflation Rate = 7% 2.50% for the months: for the months: TO DO: Make a spreadsheet which spans the rest of your expected lite. Ensure that the model doesn't have you running out of money. Assume amounts contributed are at the beginning of each month, so the rate of return on the investment portfolio (aka, nest eggl applies to those contributions during the month. Also assume amounts withdrawn are at the ending of each month, so the rate of return on the investment occurs prior to those withdrawals. Reminder: Do not forget that inflation applies to the amount you need to withdraw, each month, but inflation does not wait to begin until you begin the withdrawals. Also note that your nest egg continues to grow have a return rate and receive returns) during the months you're making withdrawals. Scenario: Expected Case (If All Goes According to Expectations) Month Livina) Month (Contributina) Amount Contributing Formula used: C$5/12 Inv. Return Rate Inv. Return (5) Month (Withdrawinel Amount Withdrawine End-of-Month Total Balance Chanee Total Account Balance