You unexpectedly earn $1,200. Instead of blowing through the money, you decide to invest it in a mutual fund which earns 4.0% compounded annually. You would like to know how long you will need to keep the money invested for your investment to grow to $66,000. What would you need to enter in Excel to help you answer this question? =NPER(4.0%, -1200, 66000) =NPER(0.04, 0, -1200, 66000) =NPV(0.04, -1200, 66000) =NPER(4.0%, 0, 1200, 66000)

You unexpectedly earn $1,200. Instead of blowing through the money, you decide to invest it in a mutual fund which earns 4.0% compounded annually. You would like to know how long you will need to keep the money invested for your investment to grow to $66,000. What would you need to enter in Excel to help you answer this question? =NPER(4.0%, -1200, 66000) =NPER(0.04, 0, -1200, 66000) =NPV(0.04, -1200, 66000) =NPER(4.0%, 0, 1200, 66000)

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 22P

See similar textbooks

Similar questions

You have invested P100,000 in a mutual fund that promises to pay 8% each year. You will keep this for 10 years and then cash out the total value. The cost to close the mutual fund account by then is expected to be P5,000. If your minimum return from this investment is 7%, compute for your cost of illiquity with regard to the investment.
You have invested P100,000 in a mutual fund that promises to pay 8% each year. You will keep this for 10 years and then cash out the total value. The cost to close the mutual fund account by then is expected to be P5,000. If your minimum return from this investment is 7%, compute for your cost of illiquity with regard to the investment. (complete and clear solution)
Today, you invest a lump sum amount in an equity fund that provides an 12% annual return. You would like to have $10,900 in 6 years to help with a down payment for a home. How much do you need to deposit today to reach your $10,900 goal? Do not round intermediate calculations. Round your answer to the nearest cent.
You invest in a mutual fund that charges a 4% front-end load, 2% total annual fees, and a 3% back-end load, which decreases 0.5% per year. How much will you pay in fees on a $10,700 investment that does not grow if you cash out after 3 years of no gain?
You have invested P100,000 in a mutual fund that promises to pay 8% each year. You will keep this for 10 years and then cash out the total value. The cost to close the mutual fund account by then is expected to be P5,000. If your minimum return from this investment is 7%, compute for your valuation of the mutual fund.
You have invested P100,000 in a mutual fund that promises to pay 8% each year. You will keep this for 10 years and then cash out the total value. The cost to close the mutual fund account by then is expected to be P5,000. If your minimum return from this investment is 7%, compute for your valuation of the mutual fund. (complete and clear solution)
Your younger brother is very concerned about investment performance, but he is willing to tolerate some risk. He decides to invest $100,000 in a mutual fund that will earn 10% per year. The proceeds will be accumulated as a lump sum and paid out at the end of year 10. Based on the data given below under Note. what is today’s purchasing power equivalent of your younger brother’s investment? Note: Your older brother is concerned more about investment safety than about investment performance. For example, he has invested $100,000 in safe 10-year corporate AAA bonds yielding an average of 6% per year, payable each year. His effective income tax rate is 33%, and inflation will average 3% per year.
Find the required value for each problem. Show the formula used and the counts for each problem.1. Jane Morrison is planning to invest $ 25,000 today in a mutual fund that provides a yield of 8% compounded annually. What will the investment be worth in ten years? 2. Ramón Rivera is investing $ 7,500 in a CD from a bank that pays 6% interest compounded annually. How much will he have earned at the end of five years? 3. María Lebrón is considering an investment that pays 7.6% interest compounded annually. How much would she have to invest today if she expects this investment to bring her $ 25,000 in six years? 4. Elizabeth Terrier wants to accumulate $ 12,000 after 12 years. If the annual compound interest rate paid by her savings account is 9.25%, how much money would he have to deposit in her account today to reach her goal? 5. Carolina Carlo needs to decide whether she accepts a $ 17,000 bond today or waits two years and receives $ 20,100. The CAGR she could invest in is 6%. What…
1. What are the differences between annuity and PV or FV? 2. You are given two numbers: Smith wants to receive $10,000 a year for next 5 years; Smith wants to have $60,000 in 5 years. Which keys you should use to represent 10,000 and 60,000, respectively? 3. You are given two numbers: Lisa is to invest $5,000 a year in a mutual fund for next 5 years; Lisa invests $20,000 in IBM stock. Which keys you should use to represent 5,000 and 20,000, respectively?
You are thinking about investing $4,865 in your friend's landscaping business. Even though you know the investment is risky and you can't be sure, you expect your investment to be worth $5,744 next year. You notice that the rate for one-year Treasury bills is 1%. However, you feel that other investments of equal risk to your friend's landscape business offer an expected return of 7% for the year. What should you do? The present value of the return is $_______ (Round to the nearest cent.)
You are thinking about investing $4,692 in your friend's landscaping business. Even though you know the investment is risky and you can't be sure, you expect your investment to be worth $5,738 next year. You notice that the rate for one-year Treasury bills is 1%. However, you feel that other investments of equal risk to your friend's landscape business offer an expected return of 8% for the year. What should you do?.
What is the excel function and formula for this question? Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000 in 2 years. To get in, you'll need to make a $10,000 deposit to their receivables account and promise not to tell anyone about it. What is the annual return on this investment?