Posted: March 21st, 2022

Excel Online Structured Activity: Lease versus Buy

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:

The equipment falls in the MACRS 3-year class.
Estimated maintenance expenses are $56,000 per year.
The firm’s tax rate is 40%.
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.
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.
Under the proposed lease terms, the lessee must pay for insurance, property taxes, and maintenance.
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 $180,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.
Year3-year MACRS133.33%244.45%314.81%47.41%

Check Price Discount

More Assignment Samples: »

Order for this Paper or Similar Assignment Help

Fill a form in 3 easy steps - less than 5 mins.

Why choose us

You Want Quality and That’s What We Deliver

Top Essay Writers

We select the finest writers to join our team. They each have expertise in specific topic fields and background in academic writing.

Affordable Prices

We offer the lowest possible pricing while still providing the best writers. Our costs are fair and reasonable compared to other writing services.

100% Plagiarism-Free

You will never receive a product that contains any plagiarism. We scan every final draft before releasing it to be delivered to a customer.

How it works

When you decide to place an order with Study Pro Essay, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: