Your production manager just came into your office with a worried look. We are missing a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your production manager just came into your office with a worried look. "We are missing a lot of delivery commitments while we are repairing that old dust collector. If we want to keep our factory running smoothly, we have to replace it. Right now, we are facing fines and higher absenteeism due to sickness because of how dusty it is in here." Your schedule is hectic today, but you know that factory productivity is plummeting and tempers have grown short over the distraction of an unreliable piece of equipment. One thing is clear: you need a replacement right away. You call two industrial equipment dealers and ask for quotes on a new dust collection system. Your only requirement is that, since you lack the cash on hand to make a major purchase anytime soon, you want proposals that allow you to spread the payments over time. Both dealers promise to have bids to you in a week. As you read the proposals the following week, you are not sure what to do. Alpha Equipment is offering a 4-year lease on the AirSweep 1000. The lease is for $16,525 annually payable in arrears, totaling $66,100 over the four years. The lease includes coverage for all major maintenance; but you estimate that you will pay an additional $1,300 annually for incidental maintenance items not covered by the lease. Beta Air Handling Corporation's proposal is different: They are offering to sell an AirSweep 1000 to you outright for $64,100. But, knowing that you can't pay for it all at once, Beta offers to finance the entire purchase price at 7.5% interest over four years, with equal annual principal installment payments of $16,025 in arrears plus interest. They also quote a separate “major maintenance" contract of $1,199 per year for the first year, with an annual renewal clause that includes a 3% annual fee increase. No one at your company has the time or skill to do heavy maintenance of the dust collector, so you know you will have to purchase the add-on maintenance contract. You further estimate that "non-covered" incidental maintenance will cost $600 every year you own the machine. You decide to gather a few facts and then analyze both proposals to find the one that has the lower cost/higher NPV. First, you estimate that the Present Value today of avoided fines, sick leave, and medical expenses attributable to the new dust collector is $80,000. This represents a benefit (i.e., cash inflow) at time t-0. Also, you know that many of the expenses you will pay are tax deductible, meaning that you can reduce the income tax you would have paid otherwise because of expenses associated with equipment use. You decide to discount the cash flows of both proposals by the opportunity cost of funds, which you conclude is the after-tax cost of the proposed 7.5% loan. Since your tax rate is 30%, this means your discount rate is 5.25%. (Your overall profit plan for the next four years, of which the dust collection costs are a small part, is about $300,000 annually, so you are certain that you will be able to take full advantage of any tax deductions you may make.) Your experience tells you that constant usage will lead to "wear and tear" sufficient that you will not want the dust collector after four years. If you choose the lease, the lessor will simply take the dust collector back at the end of the 4-year lease. If you own the dust collector, you figure that you can sell it for parts to a smaller workshop at the end of 4 years for 10% of its original purchase price. Your accounting manager lets you know that, if you buy the dust collector, a special tax incentive program will allow you to depreciate it for tax purposes in a straight line over 2 years (meaning depreciation expense equal to one-half of the purchase price for years land 2). But if you sell the dust collector for more than its depreciated book value (which is your intention), you will have to pay a capital gains tax at that time of 20% of the difference between the actual sale proceeds and the depreciated value of zero. Just before you start your analysis, you make a few lists to help with this decision. One list is of non-cash charges that are nevertheless tax deductible. The next list is of balance sheet cash flows that have no tax impacts, like the t=0 purchase price (outflow) of $64,100, the original loan (inflow) of $64,100, and the four annual principal repayment outflows. And you continue with a list of cash expenses that will reduce your taxable income, like the major maintenance contract, the incidental upkeep, the 7.5% interest on the loan, and the lease payments. After you build a "lease" case and a "buy" case, you come to a decision. Questions: A. Build a 4-year pro forma cash flow statement for the lease case and determine its NPV. B. Build a 4-year pro forma cash flow statement for the buy case and determine its NPV. C. What salvage value (to the nearest tenth of a percent or xx.x% of original purchase price) makes you indifferent between the two cases? Question 1 Parts A&B (A) Leasing Option Four Equal Annual Payments of $16,525 in Arrears $66,100 Tax Rate Atar-ax CostotDabt(DiscountRatn) 30% 525% Today End otvear 2 3 PVotAvoided Costs $80,000 Tax Rate 30% 30% 30% 30% Lease Payment ($16,525) ($16,525) ($16,525) (S16,525) NPV of Leasing Option so (B) Purchase Option Depreciable Lite (StraightLine) Purchase Price Inital Annual Maintenance Maintenance Escalabr In-House Maint Costs Salvage Value Capital Gains Tax DebtAmortzaton Pre-tax CostofDebt Income Tax Rate Atar-tax CostotDabtIDiscountRate) 2 years $64,100 $1,199 3.0% S600 10.0% ofPurch. 20% 4 years 7.50% 30% 525% End otvear Today 2 3 PVotAvoided Coss S80,000 Borrowed Funds infow 64,100 Purchase Price (64,100) Tax Rate 30% 30% 30% 30% NPV of Purchase Option Memo: DebtBalance Lease NPVS Tharebre.choose: Ri Question 1 Part C (A) Leasing Option $66,100 Four Equal Annual Payments of $16,525 in Arrears Tax Rate After-tax Cost of Debt (Discount Rate) 30% 5.25% Today End of year 1 2 3 PV of Avoided Costs Tax Rate S80.000 30% 30% 30% 30% Lease Payment ($16,525) (S16,525) ($16,525) ($16,525) NPV of Leasing Option $0 so (B) Purchase Option Depreciable Life (Straight Line) Purchase Price Initial Annual Maintenance Maintenance Escalator In-House Maint. Costs Salvage Value Capital Gains Tax Debt Amortization Pre-tax Cost of Debt Income Tax Rate After-tax Cost of Debt (Discount Rate) 2 years $64,100 $1,199 3.0% $600 ??? of Purch, 20% 4 years 7.50% 30% 5.25% End of year Today $80,000 2 PV of Avoided Costs Borrowed Funds Inflow Purchase Price Tax Rate a b 64,100 (64,100) 30% 30% 30% 30% NPV of Purchase Option Memo: Debt Balance Lease $0 Buy $0 NPVS Therefore, choose: Buy Your production manager just came into your office with a worried look. "We are missing a lot of delivery commitments while we are repairing that old dust collector. If we want to keep our factory running smoothly, we have to replace it. Right now, we are facing fines and higher absenteeism due to sickness because of how dusty it is in here." Your schedule is hectic today, but you know that factory productivity is plummeting and tempers have grown short over the distraction of an unreliable piece of equipment. One thing is clear: you need a replacement right away. You call two industrial equipment dealers and ask for quotes on a new dust collection system. Your only requirement is that, since you lack the cash on hand to make a major purchase anytime soon, you want proposals that allow you to spread the payments over time. Both dealers promise to have bids to you in a week. As you read the proposals the following week, you are not sure what to do. Alpha Equipment is offering a 4-year lease on the AirSweep 1000. The lease is for $16,525 annually payable in arrears, totaling $66,100 over the four years. The lease includes coverage for all major maintenance; but you estimate that you will pay an additional $1,300 annually for incidental maintenance items not covered by the lease. Beta Air Handling Corporation's proposal is different: They are offering to sell an AirSweep 1000 to you outright for $64,100. But, knowing that you can't pay for it all at once, Beta offers to finance the entire purchase price at 7.5% interest over four years, with equal annual principal installment payments of $16,025 in arrears plus interest. They also quote a separate “major maintenance" contract of $1,199 per year for the first year, with an annual renewal clause that includes a 3% annual fee increase. No one at your company has the time or skill to do heavy maintenance of the dust collector, so you know you will have to purchase the add-on maintenance contract. You further estimate that "non-covered" incidental maintenance will cost $600 every year you own the machine. You decide to gather a few facts and then analyze both proposals to find the one that has the lower cost/higher NPV. First, you estimate that the Present Value today of avoided fines, sick leave, and medical expenses attributable to the new dust collector is $80,000. This represents a benefit (i.e., cash inflow) at time t-0. Also, you know that many of the expenses you will pay are tax deductible, meaning that you can reduce the income tax you would have paid otherwise because of expenses associated with equipment use. You decide to discount the cash flows of both proposals by the opportunity cost of funds, which you conclude is the after-tax cost of the proposed 7.5% loan. Since your tax rate is 30%, this means your discount rate is 5.25%. (Your overall profit plan for the next four years, of which the dust collection costs are a small part, is about $300,000 annually, so you are certain that you will be able to take full advantage of any tax deductions you may make.) Your experience tells you that constant usage will lead to "wear and tear" sufficient that you will not want the dust collector after four years. If you choose the lease, the lessor will simply take the dust collector back at the end of the 4-year lease. If you own the dust collector, you figure that you can sell it for parts to a smaller workshop at the end of 4 years for 10% of its original purchase price. Your accounting manager lets you know that, if you buy the dust collector, a special tax incentive program will allow you to depreciate it for tax purposes in a straight line over 2 years (meaning depreciation expense equal to one-half of the purchase price for years land 2). But if you sell the dust collector for more than its depreciated book value (which is your intention), you will have to pay a capital gains tax at that time of 20% of the difference between the actual sale proceeds and the depreciated value of zero. Just before you start your analysis, you make a few lists to help with this decision. One list is of non-cash charges that are nevertheless tax deductible. The next list is of balance sheet cash flows that have no tax impacts, like the t=0 purchase price (outflow) of $64,100, the original loan (inflow) of $64,100, and the four annual principal repayment outflows. And you continue with a list of cash expenses that will reduce your taxable income, like the major maintenance contract, the incidental upkeep, the 7.5% interest on the loan, and the lease payments. After you build a "lease" case and a "buy" case, you come to a decision. Questions: A. Build a 4-year pro forma cash flow statement for the lease case and determine its NPV. B. Build a 4-year pro forma cash flow statement for the buy case and determine its NPV. C. What salvage value (to the nearest tenth of a percent or xx.x% of original purchase price) makes you indifferent between the two cases? Question 1 Parts A&B (A) Leasing Option Four Equal Annual Payments of $16,525 in Arrears $66,100 Tax Rate Atar-ax CostotDabt(DiscountRatn) 30% 525% Today End otvear 2 3 PVotAvoided Costs $80,000 Tax Rate 30% 30% 30% 30% Lease Payment ($16,525) ($16,525) ($16,525) (S16,525) NPV of Leasing Option so (B) Purchase Option Depreciable Lite (StraightLine) Purchase Price Inital Annual Maintenance Maintenance Escalabr In-House Maint Costs Salvage Value Capital Gains Tax DebtAmortzaton Pre-tax CostofDebt Income Tax Rate Atar-tax CostotDabtIDiscountRate) 2 years $64,100 $1,199 3.0% S600 10.0% ofPurch. 20% 4 years 7.50% 30% 525% End otvear Today 2 3 PVotAvoided Coss S80,000 Borrowed Funds infow 64,100 Purchase Price (64,100) Tax Rate 30% 30% 30% 30% NPV of Purchase Option Memo: DebtBalance Lease NPVS Tharebre.choose: Ri Question 1 Part C (A) Leasing Option $66,100 Four Equal Annual Payments of $16,525 in Arrears Tax Rate After-tax Cost of Debt (Discount Rate) 30% 5.25% Today End of year 1 2 3 PV of Avoided Costs Tax Rate S80.000 30% 30% 30% 30% Lease Payment ($16,525) (S16,525) ($16,525) ($16,525) NPV of Leasing Option $0 so (B) Purchase Option Depreciable Life (Straight Line) Purchase Price Initial Annual Maintenance Maintenance Escalator In-House Maint. Costs Salvage Value Capital Gains Tax Debt Amortization Pre-tax Cost of Debt Income Tax Rate After-tax Cost of Debt (Discount Rate) 2 years $64,100 $1,199 3.0% $600 ??? of Purch, 20% 4 years 7.50% 30% 5.25% End of year Today $80,000 2 PV of Avoided Costs Borrowed Funds Inflow Purchase Price Tax Rate a b 64,100 (64,100) 30% 30% 30% 30% NPV of Purchase Option Memo: Debt Balance Lease $0 Buy $0 NPVS Therefore, choose: Buy
Expert Answer:
Answer rating: 100% (QA)
Offer from YODER Equipment Annual Outflow 141751200 15375 PV of outflows15375371307 5708845 PV of ta... View the full answer
Related Book For
Horngrens Accounting
ISBN: 978-0133855371
10th Canadian edition Volume 1
Authors: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo-Ann L. Johnston, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
You need a particular piece of equipment for your production process. An equipment-leasing company has offered to lease you the equipment for $10,000 per year if you sign a guaranteed five-year...
-
How do we know there is such a thing as the strong nuclear force?
-
The hand piece of a miniature industrial grinder weighs 2.4 N, and its center of gravity is located on the y axis. The head of the hand piece is offset in the xz plane in such a way that line BC...
-
Steam leaves a nozzle with a pressure of 500 kPa, a temperature of 350C, and a velocity of 250 m/s. What is the isentropic stagnation pressure and temperature?
-
Advertising is an expenditure that ultimately must be justified in terms of its effect on sales and profits, yet most evaluations of advertising are in terms of the effects on attitudes. How do you...
-
Let M be the matrix game having payoff matrix Find E(x, y), (x), and v(y) when x and y have the given values. 201 -1 1-2 1-2 2 -1 0 1
-
The numbers of weeks the 33 leading movies remained at number 1 as of March 2018. Find the mean, the median, and the mode of the data, if possible. If any measure cannot be found or does not...
-
Alex Guadet of Nashville, Tennessee, has been renting a two-bedroom house for several years. He pays $900 per month in rent for the home and $300 per year in property and liability insurance. The...
-
How to compute to know if chintu should employ in house marketing or to simply koutsource this task? Chintu wants to ensure that her new business has a strong focus on corporate social...
-
A 2.5-lb collar is attached to a spring and slides without friction along a circular rod in a vertical plane. The spring has an undeformed length of 4 in. and a constant k. The collar is at rest at C...
-
Forensic scientists can learn about events at a crime scene by collecting data. Ex: Properties of glass shards at a crime scene such as chemical composition can indicate what type of glass was broken...
-
Choose an airline, an automobile company, or a fast-food company (or product). On Facebook, Twitter, YouTube, and Instagram, compare and contrast social media campaigns. How does the company engage...
-
Enron arranged for Barclays Bank to provide \($11.4\) million for an Enron employee to acquire 3 percent of the equity capital of the SPE named Chewco, and Enron provided a \($6.6\) million...
-
Two ways in which Enron used SPEs to overstate earnings were the abuse of mark-to-market accounting and contrived related party sales. Choose one asset that Enron used to employ both of these methods...
-
Ruby Company manages the daily operations for the human resources department of Jade Company. In terms of the contract, Ruby receives a fee of \($100\) per year for each employee on Jades payroll,...
-
Rhodes Co. manages a school for the Old England School District. In year 1, Rhodes Co.s first year of operating the school, the school earned per pupil fees of \($100,000.\) Rhodes is responsible for...
-
The following initial conditions exist in the "Coffee Market": -Initial Equilibrium Price (P): $ 40 per pound -Initial Equilibrium Quantity (Q): 100 pounds Question: Now suppose that a new technology...
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
Using the information from Problem 8-1B, briefly discuss the characteristics of internal control, beginning with competent, reliable, and ethical personnel. In Problem 8-1 Kyanoga Real Estate...
-
Miagi's auto showroom sells cars. Miagi's bank requires the company to submit quarterly financial statements in order to keep its line of credit. Notes Receivable and Accounts Receivable are 60...
-
As the proprietor of Willow Auto Service, you receive the invoice below from a supplier (GST has been ignored): Required 1. Journalize the transaction required on May 14, 2017. Willow Auto Services...
-
How does risk affect the financial management of sport organizations?
-
Describe the process of determining a nominal interest rate.
-
Of MLB, the NBA, and the NHL, which league has the most risk, and which has the least? Why?
Study smarter with the SolutionInn App