Questions: Crowell Company is considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 over 10 years. Crowell requires a 15% rate of return on this type of investment. Expected net cash inflows are as follows: Requirements - X 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $8,100,000. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done - X Data Table Year Plan Alpha Plan Beta 1 1,700,000 $ 1,700,000 1,700,000 2,400,000 1,700,000 3,100,000 4 1,700,000 2,400,000 1,700,000 1,700,000 6 1,700,000 1,600,000 7 1,700,000 1,300,000 1,700,000 1,000,000 1,700,000 700,000 1.700.000 1,100,000 10 17,000,000 $ 17,000,000 Total

Questions: Crowell Company is considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 over 10 years. Crowell requires a 15% rate of return on this type of investment. Expected net cash inflows are as follows: Requirements - X 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $8,100,000. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done - X Data Table Year Plan Alpha Plan Beta 1 1,700,000 $ 1,700,000 1,700,000 2,400,000 1,700,000 3,100,000 4 1,700,000 2,400,000 1,700,000 1,700,000 6 1,700,000 1,600,000 7 1,700,000 1,300,000 1,700,000 1,000,000 1,700,000 700,000 1.700.000 1,100,000 10 17,000,000 $ 17,000,000 Total

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

NPV: Basic Concepts Buena Vision Clinic is considering an investment that requires an outlay of $600,000 and promises a net cash inflow one year from now of $810,000. Assume the cost of capital is 10 percent. The present value tables provided in Exhibit 19B.1 and Exhibit 19B.2 must be used to solve the following problems. Required: 1. Break the $810,000 future cash inflow into the three components shown below. Enter all your answers as positive amounts. a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. $ 136,350 ✓ 600,000 ✓ 60,000 ✓ 150,000 ✓ 3. Compute the NPV of the investment. When required, round your answer to the nearest dollar. $ Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV? Net present value represents the present value of future profits ✓
H
Use python to answer the following question: Question 5 A capital investment in an equipment with an upfront cost of $23,540 will provide you with the following annual cash flow stream (paid end of year): 1. $2,000 2. $1,456 3. $3,230 4. $6,850 5. $2,384 6. $1,234 7. $5,987 8. $4,190 The project will incur the following cost for maintenance and repair (paid end of year): Year 3: ($2,984) Year 4: ($1,837) Year 6-8: ($2,000) Calculate the NPV of the investment and comment on whether you should invest in the project. Why or why not? What is the IRR of the investment? The required rate of return is 3.5%.
Net Present Value Method, Internal Rate of Return Method, and Analysis for a Service Company The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Biofuel Equipment Year 1 2 3 4 Year 1 2 The wind turbines require an investment of $513,900, while the biofuel equipment requires an investment of $1,093,320. No residual value is expected from either project. Present Value of an Annuity of $1 at Compound Interest 12% 0.893 1.690 2.402 3.037 3.605 3 4 5 Wind Turbines 6 7 8 9 10 Required: $180,000 180,000 180,000 180,000 6% 0.943 1.833 2.673 3.465 4.212 4.917 5.582 6.210 6.802 7.360 10% 0.909 1.736 2.487 3.170 3.791 4.355 4.868 5.335 $360,000 360,000 360,000 360,000 5.759 6.145 4.111 4.564 4.968 5.328 5.650 15% 0.870 1.626 2.283 2.855 3.353 3.785 4.160 4.487 4.772 5.019 20% 0.833 1.528 2.106 2.589 2.991 3.326 3.605 3.837 4.031 4.192 1a. Compute the net present value for each project. Use…
c. A company is planning to invest in a project over a 5-year period, but wants to know its financial implications. It expects the cash in-flow return on the investment to steadily increase over the 5 years. Using the information below, help determine the Total Net Cash Flows, the Net Present Value and the estimated Payback Period. Note: Estimate the payback period to the nearest year. Discount Rate 12% Investment Project Cash Flow Total Net Cash Flow Initial Investment $ (5,000) ? Year 1 $ 800 ? Year 2 $ 900 ? Year 3 $ 1,500 ? Year 4 $ 1,800 ? Year 5 $ 3,200 ? NPV of investment ? Estimated Payback Period
Please Need Correct Answer with Explanation with calculation
Please complete these charts
c. A company is planning to invest in a project over a 5-year period, but wants to know its financial implications. It expects the cash in-flow return on the investment to steadily increase over the 5 years. Using the information below, help determine the Total Net Cash Flows, the Net Present Value and the estimated Payback Period. Note: Estimate the payback period to the nearest year. Discount Rate 12% Investment Project Initial Investment Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow $ $ $ $ $ $ Total Net Cash Flow (5,000) 800 ? 900 ? 1,500 ? 1,800 ? 3,200 NPV of investment Estimated Payback Period
Please give answer a & b And Don't give answer in image format
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
Financial Manager of Timmy Company is considering two projects (project A and project H), which have cash flows as follows: Year Cash Flow of Project A (in $) Cash Flow of Project H (in $) 0 -100 -100 1 10 70 2 60 50 3 80 20 Timmy Company’s cost of capital is 10 percent. Calculate payback, NPV, IRR, and MIRR for both projects. (Please have a step by step format to your answer with explainations. Thanks (=)