Question

In: Finance

Assignment Description: ABC Corporation has a machine that requires repairs or should be replaced. ABC has...

Assignment Description: ABC Corporation has a machine that requires repairs or should be replaced. ABC has evaluated the two options and calculated the cash flows resulting from each option as follows: Option A: Repair the Machine Year Cash Flow 0 -50,000 1 15,500 2 20,100 3 18,900 4 17,100 5 13,700 Option B: Buy a new Machine Year Cash Flow 0 -400,000 1 51,300 2 155,000 3 127,800 4 126,900 5 125,100 You have recently been hired by ABC Corporation and your first assignment is to help them decide which of these two options should be pursued. You would like to apply Capital Budgeting and Time Value of Money concepts you have learnt in this class to analyze the problem and present your recommendation to your boss, Ms. Jane Austen. Conduct the analysis by calculating the Internal Rate of Return (IRR) and Net Present Value (NPV) for each option. The company has a Weighted Average Cost of Capital (WACC) of 12%. For this analysis, your boss asked you to calculate NPV at three different discount rates: 12% (the current WACC), 14% and 16%. Things to turn in: 1. A one-page memo explaining the results of your analysis and your recommendation. The memo should include important results of your analysis such as a summary table or graph. The memo is limited to one page so be very selective on what information to include. 2. An Excel spreadsheet showing calculation of Net Present Value at the 3 discount rates and calculation of Internal Rate of Return.

Solutions

Expert Solution

Hey there,

First of all have to tell you that, on our platform, we cant upload an excel sheet.

So I have taken the pictures of the excel sheet with utmost clarity.

The formula used are as follows

NPV "=NPV(rate,values)+initial outlay"

IRR "=IRR(values,guess)"

Hope the pictures are clear enough.

The decision rule for NPV says that Higher the NPV value, higher will the profitability.On the basis of NPV values we get, we will invest in option B when WACC is 12% as NPV value is coming out to be higher in option B,However @ 14 % and @ 12%, we would invest in Option A as they are showing us the higher values.

The decision rule for IRR says that select the project where WACC is lower than IRR.

Therefore, @ 12%,we can choose any of the projects as both the IRR values are lower than WACC, but Option B is more preferable.

@ 14% & 16%, we'll choose option A as the WACC values are lower than IRR.


Related Solutions

Excel and Writing Case Assignment Description: ABC Corporation has a machine that requires repairs or should...
Excel and Writing Case Assignment Description: ABC Corporation has a machine that requires repairs or should be replaced. ABC has evaluated the two options and calculated the cash flows resulting from each option as follows: Option A: Repair the Machine Year Cash Flow 0 -50,000 1 15,500 2 20,100 3 18,900 4 17,100 5 13,700 Year Cash Flow Option B: Buy a new Machine Cash Flow 0 -400,000 1 51,300 2 155,000 3 127,800 4 126,900 5 125,100 You have...
Pls analysis and determine which machine should purchase. ABC company requires a 12.5% rate of return...
Pls analysis and determine which machine should purchase. ABC company requires a 12.5% rate of return and uses straight-line depreciation to a zero-book value. Machine1 has a cost of $25,000, annual operating costs of $1,000, and a 3-year life. Machine2 costs $17,500, has annual operating costs of $1,300, and has a 2-year life. No matter which machine is purchased will be replaced at the end of its useful life. Which machine should be purchased and why?
Assignment Description: In this assignment, a script file should be created to contain a set a...
Assignment Description: In this assignment, a script file should be created to contain a set a SQL statements for the Pretty Prints Company to better manage their business. Use the database created for Pretty Prints in Assignment 2. Include the SQL statements to satisfy the following queries. The following queries should be included in the script: Create a view named Under_100. It consists of the item_id, title, artist, unit_price and order_qty for every print with a unit_price under 100 dollars....
Python Project Description: Text Processing This assignment requires you to process a short text from an...
Python Project Description: Text Processing This assignment requires you to process a short text from an input file, perform some analyses, manipulate the text, and save the results in an output file. For example, the input file bentley.txt contains a brief introduction of Bentley University: Each line in this file is a paragraph that contains one or more sentences. Note that each line can be very long! The program will provide the following user interaction on the screen: · Ask...
ABC Corporation purchased a machine on January 1, 2017, for $56,000. Before the machine was utilized...
ABC Corporation purchased a machine on January 1, 2017, for $56,000. Before the machine was utilized in a productive capacity, it was needed to build a support in value of $4,000 to accommodate the machine, and to train an operator for using the machine ($2,000). For security reasons, a 5-years insurance policy was purchased for the machine in value of $5,000. Depreciation on the machine was recorded at the end of each year. The depreciation rate is $6,200 per year....
ABC corporation purchased machine Z beginning 2016 at a cost of $120000. the machine is used...
ABC corporation purchased machine Z beginning 2016 at a cost of $120000. the machine is used in the productin of product X. the machine is expected tto have a useful life of 10 years and no residual value. the straight line methods of depreciation is used. if you know that at december 31,2018, the appraisal value of machine Z is $88 200. at December 2020 an adverse economic conditions result in a signigicant decline in demand for Product X and...
The management of ABC Corporation is considering the purchase of a new machine costing $430,000. The...
The management of ABC Corporation is considering the purchase of a new machine costing $430,000. The company's desired rate of return is 10%. The present value factors for $1 at compound interest of 10% for 1 through 5 years are 0.909, 0.826, 0.751, 0.683, and 0.621, respectively. In addition to the foregoing information, use the following data in determining the acceptability in this situation by using the NPV methodology calculations Year Income from Operations Net Cash Flow 1 $100,000 $180,000...
ABC company has decided to purchase a new printing machine. This Machine has a 9-yer life...
ABC company has decided to purchase a new printing machine. This Machine has a 9-yer life and will cost 750,000 to install the new machine. Total operation costs of the machine per year is 10,000. Calculate the EAC, if the discount rate is 11.25%.
The ABC Corporation is considering the purchase of a new bottling machine for its wine bottling...
The ABC Corporation is considering the purchase of a new bottling machine for its wine bottling line. The bottling machine will cost $30,500. The maintenance and operating costs will amount to $1,300 for the first year. The maintenance and operating costs can be expected to increase $3,000 for each year that the bottling machine is used. The salvage value of the bottling machine, at any time that it is removed from service, will be the bottling machine's scrap value ($1,000)....
This assignment has three parts that should all be completed on one document. For this assignment...
This assignment has three parts that should all be completed on one document. For this assignment you will explore the cost-effectiveness of informatics interventions in healthcare. In your role as director of health informatics you are tasked with putting together an executive report that outlines and EHR adoption the effectiveness of EHR. The detailed assignment requirements are below. Part I Summary of laws and mandates requiring EHR adoption EHR & treatment effectiveness and efficiency Be sure to discuss how PHR...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT