Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you walk me through the calculations. Exhibit 6 PRIMUS AUTOMATION DIVISION, 2002 Summary Table of the NPV and IRR For Four Tax and Cost-of-Capital
Can you walk me through the calculations.
Exhibit 6 | ||||
PRIMUS AUTOMATION DIVISION, 2002 | ||||
Summary Table of the NPV and IRR For Four Tax and Cost-of-Capital Scenarios | ||||
Scenario | A | B | C | D |
Effective tax rate | 34.00% | 34.00% | 0.00% | 0.00% |
Pretax cost of debt | 9.50% | 13.00% | 9.50% | 13.00% |
After-tax cost of debt | 6.27% | 8.58% | 9.50% | 13.00% |
NPV of loan (borrow and buy) | $469,273 | $484,546 | $663,800 | $671,253 |
IRR of loan (borrow and buy) | 6.27% | 8.58% | 9.50% | 13.00% |
Leasing Option #1 | $155,040 | $155,040 | $155,040 | $155,040 |
NPV of leasing option #1 | $454,717 | $436,915 | $651,863 | $616,202 |
IRR of lease | 5.32% | 5.32% | 8.61% | 8.61% |
Lease advantage over borrowing | $14,556 | $47,631 | $11,937 | $55,051 |
Leasing Option #2 | $160,003 | $160,003 | $160,003 | $160,003 |
NPV of leasing option #2 | $469,273 | $450,901 | $672,730 | $635,927 |
IRR of lease | 6.27% | 6.27% | 10.17% | 10.17% |
Lease advantage over borrowing | $0 | $33,645 | ($8,930) | $35,326 |
Leasing Option #3 | $162,350 | $162,350 | $162,350 | $162,350 |
NPV of leasing option #3 | $476,156 | $457,515 | $682,598 | $645,255 |
IRR of lease | 6.72% | 6.72% | 10.91% | 10.91% |
Lease advantage over borrowing | ($6,883) | $27,031 | ($18,798) | $25,998 |
Leasing Option #4 | $164,760 | $164,760 | $164,760 | $164,760 |
NPV of leasing option #4 | $483,225 | $464,306 | $692,730 | $654,834 |
IRR of lease | 7.19% | 7.19% | 11.68% | 11.68% |
Lease advantage over borrowing | ($13,952) | $20,240 | ($28,930) | $16,419 |
Faulhaber Gmbh | ||||
NPV of loan | $484,376 | $501,993 | $686,679 | $697,207 |
NPV of lease | $498,593 | $479,073 | $714,762 | $675,660 |
IRR of lease | 7.13% | 7.13% | 11.42% | 11.42% |
Lease advantage over borrowing | ($14,217) | $22,920 | ($28,083) | $21,547 |
Honshu Heavy Industries | ||||
NPV of loan | $438,036 | $458,436 | $624,641 | $640,997 |
NPV of lease | $478,063 | $459,346 | $685,330 | $647,839 |
IRR of lease | 8.64% | 8.64% | 13.48% | 13.48% |
Lease advantage over borrowing | ($40,027) | ($910) | ($60,689) | ($6,842) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started