Sierra Pacific Community College District Finance Office Student Loan Amortizatiorn Loan Amount 15,000.00 Loan Term Total Interest Total Principal Total Cost $ 242.28 $1,161.47 Payment $3,369.41 Ending Interest Principal Total Payment ance 15,000.00$ 14,769.25 $ 14,537.73$ 14,305.44 $ 14,072.37$ 13,838.53 $ 13,603.91 $ 13,368.51 $ 13,132.32 $ 12,895.34$ 12,657.58 $ 12,419.02 $ 2,179.67 $ 11,939.52 $ 11,698.56$ 11,456.81 $ 11,214.25$ ance 50.005 230.75 280 3/45 14,769.25 280 3/4 14,537.73 280 3/414,305.44 280.75 14,072.37 280.75 $13,838.53 280.75$ 13,603.91 280.75 13,368.51 280.75$ 13,132.32 280.75$ 12,895.34 280.75 $ 12,657.58 280.75 $ 12,419.02 280.75 $12,179.67 280.75 $11,939.52 280.75 $ 11,698.56 280.75 11,456.81 280.75 $ 11,214.25 280.75 $ 10,970.88 280.75 10,726.70 280.75 $10,481.70 $231.52 232.29 233.07 $ 233.84 $ 234.62 $ 235.40 $ 236.19 $ 236.98 $ 237.77 $ 238.56 $ 239.35 $ 240.15 $ 240.95 $ 241.75$ 242.56 $ 243.37 $ 244.18 $ 244.99 $ 19 21 42.19 $ 25 29 37.38 10,970.88 S 10,726.70 $ 10481.70 S 34,94 S 280.75 S 10,235.89 246.63 280.75 9,989.26 9,741.81 9,493.53 9,244.43 8,994.49 8,743.73 8,492.12 8,239.68 7,986.39 7,732.26 9,989.26$ 9,741.81 $ 9,493.53$ 9,244.43 $ 8,994.49 $ 8,743.73 $ 8,492.12$ 8,239.68 $ 7,986.39 $ 7,732.26$ 7,477.29$ 7,221.46$ 6,964.78 $ 6,707.25$ 6,448.86$ 6,189.60$ 5,929.49 $ 5,668.50$ 5,406.65$ 5,143.92 $ 4,880.32 $ 247.45 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 249.10 $ 249.94 $ 40 253.28 $ 7,221.46 6,964.78 6,707.25 6,448.86 256.68 $ 46 48 5,929.49 5,668.50 260.99 $ 262.73 $ 264.48 $ 5,143.92 4,880.32 54 4,350.47$ 4,084.22$ 3,817.08 $ 4,084.22 267.14 $ 268.03 $ 268.92 $ 269.82 $ 3,280.14 3,280.14$ 3,010.32$ 2,739.61 2,467.99 $ 2,195.47 |$ 1,922.03 $ 1,647.69 s 1,372.43 $ 60 2,739.61 2,467.99 2,195.47 1,922.03 1,647.69 1,372.43 1,096.26 63 64 272.52 $ 273.43 $ 276.18 $ 14.50 $ 13.61 $ 12.72 $ 11.83 $ 10.93 $ 10.03 $ 266.25 $ 267.14 $ 268.03 $ 268.92 $ 269.82 $ 270.72 $ 271.62 $ 272.52 $ 273.43 $ 274.34 $ 275.26 $ 276.18 $ 277.10 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 $ 280.75 1 8 Your Deg ng balance shouid be last payment'sending balance Enter a formula to total the Interest, Principal and Total Payment columns. Check that these totals agree to your totals in cells F5, F6 and F7