PROC MORTGAGE Output
MORTGAGE Procedure
L O A N S U M M A R Y
Payment: 768.91 Principal Amount: 100000.00
Total Interest: 176813.51 Nominal Rate: 8.500%
Total Payment: 276813.51 Effective Rate: 8.839%
Pay Interval: MONTHLY Compound Interval: MONTHLY
Number of Payments: 360
First Payment: OCT1996 Last Payment: SEP2026
Note: The computed quantity is PAYMENT.
(Data generated by PROC MORTGAGE)
PROC MORTGAGE Output
MORTGAGE Procedure
Loan Repayment Schedule
BEGINNING INTEREST PRINCIPAL ENDING
YEAR OUTSTANDING PAYMENT PAYMENT REPAYMENT OUTSTANDING
1996 100000.00 2306.73 2123.70 183.03 99816.97
1997 99816.97 9226.92 8454.82 772.10 99044.87
1998 99044.87 9226.92 8386.58 840.34 98204.53
1999 98204.53 9226.92 8312.31 914.61 97289.92
2000 97289.92 9226.92 8231.45 995.47 96294.45
2001 96294.45 9226.92 8143.48 1083.44 95211.01
2002 95211.01 9226.92 8047.70 1179.22 94031.79
2003 94031.79 9226.92 7943.46 1283.46 92748.33
2004 92748.33 9226.92 7830.02 1396.90 91351.43
2005 91351.43 9226.92 7706.54 1520.38 89831.05
2006 89831.05 9226.92 7572.18 1654.74 88176.31
2007 88176.31 9226.92 7425.90 1801.02 86375.29
2008 86375.29 9226.92 7266.69 1960.23 84415.06
2009 84415.06 9226.92 7093.44 2133.48 82281.58
2010 82281.58 9226.92 6904.85 2322.07 79959.51
2011 79959.51 9226.92 6699.61 2527.31 77432.20
2012 77432.20 9226.92 6476.21 2750.71 74681.49
2013 74681.49 9226.92 6233.07 2993.85 71687.64
2014 71687.64 9226.92 5968.46 3258.46 68429.18
2015 68429.18 9226.92 5680.43 3546.49 64882.69
2016 64882.69 9226.92 5366.95 3859.97 61022.72
2017 61022.72 9226.92 5025.75 4201.17 56821.55
2018 56821.55 9226.92 4654.41 4572.51 52249.04
2019 52249.04 9226.92 4250.25 4976.67 47272.37
2020 47272.37 9226.92 3810.36 5416.56 41855.81
2021 41855.81 9226.92 3331.58 5895.34 35960.47
2022 35960.47 9226.92 2810.52 6416.40 29544.07
2023 29544.07 9226.92 2243.33 6983.59 22560.48
2024 22560.48 9226.92 1626.04 7600.88 14959.60
2025 14959.60 9226.92 954.20 8272.72 6686.88
2026 6686.88 6926.10 239.22 6686.88 0.00
(Data generated by PROC MORTGAGE)
PROC SQL Output
Beginning Monthly Interest Principal Ending
Year Month Principal Payment Payment Repayment Principal
-----------------------------------------------------------------------
1996 10 100000 768.91 708.33 60.58 99939.42
1996 11 99939.42 768.91 707.9 61.01 99878.41
1996 12 99878.41 768.91 707.47 61.44 99816.97
(Data generated by PROC MORTGAGE)
PROC PRINT Output
Beginning Monthly Interest Principal Ending
Year Month Principal Payment Payment Repayment Principal
1996 October 100,000.00 768.91 708.33 60.58 99,939.42
1996 November 99,939.42 768.91 707.90 61.01 99,878.41
1996 December 99,878.41 768.91 707.47 61.44 99,816.97
1997 January 99,816.97 768.91 707.04 61.87 99,755.10
1997 February 99,755.10 768.91 706.60 62.31 99,692.79
1997 March 99,692.79 768.91 706.16 62.75 99,630.04
1997 April 99,630.04 768.91 705.71 63.20 99,566.84
1997 May 99,566.84 768.91 705.27 63.64 99,503.20
1997 June 99,503.20 768.91 704.81 64.10 99,439.10
1997 July 99,439.10 768.91 704.36 64.55 99,374.55
1997 August 99,374.55 768.91 703.90 65.01 99,309.54
1997 September 99,309.54 768.91 703.44 65.47 99,244.07
1997 October 99,244.07 768.91 702.98 65.93 99,178.14
1997 November 99,178.14 768.91 702.51 66.40 99,111.74
1997 December 99,111.74 768.91 702.04 66.87 99,044.87
1998 January 99,044.87 768.91 701.57 67.34 98,977.53
1998 February 98,977.53 768.91 701.09 67.82 98,909.71
1998 March 98,909.71 768.91 700.61 68.30 98,841.41
1998 April 98,841.41 768.91 700.13 68.78 98,772.63
1998 May 98,772.63 768.91 699.64 69.27 98,703.36
1998 June 98,703.36 768.91 699.15 69.76 98,633.60
1998 July 98,633.60 768.91 698.65 70.26 98,563.34
1998 August 98,563.34 768.91 698.16 70.75 98,492.59
1998 September 98,492.59 768.91 697.66 71.25 98,421.34
1998 October 98,421.34 768.91 697.15 71.76 98,349.58
1998 November 98,349.58 768.91 696.64 72.27 98,277.31
1998 December 98,277.31 768.91 696.13 72.78 98,204.53
1999 January 98,204.53 768.91 695.62 73.29 98,131.24
1999 February 98,131.24 768.91 695.10 73.81 98,057.43
1999 March 98,057.43 768.91 694.57 74.34 97,983.09
1999 April 97,983.09 768.91 694.05 74.86 97,908.23
1999 May 97,908.23 768.91 693.52 75.39 97,832.84
1999 June 97,832.84 768.91 692.98 75.93 97,756.91
1999 July 97,756.91 768.91 692.44 76.47 97,680.44
1999 August 97,680.44 768.91 691.90 77.01 97,603.43
1999 September 97,603.43 768.91 691.36 77.55 97,525.88
1999 October 97,525.88 768.91 690.81 78.10 97,447.78
1999 November 97,447.78 768.91 690.26 78.65 97,369.13
1999 December 97,369.13 768.91 689.70 79.21 97,289.92
========== ========== ==========
29,987.49 27,277.41 2,710.08
(Data generated by PROC MORTGAGE)