Lindsay is 25 years old and has a new job in Web development. Lindsay wants to make sure she is financially sound in 30 years, so she plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. Develop the two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of 0 to 12 percent in increments of 1 percent.

Lindsay is 25 years old and has a new job in Web development. Lindsay wants to make sure she is financially sound in 30 years, so she plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Construct a data table that will show Lindsay the balance of her retirement account for various levels of annual investment and return. Develop the two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of 0 to 12 percent in increments of 1 percent.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 42P

See similar textbooks

Similar questions

Lindsay is 25 years old and has a new job in web development. Lindsay wants to make sure that they are financially sound in 30 years. So, Lindsay plans to invest the same amount into a retirement account at the end of every year for the next 30 years. Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which Lindsay contributes. (a) Construct a spreadsheet model that will calculate Lindsay's retirement savings given a fixed annual amount saved and a fixed annual interest rate of return. If Lindsay invests $13,000 at an annual return of 7%, how much will be in the retirement account (in dollars) at the end of 30 years? (Round your answer to the nearest dollar.) $ (b) Develop a two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of 0% to 12% in increments of 1%. Using the table, what are the minimum annual investments Lindsay must contribute (in dollars) for…
Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. A) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. B) Alteratively, how much would she have to invest in equal monthly amounts starting at the end of the current year or monthly respectively. please show work in excel as that is what i am not understanding mostly
Sandy, a manufacturing engineer, just received a year-end bonus of 26,000 dollars that will be invested immediately. With the expectation of earning at the rate of 8% per year, Sandy hopes to take the entire amount out in exactly 20 years to pay for a family vacation when the oldest daughter is due to graduate from college. Find the amount of funds that will be available in 20 years.
Melissa is starting a savings for the initial capital to start a jewelry company right after graduation for 3 years. Her job base salary after graduating is expected to be $85,000 paid through equal payments at the end of every month throughout the year. She assumes a 7% increase in annual salary each year. Melissa expects to pay $1,800 monthly rent for her apartment and an extra $1,500 per month to cover other living expenses and she plans to save the rest. As her salary grows, she is plans to move to a nicer place and lifestyle. The expected rent increase is 5% every year and the expected increase in other expenses is 10%. She plans to keep this constant pattern of expenses and income. Assume a 5% nominal interest rate per year compounded monthly.1. Draw the Cash Flow Diagram2. How much money will she have at the end of year 3?3. If Melissa knows that she needs only $100,000 to start her company, how many months it takes until he saves up this amount with the current saving…
Marie, an employee at McCormick, has determined that she will need $5500 per month in retirement over a 30-year period. She has forecasted that her money will earn 7.2% compounded monthly. Marie will spend 25-years working toward this goal investing monthly at an annual rate of 7.2%. How much should Marie’s monthly payments be during her working years in order to satisfy her retirement needs? Hint: Find how much Marie must have at retirement, then find the monthly payments to reach that goal. What maximum amount could Marie withdraw each month so that her balance never decreases (nearest dollar)?
Bella is 23 years old and wants to invest money for her retirement. She wants to have $2,000,000 saved up when she retires at age 65. a) If she can earn 10% per year in an equity mutual fund, calculate the amount of money she would have to invest in equal annual amounts to achieve her retirement goal. b) Alternatively, how much would she have to invest in equal monthly amounts starting at the end of the current year or month respectively.