Calculate the followings requirements. 11 12 B 13 14 The system will cost 15 Useful life 16
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the followings requirements.
Transcribed Image Text:
11 12 B 13 14 The system will cost 15 Useful life 16 Salvage value 17 Discount rate or Cost of Capital 18 Tax Rate 19 Depreciation method 20 с 7 ABC Company is considering the purchase of a computer-aided manufacturing system. 8 The annual before tax cash benefits/savings associated with the system are described below: 9 10 1 Part 1 2 You will be graded based off your usage of excel and the accuracy of your answer. 3 You are required to use the NPV and IRR functions that are available through excel. DO NOT use the PV table figures. 4 Please make sure you look at the demonstration exercise I have posted for chapter 15 support folder. 5 You need to use cell references and functions whenever possible. 6 33 34 35 D E Decreased Waste cost Decrease in operating costs Increase in on-time deliveries savings $500,000 8 years 0 Straight line 45 46 17 F $55,000 25,000 39,000 23 1. Prepare a time line for displaying cash flows. Be certain to consider the effects of taxes. 24 25 36 3. Calculate the after-tax NPV on the project using the NPV function in Excel. 37 G 10% 28% Hint: Don't forget to compute net of tax amount. Look at pages 15-12 to 15-15. Hint: Don't forget the depreciation tax shield. H 26 27 28 29 30 2. Calculate the payback period for the system. Assume that the company has a policy of only accepting 31 projects with a payback of 5 years or less. Should the company buy the system based on the payback period criteria? Why? 32 38 39 4. Calculate the IRR for this project using the IRR function in Excel. 40 41 42 43 5. Should the system be purchased based on the NPV and IRR criteria? Why or Why not? 44 J K L M N 0 You should use plain straight-line depreciation, so do not use first year half year depreciation. 21 Required: Use cell references to link to the data above. The demonstration problem for chapter 15 would be a good model to use, but remember you should not be using the table figures but using the NPV, IRR, and PV functions using Excel. 22 P Q R S T U V 11 12 B 13 14 The system will cost 15 Useful life 16 Salvage value 17 Discount rate or Cost of Capital 18 Tax Rate 19 Depreciation method 20 с 7 ABC Company is considering the purchase of a computer-aided manufacturing system. 8 The annual before tax cash benefits/savings associated with the system are described below: 9 10 1 Part 1 2 You will be graded based off your usage of excel and the accuracy of your answer. 3 You are required to use the NPV and IRR functions that are available through excel. DO NOT use the PV table figures. 4 Please make sure you look at the demonstration exercise I have posted for chapter 15 support folder. 5 You need to use cell references and functions whenever possible. 6 33 34 35 D E Decreased Waste cost Decrease in operating costs Increase in on-time deliveries savings $500,000 8 years 0 Straight line 45 46 17 F $55,000 25,000 39,000 23 1. Prepare a time line for displaying cash flows. Be certain to consider the effects of taxes. 24 25 36 3. Calculate the after-tax NPV on the project using the NPV function in Excel. 37 G 10% 28% Hint: Don't forget to compute net of tax amount. Look at pages 15-12 to 15-15. Hint: Don't forget the depreciation tax shield. H 26 27 28 29 30 2. Calculate the payback period for the system. Assume that the company has a policy of only accepting 31 projects with a payback of 5 years or less. Should the company buy the system based on the payback period criteria? Why? 32 38 39 4. Calculate the IRR for this project using the IRR function in Excel. 40 41 42 43 5. Should the system be purchased based on the NPV and IRR criteria? Why or Why not? 44 J K L M N 0 You should use plain straight-line depreciation, so do not use first year half year depreciation. 21 Required: Use cell references to link to the data above. The demonstration problem for chapter 15 would be a good model to use, but remember you should not be using the table figures but using the NPV, IRR, and PV functions using Excel. 22 P Q R S T U V
Expert Answer:
Answer rating: 100% (QA)
ANSWER Time Line for displaying cash flows Year Cash Flows Depreciation Tax Shield AfterTax Cash Flo... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Calculate the followings statistics forstockreturn,market indexreturn, and T-bills returnduringperiod 1927-2016byusing the Excel functions. 1.Average return 2.Variance 3.Standard deviation PartB:...
-
Requirements are to be planned for component C5 in product P1. Required deliveries for P1 are given, and the product structure for P1. Assembly lead time for products and subassemblies (P and S...
-
Write followings for any typical Personal Loan Management System for a Bank Personal Loan Process (flow chart) Documents required for the approval process Payslip CNIC copy Copy of utilities Bills...
-
Holly funded the Holly Marx Trust in January 2020. The entire trust income is payable to her adult son Jack for 20 years. At the end of the twentieth year, the trust assets are to pass to Hollys...
-
John Watson invested $5,000,000 in SmartRead, Inc., a company that was developing an electronic reading device. Within a few months, the $5,000,000 was spent but SmartRead never developed the reading...
-
Sheridan Construction Company has entered into a contract beginning January 1, 2025, to build a parking complex. It has been estimated that the complex will cost $596,000 and will take 3 years to...
-
Ozarch Ltd is in the process of preparing direct labour and factory overhead budgets for the year ending 30 June 2025. Relevant data are set out below. Required (a) Prepare the direct labour budget...
-
If a manufacturer sells its laundry detergent to a wholesaler for $2.50, at what price will the wholesaler sell it to a retailer if the wholesaler wants a 15 percent margin based on the selling...
-
Workplace safety has economic, reputational, and ethical implications. What do you think these implications may be? what are the best aspects in employment law in the workplace?
-
Consolidation related simulation example: Millennium Capital Management, Inc., (MCM) acquired a 90% interest in NextGen, Inc. MCM's Financial Manager, Matthew Steven, has prepared a draft memo to the...
-
Solve the given system of equations x + y + z = 2, 2 x + 3 z = 5, 3 x + y + 4 z = 6.
-
Describe the differences between various garbage collection algorithms, such as Mark-and-Sweep, Generational, and Reference Counting. What are the trade-offs in terms of memory usage, latency, and...
-
Fiona and Waleed would like to buy a house in the next few years. The market price for a suitable house is approximately AUD1.8 million. The bank has suggested the best approach would be to sell the...
-
Williamson, Inc., has a debt-equity ratio of 3. The firm's weighted average cost of capital is 12 percent, and its current cost of equity is 18 percent. Williamson has no preferred stocks in its...
-
M. Supervision 1. What are the differences between general and specific supervision? 2. When should each type of supervision be used? 3. As a sport administrator, what guidelines would you provide...
-
Markus recently lost his house and contents in a bushfire that he constructed 5 years ago for $180,000 and spent $40,000 at that time on various appliances, furniture, fixtures and fittings for the...
-
Journalize the following transactions for Blossom Carpentry, Inc. (If no entry is required, select "No Entry" for the account titles and enter O for the amounts. Credit account titles are...
-
Carlton Stokes owns and operates a car-detailing business named SuperShine & Detailing. For $150, Carltons business will hand wash and wax customers cars, vacuum the interior, and thoroughly clean...
-
Cypress Corporation has regular taxable income of $170,000 (assume annual gross receipts are greater than $5 million) and regular tax liability of $49,550 for 2012. The corporation also has tax...
-
Dr. Ivan I. Incisor and his wife Irene are married and file a joint return for 2012. Ivan's Social Security number is 477-34-4321 and he is 48 years old. Irene I. Incisor's Social Security number is...
-
Olive Corporation was formed and began operations on January 1, 2012. The corporation's income statement for the year and the balance sheet at year-end are presented below. The corporation made...
-
Describe how partial and circular reasoning can be helpful or harmful in resolving ethical dilemmas.
-
Describe the various legal risks for nurses.
-
Describe the various roles of advanced practice nurses.
Study smarter with the SolutionInn App