mini-case-6-questions-with-two-questions-having-sub-questions-and-calculations-in-excel

AcademicWritersDen.com boasts a team of highly skilled and experienced writers who specialize in various academic fields. The company carefully selects its writers through a rigorous screening process to ensure that they possess the necessary qualifications and expertise. Whether it’s an essay, research paper, or any other homework assignment, students can rely on AcademicWritersDen.com to connect them with professionals who have an in-depth understanding of the subject matter. This ensures that the work delivered is of high quality and meets the academic standards set by educational institutions.

Complete Mini Case 8 Answer questions A1-A5, B1-B2, C, D, E, F.

• APA format. Cite at least one source minimum. Will turn into Turnitin for review.
• For the calculations – Please be sure to show all calculations for the net advantage to leasing and net advantage to owning. You will need to complete this in Excel. There is a very specific format for this. Attach Excel Document Separate.

Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm’s brokers. The system also permits customers to call up current quotes on terminals in the lobby.

The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a 6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could

be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system technology is changing rapidly, the actual residual value is uncertain.

As an alternative to the borrow-and-buy plan, the equipment manufacturer informed Lewis that Consolidated Leasing would be willing to write a 4-year guideline lease on the equipment, including maintenance, for payments of $260,000 at the beginning of each year. Lewis’s marginal federal-plus-state tax rate is 40%. You have been asked to analyze the lease-versus-purchase decision and, in the process, to answer the following questions.

A. Answer 1-5 Below.

1. Who are the two parties to a lease transaction?

2. What are the five primary types of leases, and what are their characteristics?

3. How are leases classified for tax purposes?

4. What effect does leasing have on a firm’s balance sheet?

5. What effect does leasing have on a firm’s capital structure?

B. Answer 1-2 Below

1. What is the present value cost of owning the equipment? (Hint: Set up a time line that shows the net cash flows over the period t = 0 to t = 4, and then find the PV of these net cash flows, or the PV cost of owning.)

2. Explain the rationale for the discount rate you used to find the PV.

C. What is Lewis’s present value cost of leasing the equipment? (Hint: Again, construct a time line.)

D. What is the net advantage to leasing (NAL)? Does your analysis indicate that Lewis should buy or lease the equipment? Explain.

E. Now assume that the equipment’s residual value could be as low as $0 or as high as $400,000, but $200,000 is the expected value. Because the residual value is riskier than the other relevant cash flows, this differential risk should be incorporated into the analysis. Describe how this could be accomplished. (No calculations are necessary, but explain how you would modify the analysis if calculations were required.) What effect would the residual value’s increased uncertainty have on Lewis’s lease-versus purchase decision?

F. The lessee compares the cost of owning the equipment with the cost of leasing it. Now put yourself in the lessor’s shoes. In a few sentences, how should you analyze the decision to write or not to write the lease?

 

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.