Suppose a firm has two business options to choose from and has asked you, a Business Mathematics student, to help it make a decision. Option "A" requires an immediate cost of $25,000 along with "upgradecosts" of $4,000 in year 3 and $7,500 in year 6. The returns from these investments begin in year 2 and are estimated to be $2,000 per year for 3 years, $4,000 per year for the next 3 years, and then $7,000 inyears 8 and 9, respectively. The only return in year 10 is a residual value of $6,000. Option "B" requires a cost today and in years 1 and 2 of $7,000 and has estimated returns beginning in year 4 and ending inyear 10 of $5,000 per year. There will also be a residual value of $2,000 in year 10. Using Excel's IRR function, find the Rate of Return for each of the two investment options available to the business based onthe information given. Assume the business's expected return on investment is 14 percent. Which option would you recommend?The rate of return on option A is %.(Round to the nearest whole number as needed.)(---)))

Answered: Image /qna-images/answer/9a313ef3-5424-4cd9-aa57-0db4b1f71b25.jpg

ppose a firm has two business options to choose from and has asked you, a Business Mathematics student, to help it m sts" of $4,000 in year 3 and $7,500 in year 6. The returns from these investments begin in year 2 and are estimated to be ars 8 and 9, respectively. The only return in year 10 is a residual value of $6,000. Option "B" requires a cost today and in ar 10 of $5,000 per year. There will also be a residual value of $2,000 in year 10. Using Excel's IRR function, find the Ra information given. Assume the business's expected return on investment is 14 percent. Which option would you recom

ppose a firm has two business options to choose from and has asked you, a Business Mathematics student, to help it m sts" of $4,000 in year 3 and $7,500 in year 6. The returns from these investments begin in year 2 and are estimated to be ars 8 and 9, respectively. The only return in year 10 is a residual value of $6,000. Option "B" requires a cost today and in ar 10 of $5,000 per year. There will also be a residual value of $2,000 in year 10. Using Excel's IRR function, find the Ra information given. Assume the business's expected return on investment is 14 percent. Which option would you recom

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

Decision D6, which has three possible choices (X, Y, or Z), must be made in year 3 of a 6-year study period in order to maximize E(PW). Using an MARR of 18% per year, the investment required in year 3, and the estimated cash flows for years 4 through 6, determine which decision should be made in year 3. D6 X Y Z High (X) Low (X) High (Y) Low (Y) High High (Z) Low (Z) Low High Low High Investment, Cash Flow, (Year Cash Flow, $1000 Year 3 3) (Year 4) 3 4 $-260,000 $50 $40 $30 $30 $190 $-30 Low $-52,000 $-250,000 The present worth of X is $ The present worth of Y is $ The present worth of Z is $ Select decision branch Y Cash Flow, $1000 (Year 5) 5 $50 $30 $40 $30 $170 $-30 Cash Flow, $1000 (Year 6) 6 $50 $20 $50 $30 $150 $-30 Outcome Probability 0.72 0.28 0.45 0.55 0.7 0.3
A firm evaluates all of its projects by applying the IRR rule. A project under consideration has the following cash flows: Year Cash Flow 0 $27,700 1 11,700 14,700 3 10,700 If the required return is 18 percent, what is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR % Should the firm accept the project? Yes No
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 11 percent, and that the maximum allowable payback and discounted payback statistics for your company are 3.0 and 3.5 years, respectively. Time: Cash flow: 1 2 -$236,000 $65,900 $84,100 $141,100 $122,100 $81,300 Use the IRR decision rule to evaluate this project. (Do not round intermediate calculations and round your final answer to 2 decimal places.) IRR % Should it be accepted or rejected? O rejected accepted
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 11 percent, and that the maximum allowable payback and discounted payback statistics for your company are 3 and 3.5 years, respectively. Time: Cash flow: 0 1 3 4 -$233,000 $65,600 $83,800 $140, 800 $121,800 MIRR Use the MIRR decision rule to evaluate this project. Note: Do not round intermediate calculations and round your final answer to 2 decimal places. 5 $81,000 %
Example: Evaluating a business investment opportunity • A low-risk, 4-year investment opportunity promises to pay $3,000, $6,000, and $5,000 at the end of the first, second and fourth year, respectively. A cash injection of $1,000 is required at the end of the third year. The investment may be purchased for $10,000, which would have to be borrowed at an effective interest rate of 10%. Use Economic Value Added principle to determine whether the investment should be undertaken.
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?
Connor Corporation is considering two projects (see below). For your analysis, ass rate of return of 10%. Based on your analysis, which is the best choice? Initial Investment Cash Flow Year 1 PV NPV Profitability Index IRR Project A -465,000 510,000 463,636.364 ($1,363.64) $1.00 ANSWER 10% Project B -700,000 You can change the i 850,000 772,727.273
ok ht ences A firm evaluates all of its projects by applying the IRR rule. A project under consideration has the following cash flows: Year 0 1 2 3 Cash Flow IRR -$27,400 11,400 14,400 10,400 If the required return is 16 percent, what is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) % Should the firm accept the project? Yes O No
The estimated negative cash flows for three design alternatives are shown below. The MARR is 13% per year and the study period is six years. Which alternative is best based on the IRR method? Doing nothing is not an option. Capital investment Annual expenses A. Alternative A B. Alternative C OC. Alternative B EOY 0 1-6 Which alternative would you choose as a base one? Choose the correct answer below. A $79,300 7,900 Alternative B $63,000 12,370 $71,600 10,120
1. You are considering the purchase of an apartment building with the following information: Purchase price Expected year 1 NOI Expected annual NOI growth Expected Exit Cap Rate Holding Period $12,500,000 $1,000,000 4% 8.5% 3 years Solve for each of the following: Initial (going in) cap rate Expected sales price end of year 3 Net Present Value at 9% Discount Rate IRR Would you buy this asset for $12,500,000? Why or why not?
You invest $5000 at time t=0 and an additional $2000 at time t=1/2. At time t=1/2 you have $5300 in your account and at time t=1 you have $7300 in your account. Find the dollar-weighted rate of return rd and the time-weighted rate of return rt on this investment.A. rd= 2.86 %, rt=3.43 %B. rd= 2 %, rt=2.4 %C. rd= 6.26 %, rt=7.5 %D. rd= 2.51 %, rt=3 %E. rd= 5.01 %, rt= 6 % Please answer it only correct without using Excel
Question 4a) A firm has a choice between two investment projects, all of which involve an initial outlay of GH¢36,000. The returns at the end of the next 4 years are given below. If the interest rate is 15%, say whether each project is viable or not, and which is the best investment.Year Project A Project B1 15,000 5,0002 15,000 10,0003 15,000 20,0004 15,000 25,000All values are given in GH¢. b) A factory increase its production by 712% and produced 1290 tonnes. How many tonnes did she produce before? c) If we place GH¢100 in the savings account that yields 12% compounded quarterly, what nearest GH¢ would our investment grow to at the end of 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