To retire at a decent age and move to Hawaii, an engineer plans to trust her account to an investment firm that promises to make a real rate of return of 10% per year when the inflation rate is 4% per year. If the account currently is valued at $422,000 and she wants to retire in 15 years, how much (in then-current dollars) will have to be in the account for the realized rate of return to be a real 10% per year? Also, write a single- cell spreadsheet function to display the answer.

To retire at a decent age and move to Hawaii, an engineer plans to trust her account to an investment firm that promises to make a real rate of return of 10% per year when the inflation rate is 4% per year. If the account currently is valued at $422,000 and she wants to retire in 15 years, how much (in then-current dollars) will have to be in the account for the realized rate of return to be a real 10% per year? Also, write a single- cell spreadsheet function to display the answer.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

To live comfortably in retirement, you decide you will need to save $2 million by the time you are 65 (you are 30 years old today). You will start a new retirement savings account today and contribute the same amount of money on every birthday up to and including your 65th birthday. Using TVM principles, how much must you set aside each year to make sure that you hit your target goal if the interest rate is 5%? What flaws might exist in your calculations, and what variables could lead to different outcomes? What actions could you take ensure you reach your target goal?
Abhy is thinking about purchasing an investment from XYZ investments. If she buys the investment, Abhy will receive P100 every three months for five years. The first P100 payment will be made as soon as she purchases the investment. If Abhy's required rate of return is 16 percent, how much should she be willing to pay for this investment? * P1,519 O P1,310 O P1,413 P1,112 P1,359 What is the present value of P2,500 semiannual payments received at the beginning of each period for the next 10 years? The annual percentage rate is 6% O 37,194.70 38,309.50 O 35,809.50 O 36,884.80 None of the above Which of the following statements is CORRECT? * Time lines cannot be constructed in situations where some of the cash flows occur annually but others occur quarterly. Some of the cash flows shown on a time line can be in the form of annuity payments, but none can be uneven amounts. Time lines can be constructed for annuities where the payments occur at either the beginning or the end of the…
Marian Plunket owns her own business and is considering an investment. If she undertakes the investment, it will pay $4,680 at the end of each of the next 3 years. The opportunity requires an initial investment of $1,170 plus an additional investment at the end of the second year of $5,850. What is the NPV of this opportunity if the interest rate is 2.3% per year? Should Marian take it? What is the NPV of this opportunity if the interest rate is 2.3% per year? The NPV of this opportunity is $. (Round to the nearest cent.)
Justine is thinking about purchasing an investment from RCBC Capital. If she buys the investment, Justine will receive P1,000 every three months for two years. The first P1,000 payment will be made as soon as she purchases the investment. If Justine's required rate of return is 16%, how much should she be willing to pay for this investment? a.P1,368.57 b.P10,764.80 c.P1,345.60 d.P7,002.05
Marian Plunket owns her own business and is considering an investment. If she undertakes the investment, it will pay $4,600 at the end of each of the next 3 years. The opportunity requires an initial investment of $1,150 plus an additional investment at the end of the second year of $5,750. What is the NPV of this opportunity if the interest rate is 1.9%per year? Should Marian take it? What is the NPV of this opportunity if the interest rate is per year?
Justine is thinking about purchasing an investment from RCBC Capital. If she buys the investment, Justine will receive P1,000 every three months for two years. The first P1,000 payment will be made as soon as she purchases the investment. If Justine's required rate of return is 16%, how much should she be willing to pay for this investment? a. P10,764.80 b. P7,002.05 c. P1,368.57 d. P1,345.60
Marian Plunket owns her own business and is considering an investment. If she undertakes the investment, it will pay $16,000 at the end of each of the next 3 years. The opportunity requires an initial investment of $4,000 plus an additional investment at the end of the second year of $20,000. What is the NPV of this opportunity if the interest rate is 3% per year? Should Marian take it? The NPV of this opportunity is $____ (Round to the nearest dollar.)
Please provide solutions to the following problems: You receive a cash bonus, but your employer gives you two options: receive $8,000 right now or $10,000 two years from now. Assuming an interest rate of 12% what would be the best option. Show all calculations. Find the future value of $500 in 6 years at 9%. What is the present value of an investment that will generate $300 per year for 15 years at 6%? If your grandparents decide to give you $30,000 when you complete your degree what might you offer to them today as an amount as opposed to waiting the 4 years (assume a 5% interest rate). Calculations must be shown for full credit. Also they help in awarding partial credit at the instructors discretion. If using formulas, a financial calculator, or online calculator is used, what value is entered for each variable must be given. If Excel is used the spreadsheet with the formula must be submitted.
Marian Plunket owns her own business and is considering an investment. If she undertakes the investment, it will pay $40,000 at the end of each of the next 3 years. The opportunity requires an initial investment of $ 10,000 plus an additional investment at the end of the second year of $50,000. What is the NPV of this opportunity if the interest rate is2% per year? Should Marian take it?
Marian Plunket owns her own business and is considering an investment. If she undertakes the investment, it will pay $5,440 at the end of each of the next 3 years. The opportunity requires an initial investment of $1,360 plus an additional investment at the end of the second year of $6,800. What is the NPV of this opportunity if the interest rate is 1.6% per year? Should Marian take it?
If she starts now, how much does Sally need to save each month for the next 9 years to accumulate $110,000 to be able to buy her dream vacation property. Assume she will be able to get a 2.5% annual rate of return on the savings. Input your answer to the nearest dollar. Answer: Check 4
You invest $2000 today at 7% per year. If you leave thisfor your grandchildren by not touching the account for80 years, what is the amount of interest on interestearned for this investment? Please explain how to do this problem in the financial calculator. The most important thing is that I understand how to solve the problem on my own