Is this done correctly? If not how can I fix it?

1. Set up an amortization schedule for a $60,000 loan to be repaid in 20 equal annual installments at an interest rate of 10 percent. What is the annual payment?

Clipboard 21 Font Alignment Number H28 fic c H I J K L Year 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 B D E F G Beginning of Payment Interest Repayment Remaining Loan Balanc 1 $60,000.00 $579.01 $5,955.31 $992.81 $59,007.16 2 $59,007.16 $579.01 $5,851.36 $1,096.76 $57,910.35 3 $57,910.35 $579.01 $5,736.50 $1,211.62 $56,698.69 4 $56,698.69 $579.01 $5,609.63 $1,338.49 $55,360.16 5 $55,360.16 $579.01 $5,469.47 $1,478.65 $53,881.47 6 $53,881.47 $579.01 $5,314.63 $1,633.49 $52,247.93 7 $52,247.93 $579.01 $5,143.56 $1,804.56 $50,443.35 8 $50,443.35 $579.01 $4,954.61 $1,993.51 $48,449.80 9 $48,449.80 $579.01 $4,745.87 $2,202.25 $46,247.50 10 $46,247.50 $579.01 $4,515.25 $2,432.87 $43,814.59 11 $43,814.59 $579.01 $4,260.48 $2,687.64 $41,126.92 12 $41,126.92 $579.01 $3,979.05 $2,969.07 $38,157.82 13 $38,157.82 $579.01 $3,668.15 $3,279.97 $34,877.81 14 $34,877.81 $579.01 $3,324.71 $3,623.41 $31,254.35 15 $31,254.35 $579.01 $2,945.27 $4,002.85 $27,251.46 16 $27,251.46 $579.01 $2,526.12 $4,422.00 $22,829.42 17 $22,829.42 $579.01 $2,063.08 $4,885.04 $17,944.33 18 $17,944.33 $579.01 $1,551.55 $5,396.57 $12,547.71 19 $12,547.71 $579.01 $986.42 $5,961.70 $6,585.99 20 $6,585.99 $579.01 $362.16 $6,585.96 $0.00