Devise an investment plan for your uncle that maximizes

Assignment Help Financial Management

Reference no: EM132043008

Use Microsoft excel and it's solver add in to solve the following question

Manny has $90,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years. After consulting with his financial advisor, he has been offered four types of fixed-income investments, labeled as investments A, B, C, and D.

Investments A and B are available at the beginning of each of the next five years (call them years 1-5). Each dollar invested in A at the beginning of a year returns $1.20 (a profit of $0.20) two years later, in time for immediate reinvestment. Each dollar invested in B at the beginning of a year returns $1.36 three years later.

Investments C and D will each be available just once in the future. Each dollar invested in C at the beginning of year 2 returns $1.66 at the end of year 5. Each dollar invested in D at the beginning of year 5 returns $1.12 at the end of year 5.

Manny is obligated to make a balloon payment on an existing loan in the amount of $24,000 at the end of year 3. He wants to make that payment out of the investment account.

Devise an investment plan for your uncle that maximizes the value of the investment account at the end of five years. How much money will be available for the annuity in five years?

Reference no: EM132043008

Questions Cloud

What is the intrinsic value of an rwj corp call option : What is the arbitrage profit you could make on each of the mispriced options? (Round your answers to 2 decimal places, e.g., 3 2.16.)

Partially separate from brain function : Do you think human consciousness is a phenomenon that is totally or partially separate from brain function (dualist view)

Identify how your company manages its foreign currency : Identify how your company manages its foreign currency exposure. What strategies does it use? Explain how currency rates affect the Firm's business.

Conditions of the independent variable : Define a survey that could be analyzed by one-way ANOVA with three conditions of the independent variable?

Devise an investment plan for your uncle that maximizes : Devise an investment plan for your uncle that maximizes the value of the investment account at the end of five years.

Negative impact on the self-esteem of women : What is an example of one way Anova's based on social media and it's negative impact on the self-esteem of women?

Calculate the incremental irr for the cash flows : To be prudent, you compute the NPV for both projects. Which project should you choose? Is it consistent with the incremental IRR rule?

Difference between reliability and validity : What is the difference between reliability and validity? Can a test have one without the other?

What exactly do intelligence tests measure : What exactly do intelligence tests measure? What can they predict?

User Account

All Pages