Having just graduated from Wayland with a degree in finance, you landed a job as a finance
Question:
Having just graduated from Wayland with a degree in finance, you landed a job as a finance counselor for a large company. Your very first client is a young couple who want to put their financial business in order. Both the husband and the wife are 27 years ago and in stable employment. They want to retire together at the age of 65. Thus, they have 38 (=65-27) years until retirement from now. They want you to help them in their financial planning by answering a series of questions as follows.
1. The couple has combined annual income of $75,000 today. They expect an annual average growth in their income of 4%. Use Excel spread sheet to show your analysis. How much will they be making annually by the time they retire?
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank