Q32 For the following organisation, calculate the undiscounted cash flow. You can do it in Excel and paste the result below. Year Unit Price Units Sold Net Sales Variable Costs Fixed Costs Depreciation PBIT Tax@40% NOPAT Adjustments Add back Depreciation CapEx Salvage value Net cash flow Cumulative cash flow 0 $100,000 1 $105 900 2 $110 1000 3 $115 1100 4 $120 1200 $54,000 $60,000 $15,000 $15,750 $13,000 $13,000 $13,000 5 $125 1300 $66,000 $72,000 $78,000 $16,538 $17,364 $18,233 $13,000 $13,000 $40,000 Place your answer (Excel) in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above.

Q32 For the following organisation, calculate the undiscounted cash flow. You can do it in Excel and paste the result below. Year Unit Price Units Sold Net Sales Variable Costs Fixed Costs Depreciation PBIT Tax@40% NOPAT Adjustments Add back Depreciation CapEx Salvage value Net cash flow Cumulative cash flow 0 $100,000 1 $105 900 2 $110 1000 3 $115 1100 4 $120 1200 $54,000 $60,000 $15,000 $15,750 $13,000 $13,000 $13,000 5 $125 1300 $66,000 $72,000 $78,000 $16,538 $17,364 $18,233 $13,000 $13,000 $40,000 Place your answer (Excel) in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter7: Valuation Of Stocks And Corporations

Section: Chapter Questions

Problem 23SP

See similar textbooks

Similar questions

What is the internal rate of return for the following set of cash flows?Year Cash Flow0 -$60,0001 20,0002 20,0003 40,0004 40,000 Do not answer in excel format. Please give formula/handwritten or TI-84 calculator 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.
Consider a project with the following cash flows: Time 0 1 2 3 4 5 CF -$5,000 $5,000 $4,000 $2,000 $1,000 -$6,000 Please round your answer to two decimal places. (e.g. 12345.67 for $12,345.67; 12.34 for 12.34%) a) To calculate the MIRR, find the modified cash flow at year 5 b) What does excel (or your calculator) say the IRR is?
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…
Find the NPV for the following cash flows assuming a WACC of 10%. YR CF 0 -15,000 1 6,000 2 4,000 3 2,000 4 3,000 5 2,000
Consider the following financial information and answer the questionsthat follow:Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000You are required to:i) Calculate the operating cash flow ii) Calculate the cash flow to creditors iii) Calculate the cash flow to shareholders iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC PLEASE SHOW WORKING
Consider the following financial information and answer the questionsthat follow:Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000You are required to:i) Calculate the operating cash flow ii) Calculate the cash flow to creditors iii) Calculate the cash flow to shareholders iv) Calculate the cash flow from assets v) Calculate net capital spending vi) Calculate change in NWC
Consider the following financial information and answer the questionsthat follow:Sales : $250,000Costs : $134,000Depreciation : $10,200Operating expenses : $6,000Interest expenses : $20,700Taxes : $18,420Dividends : $10,600Addition to Retained Earnings : $50,080Long term debt repaid : $9,300New Equity issued : $8,470New fixed assets acquired : $15,000You are required to:i) Calculate the operating cash flow ii) Calculate the cash flow to creditorsiii) Calculate the cash flow to shareholders
Consider a project with the following cash flows: Time 0 1 2 3 4 5 CF -$5,000 $5,000 $4,000 $2,000 $1,000 -$6,000 Please round your answer to two decimal places. (e.g. 12345.67 for $12,345.67; 12.34 for 12.34%) a) What does excel (or your calculator) say the IRR is?
Anderson Systems is considering a project that has the following cash flow and WACC data. The project's NPV is $___________. Enter two decimals. WACC = 9% Year 0 1 2 3 Cash Flows -$1,000 $500 $500 500
Datta Computer Systems is considering a project that has the following cash flow data. What is the project’s IRR? Year 0 1 2 3 Cash flows −$1,200 $350 $570 $690 Group of answer choices 9.70% 10.78% 13.31% 14.50% 11.98%
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