How were these numbers calculated in excel? what formulas were used?

Principal Pmt Use a cell reference or a single formula where appropriate in order to receive full credit. Do Principal: $15,000.00 APR: 5.35% Term: 5 years a.) a.) a.) a.) a.) Month Beginning Monthly Interest Principal Balance Payment Payment Payment Ending Balance $15,000.00 $285.48 $66.88 $218.61 $14,781.39 $14,781.39 $285.48 $65.90 $219.58 $14,561.82 $14,561.82 $285.48 $64.92 $220.56 $14,341.26 $ 14,341.26 $285.48 $63.94 $221.54 $14,119.71 $14,119.71 $285.48 $62.95 $222.53 $13,897.19 $ 13,897.19 $285.48 $61.96 $223.52 $13,673.66 $13,673.66 $285.48 $60.96 $224.52 $13,449.14 $13,449.14 $285.48 $59.96 $225.52 $13,223.63 $13,223.63 $285.48 $58.96 $226.52 $12,997.10 10 $12,997.10 $285.48 $57.95 $227.53 $12,769.57 11 $12,769.57 $285.48 $56.93 $228.55 $ 12,541.02 12 $12,541.02 $285.48 $55.91 $229.57 $12,311.45 13 $12,311.45 $285.48 $54.89 $230.59 $12,080.86 $12,080.86 $285.48 $53.86 $231.62 $11,849.24 15 $11,849.24 $285.48 $52.83 $232.65 $11,616.59 16 $11,616.59 $285.48 $51.79 $233.69 $11,382.90 17 $11,382.90 $285.48 $50.75 $234.73 $11,148.17 18 $11,148.17 $285.48 $49.70 $235.78 $10,912.39 19 $10,912.39 $285.48 $48.65 $236.83 $10,675.56 20 $10,675.56 $285.48 $47.60 $237.88 $10,437.67 21 $10,437.67 $285.48 $46.53 $238.95 $ 10,198.73 22 $10,198.73 $285.48 $45.47 $240.01 $9,958.72 23 $9,958.72 $285.48 $44.40 $241.08 $9,717.64 24 $9,717.64 $285.48 $43.32 $242.16 $9,475.48 25 $9,475.48 $285.48 $42.24 $243.24 $9,232.25 26 $9,232.25 $285.48 $41.16 $244.32 $8,987.93 27 $8,987.93 $285.48 $40.07 $245.41 $8,742.52 28 $8,742.52 $285.48 $38.98 $246.50 $8,496.01 29 $8,496.01 $285.48 $37.88 $247.60 $8,248.41 30 $8,248.41 $285.48 $36.77 $248.71 $7,999.71 31 $7,999.71 $285.48 $35.67 $249.81 $7,749.89 32 $7,749.89 $285.48 $34.55 $250.93 $7,498.96 33 $7,498.96 $285.48 $33.43 $252.05 $7,246.92 34 $7,246.92 $285.48 $32.31 $253.17 $6,993.75