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
-
Prepare the journal entry to record the issuance of camman stack Dr CR CR On January 1, 2022 B&O issues 1,000 shares of $100 par value 2% cumulative Class A preferred stack for $150,000. Prepare the...
-
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...
-
Pop Corporation acquired a 70 percent interest in Stu Corporation on January 1, 2011, for $2,800,000, when Stu's stockholders' equity consisted of $2,000,000 capital stock and $1,200,000 retained...
-
Does the income statement of Tastykake in Appendix A indicate the net income earned by its business segments? If so, list them.
-
Determine the magnitudes of F1, F2 and F3 for equilibrium of the particle F = {- 9i - 8j - 5k}. Units Used: kN = 103 N Given: F = (-9 -8 -5) kN a = 4 m b = 2 m c = 4 m θ1 = 30 deg θ2 = 60...
-
On 1 January 20X2, Lucky Company purchased $5,700,000 of Fire Corp. 3% bonds, classified as a FVTPL. The bonds pay semi-annual interest each 30 June and 31 December. The market interest rate was 4%...
-
A2 percent increase in the price of milk causes a 4 percent reduction in the quantity demanded of chocolate syrup. What is the cross-price elasticity of demand for chocolate syrup with respect to the...
-
A 5 kg block is given an initial velocity of 10 m/s. If there is a friction force of 13 N opposing the motion of the block, how far will the block move before coming to a rest?
-
Select two of the unit student learning outcome (USLO) prompts below to respond to in this week's discussion. Identify the organelles of the cell as well as their function. Differentiate the...
-
Using the topic : Effects of technology and automation Identify one or more aspects of the List A issue that might fall prey to a logical fallacywhether formal or informalwhen developing an argument....
-
Compare and contrast the most widely discussed leadership styles today include authoritarian or autocratic, democratic, transformational, transactional, servant, and laissez-faire, with a conclusion,...
-
Educational Philosophy 10 points Write a brief paper that presents your philosophy on the education of students with disabilities (i.e., your thoughts about access and inclusion in public schools,...
-
Compare and contrast nonprofit management with for-profit business management. In your view, what are the three most important differences that effective managers should be aware of?
-
Complete Journal entries for all the above and balance General Ledger where applicable Binh's Bin opened a new company for Dumpsters on March 1, 2022. During June 2022, the following transactions...
-
The following information is for Montreal Gloves Inc. for the year 2020: Manufacturing costs Number of gloves manufactured Beginning inventory $ 3,016,700 311,000 pairs 0 pairs Sales in 2020 were...
-
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)....
-
What is the cost of net debt of a company that has no more shareholders equity equal to? And the cost of capital?
-
Is the cost of capital an accounting or financial concept?
-
What are we forgetting when we say that by increasing return on equity, the leverage effect of debt cannot increase value?
Study smarter with the SolutionInn App