Managerial Finance Case One - Personal Finance Application You are X (you will input your age) years old, college grad with a full time job in your career, thinking about saving for retirement. You go to a financial planning site to get some ideas. The site asks you the following questions: 1) At what age do you think you would like to retire? 2) How much money do you feel you would need per year to live on during the first year of retirement? (consider housing, medical expenses, travel, etc. - many financial experts suggest 80% to 100 % of your income when you retire) 3) How is your health, what age would you look to have retirement benefits for? 4) How comfortable are you with risk? Would you consider yourself a risky investor - you are fine with the ups and downs of the stock market? (use an investment rate from 10% to 14%) Moderate risk - would like some growth from the stock market but would like safer investments such as bonds as well? (use an investment rate between 5% and 9%) Or low risk investor - mostly bonds, CD's money markets? (use an investment rate between 2.5% and 5%) Fill in answers: Age now: Age at retirement: (difference between age at retirement and age now must be greater than 15 years) Age want to receive retirement income until (suggest between 80 and 100): Investment rate: Inflation rate: (average rate over last 50 years = 3.5%, choose a rate between 1% and 6%) Current year's salary: Amount you have already saved for retirement: (must be greater than $100) (must be greater than $1000) Amount you want to leave to heirs: 1. Calculate the amount of money you will need the first year of retirement: To do this you will calculation the number of years until retirement: Age at retirement - age now. Next assume you will progress in your career and make 3% more per year then the rate of inflation you chose: so now grow your current year's salary by inflation plus 3% for the number of years until retirement. We will assume here that you want to continue with 100% of that amount, so that is the amount you need for the first year of retirement. 2. Calculation the amount you will need the day you retire if you want the amount you calculated in part 1 paid out annually from the day you retire until the last date you want to receive retirement income and you want to leave nothing to your heirs. Assume the rate of return you will receive during this period is 2% less than the investment rate you chose above (people generally invest a little bit more conservatively during retirement). 3. Now do the same calculation as part 2, but include the amount you decided to leave to your heirs above. 4. Using your answer to part 3, find the equal annual amount you would need to save every year from the age you input as now until the date you retire to reach the amount in answer 3, use the investment rate you chose above. 5. Now let's assume you are 10 years into saving for your retirement, so 10 years older than what you chose as your age now and assume you earned 2% less than expected on your investments and you ended up putting away only half as much as you assumed above. Now calculate the equal annual amount you would need to save every year to still save to the amount in part 3, assuming you can now earn the assumed investment rate. 6. Assume that the amount you calculate in part 5 is too much for you to possibly save, suggests so ethical options. You must you all your work (show how you arrived at your calculations). You can show it by inputs to the calculator and hand it in or upload it to BlackBoard (BB) - as a last resort you can email it to me but be clear in the subject that it is your case for this course. All electronic submission must submit file with file name: Lastname.firstname.ManFin.classdayandtime.case1, for example Donovan.Shannon.ManFin.TR8am.case 1, if I was in the TR 8 am class. If you do your case using EXCEL, then you MUST send me the Excel spreadsheet (either through BB, preferred, or email). 6. Assume that the amount you calculate in part 5 is too much for you to possibly save, suggests so ethical options. You must you all your work (show how you arrived at your calculations). You can show it by inputs to the calculator and hand it in or upload it to BlackBoard (BB) as a last resort you can email it to me but be clear in the subject that it is your case for this course. All electronic submission must submit file with file name: Lastname.firstname.Man Fin.classdayandtime.case 1, for example Donovan.Shannon.Man Fin.TR8am.case1, if I was in the TR 8 am class. If you do your case using EXCEL, then you MUST send me the Excel spreadsheet (either through BB, preferred, or email). All electronic submission must be in either WORD, EXCEL or PDF. I will not accept any other file forms. I will not accept late submissions. All cases must be done on your own; do not word with others. There is basically no possibly of you and someone else in the course choosing the exact same inputs. All of your inputs must be different from the case example. If I find you worked with others you will receive a zero on the assignment and be reported to the dean and Academic Affairs. Remember to include all your inputs, at the top of your case, so I can correct it. You do not have to do the case on yourself. You can do it on a fictional you in the future, a completely fictional person, a friend or relative etc. Just make sure you provide all the inputs and they follow the guide. Managerial Finance Case One - Personal Finance Application You are X (you will input your age) years old, college grad with a full time job in your career, thinking about saving for retirement. You go to a financial planning site to get some ideas. The site asks you the following questions: 1) At what age do you think you would like to retire? 2) How much money do you feel you would need per year to live on during the first year of retirement? (consider housing, medical expenses, travel, etc. - many financial experts suggest 80% to 100 % of your income when you retire) 3) How is your health, what age would you look to have retirement benefits for? 4) How comfortable are you with risk? Would you consider yourself a risky investor - you are fine with the ups and downs of the stock market? (use an investment rate from 10% to 14%) Moderate risk - would like some growth from the stock market but would like safer investments such as bonds as well? (use an investment rate between 5% and 9%) Or low risk investor - mostly bonds, CD's money markets? (use an investment rate between 2.5% and 5%) Fill in answers: Age now: Age at retirement: (difference between age at retirement and age now must be greater than 15 years) Age want to receive retirement income until (suggest between 80 and 100): Investment rate: Inflation rate: (average rate over last 50 years = 3.5%, choose a rate between 1% and 6%) Current year's salary: Amount you have already saved for retirement: (must be greater than $100) (must be greater than $1000) Amount you want to leave to heirs: 1. Calculate the amount of money you will need the first year of retirement: To do this you will calculation the number of years until retirement: Age at retirement - age now. Next assume you will progress in your career and make 3% more per year then the rate of inflation you chose: so now grow your current year's salary by inflation plus 3% for the number of years until retirement. We will assume here that you want to continue with 100% of that amount, so that is the amount you need for the first year of retirement. 2. Calculation the amount you will need the day you retire if you want the amount you calculated in part 1 paid out annually from the day you retire until the last date you want to receive retirement income and you want to leave nothing to your heirs. Assume the rate of return you will receive during this period is 2% less than the investment rate you chose above (people generally invest a little bit more conservatively during retirement). 3. Now do the same calculation as part 2, but include the amount you decided to leave to your heirs above. 4. Using your answer to part 3, find the equal annual amount you would need to save every year from the age you input as now until the date you retire to reach the amount in answer 3, use the investment rate you chose above. 5. Now let's assume you are 10 years into saving for your retirement, so 10 years older than what you chose as your age now and assume you earned 2% less than expected on your investments and you ended up putting away only half as much as you assumed above. Now calculate the equal annual amount you would need to save every year to still save to the amount in part 3, assuming you can now earn the assumed investment rate. 6. Assume that the amount you calculate in part 5 is too much for you to possibly save, suggests so ethical options. You must you all your work (show how you arrived at your calculations). You can show it by inputs to the calculator and hand it in or upload it to BlackBoard (BB) - as a last resort you can email it to me but be clear in the subject that it is your case for this course. All electronic submission must submit file with file name: Lastname.firstname.ManFin.classdayandtime.case1, for example Donovan.Shannon.ManFin.TR8am.case 1, if I was in the TR 8 am class. If you do your case using EXCEL, then you MUST send me the Excel spreadsheet (either through BB, preferred, or email). 6. Assume that the amount you calculate in part 5 is too much for you to possibly save, suggests so ethical options. You must you all your work (show how you arrived at your calculations). You can show it by inputs to the calculator and hand it in or upload it to BlackBoard (BB) as a last resort you can email it to me but be clear in the subject that it is your case for this course. All electronic submission must submit file with file name: Lastname.firstname.Man Fin.classdayandtime.case 1, for example Donovan.Shannon.Man Fin.TR8am.case1, if I was in the TR 8 am class. If you do your case using EXCEL, then you MUST send me the Excel spreadsheet (either through BB, preferred, or email). All electronic submission must be in either WORD, EXCEL or PDF. I will not accept any other file forms. I will not accept late submissions. All cases must be done on your own; do not word with others. There is basically no possibly of you and someone else in the course choosing the exact same inputs. All of your inputs must be different from the case example. If I find you worked with others you will receive a zero on the assignment and be reported to the dean and Academic Affairs. Remember to include all your inputs, at the top of your case, so I can correct it. You do not have to do the case on yourself. You can do it on a fictional you in the future, a completely fictional person, a friend or relative etc. Just make sure you provide all the inputs and they follow the guide