Question

For the cash flows shown below, decide whether the project is acceptable or not using IRR...

For the cash flows shown below, decide whether the project is acceptable or not using IRR function in MS Excel (Assume MARR = 10%). Provide the screenshot

Year first cost($) Revenue ($) M&O cost ($) Salvage ($)
0 1000000
1 300000 100000
2 200000 0
3 400000 100000
4 300000 0
5 500000 200000 200000
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company has the following investment alternatives. The cash flows are shown below. Year          Project A         Project B...
A company has the following investment alternatives. The cash flows are shown below. Year          Project A         Project B 0                -$2,000            -$2,000 1                   1,000                1,100 2                      800                   600 3                      900                   800 Which project(s) should the company select if the cost of capital is 13%? Project B with an IRR of 15.69% Project A with an IRR of 17.03% Both project A and project B Project B with an IRR of 12.93% Project A with an IRR of 14.37%
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR and PayBack Period 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $     200,000 2) New equipment cost $          (200,000) 9) Sales increase per year 4% 3) Equipment ship & install cost $            (25,000) 10) Operating cost: $    (120,000) 4) Related start up cost $              (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $             25,000 11) Depreciation (Straight Line)/YR $      (60,000) 6) Accounts Payable...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR and PayBack Period 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $     200,000 2) New equipment cost $          (200,000) 9) Sales increase per year 4% 3) Equipment ship & install cost $            (25,000) 10) Operating cost: $    (120,000) 4) Related start up cost $              (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $             25,000 11) Depreciation (Straight Line)/YR $      (60,000) 6) Accounts Payable...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR...
1. Learning Objectives (a)  Develop proforma Project Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cash flows, NPV,  IRR and PayBack Period 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $     200,000 2) New equipment cost $          (200,000) 9) Sales increase per year 4% 3) Equipment ship & install cost $            (25,000) 10) Operating cost: $    (120,000) 4) Related start up cost $              (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $             25,000 11) Depreciation (Straight Line)/YR $      (60,000) 6) Accounts Payable...
7. The (net) cash flows of project X are shown below: Year (Net) Cash Flows ($)...
7. The (net) cash flows of project X are shown below: Year (Net) Cash Flows ($) 0 -10,000 1 35,200 2 -29,751 a. What are the multiple internal rates of return of project X? (1 point) b. Draw the approximate NPV profile of project X. (1 point) c. Should this project be accepted if the cost of capital is 10%? Why? (0.5 point)
A tire manufacturing firm is considering Projects S and L, whose cash flows are shown below....
A tire manufacturing firm is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. What is the cost of capital at which the decision to take project L (or S) based on NPV will contradict the decision based on IRR method? Hint: Calculate the crossover rate and explain how the crossover rate would influence your decision to take project L or project S based on NPV vs. IRR?...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
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: 0 1 2 3 4 5 Cash flow –$235,000 $65,800 $84,000 $141,000 $122,000 $81,200 Use the IRR decision rule to evaluate this project. (Do not round intermediate calculations and round...
A company has a proposed 2-year project with the cash flows shown below and would like...
A company has a proposed 2-year project with the cash flows shown below and would like to calculate the NPV of this project so that they can decide whether to pursue the project or not. The company has a target capital structure of 60% equity and 40% debt. The beta for this firms stock is 1, the risk-free rate is 4.2, and the expected market risk premium is 5.8%. The bonds for this company pay interest semiannually and have a...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
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 8 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow: −$5,000 $1,200 $2,400 $1,600 $1,600 $1,400 $1,200 Use the IRR decision rule to evaluate this project. (Do not round intermediate calculations...
Suppose your firm is considering investing in a project with the cash flows shown below, that...
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 7 percent, and that the maximum allowable payback and discounted payback statistics for the project are 2.0 and 3.0 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow: –$6,800 $1,010 $2,210 $1,410 $1,410 $1,210 $1,010 Use the IRR decision rule to evaluate this project. (Negative amount should be indicated...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT