Catelyn Merrill
Rhodes
Environmental, Inc.
Actual
2002
2003
2004
2005
2006
2007
Loan
Amortization Tables
Equipment
Loans
Pmt
50,000
50,000
50,000
50,000
31,954
0
Prin.
29,600
33,152
37,131
41,586
28,531
0
Int @ 9.75%
20,400
16,848
12,869
8,414
3,423
0
Bal B.F.
170,000
140,400
107,248
70,117
28,531
0
0
Bank Loan
Pmt
141,856
134,553
127,240
119,928
112,615
105,303
Prin.
75,000
75,000
75,000
75,000
75,000
75,000
Int @ 9.75%
66,856
59,553
52,240
44,928
37,615
30,303
Bal B.F.
685,800
610,800
535,800
460,800
385,800
310,800
235,800
Total
Interest
87,265
76,401
65,109
53,342
41,038
30,303
Capital
Budget
New Equipment- Maintenance
25,000
25,000
25,000
25,000
25,000
New Equipment- Construction
35,000
35,000
35,000
35,000
35,000
New Equipment- Office
5,000
5,000
5,000
5,000
5,000
Depreciation
Schedule
Yr. 02
115,152
115,152
115,152
115,152
115,152
115,152
Yr. 03
10,238
10,238
10,238
8,571
8,571
Yr. 04
10,238
10,238
10,238
8,571
Yr. 05
10,238
10,238
10,238
Yr. 06
10,238
10,238
Yr. 07
10,238
Total
115,152
125,390
135,628
145,866
154,437
163,008


Recent Comments