Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Online Structured Activity: Lease vernus buy Sullivan-Swift Mining Company must install $1.6 million of new machinery in its Nevada mine. It can obtain a

image text in transcribed
Excel Online Structured Activity: Lease vernus buy Sullivan-Swift Mining Company must install $1.6 million of new machinery in its Nevada mine. It can obtain a bank loan for 100% of the requirad amount. Altematively, a Nevade investment bonking firm that represents a group of investors believes that it can arrange for a lease finanding plan. Assume that the following facts apgly: 1. The equipment falls in the Macrs 3 -year ciass. The applicable MaCRS rates are 33%,45%,15%, and 7%. 2. Estimated maintenance expenses are $75,000 per year. 3. Sulivan-Swift's federal-plus-state tax rate is 35%. 4. If the money is borrowed, the bank loan will be at a rate of 15%, amortized in 4 equal installments to be paid at the end of each year. 5. The tentative lease terms call for end-af-year payments of $250,000 per year for 4 years. 6. Under the proposed lease terms, the lessee must pay for insurance, property taxes, and maintenance. 7. The equipment has an estimated salvage value of $250,000, which is the expected market value after 4 years, at which time Sulivan-Swift plans to replace the equipment regardless of whether the firm leases or purchases it. The best estimate for the salvage value is $250,000, but it may be much higher or lower under certain circumstances. 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 marking the proper lease-versus-buy decision, you are asked to answer the following questions. a. Assuming that the lease can be arranged, should Sullivan-Swit lease or borrow and buy the equipment? Do not round intermediate calculations. Round your answer to the nearest dollar. Use a minus sign to enter a negative value, if there is a disadvantage. Net advantage to leasing (NAL): $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: E. Thomas Garman, Raymond Forgue

8th Edition

0618471421, 9780618471423

More Books

Students also viewed these Finance questions