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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6649521bf1f9b_1796649521b4b37e.jpg)
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 $54,000 per year. 3. The firm's tax rate is 32%. 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 $240,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 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 $54,000 per year. 3. The firm's tax rate is 32%. 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 $240,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
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Numerous companies have established home pages on the Internet, e.g., the soda companies Capt'n Eli Root Beer Company and Cheerwine. Instructions Examine the home pages of any two companies and...
-
A new asymmetric, polyimide, polymer membrane has been developed for the separation of N2 from CH4. At 30C, permeance values are 50,000 and 10,000 barrer/cm for N2 and CH4, respectively. If this new...
-
Consider the September transactions for Sherman Lawn Service. (Cost data has been removed from the sale transactions). Requirements 1. Prepare perpetual inventory records for September for Sherman...
-
City-Alive Company of Fargo, North Dakota, publishes a monthly magazine featuring local restaurant reviews and upcoming social, cultural, and sporting events. Subscribers pay for subscriptions either...
-
Dunstan Electric Inc. is a private company specializing in the sale of high-end home appliances and consumer electronics with over 40 stores across Canada. Dunstan Electric is known for its...
-
Crystal Charm Company makes handcrafted silver charms that attach to jewelry such as a necklace or bracelet Each charm is adorned with two crystals of various colors. Standard costs follow: \ table [...
-
Discuss in detail how recycling contributes to sustainability. Provide illustrations and multi-level (economical. social and environmental) implications
-
If an interest rate of 3.72 per cent is quoted on a 360-day count convention, what is the bey rate for this?
-
Explain Eurocurrency and why it came into existence.
-
Without giving examples, briefly explain the nature of the following types of data input validation checks: a. Field checks b. Record checks c. Batch checks d. File checks
-
_____ is the process of introducing new employees to the organization and their jobs.
-
List four types of information typically placed on a batch cover sheet. Briefly explain the purpose of each piece of information you list for the overall control of the batch.
-
How Increase in direct to consumer online purchasing will change distribution packaging and drive the demand for certain types of packaging and packaging technology ?
-
The graph of the sequence whose general term is an = n - 1 is which of the following? [8.1] A. B. TITTT 3-2-1 23.45 2.3.4
-
a. The market capitalization of a firm with 100 percent stock equity is $10,000,000. Assume $8,000,000 of .10 debt is substituted for stock (the debt is given to the shareholders). The tax rate is...
-
a. Assume a one year investment of $10,000 returns $10,900 at time 1. What is the return on $1,000 of equity if $9,000 of .05 debt is used? Assume zero taxes. b. What is the IRR (after tax) on $1,000...
-
In deciding whether to drop its electronics product line, Amazon.com would consider a. the costs it could save by dropping the product line b. the revenues it would lose from dropping the product...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App