7. An investment has a cost of $2000. The investment will have a payout of X...

7. An investment has a cost of $2000. The investment will have a payout of X at the end of the first year. This initial payout X will grow at the rate of 10% per year for the next 3 years, then by 6% per year for the next 2 years, and then at the rate of 4% per year for the following 1 year. You believe the riskiness of this investment is 9%.

a. Calculate the smallest X that would entice you to invest.

Solutions

Expert Solution

Present Value of the payouts must at least equal cost i.e., 2000

Hence,
I have just taken the present value of the cash flows in this manner

X/1.09+X/1.09*(1.1/1.09)^1+X/1.09*(1.1/1.09)^2+X/1.09*(1.1/1.09)^3+X/1.09*(1.1/1.09)^3*(1.06/1.09)+X/1.09*(1.1/1.09)^3*(1.06/1.09)^2+X/1.09*(1.1/1.09)^3*(1.06/1.09)^2*(1.04/1.09)=2000

=>X=2000/(1/1.09+1/1.09*(1.1/1.09)^1+1/1.09*(1.1/1.09)^2+1/1.09*(1.1/1.09)^3+1/1.09*(1.1/1.09)^3*(1.06/1.09)+1/1.09*(1.1/1.09)^3*(1.06/1.09)^2+1/1.09*(1.1/1.09)^3*(1.06/1.09)^2*(1.04/1.09))

=>X=313.48

The Goal Seek prompt can be accessed through Data tab->What if Analysis->Goal Seek

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Assume a company has a payout ratio of 42 percent, a profit margin of 7 percent,...

Assume a company has a payout ratio of 42 percent, a profit margin of 7 percent, a cost of equity of 15 percent and a growth rate of 3.5 percent. Do not round intermediate calculations. Round your answers to three decimal places. What is the forward price–sales multiple? What is the trailing price–sales multiple?

7. Which of the following statements is (are) correct? (x) A firm has a fixed cost...

7. Which of the following statements is (are) correct? (x) A firm has a fixed cost of $16,000 in its first year of operation. When the firm produces 4,000 units of output, its total costs are $65,000. The marginal cost of producing 200 more units beyond 4,000 units is $28 per unit. Therefore, the total cost of producing 4,200 units is $70,600 (y) A firm has a fixed cost of $12,800 in its first year of operation. If the firm...

The Green Giant has a 7 percent profit margin and a 38 percent dividend payout ratio....

The Green Giant has a 7 percent profit margin and a 38 percent dividend payout ratio. The total asset turnover is 1.3 times and the equity multiplier is 1.4 times. What is the sustainable rate of growth? A. 12.01% B. 8.58% C. 9.88% D. 12.74% E. 1.82%

Which of the following statements is (are) correct? (x) If the cost of an investment is...

Which of the following statements is (are) correct? (x) If the cost of an investment is $20,000 and the annual sales from the investment is 12.5 percent of the cost, then the payback period is 8.0 years. (y) It is always possible to determine a payback period when the cash inflows from the project are uneven as long as the cash inflows exceed the cost of the project. (z) If the discounted payback period for a given project is longer...

Steelcase Inc. has a robotic welder that cost $89,500. Shipping and site preparation cost $2000 and...

Steelcase Inc. has a robotic welder that cost $89,500. Shipping and site preparation cost $2000 and installation cost $700. At the end of the 4 th year of service, this robotic welder was traded in for a new robotic welder with a purchase price of $95,900, shipping and site preparation cost $2,300 and installation cost $800. The trade- in allowance for the old robotic welder was $32,000 for purchasing the new robotic welder.This equipment is a 7-year MACRS class. a)What...

7. Three students have each saved $1,000. Each has an investment opportunity in which he or...

7. Three students have each saved $1,000. Each has an investment opportunity in which he or she can invest up to $2,000. Here are the rates of return on the students’ investment projects: Harry 5percent Ron 8percent Hermione 20 percent a. If borrowing and lending are prohibited, so each student uses only personal saving to finance his or her own investment project, how much will each student have a year later when the project pays its return? b. Now suppose...

An investment has an installed cost of $673.658

An investment has an installed cost of $673.658. The cash flows over the four year life of the investment are projected to be $228,701, $281,182, $219,209, and $190,376. Requirement 1: If the discount rate is zero, what is the NPV? (Do not round intermediate calculations.) Requirement 2: If the discount rate is infinite, what is the NPV? (Do not round intermediate calculations. Negative amount should be indicated by a minus sign.) Requirement 3: At what discount rate is the NPV just equal to zero? (Do not...

Company X has an investment project requiring a $10m investment today and that has a $1m...

Company X has an investment project requiring a $10m investment today and that has a $1m net present value. The company has 1 million shares, no internal funds and, given the nature of its business, cannot get debt financing. Hence it must raise funds by issuing equity or abandon the project. While the market knows all about the investment project, it does not know whether the value of the company’s existing assets (i.e., excluding the new project) is $10m or...

Company X has an investment project requiring a $10m investment today and that has a $1m...

If Bob buys a backhoe for $100,000, which has a maintenance cost of $2000/yr that will...

If Bob buys a backhoe for $100,000, which has a maintenance cost of $2000/yr that will increase $1,000 per year after year 5, has a required rebuild of its hydraulic system at year 6 that costs $12,000, and then he sells it for $20,000 after 10 years, what is the life cycle cost of his backhoe if the interest rate is 3% per year. PLEASE INCLUDE A CASH FLOW DIAGRAM or I will not rate!! Thank you.

Subjects