Show Excel functions =NPV and =IRR 9. Calculating Project OCF [LO1] Quad Enerpriese is considering a...

Show Excel functions =NPV and =IRR 9. Calculating Project OCF [LO1] Quad Enerpriese is considering a new three-year expansion
project that rerrquires an initial fixed asset investment of $2.9 mllion. The fized asset will be
depreciated striaght-line to zero over its three-year tax life, after which time time it will be
worthless. The project is estrimate to generate $2,190,000 in annual sales with costs of $815,000.
If the tax rate is 35 percent, what is the OCF for this project?
10. Calculating Project NPV [LO1] In the previous problem, suppose the required return on the project
is 12 percent. What is the project's NPV

Solutions

Expert Solution

Calculate the NPV and IRR of the project as follows:

Formulas:

jeff jeffy answered 1 month ago

Next > < Previous

Related Solutions

IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project...

IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project A and B (show work). Which Project would you select and why? Be specific. Project A will require an initial investment of $ 200,000 and Project B will require and initial investment of $ 325,000. The cost of capital for both projects is 12%. The cash inflows for the next 5 years are listed below: Project A Project B 0 ($200,000) ($325,000) 1 $50,000...

14. (Toolkit – Decision Rules – PBAK, IRR, NPV) Calculating NPV & IRR: Your next project...

14. (Toolkit – Decision Rules – PBAK, IRR, NPV) Calculating NPV & IRR: Your next project provides an annual cash flow of $15,400 for nine years and costs $67,000 today. Is this a good project at 8% required return? How about 20%? Question 14 options: Yes, Yes Yes, No No, Yes No, No

Problem 10-12 NPV and Modified ACRS [LO1] Quad Enterprises is considering a new three-year expansion project...

Problem 10-12 NPV and Modified ACRS [LO1] Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.79 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $2,110,000 in annual sales, with costs of $799,000. The project requires an initial investment in net working capital of $330,000, and the fixed asset will have a market value of $225,000 at the end of the project. If...

1. Compute the NPV of a project with the following information. The IRR is 9%. The...

1. Compute the NPV of a project with the following information. The IRR is 9%. The project life is 3 years. The initial cost is $19,000. In years 1 and 2 the cash inflows are $4,500 and $5,500, respectively. Cash flow in year 3 is missing. WACC is 12%.

Problem 6-25 Calculating NPV and IRR for a Replacement A firm is considering an investment in...

Problem 6-25 Calculating NPV and IRR for a Replacement A firm is considering an investment in a new machine with a price of $16.6 million to replace its existing machine. The current machine has a book value of $6.3 million and a market value of $5 million. The new machine is expected to have a 4-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the...

Problem 8-22 Calculating NPV and IRR for a Replacement A firm is considering an investment in...

Problem 8-22 Calculating NPV and IRR for a Replacement A firm is considering an investment in a new machine with a price of $18.15 million to replace its existing machine. The current machine has a book value of $6.15 million and a market value of $4.65 million. The new machine is expected to have a four-year life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the...

(Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering a major expansion of its product line...

(Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $11,100,000, and the project would generate cash flows of $1,290,000 per year for 20 years. The appropriate discount rate is 8.1 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR. d. Should this project be accepted? Why or why not? -------------------------------------------------------------------------------------------------------------------------------------- a. The...

(Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering a major expansion of its product line...

(Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $10,800,000, and the project would generate cash flows of $1,250,000 per year for 20 years. The appropriate discount rate is 9.0 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR. d. Should this project be accepted? Why or why not?

(Related to Checkpoint 11.1 and Checkpoint 11.4) (Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering...

(Related to Checkpoint 11.1 and Checkpoint 11.4) (Calculating NPV, PI, and IRR) Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $11 comma 300 comma 000, and the project would generate cash flows of $1 comma 150 comma 000 per year for 20 years. The appropriate discount rate is 6.8 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate...

NPV, PI, and IRR calculations) You are considering a project with an initial cash outlay of...

NPV, PI, and IRR calculations) You are considering a project with an initial cash outlay of $70,000 and expected free cash flows of $28,000 at the end of each year for 6 years. The required rate of return for this project is 7 percent. a. What is the project's payback period? b. What is the project's NPV? c. What is the project's PI? d. What is the project's IRR?

Subjects