Question
In: Finance
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 8 months agoRelated 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?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- An investment project costs $20,100 and has annual cash flows of $4,400 for six years. ...
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
ADVERTISEMENT