A financial advisor tells you that you can make your child a millionaire if you just...

A financial advisor tells you that you can make your child a millionaire if you just start saving early. You decide to put an equal amount each year into an investment account that earns 8.0% interest per year, starting on the day your child is born until his 39thbirthday. How much would you need to invest each year to accumulate a million for your child by the time he is 40years old? (Your last deposit will be made on his 39th birthday.)a.$3,860.16b.$3,574.22c.$3,875.12d.$4,185.13e.$3,965.33 (HOW WOULD YOU SOLVE THIS IN EXCEL USING THE PMT FUNCTION)

Solutions

Expert Solution

Answer:a)3,860.16 We can use the PMT() in excel to determine the payment

The number of periods =40(0+1 to 39)

The interest rate= 8.00%

The Future value =$1,000,000

So the formula used would be =PMT(B3,B4,0,-B2)

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Make me a millionaire. Assume that you are a financial advisor. I have come to you...

Make me a millionaire. Assume that you are a financial advisor. I have come to you because I want to develop a plan for retiring early. I am currently 24 years old and I want to retire by age 55. That gives me 31 years to build wealth. I have just graduated from college and obtained my first job as an urban planner with a local city, earning $32,000 per year. People in this field usually top out at about...

Your financial advisor tells you that the best metric to evaluate an asset is its beta,...

Your financial advisor tells you that the best metric to evaluate an asset is its beta, since only systematic risk matters for expected returns. Do you agree with this advice? Explain if this is true, false, or uncertain

Suppose your financial advisor tells you that you need to save enough to draw no more...

Suppose your financial advisor tells you that you need to save enough to draw no more than 4% of your initial retirement account balance each year once you retire. You want to withdraw $50,000 per year. What balance must you achieve in your retirement account to reach your goal? Select one: a. $50,000 b. $2,000 c. $1,250,000 d. $679,516

It is December 10th and you just met with your financial advisor, who suggested that you...

It is December 10th and you just met with your financial advisor, who suggested that you begin putting $5,000 into a Roth RIA at the beginning of each year, starting next month. Your advisor says that, although there is no guarantee, you could average an annual return of 8% over the next twenty (20) years with the right mix of investments. You want to know just how big of a "nest egg" you can create if you take her advide...

You decide you want your child to be a millionaire. You have a daughter today and...

You decide you want your child to be a millionaire. You have a daughter today and you deposit $59,000 in an investment account that earns 7.5% per year. The money in the account will be distributed to your daughter whenever the total reaches $3,750,000. How old will your daughter be when she gets the money (rounded to the nearest year)? Please show work

Assume you are and econmic advisor for the future president. She tells you that unemployment is...

Assume you are and econmic advisor for the future president. She tells you that unemployment is at high levels and GDP growth is at .5%. She asks you to adress the following. a.) What is a possible cause of the econmic condition? b.) How can we solve the unemployment problem and biost the economy?

Your goal in life is to be a millionaire. Today, your financial portfolio is worth $3,733.24....

Your goal in life is to be a millionaire. Today, your financial portfolio is worth $3,733.24. After extensive studying of the stock market and the nature of investments, you have determined that you can earn 15% every year on your portfolio. You do not plan to invest any additional money in this portfolio, nor will you withdraw any funds from it before it grows to $1 million. Given your 15% interest rate, how long will you have to wait to...

You just received your annual performance statement from your investment advisor. The statement indicates that your...

You just received your annual performance statement from your investment advisor. The statement indicates that your portfolio return for the past year was up 12%. In addition, you noticed, within the statement, that the S&P 500 rose 10.5%. Also, the statement reflected that your portfolio had a beta 1.25. Further on, you noticed that the risk-free rate of return was 1.5%. To your dismay, the statement did not provide what the risk-adjusted rate of return was for the year. Therefore,...

You are investing for your retirement and your financial advisor has strongly recommended the mutual fund,...

You are investing for your retirement and your financial advisor has strongly recommended the mutual fund, Fidelity Select Retailing Portfolio, FSRPX. She suggested this fund can meet your needs since it has been around since December 1985 and has performed quite well. Being the aggressive investor that you are, you want to invest in a fund that has a high annual return rate. The annual returns (in percents, from oldest to newest) are as follows: 14.18, -7.36, 38.71, 29.53, -5.03,...

Mariana Pajón just hired your as her financial advisor. She has received two offers for cycling...

Mariana Pajón just hired your as her financial advisor. She has received two offers for cycling professionally and wants to select the best based only on money. Offer A is a $10m ($2m a year for 5 years). Offer B is $11m ($1m a year for four years and $7m in year 5). What is your advice? Use a 10% interest rate.

Subjects