The following spreadsheet has been developed to solve for the incremental internal rate of return for the comparison of the new challenger to the defender. Complete the missing information in the table. Net Cash Flow (NCF) for challenger Net Cash Flow (NCF) for defender Incremental Cash Flow End of Year (EOY) (INCR, CF) 24 $-520,000 $0,000 24 1-9 $140,000 $0,000 10 $300,000 $0,000 Round your answer to the nearest dollar. The tolerance is +/- 10. If entering a negative number use the (-) sign. What is the IRR for the incremental cash flow? IRR = % Do all calculations to 5 decimal places and round final answer to 2 decimal places. The tolerance is +/- 0.02. If entering a negative number use the (-) sign.

The following spreadsheet has been developed to solve for the incremental internal rate of return for the comparison of the new challenger to the defender. Complete the missing information in the table. Net Cash Flow (NCF) for challenger Net Cash Flow (NCF) for defender Incremental Cash Flow End of Year (EOY) (INCR, CF) 24 $-520,000 $0,000 24 1-9 $140,000 $0,000 10 $300,000 $0,000 Round your answer to the nearest dollar. The tolerance is +/- 10. If entering a negative number use the (-) sign. What is the IRR for the incremental cash flow? IRR = % Do all calculations to 5 decimal places and round final answer to 2 decimal places. The tolerance is +/- 0.02. If entering a negative number use the (-) sign.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter14: Statement Of Cash Flows (cashflow)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

Assume San Lucas Corporation in MAD 26-1 assigns the following probabilities to the estimated annual net cash flows: a. Compute the expected value of the annual net cash flows. b. Determine the expected net present value of the equipment, assuming a desired rate of return of 10% and the expected annual net cash flows computed in part (a). Use the present value tables (Exhibits 2 and 5) provided in the chapter in determining your answer. c. Based on your results in parts (a) and (b), should San Lucas Corporation invest in the equipment?
The management of Ryland International Is considering Investing in a new facility and the following cash flows are expected to result from the investment: A. What Is the payback period of this uneven cash flow? B. Does your answer change if year 6s cash inflow changes to $920,000?
The management of Kawneer North America is considering investing in a new facility and the following cash flows are expected to result from the investment: A. What is the payback period of this uneven cash flow? B. Does your answer change if year 10s cash inflow changes to $500,000?
Assume a company is going to make an investment in a machine of $825,000 and the following are the cash flows that two different products would bring. Which of the two options would you choose based on the payback method?
Please I will like an answer step by step. Thank you. Given the following sensitivity analysis, which of the following statements is true? Estimated Annual Net Cash Flow $500,000 $600,000 $700,000 Present value of annual net cash flows (× 4.487) $2,243,500 $2,692,200 $3,140,900 Present value of residual value 50,000 50,000 50,000 Total present value $2,293,500 $2,742,200 $3,190,900 Amount to be invested (3,000,000) (3,000,000) (3,000,000) Net present value (706,500) (257,800) 190,900 a.The investment is not justified if the annual net cash flow will be $500,000 or $600,000. b.The annual net cash flow necessary to generate a positive net present value is above $700,000. c.The total amount to be invested is $3,050,000. d.Only an annual net cash flow of $700,000 will allow for a positive residual value.
A company has received a proposal from a manager asking to spend ₱1,500,000on equipment that will result in cash inflows as indicated in the table below:Year Cash Flow1 150,0002 150,0003 200,0004 600,0005 900,000What is the payback period if averaging and subtracting methods are used?
Xander Inc. has prepared the following sensitivity analysis: Line Item Description Amount Amount Amount Estimated Annual Net Cash Flow $500,000 $600,000 $700,000 Present value of annual net cash flows (× 4.487) $2,243,500 $2,692,200 $3,140,900 Present value of residual value 50,000 50,000 50,000 Total present value $2,293,500 $2,742,200 $3,190,900 Amount to be invested (3,000,000) (3,000,000) (3,000,000) Net present value $(706,500) $(257,800) $190,900 In addition, it has assigned the following likelihoods to the three possible annual net cash flows: $500,000, 70%; $600,000, 20%; and $700,000, 10%. Based on an expected value analysis, which of the following statements is accurate? a. The expected value of the annual net cash flow is $540,000, and the project should be accepted. b. The expected value of the annual net cash flow is $660,000, and the project should be accepted. c. The expected value of the annual net cash flow is $660,000, and the project…
For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed by the IRR function (c) the external rate of return using the MIRR method if ii = 18% per year and ib = 10% per year. Year 0 1 2 3 4 Revenues, $ 0 25,000 19,000 4000 18,000 Costs, $ −6000 −30,000 −7000 −6000 −12,000
As assistant to the CFO of Boulder Inc., you must estimate the Year 1 cash flow for a project with the following data. What is the Year 1 cash flow? Do not round the intermediate calculations and round the final answer to the nearest whole number. Sales revenues$11,800Depreciation$4,000Other operating costs$6,000Tax rate35.0% a.$4,756 b.$5,170 c.$6,359 d.$5,377 e.$4,033
Consider the following project cash flow. YEAR CASH FLOW 0 -1000 1 500 2 500 3 500 4 500 5 500 Use this information to calculate the Internal Rate of Return by linear interpolation(the trial and error method). WITH WORKING PLEASE
The following table indicates the net cash flows of a capital asset: Year Net Cash Flow 0 $-159,000 1 $59,000 2 $59,000 3 $59,000 4 $59,000 Do not enter dollar signs or commas in the input boxes. Round your answer to 2 decimal places. Calculate the cash payback period using the formula method. Payback: Answer years
Fransico Ltd. is trying to determine which of three projects it wants to invest in. All three projects have been analyzed into Net Present Value amounts. (Round your answers to two decimal places when needed and use rounded answers for all future calculations). 1. Calculate the Net Present Value based on the following information: Cash Flows Project 2 Project 6 Project 12 Present Value of net cash inflows $491,900 $778,300 $503,700 Initial InvestmentSingle line $146,000Single line $407,400Single line $206,400Single line Single lineNet Present ValueDouble line Single lineDouble line Single lineDouble line Single lineDouble line 2. Calculate the Profitability Index for each of the projects. Round to two decimal places. Project Present value of net cash inflows / Initial Investment = Profitability Index 2 / = 6 / = 12 / = 3. Based on the Profitability Index, which project should be selected?