You have the option of investing in a friend's mortgage fund, for an anticipatedyearly return of 13% for 5 years, paid yearly at the end of the year.paid yearly at the1. Please show in detail how this investment will look with future value overthe 5 years. Using excel formula. Investing $200,000.

Investment amount = $200,000Yearly returns = 13%Number of years = 5 years

You have the option of investing in a friend's mortgage fund, for an anticipa yearly return of 13% for 5 years, paid yearly at the end of the year. 1. Please show in detail how this investment will look with future value over the 5 years. Using excel formula. Investing $200,000.

You have the option of investing in a friend's mortgage fund, for an anticipa yearly return of 13% for 5 years, paid yearly at the end of the year. 1. Please show in detail how this investment will look with future value over the 5 years. Using excel formula. Investing $200,000.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You need $25,356 at the end of 9 years, and your only investment outlet is an 9 percent long-term certificate of deposit (compounded annually). With the certificate of deposit, you make an initial investment at the beginning of the first year. Use Appendix B and Appendix C for an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. What single payment could be made at the beginning of the first year to achieve this objective? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) b. What amount could you pay at the end of each year annually for 9 years to achieve this same objective? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Suppose that you borrow $200,000 in the form of a 12-year loan with an annual interest rate of 6% with monthly payments and monthly compounding. How much principal will you pay in the last year of the loan? Please describe how to solve using a financial calculator thank you.
Eric is evaluating a growing perpetuity investment from a large financial service firm. The investment promises an initial pymt of $19,800 at the end of this year and subsequent pymts that will grow at a rate of 2.8% annually. If you use a 9% discount rate for investments like this, what is the present value of this growing perpetuity? (round final answer 2 decimal palces)
Create a data table that calculates the Future Value of a 401(k) using the following information: Future Value = -FV(APR/12, 12 Years, Monthly Deposit) Vary the number of years investing from 12 to 36 by 2 Vary the APR from 1.0% to 12.0% by 1.0% If you client invests $100 per month every month earning 6.0% APR, how many years will it take before their investment exceeds $100,000?
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer:
Your finance advisor offers you an investment that promise $200000 in 15 years from now. He said that you will need to contribute an initialinvestment of $45,000 now. Required:a. What rate of interest was used in the computation of this investment offerassuming the rate is compounding annually?b. If you wish to retire in just 10 years from now with the same $200 000and the rate of return is 12%, how much money would you need to invest now?c. If you wish to retire with $250 000, using the same initial investment of$45 000 and the rate of return of 15%, how long will you need to wait beforeyou can retire?
Your financial advisor from Bluerock recommends you to invest in one of the plan. You want to compare and verify which of the following is the best investment option. Investment Plan A: Deposit $125,000 at the beginning and obtain $175,318.97 after 5 years.Investment Plan B: Deposit $243,000 at the beginning and obtain $319,771.42 after 7 years.Investment Plan C: Deposit $314,000 at the beginning and obtain $530,496.39 after 9 years. 1. Compute interest rate for all 3 plans. Which investment plan provides you the highest rate? 2. Your advisor updated the investment plan information yesterday. While the interest rate did not change for all 3 plans, future values of each investment are 210382.76, 415702.85, 742694.95, respectively. What would be the investment period for each plan? 3. Your advisor thinks it would be a good investment if you make an investment portfolio using all 3 investment plans suggested. He recommends investing in all 3 plans at year 0 and reinvest the money to…
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 are planning to put $1,060 in the bank at the end of each year for the next three years in hopes that you will have enough money for a newest LCD model that is available. If you are investing at an annual interest rate of 12%, you'll have accumulated at the end of three years. How would you plug this into a BA II calculator?
Answer the given question with a proper explanation and step-by-step solution. Please provide the answer using the math tool otherwise I give the downvote. Financial Mathematics Please answer all parts of the question Suppose you will receive $50,000 in 10 years time.a) What is the discount factor assuming quarterly compounding at 7% interest rate?b) What is the present value?c) What happens to the present value if the payment was to occur in five years?d) What happens to the present value if the interest rate was 8% instead?
you have just won the lottery and will receive $460,000 in one year. you will receive payments for 21 years, and the payments will increase 4 percent per year. if the appropriate discount rate is 11 percent, what is the present value of your winnings? Please explain how to solve using the financial calculator to show and explain steps thanks
You just opened an account with a mutual fund and will invest $200 each month through its automatic investment program. Assuming your earn a 6% annual rate of return, how much money will you have in 5 years?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS