In: Finance
Comey Products has decided to acquire some new equipment having a $270,000 purchase price. The equipment will last 4 years and is in the MACRS 3-year class. (The depreciation rates for Year 1 through Year 4 are equal to 0.3333, 0.4445, 0.1481, and 0.0741.) The firm can borrow at a 10% rate and pays a 25% federal-plus-state tax rate. Comey is considering leasing the property but wishes to know the cost of borrowing that it should use when comparing purchasing to leasing and has hired you to answer this question. What is the correct answer to Comey’s question? (Hint: Use the shortcut method to find the after-tax cost of the loan payments.) Do not round intermediate calculations. Round your answer to the nearest dollar.
Calculation Cost | |||||
Year | Cashout flow | Tax Save | NCOF | DF @ 10% | PV |
0 | $ - | $ - | $ - | 1.0000 | $ - |
1 | $ 85,177.12 | $ 29,247.75 | $ 55,929.37 | 0.9091 | $ 50,844.88 |
2 | $ 85,177.12 | $ 35,299.32 | $ 49,877.80 | 0.8264 | $ 41,221.32 |
3 | $ 85,177.12 | $ 13,692.45 | $ 71,484.67 | 0.7513 | $ 53,707.49 |
4 | $ 85,177.12 | $ 6,937.59 | $ 78,239.53 | 0.6830 | $ 53,438.65 |
Net Present Value | $ 199,212.34 | ||||
Calculation of Tax Save | |||||
Year | Depreciation | Interest | Total | Tax Save | |
0 | $ - | $ - | $ - | $ - | |
1 | $ 89,991.00 | $ 27,000.00 | $ 116,991.00 | $ 29,247.75 | |
2 | $ 120,015.00 | $ 21,182.29 | $ 141,197.29 | $ 35,299.32 | |
3 | $ 39,987.00 | $ 14,782.80 | $ 54,769.80 | $ 13,692.45 | |
4 | $ 20,007.00 | $ 7,743.37 | $ 27,750.37 | $ 6,937.59 | |
Calculation of Repayment Schedule | |||||
Year | Principal | Interest | Installment | Cl. Principal | |
1 | $ 270,000.00 | $ 27,000.00 | $ 85,177.12 | $ 211,822.88 | |
2 | $ 211,822.88 | $ 21,182.29 | $ 85,177.12 | $ 147,828.05 | |
3 | $ 147,828.05 | $ 14,782.80 | $ 85,177.12 | $ 77,433.73 | |
4 | $ 77,433.73 | $ 7,743.37 | $ 85,177.12 | $ (0.01) | |
Calculation of Depreciation | |||||
Year | Principal | Dep. Rate | Depreciation | ||
1 | $ 270,000.00 | 0.3333 | $ 89,991.00 | ||
2 | $ 270,000.00 | 0.4445 | $ 120,015.00 | ||
3 | $ 270,000.00 | 0.1481 | $ 39,987.00 | ||
4 | $ 270,000.00 | 0.0741 | $ 20,007.00 |