Question 1: Your company is considering the replacement of production equipment. There are two choices to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 1: Your company is considering the replacement of production equipment. There are two choices to consider and the company must choose only one of the available models. The required rate of return is 9% p.a. Assume a corporate tax rate of 30% and there is no additional working capital requirements in this case study. Depreciation follows a straight-line method on the cost of the equipment. The company expects to sell the equipment at the end of the terminal year. INPUT AREA Cost of equipment Useful life (years) Additional revenue before-tax (per annum) Additional operating costs before-tax (per Salvage value at end of useful life Model A $ Model B 800,000 $ 5 $ $ 725,000 $ 180,000 $ $ 200,000 $ Tax rate ROR 30% 9.0% 1,200,000 8 760,000 265,000 Operating expenses comprise of both VC and FC, there is no break-down in this question. 240,000 Question 1A: Set up the table of incremental cash flows for both Models A and B in the areas below. Use cell referencing (instead of hard coding the values). Determine the capital budgeting metrics for Models A and B, in the areas marked yellow below. Ensure your results are formula driven (instead of hard coding). Otherwise you will be unable to complete Parts B and C. Question 1A is worth 2 marks Model A: Revenue -Operating expenses EBITDA -D&A EBIT -Tax NOPAT +D&A CF from Operations - Capital Expenditure -Tax paid on CGT or Tax Saving on capital loss Incremental after-tax FCFS Cash flows to work out discounted payback period Cash flows to work out MIRR 0 1 2 3 5 Model B: Revenue -Operating expenses EBITDA -D&A EBIT UA NOPAT +D&A CF from Operations Capital Expenditure -Tax paid on CGT or Tax Saving on capital loss Incremental after-tax FCFs Cash flows to work out discounted payback period Cash flows to work out MIRR 0 6 7 8 Summary of base case estimates NPV IRR MIRR PI PI Payback Period, years Discounted Payback Period, years NPV Perpetuity Equilvalent Annual Annuity (EAC) Model A Model B Question 1B: Conduct a sensitivity analysis for Optimistic and Pessimistic variations to Revenues and Operating Costs. Report/summarise the NPVS from each outcome in the areas marked yellow below. Determine the range NPVs for each model under the Optimistic and Pessimistic scenarios to enhance your discussions. Hint: You can either make changes directly to the input (green) area and copy the NPVS from Row 60 as hard coded values into the yellow area below, OR you can make copies of the base case worksheet and make changes to the components. Question 1B is worth 0.5 marks Sensitivity Changes to Revenue 35%. Model A Model B Analysis (summary table) Changes to Op. Costs 35%: Model A Model B Base Case Optimistic Pessimistic Range Y Question 1C: Determine the NPV breakeven level of operating costs. How high must additional operating costs rise to, for each Model, in order for the alternative to be unfeasible? Report this in the areas marked yellow below. You can work out the percentage increase from base case estimates, to enhance your discussions. Question 1C is worth 0.5 marks NPV Breakeven Analysis (summary of findings) Maximum level of operating costs % increase Model A Model B Question 1D: Discuss if your company should replace production equipment with Model A or Model B. Elaborate on your reasoning. Enter your discussions in the textbox provided. Frame your discussions as an investment recommendation. Your recommendation should be based on evaluating the capital budgeting metrics for both alternatives and considers your findings from your sensitivity and breakeven analysis. Minimum 150 words. Maximum 250 words. Question 1D is worth 1 mark Question 1: Your company is considering the replacement of production equipment. There are two choices to consider and the company must choose only one of the available models. The required rate of return is 9% p.a. Assume a corporate tax rate of 30% and there is no additional working capital requirements in this case study. Depreciation follows a straight-line method on the cost of the equipment. The company expects to sell the equipment at the end of the terminal year. INPUT AREA Cost of equipment Useful life (years) Additional revenue before-tax (per annum) Additional operating costs before-tax (per Salvage value at end of useful life Model A $ Model B 800,000 $ 5 $ $ 725,000 $ 180,000 $ $ 200,000 $ Tax rate ROR 30% 9.0% 1,200,000 8 760,000 265,000 Operating expenses comprise of both VC and FC, there is no break-down in this question. 240,000 Question 1A: Set up the table of incremental cash flows for both Models A and B in the areas below. Use cell referencing (instead of hard coding the values). Determine the capital budgeting metrics for Models A and B, in the areas marked yellow below. Ensure your results are formula driven (instead of hard coding). Otherwise you will be unable to complete Parts B and C. Question 1A is worth 2 marks Model A: Revenue -Operating expenses EBITDA -D&A EBIT -Tax NOPAT +D&A CF from Operations - Capital Expenditure -Tax paid on CGT or Tax Saving on capital loss Incremental after-tax FCFS Cash flows to work out discounted payback period Cash flows to work out MIRR 0 1 2 3 5 Model B: Revenue -Operating expenses EBITDA -D&A EBIT UA NOPAT +D&A CF from Operations Capital Expenditure -Tax paid on CGT or Tax Saving on capital loss Incremental after-tax FCFs Cash flows to work out discounted payback period Cash flows to work out MIRR 0 6 7 8 Summary of base case estimates NPV IRR MIRR PI PI Payback Period, years Discounted Payback Period, years NPV Perpetuity Equilvalent Annual Annuity (EAC) Model A Model B Question 1B: Conduct a sensitivity analysis for Optimistic and Pessimistic variations to Revenues and Operating Costs. Report/summarise the NPVS from each outcome in the areas marked yellow below. Determine the range NPVs for each model under the Optimistic and Pessimistic scenarios to enhance your discussions. Hint: You can either make changes directly to the input (green) area and copy the NPVS from Row 60 as hard coded values into the yellow area below, OR you can make copies of the base case worksheet and make changes to the components. Question 1B is worth 0.5 marks Sensitivity Changes to Revenue 35%. Model A Model B Analysis (summary table) Changes to Op. Costs 35%: Model A Model B Base Case Optimistic Pessimistic Range Y Question 1C: Determine the NPV breakeven level of operating costs. How high must additional operating costs rise to, for each Model, in order for the alternative to be unfeasible? Report this in the areas marked yellow below. You can work out the percentage increase from base case estimates, to enhance your discussions. Question 1C is worth 0.5 marks NPV Breakeven Analysis (summary of findings) Maximum level of operating costs % increase Model A Model B Question 1D: Discuss if your company should replace production equipment with Model A or Model B. Elaborate on your reasoning. Enter your discussions in the textbox provided. Frame your discussions as an investment recommendation. Your recommendation should be based on evaluating the capital budgeting metrics for both alternatives and considers your findings from your sensitivity and breakeven analysis. Minimum 150 words. Maximum 250 words. Question 1D is worth 1 mark
Expert Answer:
Answer rating: 100% (QA)
Model A 1 Capital Cost 800000 2 Useful Life 5 years 3 Additional Revenue per year 600000 4 Additiona... View the full answer
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ
Posted Date:
Students also viewed these finance questions
-
Assume that it is January 1, 2019, and that the Mendoza Company is considering the replacement of a machine that has been used for the past 3 years in a special project for the company. This project...
-
From reading Saudi Vision 2030 (the PDF & review the 2030 Vision website) please identify a KSA leader who embodies a Leadership concept from this week's material. - How does this leader's work or...
-
What are due process and stare decisis, and why are they important?
-
The modulus of elasticity for spinel (MgAl2O4) having 5 vol% porosity is 240 GPa (35 106 psi). (a) Compute the modulus of elasticity for the nonporous material. (b) Compute the modulus of elasticity...
-
Investors receive dividends as payoffs for investing in equity shares. Thus the value of a share should be calculated by discounting expected dividends. True or false?
-
In Figure 7.7, consider the cart's initial speed to be \(v_{\mathrm{i}}\). Assuming no potential energy is initially stored in the spring, how much potential energy is stored in the spring at the...
-
The risk-free rate on T-bills recently was 1.23%. If the real rate of interest is estimated to be 0.80%, what was the expected level of inflation?
-
1. Your program asks the user how many bananas they want to buy, and what the price is. This information is then passed to getTotal to calculate the total cost. System.out.println("How many bananas...
-
PART-4 PART-5 PART-6 Jaguar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the following: Cash Investments (short-term) Accounts...
-
Write a Java program to create a new array list, add 10 names (string) and print out the list [6 marks] Update the program to insert an element into the array list at the first position. [3 marks]...
-
What is your view of the adequacy of U.S. environmental laws to protect the environment and human health? What would you change about the U.S. environmental laws if you had the power to do so?
-
Is there an environmental issue that you feel is not being properly addressed? Do you feel that we have sufficient environmental laws? Are environmental laws being properly enforced?
-
Which branch of the Federal Government writes Environmental Laws? Where do they get this authority? How can an Environmental Law be challenged? What is the basis to overturn an Environmental Law?...
-
What are the major sources of environmental law, the litigation (court cases) process, and the way in which environmental agencies enforce environmental law? How are states and municipalities...
-
Do you think the United States has enough environmental laws? How do you feel about the enforcement of present environmental laws? Should the laws be stronger, or do you feel they are overly...
-
You are considering to invest in Stock A and Stock B. The expected returns% of the stocks under different economic conditions are as follows: Probability Stock A return% Stock B return% Bear Market...
-
How can a promoter avoid personal liability for pre-incorporation contracts?
-
When the Coronet Company formed three divisions a year ago, the president told the division managers that an annual bonus would be paid to the most profitable division. However, absolute division...
-
The Walk Rite Shoe Company operates a chain of shoe stores. The stores sell ten different styles of inexpensive mens shoes with identical unit costs and selling prices. A unit is defined as a pair of...
-
Cost-Less Foods is considering replacing all of its old cash registers with new ones. The old registers are fully depreciated and have no disposal value. The new regis ters cost $600,000 (in total)....
-
Coherent states are potentially an interesting basis to consider in which to express states on the Hilbert space. Are they a good basis, satisfying qualities that we desire of a basis on the Hilbert...
-
In this chapter, we had only expressed eigenstates of the harmonic oscillator Hamiltonian through repeated action of the raising operator, \(\hat{a}^{\dagger}\). This gives us a concrete algorithm...
-
With this abstract form of a coherent state in Eq. (6.103), defined through the action of the raising operator on the ground state of the harmonic oscillator, lets see if we can express it in a more...
Study smarter with the SolutionInn App