02 Jul Mini Case 6 questions with two questions having sub questions and calculations in excel
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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.