Create amortization schedule using excel.

Amortization Schedule $ Principal Interest Years 50,000 6% 5 Years Beginning Balance Payment Interest 1 $ 2 $ 3 $ 4 $ 5 $ Total 50,000.00 41,130.18 31,728.17 21,762.04 11,197.94 $11,869.82 $3,000.00 $11,869.82 $ 2,467.81 $11,869.82 $ 1,903.69 $11,869.82 $ 1,305.72 $11,869.82 $ 671.88 $59,349.10 $ 9,349.10 Principal Payment Ending Balance $ 50,000.00 $8,869.82 $ 41,130.18 $9,402.01 $ 31,728.17 $9,966.13 $ 21,762.04 $10,564.10 $ 11,197.94 $11,197.94 $ $50,000.00