In: Finance
Under consideration is financing the purchase of a machine using a 3-year loan paid in years 1 through 3 with a down payment of 40 percent and interest rate of 8.0%. An analysis of the 60,000 machine paid in full at time of purchase a forecast of taxable income (not taxes) which included depreciation using 3 year MACRS percentages gave the results below.
Year | 1 | 2 | 3 | 4 |
Forecasted Taxable Income | 22,000 | 26,000 | 8,000 | 4,000 |
Calculate and report the new estimate of the taxable income (not taxes) in years 1 through 4 with this loan.
Loan amount = (60000-(60000*40%)) | 36000 | ||||
Interest rate annual= | 8% | ||||
Time in years (n)= | 3 | ||||
Equal annual payments for loan formula = P* i *((1+i)^n)/((1+i)^n-1) |
|||||
36000*0.08*((1+0.08)^3)/(((1+0.08)^3)-1) |
|||||
$13,969.21 | |||||
Loan amortization table |
|||||
Year | Beginning balance | Payment | Interest @8% | Loan Red. | Ending balance |
(Beg. Bal, *8%) | (Payment - interest) |
(Beg. Balance - Loan red.) |
|||
1 | 36000.00 | 13969.21 | 2880.00 | 11089.21 | 24910.79 |
2 | 24910.79 | 13969.21 | 1992.86 | 11976.34 | 12934.45 |
3 | 12934.45 | 13969.21 | 1034.76 | 12934.45 | 0.00 |
Calculation of Forecasted taxable income Interest will be reduced from income given as already all costs and depreciation has been deducted. |
|||||
Year | 1 | 2 | 3 | 4 | |
Taxable income before interest | 22000.00 | 26000.00 | 8000.00 | 4000.00 | |
Less : interest | -2880.00 | -1992.86 | -1034.76 | 0.00 | |
Estimated taxable income | 19120.00 | 24007.14 | 6965.24 | 4000.00 | |
So, Forecasted taxable income is |
|||||
year 1 | $19,120.00 | ||||
year 2 | $24,007.14 | ||||
year 3 | $6,965.24 | ||||
year 4 | $4,000.00 |