Question
In: Finance
High electricity costs have made Farmer Corporation’s chicken-plucking machine economically worthless. Only two machines are available...
High electricity costs have made Farmer Corporation’s chicken-plucking machine economically worthless. Only two machines are available to replace it. The International Plucking Machine (IPM) model is available only on a lease basis. The lease payments will be $73,000 for five years, due at the beginning of each year. This machine will save Farmer $23,000 per year through reductions in electricity costs. As an alternative, Farmer can purchase a more energy-efficient machine from Basic Machine Corporation (BMC) for $370,000. This machine will save $33,000 per year in electricity costs. A local bank has offered to finance the machine with a $370,000 loan. The interest rate on the loan will be 12 percent on the remaining balance and will require five annual principal payments of $74,000. Farmer has a target debt-to-asset ratio of 64 percent. Farmer is in the 40 percent tax bracket. After five years, both machines will be worthless. The machines will be depreciated on a straight-line basis.
What is the NAL of leasing?
How much debt is displaced by this lease?
how do you work through this problem using excel? Can this also be done using a calculator?
Solutions
Expert Solution
| Option 1 (Lease option) | Yr 0 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Total |
| Annual Payout (Lease) | $ 73,000.00 | $ 73,000.00 | $ 73,000.00 | $ 73,000.00 | $ 73,000.00 | $ - | $ 365,000.00 |
| Interest Payout | $ - | $ - | $ - | $ - | $ - | ||
| Electricity savings (end of year assumed) | $ (23,000.00) | $ (23,000.00) | $ (23,000.00) | $ (23,000.00) | $ (23,000.00) | ||
| Net outflow (Pre tax) | $ 73,000.00 | $ 50,000.00 | $ 50,000.00 | $ 50,000.00 | $ 50,000.00 | $ (23,000.00) | |
| Tax saved * | $ (20,000.00) | $ (20,000.00) | $ (20,000.00) | $ (20,000.00) | $ (20,000.00) | ||
| Net outflow (Post tax) | $ 73,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ 30,000.00 | $ (43,000.00) | |
| Discount factor (12%) | 1 | 0.892857 | 0.797194 | 0.711780 | 0.635518 | 0.567427 | |
| Current Value of Future Cash outflow | $ 73,000.00 | $ 26,785.71 | $ 23,915.82 | $ 21,353.41 | $ 19,065.54 | $ (24,399.35) | $ 139,721.13 |
| * Tax calculation | Yr 0 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Total |
| Annual Payout (Lease) (Note) | - | $ 73,000.00 | $ 73,000.00 | $ 73,000.00 | $ 73,000.00 | $ 73,000.00 | $ 365,000.00 |
| Electricity savings (end of year assumed) | - | $ (23,000.00) | $ (23,000.00) | $ (23,000.00) | $ (23,000.00) | $ (23,000.00) | |
| Total expense (Pre tax) | - | $ 50,000.00 | $ 50,000.00 | $ 50,000.00 | $ 50,000.00 | $ 50,000.00 | |
| Taxes saved @ 40% | - | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 |
| Option 2 (Purchase/Loan option) | Yr 0 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Total |
| Annual Payout (Principal repayment) | - | $ 74,000.00 | $ 74,000.00 | $ 74,000.00 | $ 74,000.00 | $ 74,000.00 | $ 370,000.00 |
| Interest Payout ** | $ 44,400.00 | $ 35,520.00 | $ 26,640.00 | $ 17,760.00 | $ 8,880.00 | ||
| Electricity savings (end of year assumed) | $ (33,000.00) | $ (33,000.00) | $ (33,000.00) | $ (33,000.00) | $ (33,000.00) | ||
| Net outflow (Pre tax) | - | $ 85,400.00 | $ 76,520.00 | $ 67,640.00 | $ 58,760.00 | $ 49,880.00 | |
| Tax saved @ 40% | $ (34,160.00) | $ (30,608.00) | $ (27,056.00) | $ (23,504.00) | $ (19,952.00) | ||
| Net outflow (Post tax) | - | $ 51,240.00 | $ 45,912.00 | $ 40,584.00 | $ 35,256.00 | $ 29,928.00 | |
| Discount factor (12%) | 1 | 0.892857 | 0.797194 | 0.711780 | 0.635518 | 0.567427 | |
| Current Value of Future Cash outflow | - | $ 45,750.00 | $ 36,600.77 | $ 28,886.89 | $ 22,405.83 | $ 16,981.95 | $ 150,625.43 |
|
** Interest calculation |
Yr 0 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Total |
| Principal (Opening balance) | $370,000.00 | $370,000.00 | $296,000.00 | $222,000.00 | $148,000.00 | $ 74,000.00 | |
| Principal repaid | - | $ 74,000.00 | $ 74,000.00 | $ 74,000.00 | $ 74,000.00 | $ 74,000.00 | |
| Outstanding Principal (Closing balance) | $370,000.00 | $296,000.00 | $222,000.00 | $148,000.00 | $ 74,000.00 | $ - | |
| Interest @ 12% (on opening balance) | $ 44,400.00 | $ 35,520.00 | $ 26,640.00 | $ 17,760.00 | $ 8,880.00 | $ 133,200.00 |
Note
Taxes are paid for each accounting year and on the accrual basis of accounting . Therefore, the lease paid at the beginning of the year has been adjusted.
Outflow saved is treated as inflow. Hence electricity savings and tax savings are treated as inflows.
What is the NAL of leasing?
NAL of Leasing = Cost of Purchasing - Cost of Leasing = $ 150,625.43 - $ 139,721.13 = $ 10,904.31
How much debt is displaced by this lease?
With the lease option, the farmer has displaced a debt of $ 370,000.
jeff jeffy answered 2 years agoRelated Solutions
High electricity costs have made Farmer Corporation’s chicken-plucking machine economically worthless. Only two machines are available...
High electricity costs have made Farmer Corporation’s
chicken-plucking machine economically worthless. Only two machines
are available to replace it. The International Plucking Machine
(IPM) model is available only on a lease basis. The lease payments
will be $83,000 for five years, due at the beginning of each year.
This machine will save Farmer $30,500 per year through reductions
in electricity costs. As an alternative, Farmer can purchase a more
energy-efficient machine from Basic Machine Corporation (BMC) for
$387,000. This machine...
High electricity costs have made Farmer Corporation’s chicken-plucking machine economically worthless. Only two machines are available...
High electricity costs have made Farmer Corporation’s
chicken-plucking machine economically worthless. Only two machines
are available to replace it. The International Plucking Machine
(IPM) model is available only on a lease basis. The lease payments
will be $85,000 for five years, due at the beginning of each year.
This machine will save Farmer $31,500 per year through reductions
in electricity costs. As an alternative, Farmer can purchase a more
energy-efficient machine from Basic Machine Corporation (BMC) for
$405,000. This machine...
High electricity costs have made Farmer Corporation’s chicken-plucking machine economically worthless. Only two machines are available...
High electricity costs have made Farmer Corporation’s
chicken-plucking machine economically worthless. Only two machines
are available to replace it. The International Plucking Machine
(IPM) model is available only on a lease basis. The lease payments
will be $87,000 for five years, due at the beginning of each year.
This machine will save Farmer $32,500 per year through reductions
in electricity costs. As an alternative, Farmer can purchase a more
energy-efficient machine from Basic Machine Corporation (BMC) for
$418,000. This machine...
A company is contemplating to purchase a machine. Two machines A & B are available each...
A company is contemplating to purchase a machine. Two machines
A & B are available each costing $ 500,000. In computing
profitability of the machines a discounted rate of 10% is to be
used.
Cash Flows (Rs)
Year Machine A Machine B
1 1,50,000 50,000
2 2,00,000 1,50,000
3 2,50,000 2,00,000
4 1,50,000 3,00,000
5 1,00,000 2,00,000
Using NPV Method, indicate which m/c would be
profitable?
A company is contemplating to purchase a machine. Two machines A & B are available each...
A company is contemplating to purchase a machine. Two machines
A & B are available each costing $ 500,000. In computing
profitability of the machines a discounted rate of 10% is to be
used.
Cash Flows (Rs)
Year Machine A Machine B
1 1,50,000 50,000
2 2,00,000 1,50,000
3 2,50,000 2,00,000
4 1,50,000 3,00,000
5 1,00,000 2,00,000
Using NPV Method, indicate which m/c would be
profitable?
A farmer wants to cross a river with a chicken, some grain, and a fox. His boat can only carry two items at a time.
Process Synchronization A farmer wants to cross a river with a chicken, some grain, and a fox. His boat can only carry two items at a time. The fox will eat the chicken if left alone. The chicken will eat the grain if left without the farmer. Build the application to synchronize the crossing so all three items arrive across the river.
UMB Co. is evaluating two machines. Both machines meet the firm’s quality standard. Machine X costs...
UMB Co. is evaluating two machines. Both machines meet the
firm’s quality standard. Machine X costs $40 000 initially and
$1000 per year to maintain. Machine Y costs $24 000 initially and
$2000 per year to maintain. Machine X has a six-year useful life
and Machine Y has a three-year useful life. Both machines have zero
salvage value. Assume the firm will continue to replace worn-out
machines with similar machines and that the discount rate is 25%.
Which machine should...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have...
Thane Company is interested in establishing the relationship
between electricity costs and machine hours. Data have been
collected and a regression analysis prepared using Excel. The
monthly data and the regression output follow: Month Machine Hours
Electricity Costs January 3,000 $ 18,650 February 3,400 $ 21,500
March 2,400 $ 13,750 April 3,600 $ 23,500 May 4,300 $ 28,500 June
3,800 $ 22,500 July 4,600 $ 25,000 August 4,000 $ 23,000 September
2,500 $ 16,000 October 4,200 $ 26,500 November 5,600...
You are evaluating two machines. Machine I costs $240,000 and it has a three-year life. It...
You are evaluating two machines. Machine I costs $240,000 and it
has a three-year life. It has pre-tax operating costs of $60,000
per year. Machine II costs $450,000 and it has a five-year life. It
has pre-tax operating costs of $40,000 per year. For both machines,
we use straight-line depreciation to zero over the machine’s life.
The pre-tax salvage value of Machine I is $50,000 at the end of its
life. The pre-tax salvage value of Machine II is $150,000...
You are evaluating two different machines. Machine A costs $210,000, has a three-year life and has...
You are evaluating two different machines. Machine A costs
$210,000, has a three-year life and has pretax operating costs of
$30,000 per year. Machine B costs $320,000, has a five-year life
and has pretax operating costs of $23,000 per year. You will
depreciate both machines using straight-line depreciation to a zero
salvage value over the machine’s life. The expected salvage value
for each machine is $20,000. If your tax rate is 40%, both machines
are repeatable and your discount rate...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In two or three sentences, explain how you have seen the concept of grit work in...
- You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella Co.,...
- Parallel Arrays This question is in MindTap Cengage Summary In this lab, you use what you...
- 5. You have invested 30 percent of your portfolio in Jacob, Inc., 40 percent is Bella...
- JAVA Write a test program that prompts the user to enter a series of integers and...
- (2) Cite an example on how organizations like Google, Facebook, Youtube etc collect data for image...
- The legal landscape is perpetually changing. Psychologists must remain abreast of these changes to avoid potentially...
ADVERTISEMENT