Question

In: Finance

You are evaluating a project based on the following: Initial Investment: $1,250,000 Cash Flows: $275,000 per...

You are evaluating a project based on the following: Initial Investment: $1,250,000 Cash Flows: $275,000 per year for 5 years (end of year) Required Return: 10% Required Payback: 5 Years 1. Would you accept or reject the project based on the Net Present Value (NPV)? 2. Would you accept or reject the project based on the Payback Period? 3. Would you accept or reject the project based on the Discounted Payback Period? 4. Based on your answers to Questions 1-3, would you accept or reject the project? Why? Answer questions and include all work on the submission. Please show all work do not use Excel. Show all calculations. Thank you.

Solutions

Expert Solution

1)

Net present value = Present value of cash inflows - present value of cash outflows

Net present value = Annuity * [1 - 1 / (1 + r)n] / r - Initial investment

Net present value = 275,000 * [1 - 1 / (1 + 0.1)5] / 0.1 - 1,250,000

Net present value = 275,000 * 3.790787 - 1,250,000

Net present value = -$207,533.64

Project should be REJECTED as it has a negative NPV

2)

Payback period = Initial investment / cash flows

Payback period = 1,250,000 / 275,000

Payback period = 4.55 years

Project should be ACCEPTED based on payback as payback is less than 5 years

3)

Present value of year 1 cash flow = 275,000 / (1 + 0.1) = 250,000

Present value of year 2 cash flow = 275,000 / (1 + 0.1)2 = 227,272.7273

Present value of year 3 cash flow = 275,000 / (1 + 0.1)3 = 206,611.5702

Present value of year 4 cash flow = 275,000 / (1 + 0.1)4 = 187,828.7002

Present value of year 5 cash flow = 275,000 / (1 + 0.1)5 = 170,753.3638

Cumulative cash flow for year 0 = -1,250,000

Cumulative cash flow for year 1 = -1,250,000 + 250,000 = -1,000,000

Cumulative cash flow for year 2 = -1,000,000 + 227,272.7273 = -772,727.2727

Cumulative cash flow for year 3 = -772,727.2727 + 206,611.5702 = -566,115.7025

Cumulative cash flow for year 4 = -566,115.7025 + 187,828.7002 = -378,287.0023

Cumulative cash flow for year 5 = -378,287.0023 + 170,753.3638 = -207,533.64

The project does not payback as per discounted payback method. Therefore, project should be rejected.

4)

Project should be REJECTED as it has a negative NPV. We always look at the NPV as the most important criteria.

jeff jeffy answered 7 months ago
Next > < Previous

Related Solutions

A). You are evaluating a project with the following cash flows: initial investment is $-12, and...
A). You are evaluating a project with the following cash flows: initial investment is $-12, and the expected cash flows for years 1 - 3 are $10, $11 and $17 (all cash flows are in millions of dollars). What is this projects NPV? The company's WACC is 10%. B). You are evaluating a project with an initial investment of $16.9 million dollars, and expected cash flows of $7 million dollars each for years 1-3. What is the project's simple payback?...
You are evaluating a project with the following cash flows: initial investment is $-23, and the  expected...
You are evaluating a project with the following cash flows: initial investment is $-23, and the  expected cash flows for years 1 - 3 are $12, $9 and $8 (all cash flows are in millions of dollars). What is this projects NPV? The company's WACC is 9%. Express your answer in millions of dollars, rounded to 2 decimals and without the dollar sign. So, if your answer is 23.5678, just enter 23.57.
You are evaluating a project (initial investment is $41,000) that is expected to produce cash flows...
You are evaluating a project (initial investment is $41,000) that is expected to produce cash flows of $5,000 each year for the next ten years and $7,000 each year for the following ten years. The IRR of this project is 12%. The firm’s WACC is 8%. What is the project’s NPV?
A five-year project has an initial fixed asset investment of $275,000, an initial NWC investment of...
A five-year project has an initial fixed asset investment of $275,000, an initial NWC investment of $23,000, and an annual OCF of −$22,000. The fixed asset is fully depreciated over the life of the project and has no salvage value. If the required return is 10 percent, what is this project’s equivalent annual cost, or EAC? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,...
If you are evaluating a project with the following cash flows, for what range of costs...
If you are evaluating a project with the following cash flows, for what range of costs of capital would you accept the project? Year 0 Year 1 Year 2 Year 3 Project CF $1,000 -$700 -$600 -$500 2. You are considering two mutually exclusive projects with the following cash flows. The appropriate cost of capital for Project A is 10%. The appropriate cost of capital for Project B is 14%. Year 0 Year 1 Year 2 Year 3 Project A...
You are analysing a project and have prepared the following data: Year         Cash flows     0             -$275,000 &nbs
You are analysing a project and have prepared the following data: Year         Cash flows     0             -$275,000       1                 $ 50,000      2                $ 75,000      3                $ 95,000       4                 $ 15,000 Required payback period 3 years    Required rate of return 5% a) Determine the project’s Profitability Index, Internal Rate of Return, NPV and Discounted Payback Period                                                                                                                                                    [40 Marks] b) Decide whether accept the project based on the above investment decision criteria?          [5 Marks] [Total: 45 Marks] Please provide full steps (No excel...
Given the following, calculate the cash flows for the project. Initial investment $365,000 Expected life is...
Given the following, calculate the cash flows for the project. Initial investment $365,000 Expected life is 5 years First Year Revenues: 245,000 First Year Expenses: $70,000 Growth for revenue and expenses: 3 percent per year Straight Line Depreciation over 5 years Salvage Value: $45,000 One-time net working capital investment of $10,000 required at the start of the project This investment is recovered at the end of the project The tax rate is 34 percent Answer the following: What are the...
Solo Corp. is evaluating a project with the following cash flows:
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 28,500 1 10,700 2 13,400 3 15,300 4 12,400 5 – 8,900 The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Calculate the MIRR...
Solo Corp. is evaluating a project with the following cash flows:
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 28,500 1 10,700 2 13,400 3 15,300 4 12,400 5 – 8,900 The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Calculate the MIRR...
Waste Industries is evaluating a $55,500 project with the following cash flows. Years Cash Flows 1...
Waste Industries is evaluating a $55,500 project with the following cash flows. Years Cash Flows 1 $ 9,120 2 20,200 3 26,600 4 16,300 5 26,300 The coefficient of variation for the project is 0.475. Coefficient of Variation Discount Rate 0 − 0.25 7 % 0.26 − 0.50 9 % 0.51 − 0.75 13 % 0.76 − 1.00 16 % 1.01 − 1.25 19 % Use Appendix B for an approximate answer but calculate your final answer using the formula...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT