How can i create this excel file?
4. Consider the following information: a. You will work for (maybe) 42 years and then, retire. b. You will live for an additional 28 years (more or less) after you retire. c. You estimate that you will need about $15,000 per month through your retirement years. (You are not absolutely sure about the amount or if you need it at the beginning or end of each month.) d. You want to leave (about) $1,500,000 to your heirs upon your demise. e. You expect to earn (around) 10% on your retirement fund during your working years and (at least) 3.5% after you retire. f You want to take an around-the-world cruise 1 year before you retire. Based on current prices and estimated inflation, the cruise for you and your travelling companion will cost (at least) $75,000. 1 In a worksheet labeled Retirement, construct a dynamic spreadsheet incorporating the information above while allowing for easy modifications of the inputs. Your output (clearly identified and labeled should be the monthly savings required to meet your goals IL Now, consider that you estimate the average inflation rate will be 2% during your retirement years (this will impact your monthly cash flows). Also, your salary will grow at an average annual rate of 4% during your working years. In a worksheet labeled Retirement 2 construct a dynamic spreadsheet that incorporates the items listed above and allows for easy modifications of the inputs. Your output (clearly identified and labeled) should be the first month savings required to meet your goals III. Now, make one change to the above information: You change your monthly income after retirement to be $18,000 per month In a worksheet labeled Retirement 3, determine the percentage of your salary you must save to meet the new goal (clearly identified and labeled) 4. Consider the following information: a. You will work for (maybe) 42 years and then, retire. b. You will live for an additional 28 years (more or less) after you retire. c. You estimate that you will need about $15,000 per month through your retirement years. (You are not absolutely sure about the amount or if you need it at the beginning or end of each month.) d. You want to leave (about) $1,500,000 to your heirs upon your demise. e. You expect to earn (around) 10% on your retirement fund during your working years and (at least) 3.5% after you retire. f You want to take an around-the-world cruise 1 year before you retire. Based on current prices and estimated inflation, the cruise for you and your travelling companion will cost (at least) $75,000. 1 In a worksheet labeled Retirement, construct a dynamic spreadsheet incorporating the information above while allowing for easy modifications of the inputs. Your output (clearly identified and labeled should be the monthly savings required to meet your goals IL Now, consider that you estimate the average inflation rate will be 2% during your retirement years (this will impact your monthly cash flows). Also, your salary will grow at an average annual rate of 4% during your working years. In a worksheet labeled Retirement 2 construct a dynamic spreadsheet that incorporates the items listed above and allows for easy modifications of the inputs. Your output (clearly identified and labeled) should be the first month savings required to meet your goals III. Now, make one change to the above information: You change your monthly income after retirement to be $18,000 per month In a worksheet labeled Retirement 3, determine the percentage of your salary you must save to meet the new goal (clearly identified and labeled)
