1 EXPANSION PROBLEM I 2 Full price of machine 3 Increase in networking capital 4 Marginal...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 EXPANSION PROBLEM I 2 Full price of machine 3 Increase in networking capital 4 Marginal tax re 5 Sale price of machine 6 Incremental Revenues or Cost Savings 7 WACC 8 Depreciation year 1 9 Depreciation year 2 10 10 Depreciation year 3 11 Depreciation year 4 12 Depreciation year 5 13 Depreclation year 6 14 15 16 Full Price of Machine 17 18 Increase in net working capital 19 20 Incremental Revenues or Cost Savings 21 Depreciation 22 Operating Profit before taxes 23 Taxes 24 Operating Profit after taxes 25 Add back depreciation 26 Operating Cash Flow 27 28 Sale of Machine 29 Taxes 30 Net Salvage 31 32 Return of net working capital 33 34 Total Cash Flow 25 35 36 NPV 37 38 39 40 41 42 43 44 45 46 47 B 150,000.00 0.00 40,00 % 400,000.00 400,000,00 12.00% 33.00% 45.00% 15.00 % 7.00% 0.00% 0,00% Year 0 C Year 1 D Year 2 E NPV End of year BV Year 3 F Year 4 G Year 5 H Year 6 I J Spreadsheet 3 X L Not M B MITSHUNDRA "AS05 BIT COMPANY SOUNDS LIKE A REALLY WISE Chich to " N 0 P Q R You have been hired as a financial consultant by BUBBA corporation. BUBBA is considering investing in a new machine to produce dog biscuits. S BUBBA has provided you with the following information: Full price of machine is $150,000. There is no increase in net working capital. BUBBA has a 40% marginal tax rate. The machine falls into the MACRS 3-year class (33 %, 45%, 15%, and 7% depreciation rates) BBA will use the machine for 6 years and then plans to sell it for $20,000 at the end of year 6. The machine is expected to increase earnings before depreciation by $35,000 a year for the life of the machine. BUBBA has a WACC of 12%. Create a MS-Excel spreadsheet to calculate the NPV similar to the Cash Flow Estimation spreadsheet (40 points). This sheet should include cash flows in years 4, 5 and 6. The spreadsheet will be used by the BUBBA managers to assist them in making the investment decision. The spreadsheet should be set up to allow for a sensitivity analysis to be conducted. The cells to input the full price, increased earnings, sale price in year 6, and WACC should be easily identified and allow the BUBBA managers to change their values. Your sheet should be set up so that if the assumptions change your sheet updates. appropriately. 1 EXPANSION PROBLEM I 2 Full price of machine 3 Increase in networking capital 4 Marginal tax re 5 Sale price of machine 6 Incremental Revenues or Cost Savings 7 WACC 8 Depreciation year 1 9 Depreciation year 2 10 10 Depreciation year 3 11 Depreciation year 4 12 Depreciation year 5 13 Depreclation year 6 14 15 16 Full Price of Machine 17 18 Increase in net working capital 19 20 Incremental Revenues or Cost Savings 21 Depreciation 22 Operating Profit before taxes 23 Taxes 24 Operating Profit after taxes 25 Add back depreciation 26 Operating Cash Flow 27 28 Sale of Machine 29 Taxes 30 Net Salvage 31 32 Return of net working capital 33 34 Total Cash Flow 25 35 36 NPV 37 38 39 40 41 42 43 44 45 46 47 B 150,000.00 0.00 40,00 % 400,000.00 400,000,00 12.00% 33.00% 45.00% 15.00 % 7.00% 0.00% 0,00% Year 0 C Year 1 D Year 2 E NPV End of year BV Year 3 F Year 4 G Year 5 H Year 6 I J Spreadsheet 3 X L Not M B MITSHUNDRA "AS05 BIT COMPANY SOUNDS LIKE A REALLY WISE Chich to " N 0 P Q R You have been hired as a financial consultant by BUBBA corporation. BUBBA is considering investing in a new machine to produce dog biscuits. S BUBBA has provided you with the following information: Full price of machine is $150,000. There is no increase in net working capital. BUBBA has a 40% marginal tax rate. The machine falls into the MACRS 3-year class (33 %, 45%, 15%, and 7% depreciation rates) BBA will use the machine for 6 years and then plans to sell it for $20,000 at the end of year 6. The machine is expected to increase earnings before depreciation by $35,000 a year for the life of the machine. BUBBA has a WACC of 12%. Create a MS-Excel spreadsheet to calculate the NPV similar to the Cash Flow Estimation spreadsheet (40 points). This sheet should include cash flows in years 4, 5 and 6. The spreadsheet will be used by the BUBBA managers to assist them in making the investment decision. The spreadsheet should be set up to allow for a sensitivity analysis to be conducted. The cells to input the full price, increased earnings, sale price in year 6, and WACC should be easily identified and allow the BUBBA managers to change their values. Your sheet should be set up so that if the assumptions change your sheet updates. appropriately.
Expert Answer:
Related Book For
Accounting Information Systems
ISBN: 978-1133935940
10th edition
Authors: Ulric J. Gelinas, Richard B. Dull
Posted Date:
Students also viewed these accounting questions
-
Technology Summary 3.4 briefly describes cloud computing. Write a report on the opportunities and concerns relating to a company using the cloud for mission critical software applications. ( Your...
-
With respect to Table 2.5, indicate in each case whether or not trade is possible and the basis for trade. Table 2.5 Production Possibilities in the United States and the United Kingdom Case A Case B...
-
Create a 3 2 contingency table with row totals of 25, 30, and 25 and column totals of 30 and 50. How many table cell counts are truly free (i. e., what is the smallest number of table cell counts...
-
We often speak of how price rations goods. What are other rationing measures in clinics in which free care is provided?
-
What caused the twin peaks of unemployment and inflation in 197475 and 198082? What theoretical innovations developed to explain the twin peaks?
-
Butane is combustible. Therefore, it burns. Identify the fallacies of presumption, ambiguity, and illicit transference committed by the following arguments, giving a brief explanation for your...
-
Distinguish between a liability and an environmental liability. Is there any difference, in principle, between the recognition criteria for normal and environmental liabilities in conventional...
-
Sandhills Bank would like to increase the number of customers who use payroll direct deposit as part of the rollout of its new e-banking platform. Management has proposed offering an increased...
-
COVID-19 Has had a massive impact on the Service Industry. Please read the article Corona Virus Impact on Service OrganizationsLinks to an external site. After reading the above article, please...
-
Answer parts (A) and (B ) in Example 7 for fixed costs of $250 per day and total costs of $3,450 per day at an output of 80 skateboards per day. Data from Example 7 The management of a company that...
-
Abstract Algebra: (a.) Which of the following rings are integral domains? (Possible to have more than one answer) -The set of 2 x 2 matrices with real coefficients -The integers modulo 36 -{a + b...
-
In thinking about biomedical issues, address the following questions: How do we decide which patient will receive an organ transplant? Can we be positive that a particular combination of genetics,...
-
Why is it so important to have accurate medical billing and coding?
-
What are the differences among an onsite team, a virtual team, a task force, and a committee? What are some of the potential differences in dynamics between people in these different groups?
-
How do medical billing and coding specialists keep up-to-date with changes in ICD and CPT?
-
Discuss the various ways in which health care reform has affected and may affect the financial delivery of health care today and into the future.
-
the following questions: Consider the following snippet of MIPS code and answer SW r16, 12(r6) lw r16, 8(r6) add r5,r1,r16 slt r3,r5,r4 Consider the MIPS pipeline architecture we have been discussing...
-
During the month, services performed for customers on account amounted to $7,500 and collections from customers in payment of their accounts totaled $6,000. At the end of the month, the Accounts...
-
Construct a systems flowchart based on the narrative and the output from Problems 4- 4 through 4- 6. Use Microsoft Visio or other diagramming software.
-
Technology Summary 5.2 uses examples of employee ID codes to illustrate five data coding types. Refer to those examples. Create student ID codes that illustrate each of the five coding schemes....
-
Figures show three data flows running to the general ledger (GL) for the purpose of updating the general ledger master data. For each of the following three data flows, show the journal entry (in...
-
Determine the variation in the depth \(d\) of the cantilever beam that supports the concentrated force \(\mathbf{P}\) so that it has the same maximum bending stress \(\sigma_{\max }\) throughout its...
-
Determine the variation of the radius \(r\) of the cantilevered beam that supports the uniform distributed load so that it has a constant maximum bending stress \(\sigma_{\max }\) throughout its...
-
Determine the variation in the depth \(d\) of a cantilever beam that supports a concentrated force \(\mathbf{P}\) so that it has the same maximum bending stress \(\sigma_{\max }\) throughout its...
Study smarter with the SolutionInn App