Question

In: Statistics and Probability

Project 1 involves an outlay of $2.5m and gets an annual netincome of $1m for...

Project 1 involves an outlay of $2.5m and gets an annual net income of $1m for 5 years. Project 2 involves an outlay of $10m but gets no income until year 5. year project 1 project 2 0 -2.5 -10 1 1 0 2 1 0 3 1 0 4 1 0 5 1 15 . Use the payback method to decide which is the most attractive project. What is the accounting rate of return for project 1? Write your answer as a percent using the percent symbol. . What is the accounting rate of return for project 2? Write your answer as a percent using the percent symbol. Decide which is the most attractive project using the accounting rate of return method.

Solutions

Expert Solution

Simple IRR calculations done in excel to find the answer.

Formulates in the IRR cells are shown below

As we can see from above that the P1 has the IRR (internal rate of return) of 28.65% while P2 has only 2.09% Rate of return which makes Project 1 much better than Project 2

Attractive project using the accounting rate of return method is Project 1

The accounting rate of return for project 2 is 3.09%

Now you can use this formula in excel to calculate IRR for any project. The first value is -ve as it indicates the outflow.


Related Solutions

A project has an initial outlay of $2,378. The project will generate annual cash flows of...
A project has an initial outlay of $2,378. The project will generate annual cash flows of $660 over the 4-year life of the project and terminal cash flows of $202 in the last year of the project. If the required rate of return on the project is 13%, what is the net present value (NPV) of the project? Note: Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box.
1. The equivalent annual annuity method involves calculating the annual payment amount that a particular project...
1. The equivalent annual annuity method involves calculating the annual payment amount that a particular project would provide if it were an annuity. When comparing projects of unequal lives, the one with the higher equivalent annual annuity should be chosen.   a. True           b. False 2. Mutually exclusive projects sometimes have long and different lives which makes applying the replacement chain method difficult because the lowest common denominator is very large. The equivalent annual annuity is a substitute method which uses...
An investment project requires an initial outlay of $100,000, and is expected to generate annual cash...
An investment project requires an initial outlay of $100,000, and is expected to generate annual cash inflows of $28,000 for the next 5 years. The cost of capital is 12 percent. Determine the internal rate of return for the project (to the nearest tenth of one percent). a. 12.0% b. 12.6% c. 3.6% d. 12.4%
6. A project requires initial capital outlay of GH₡300,000. The project will provide annual cash flow...
6. A project requires initial capital outlay of GH₡300,000. The project will provide annual cash flow of GH₡80,000 for 5 years. what is the payback period? * Your answer
If Company XYZ plans to invest in a project with initial capital outlay $52,125, annual net...
If Company XYZ plans to invest in a project with initial capital outlay $52,125, annual net cash inflow $12,000 for 8 years, and discount rate 12%, what is the Company XYZ’s NPA, IRR, MIRR, Payback period, and Discounted Payback Period?
                PROJECT A           PROJECT B Initial Outlay      -50000   -70000 Inflow year 1
                PROJECT A           PROJECT B Initial Outlay      -50000   -70000 Inflow year 1      12000    13000 Inflow year 2      12000    13000 Inflow year 3      12000    13000 Inflow year 4      12000    13000 Inflow year 5      12000    13000 Inflow year 6      12000    13000 ​​(​NPV, ​PI, and IRR calculations​) You are considering two independent​ projects, project A and project B. The initial cash outlay associated with project A is ​$50000​, and the initial cash outlay associated with project B is ​$70000. The required rate of...
XYZ is considering a 3-yr project. The initial outlay is $120,000, annual cash flow is $50,000...
XYZ is considering a 3-yr project. The initial outlay is $120,000, annual cash flow is $50,000 and the terminal cash flow is $10,000. The required rate of return (cost of capital) is 15%. The net present value is $736.42. What if the required rate of return is 9% instead? Re-calculate the NPV.
Question N1 - XYZ is considering a 3-yr project. The initial outlay is $120,000, annual cash...
Question N1 - XYZ is considering a 3-yr project. The initial outlay is $120,000, annual cash flow is $50,000 and the terminal cash flow is $10,000. The required rate of return (cost of capital) is 15%. The net present value is $736.42. What if the annual cash flow increases to $57,000 instead? Re-calculate the NPV. Question N2 - Six years ago, XYZ Company invested $51,959 in a new machinery. The investment in net working capital was $4,716 which would be...
XYZ is considering a 3-yr project. The initial outlay is -$120,000, annual cash flow is $50,000...
XYZ is considering a 3-yr project. The initial outlay is -$120,000, annual cash flow is $50,000 and the terminal cash flow is $10,000. The required rate of return (cost of capital) is 15%. The net present value is $736.42. What if the annual cash flow increases to $54,000 instead? Re-calculate the NPV.
1. A proposed loan of $1m has total annual interest rate and fees of 6%. The...
1. A proposed loan of $1m has total annual interest rate and fees of 6%. The loan’s duration is 5.7 years. The lender’s cost of funds is 5.25%. Comparable loans have an interest rate of 5.85%. The expected maximum change in the loan rate due to a change in the credit risk premium for the loan is 1.25% (based on actual change in credit risk premium for the worst 1% of comparable loans over some prior period). a. What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT