Question

In: Finance

Suppose your business borrows $100,000 to purchase a piece of equipment. You will be borrowing the...

Suppose your business borrows $100,000 to purchase a piece of equipment. You will be borrowing the money and repaying it over a three year period with a fixed monthly payment at an annual interest rate of 6%. Construct a loan amortization table for this loan.

Solutions

Expert Solution

Monthly rate(M)= yearly rate/12= 0.50% Monthly payment= 3042.19
Month Beginning balance (A) Monthly payment Interest = M*A Principal paid Ending balance
1 100000.00 3042.19 500.00 2542.19 97457.81
2 97457.81 3042.19 487.29 2554.90 94902.90
3 94902.90 3042.19 474.51 2567.68 92335.22
4 92335.22 3042.19 461.68 2580.52 89754.70
5 89754.70 3042.19 448.77 2593.42 87161.28
6 87161.28 3042.19 435.81 2606.39 84554.90
7 84554.90 3042.19 422.77 2619.42 81935.48
8 81935.48 3042.19 409.68 2632.52 79302.96
9 79302.96 3042.19 396.51 2645.68 76657.28
10 76657.28 3042.19 383.29 2658.91 73998.38
11 73998.38 3042.19 369.99 2672.20 71326.17
12 71326.17 3042.19 356.63 2685.56 68640.61
13 68640.61 3042.19 343.20 2698.99 65941.62
14 65941.62 3042.19 329.71 2712.49 63229.13
15 63229.13 3042.19 316.15 2726.05 60503.09
16 60503.09 3042.19 302.52 2739.68 57763.41
17 57763.41 3042.19 288.82 2753.38 55010.03
18 55010.03 3042.19 275.05 2767.14 52242.89
19 52242.89 3042.19 261.21 2780.98 49461.91
20 49461.91 3042.19 247.31 2794.88 46667.02
21 46667.02 3042.19 233.34 2808.86 43858.17
22 43858.17 3042.19 219.29 2822.90 41035.26
23 41035.26 3042.19 205.18 2837.02 38198.24
24 38198.24 3042.19 190.99 2851.20 35347.04
25 35347.04 3042.19 176.74 2865.46 32481.58
26 32481.58 3042.19 162.41 2879.79 29601.80
27 29601.80 3042.19 148.01 2894.18 26707.61
28 26707.61 3042.19 133.54 2908.66 23798.96
29 23798.96 3042.19 118.99 2923.20 20875.76
30 20875.76 3042.19 104.38 2937.81 17937.94
31 17937.94 3042.19 89.69 2952.50 14985.44
32 14985.44 3042.19 74.93 2967.27 12018.17
33 12018.17 3042.19 60.09 2982.10 9036.07
34 9036.07 3042.19 45.18 2997.01 6039.06
35 6039.06 3042.19 30.20 3012.00 3027.06
36 3027.06 3042.19 15.14 3027.06 0.00
Where
Interest paid = Beginning balance * Monthly interest rate
Principal = Monthly payment – interest paid
Ending balance = beginning balance – principal paid
Beginning balance = previous Month ending balance

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

XYZ Company borrows $450,000 to purchase a piece of capital equipment. The term of the loan...
XYZ Company borrows $450,000 to purchase a piece of capital equipment. The term of the loan is 20 years at an APR of 6.5%. What is the monthly payment?   N = I = PV = PMT = FV = P/Y = After five years, APR falls to 4.75%. How much is the balance due on the loan?                         N =                         I =                         PV =                         PMT =                         FV =                         P/Y =   How much of the loan...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment is $50,000. The installation and transportation cost of bringing the equipment to its location is $6,000. The equipment falls into the MACRS 3-year class. The project is expected to increase revenues by $80,000 each year and increase operating costs (excluding depreciation) by $30,000 each year. This project leads to an increase in net operating working capital by $10,000. You can salvage the equipment for...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment is $50,000. The installation and transportation cost of bringing the equipment to its location is $6,000. The equipment falls into the MACRS 3-year class. The project is expected to increase revenues by $80,000 each year and increase operating costs (excluding depreciation) by $30,000 each year. This project leads to an increase in net operating working capital by $10,000. You can salvage the equipment for...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment is $50,000. The installation and transportation cost of bringing the equipment to its location is $6,000. The equipment falls into the MACRS 3-year class. The project is expected to increase revenues by $80,000 each year and increase operating costs (excluding depreciation) by $30,000 each year. This project leads to an increase in net operating working capital by $10,000. You can salvage the equipment for...
You want to buy a new piece of equipment for your business that costs $500,000. You...
You want to buy a new piece of equipment for your business that costs $500,000. You believe you can use the equipment to increase your gross profit by $45,000 each year for the next 15 years. The equipment will be depreciated over 10 years using straight-line depreciation and the half-year convention. Insurance for the new equipment will cost $150 per month. Utility and maintenance expense to support the new equipment will amount to $1,000 per month. Your business’ income tax...
Suppose that you are interested in borrowing $5300 for the purchase of a second hand car....
Suppose that you are interested in borrowing $5300 for the purchase of a second hand car. Suppose that you would like to make fix amount quarterly payments (making the first payment by the end of the first quarter), and that you want to be debt free by the end of 7 and a half (7.5) years. If the interest rate charged by the bank is 4.6%, then: The quarterly amount that you would have to pay for this loan is:...
To finance the purchase a new piece of equipment for his business Allan borrowed money from...
To finance the purchase a new piece of equipment for his business Allan borrowed money from his bank paying 5% interest. Before he has paid off the loan he sells the business and disposes of the equipment. There is insufficient sales proceeds to completely pay off the loan and he still has to pay the interest on the unpaid balance. He cannot claim the interest payments a deduction because his business has ceased. True False
A business owner must purchase a new piece of equipment for his manufacturing process. He has...
A business owner must purchase a new piece of equipment for his manufacturing process. He has narrowed it down between two options that both have a useful life of 9 years. Option A has an initial cost of $18,000, will provide the company with $3000 a year in profit, and has a salvage value of $1000. Option B has no salvage value and is more expensive with an initial cost $26,000 but it will provide the company with $4200 a...
Draw the cash flow: Your aunt Carry wants to purchase a 200K piece of equipment for...
Draw the cash flow: Your aunt Carry wants to purchase a 200K piece of equipment for her factory, operations cost will be 20K a year as well as a 80K fee at the end of year three. By year seven your aunt would be able to resell the piece of equipment for 15K
Buch Company acquired a piece of equipment in Year 1 at a cost of $100,000. The...
Buch Company acquired a piece of equipment in Year 1 at a cost of $100,000. The equipment has a 10-year estimated life, zero salvage value, and is depreciated on a straight-line basis. Technological innovations take place in the industry in which the company operates in Year 3. Buch gathers the following information for this piece of equipment at the end of Year 3: Expected future undiscounted cash flows - $75,000 Present value of expected future cash flows - $55,000 Net...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT