Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume that these facts apply: 1. The equipment falls in the MACRS 3-year class. 2. Estimated maintenance expenses are $56,000 per year. 3. The firm's tax rate is 38%. 4. If the money is borrowed, the bank loan will be at a rate of 14%, amortized in six equal installments at the end of each year. 5. The tentative lease terms call for payments of $280,000 at the end of each year for 3 years. The lease is a guideline lease. 6. Under the proposed lease terms, the lessee must pay for insurance, property taxes, and maintenance. 7. Sadik must use the equipment if it is to continue in business, so it will almost certainly want to acquire the property at the end of the lease. If it does, then under the lease terms it can purchase the machinery at its fair market value at Year 3. The best estimate of this market value is $250,000, but it could be much higher or lower under certain circumstances. If purchased at Year 3, the used equipment would fall into the MACRS 3-year class. Sadik would actually be able to make the purchase on the last day of the year (i.e., slightly before Year 3), so Sadik would get to take the first depreciation expense at Year 3 (the remaining depreciation expenses would be at Year 4 through Year 6). On the time line, Sadik would show the cost of the used equipment at Year 3 and its depreciation expenses starting at Year 3. Year 3-year MACRS 1 33.33 % 2 44.45 % 3 14.81 % 4 7.41 % The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet To assist management in making the proper lease-versus-buy decision, you are asked to answer the following questions: a. What is the net advantage of leasing? Should Sadik take the lease? Do not round intermediate calculations. Round your answer to the nearest dollar. Net advantage of leasing $ Since the cost of leasing the machinery is less than the cost of owning it, the firm should lease the equipment. b. The decision almost can be considered a bet on the future residual value. Do you think the residual cash flows are equal in risk to the other cash flows? (Hint: if you discount a negative cash flow at a higher rate, you get a better NPV - the NPV of a negative cash flow stream is less negative at high discount rates.) No. Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume that these facts apply: 1. The equipment falls in the MACRS 3-year class. 2. Estimated maintenance expenses are $56,000 per year. 3. The firm's tax rate is 38%. 4. If the money is borrowed, the bank loan will be at a rate of 14%, amortized in six equal installments at the end of each year. 5. The tentative lease terms call for payments of $280,000 at the end of each year for 3 years. The lease is a guideline lease. 6. Under the proposed lease terms, the lessee must pay for insurance, property taxes, and maintenance. 7. Sadik must use the equipment if it is to continue in business, so it will almost certainly want to acquire the property at the end of the lease. If it does, then under the lease terms it can purchase the machinery at its fair market value at Year 3. The best estimate of this market value is $250,000, but it could be much higher or lower under certain circumstances. If purchased at Year 3, the used equipment would fall into the MACRS 3-year class. Sadik would actually be able to make the purchase on the last day of the year (i.e., slightly before Year 3), so Sadik would get to take the first depreciation expense at Year 3 (the remaining depreciation expenses would be at Year 4 through Year 6). On the time line, Sadik would show the cost of the used equipment at Year 3 and its depreciation expenses starting at Year 3. Year 3-year MACRS 1 33.33 % 2 44.45 % 3 14.81 % 4 7.41 % The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet To assist management in making the proper lease-versus-buy decision, you are asked to answer the following questions: a. What is the net advantage of leasing? Should Sadik take the lease? Do not round intermediate calculations. Round your answer to the nearest dollar. Net advantage of leasing $ Since the cost of leasing the machinery is less than the cost of owning it, the firm should lease the equipment. b. The decision almost can be considered a bet on the future residual value. Do you think the residual cash flows are equal in risk to the other cash flows? (Hint: if you discount a negative cash flow at a higher rate, you get a better NPV - the NPV of a negative cash flow stream is less negative at high discount rates.) No.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
(8) (Non circular cylinder) A solid right (noncircular) cylinder has its base the R in the xy-plane and is bounded above by is 22-y + +5 5 * (x + y) dx dy paraboloid 2= x + y . The cylinder's volume....
-
When might a company use budgeted costs rather than actual costs to compute direct-labor rates?
-
Maria Fierro SpA reported the following amounts in 2018, 2019, and 2020. Instructions (a) Identify and describe the three tools of financial statement analysis. (b) Perform each of the three types of...
-
Flowchart symbols represent what aspect of a system?
-
Bridger Bike Corp. manufactures mountain bikes and distributes them through retail outlets in Montana, Idaho, Oregon, and Washington. Bridger Bike Corp. has declared the following annual dividends...
-
Flying Tiger Corp has total current assets of $38,503,523, current ratio of 2.4, and inventories of $28,152,849. Find the quick ratio of the company (hint: find the current liabilities of the company...
-
Write a program using nested if-else statement that will implement the following table Loudness in Decibels Perception 50 or lower Quiet 51 - 70 Intrusive 71...
-
What is the full name of the award that would apply to a waiter in a restaurant who had several years experience and was involved in taking reservations, serving food and alcohol, placing orders,...
-
a. Refer to the options with a strike price of $27.00 in the table above. What is the intrinsic value of the October 2023 Put option? b. Refer to the options with a strike price of $27.00 in the...
-
How can an FQHC have the room and availability to expand integrated sites and provide multiple services at one location, exceeding inongoing grant opportunities and new ways to provide care which...
-
What measures can change leaders implement to mitigate resistance to change and facilitate stakeholder buy-in, particularly in contexts characterized by entrenched organizational cultures and vested...
-
. An urn has 10 balls that are identical except that7are white and 3 are red. A sample of 8 is selected randomly without replacement. What is the probability that exactly 6 are white and2are red?...
-
a) Explain the disadvantages of the Gauss-Seidel method, what is the alternative solution? V = 1 p.u. P=0.6 p.u. V= 1 p.u. Slack j0.2 p.u. j0.05 p.u. jo.025 p.u. (0.8 + j0.6) p.u. b) Set up the...
-
Represent each of the following combination of units in the correct SI form using an appropriate prefix: (a) m/ms, (b) k m, (c) k s /mg, and (d) k m N.
-
Sarah Saxon and Jane Rolf are partners in a business called J & S Service. The partnership's work sheet for the year ended December 31 of the current year is provided in the Working Papers....
-
Donald Winn and Judy Reed agreed to liquidate their partnership on June 30 of the current year. On that date, after financial statements were prepared and closing entries were posted, the general...
-
Theresa Doran and Roy Eden are partners in a business called D & E Sales. The partnership's work sheet for the year ended December 31 of the current year is provided in the Working Papers. ...
Study smarter with the SolutionInn App