Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Boy , this is all so confusing, said Ryan as he stared at the papers on his desk. If only I had taken the advice
Boy this is all so confusing, said Ryan as he stared at the papers on his desk. If only I had taken the advice of my finance instructor, I would not be in such a predicament today. Ryan Daniels, aged graduated five years ago with a degree in food marketing and is currently employed as a middlelevel manager for a fairly successful grocery chain. His current annual salary of $ has increased at an average rate of percent per year and is projected to increase at least at that rate for the foreseeable future. The firm has had a voluntary retirement savings program in place, whereby employees are allowed to contribute up to of their gross annual salary up to a maximum of $ per year and the company matches every dollar that the employee contributes. Unfortunately, like many other young people who start out in their first real job, Ryan has not yet taken advantage of the retirement savings program. He opted instead to buy a fancy car, rent an expensive apartment, and consume most of his income. However, with wedding plans on the horizon, Ryan has finally come to the realization that he had better start putting away some money for the future. His fiance Amber, of course, had a lot to do with giving him this reality check. Amber reminded Ryan that besides retirement, there were various other large expenses that would be forthcoming and that it would be wise for him to design a comprehensive savings plan, keeping in mind the various cost estimates and timelines involved. Ryan figures that the two largest expenses down the road would be those related to the wedding and down payment on a house. He estimates that the wedding, which will take place in twelve months, should cost about $ in todays dollars. Furthermore, he plans to move into a $ house in todays terms after years, and would need for a down payment. Ryan is aware that his cost estimates are in current terms and would need to be adjusted for inflation. Moreover, he knows that an automatic payroll deduction is probably the best way to go since he is not a very disciplined investor. Ryan is really not sure how much money he should put away each month, given the inflation effects, the differences in timelines and the salary increases that would be forthcoming. All this number crunching seems overwhelming and the objectives seem insurmountable. If only he had started planning and saving five years ago, his financial situation would have been so much better. Questions set up in Excel Returns the future value of an investment fv Returns the present value of an investment pv Returns the periodic payment for an annuity pmt Returns the number of periods for an investment nper Returns the interest rate per period of an annuity rate What was Ryans starting salary? How much could he have contributed to the voluntary savings plan in his first year of employment? Had Ryan taken advantage of the companys voluntary retirement plan up to the maximum, every year for the past five years, how much money would he currently have accumulated in his retirement account, assuming a nominal rate of return of How much more would his investment value have been worth had he opted for a higher risk alternative ie in common stocks which was expected to yield an average compound rate of return of APR
Boy this is all so confusing, said Ryan as he stared at the papers on his desk.
If only I had taken the advice of my finance instructor, I would not be in such a
predicament today. Ryan Daniels, aged graduated five years ago with a degree in food marketing and is currently employed as a middlelevel manager for a fairly successful grocery chain. His current annual salary of $ has increased at an average rate of percent per year and is projected to increase at least at that rate for the foreseeable future. The firm has had a voluntary retirement savings program in place, whereby employees are allowed to contribute up to of their gross annual salary up to a maximum of $ per year and the company matches every dollar that the employee contributes. Unfortunately, like many other young people who start out in their first real job, Ryan has not yet taken advantage of the retirement savings program. He opted instead to buy a fancy car, rent an expensive apartment, and consume most of his income.
However, with wedding plans on the horizon, Ryan has finally come to the realization that he had better start putting away some money for the future. His fiance Amber, of course, had a lot to do with giving him this reality check. Amber reminded Ryan that besides retirement, there were various other large expenses that would be forthcoming and that it would be wise for him to design a comprehensive savings plan, keeping in mind the various cost estimates and timelines involved.
Ryan figures that the two largest expenses down the road would be those related to the wedding and down payment on a house. He estimates that the wedding, which will take place in twelve months, should cost about $ in todays dollars. Furthermore, he plans to move into a $ house in todays terms after years, and would need for a down payment. Ryan is aware that his cost estimates are in current terms and would need to be adjusted for inflation. Moreover, he knows that an automatic payroll deduction is probably the best way to go since he is not a very disciplined investor. Ryan is really not sure how much money he should put away each month, given the inflation effects, the differences in timelines and the salary increases that would be forthcoming. All this number crunching seems overwhelming and the objectives seem insurmountable. If only he had started planning and saving five years ago, his financial situation would have been so much better. Questions set up in Excel Returns the future value of an investment fv
Returns the present value of an investment pv
Returns the periodic payment for an annuity pmt
Returns the number of periods for an investment nper
Returns the interest rate per period of an annuity rate
What was Ryans starting salary? How much could he have contributed to the voluntary savings plan in his first year of employment?
Had Ryan taken advantage of the companys voluntary retirement plan up to the maximum, every year for the past five years, how much money would he currently have accumulated in his retirement account, assuming a nominal rate of return of How much more would his investment value have been worth had he opted for a higher risk alternative ie in common stocks which was expected to yield an average compound rate of return of APR
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started