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 draft 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 25%. You have been asked to analyze the lease-versus-purchase decision and, in the process, to answer the following questions. B. (1) What is the present value 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 of owning.) (2) What is the discount rate for the cash flows of owning? Already know it's 7.5% What is Lewis's present value of leasing the equipment? (Hint: Again, construct a time line.) I know this question has already been asked and answered, but my calculations are slightly different than what was posted on bartleby.  I'm including my calculations for evaluation. Please advise.  Thank you.

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter7: Operating Assets
Section: Chapter Questions
Problem 71BPSB: Depreciation Schedules Dunn Corporation acquired a new depreciable asset for $135,000. The asset has...
icon
Related questions
Question
100%

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 draft 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 25%. You have been asked to analyze the lease-versus-purchase decision and, in the process, to answer the following questions.

B.

  • (1)
  • What is the present value 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 of owning.)
  • (2)
  • What is the discount rate for the cash flows of owning? Already know it's 7.5%
  1. What is Lewis's present value of leasing the equipment? (Hint: Again, construct a time line.)

I know this question has already been asked and answered, but my calculations are slightly different than what was posted on bartleby.  I'm including my calculations for evaluation. Please advise.  Thank you.

 

 

The Depreciation Schedule is as follows:
Cost of Equipment
$1,000,000.00
Equipment classified as MACRS 3
Tax rate is 25%
DEPRECIATION EX BOOK VALUE TAX SAVINGS ON DEPRECIATION
$333,000.00 s667,000.00
$445,000.00 $222,000.00 $111,250.00
$148,100.00
$74,100.00
YEARS
MACRS RATE
1
0.333
$83,250.00
2
0.445
$73,900.00
($200.00) $18,525.00
3
0.1481
$37,025.00
4
0.0741
The cost of owning:
Maintenance cost
20,000.00
Tax deductible so,
Residual Value:
Also Tax deductible so,
(1-25%)%20,000=$15,000
200,000.00
200,000 (1-25%)=$150,000
YEARS
1
2
3
4
-60000
$37,025.00
-15000
After tax loan payment
-60000
-60000
-1060000
Depreciation tax savings
$83,250.00 $111,250.00
$18,525.00
Maintenance cost
-15000
-15000
-15000
Residual Value
Net Cash Flow
150000
-15000
8250
36250
-37975
-891475
Present Value to own:
Discount rate is 10%
Discount rate net of tax is 7.5%
YEARS
NET CASH FLOW (NCF
PV FACTOR (7.5%) (PV
1
2
3
4 Total sum
-15000
8250
36250
-37975
-891475
1.000
0.93023
0.86533
0.80496
0.7488
PRESENT VALUE OF
CASH FLOW (NCF
PV)
S (15,000.00) S
7,674.40 $ 31,368.21 S(30,568.36) $ (667,536.48)S (674,062.23)
PV of Equipment
Present Value of Leasing Equipment
YEARS
Lease Payment
1
3 Total Sum:
260000
260000
260000
260000
Less tax (25%)
After tax lease paym
(PV) PV Factor (7.5%)
PV of cash flow (AT
-65000
-65000
-65000
-65000
195000
195000
0.80496
156967.20
195000
195000
1.000
0.93023
0.86533
195000
181394.85
168739.35
702101.40 PV of leasing
28,039.17 Advantage of buying
Transcribed Image Text:The Depreciation Schedule is as follows: Cost of Equipment $1,000,000.00 Equipment classified as MACRS 3 Tax rate is 25% DEPRECIATION EX BOOK VALUE TAX SAVINGS ON DEPRECIATION $333,000.00 s667,000.00 $445,000.00 $222,000.00 $111,250.00 $148,100.00 $74,100.00 YEARS MACRS RATE 1 0.333 $83,250.00 2 0.445 $73,900.00 ($200.00) $18,525.00 3 0.1481 $37,025.00 4 0.0741 The cost of owning: Maintenance cost 20,000.00 Tax deductible so, Residual Value: Also Tax deductible so, (1-25%)%20,000=$15,000 200,000.00 200,000 (1-25%)=$150,000 YEARS 1 2 3 4 -60000 $37,025.00 -15000 After tax loan payment -60000 -60000 -1060000 Depreciation tax savings $83,250.00 $111,250.00 $18,525.00 Maintenance cost -15000 -15000 -15000 Residual Value Net Cash Flow 150000 -15000 8250 36250 -37975 -891475 Present Value to own: Discount rate is 10% Discount rate net of tax is 7.5% YEARS NET CASH FLOW (NCF PV FACTOR (7.5%) (PV 1 2 3 4 Total sum -15000 8250 36250 -37975 -891475 1.000 0.93023 0.86533 0.80496 0.7488 PRESENT VALUE OF CASH FLOW (NCF PV) S (15,000.00) S 7,674.40 $ 31,368.21 S(30,568.36) $ (667,536.48)S (674,062.23) PV of Equipment Present Value of Leasing Equipment YEARS Lease Payment 1 3 Total Sum: 260000 260000 260000 260000 Less tax (25%) After tax lease paym (PV) PV Factor (7.5%) PV of cash flow (AT -65000 -65000 -65000 -65000 195000 195000 0.80496 156967.20 195000 195000 1.000 0.93023 0.86533 195000 181394.85 168739.35 702101.40 PV of leasing 28,039.17 Advantage of buying
Expert Solution
Step 1

Leasing is an agreement which provide rights to one party to use of get the asset for a particular time period by paying periodically payments to other party.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Trading
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College