At the end of two consecutive investments you have $18,510.10. Investment one was 4% (SA) for...

At the end of two consecutive investments you have $18,510.10. Investment one was 4% (SA) for 30 months Investment two was 9% (Q) for 15 months What was the original amount deposited? Round to the nearest WHOLE dollar, NO dollar ($) signs, Use commas (,) when and where needed

Solutions

Expert Solution

Let the original investment be $100. Thus nper = 30/12*2 = 5 semi annual periods; rate = 4%/2; PV = 100.

Amount at the end of the 1st investment: FV (4%/2, 5, 0, -100) = $110.41

Now PV for investment 2 = 110.41; nper = 15/12*4 = 5 quarterly period; rate = 9%/4.

Amount at the end of 2md investment: FV (9%/4; 5, 0, -110.41) = $123.40

However we want FV at the end of the 2nd investment to be $18,510.10. We can use the "goal seek" function and excel and set the cell pertaining the value of $123.40 to $18,510.10 by changing the value of the cell that has the value of $100.

The goal seek function gives a value of 15,000.

Thus the answer is 15,000.

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

to pass a test you have to perform successfully two consecutive tasks, one easy and one...

to pass a test you have to perform successfully two consecutive tasks, one easy and one hard. the easy task you think you can perform with probability z.and the hard task you think you can perform with probability h, where h<z. you are allowed three attempts. either in the order(easy, hard, easy)or in the order (hard, easy, hard). whichever order, you must be successful twice in a row to pas. assuming that your attempts are independent, in what order should...

You have a choice of two investments accounts. Investment A is a 10-year annuity that features...

You have a choice of two investments accounts. Investment A is a 10-year annuity that features end-of-month $1,525 payments and has an interest rate of 7% compounded monthly. Investment B is an annually compounded lump-sum investment with an interest rate of 9 percent, also good for 10 years. How much money would you need to invest in Investment B today for it to be worth as much as Investment A 10 years from now? Use Excel and provide formula

You want to make a one-year investment in a ﬁxed-income security. You have two investment choices:...

You want to make a one-year investment in a ﬁxed-income security. You have two investment choices: a Treasury security and a Treasury inﬂation-protected security (TIPS). The nominal interest rate for the Treasury security is 4% and TIPS promises 1% real interest rate. You use scenario analysis to compare two securities. There are two possible scenarios with equal probabilities: High inﬂation and low inﬂation. The inﬂation rate will be 0% in the low state and 6.1% in the high state. (Do...

Consider two $60,000 investments – call them Investment A and Investment B. Both investments will earn...

Consider two $60,000 investments – call them Investment A and Investment B. Both investments will earn $5,000 with a probability of 0.5 and $1,000 with a probability of 0.5. Investment A will use 100% equity financing (issuing stocks). Investment B will get $30,000 through issuing stocks and $30,000 through issuing bonds. Investment B must pay 4% interest on the bonds. a. Calculate the expected returns on equity (returns after interest payments divided by the amount of equity) for Investment A...

You are offered an investment that will pay you $150 at the end of year one,...

You are offered an investment that will pay you $150 at the end of year one, $250 at the end of year four, and $800 at the end of year eight. What is the total present value of these three cash flows if the discount rate is 6%?

Consider the following two investments. One is a risk-free investment with a $100 return. The other...

Consider the following two investments. One is a risk-free investment with a $100 return. The other investment pays $2,000 20% of the time and a $375 loss the rest of the time. Based on this information, answer the following: (i) Compute the expected returns and standard deviations on these two investments individually. (ii) Compute the value at risk for each investment. (iii) Which investment will risk-averse investors prefer, if either? Which investment will risk- neutral investors prefer, if either?

Consider the following two investments. One is a risk-free investment with a $100 return. The other...

Write a program in Python where you can swap only two consecutive elements. You have to...

Write a program in Python where you can swap only two consecutive elements. You have to show all steps to convert a string into another string (both strings will be anagrams of each other). E.g. GUM to MUG GUM GMU MGU MUG

XYZ owns two investments, A and B that have a combined total value of $54,000. Investment...

XYZ owns two investments, A and B that have a combined total value of $54,000. Investment A is expected to pay $31,000 in 2 years from today and has an expected turn of 7.60 percent per year. Investment B is expected to pay $44,000 in 5 years from today and has an expected turn of R per year. What is R, the expected annual return for investment B? A. 12.32% B. 13.85% C. 11.80% D. 10.08% E. None of the...

Two investments (A and B, below) have been proposed to the Capital Investment committee of your...

Two investments (A and B, below) have been proposed to the Capital Investment committee of your organization; The required rate of return for your company is 15%. What is the NPV for each investment? Assume the initial investments ($150k and $50k) occur at the beginning of the year and all other costs and benefits occur at the end of the year indicated. Ignore inflation. What is the payback period for each investment? Which investment would you recommend and why? Why...

Subjects