|
University of Massachusetts > Treasurer's Office > POOL Loan Example
Pool
Loan Repayment Examples
The following are two examples of
repayment plans for loans from the Pool.
Note: In order to estimate a repayment plan for a different loan amount with
the same assumptions in either example 1 or 2 below, simply divide your loan
amount by $1,000,000 and multiply the result with the loan payment presented in
either example. As an example, if you want to determine a repayment amount for
a $2,000,000 loan with the same assumptions as in example 1, divide $2,000,000
by $1,000,000 and the result is 2. Next, multiply the payments in example 1 by
2 to determine the estimated repayments.
Example
1 - $1,000,000
Assumptions:
Interest rate: 2.0%
Loan date: 05/01/2013
Loan length: 3 years
|
Date Due
|
Principal
|
Interest
|
Total
|
|
5/1/2013
|
-
|
-
|
-
|
|
6/1/2013
|
-
|
1,666.66
|
1,666.66
|
|
7/1/2013
|
74,619.12
|
1,666.66
|
76,285.78
|
|
8/1/2013
|
-
|
1,542.29
|
1,542.29
|
|
9/1/2013
|
-
|
1,542.29
|
1,542.29
|
|
10/1/2013
|
74,998.65
|
1,542.29
|
76,540.94
|
|
11/1/2013
|
-
|
1,417.29
|
1,417.29
|
|
12/1/2013
|
-
|
1,417.29
|
1,417.29
|
|
1/1/2014
|
75,380.11
|
1,417.29
|
76,797.40
|
|
2/1/2014
|
-
|
1,291.66
|
1,291.66
|
|
3/1/2014
|
-
|
1,291.66
|
1,291.66
|
|
4/1/2014
|
75,755.13
|
1,291.66
|
77,046.79
|
|
5/1/2014
|
-
|
1,165.40
|
1,165.40
|
|
6/1/2014
|
-
|
1,165.40
|
1,165.40
|
|
7/1/2014
|
76,136.23
|
1,165.40
|
77,301.63
|
|
8/1/2014
|
-
|
1,038.51
|
1,038.51
|
|
9/1/2014
|
-
|
1,038.51
|
1,038.51
|
|
10/1/2014
|
76,523.48
|
1,038.51
|
77,561.99
|
|
11/1/2014
|
-
|
910.97
|
910.97
|
|
12/1/2014
|
-
|
910.97
|
910.97
|
|
1/1/2015
|
76,912.70
|
910.97
|
77,823.67
|
|
2/1/2015
|
-
|
782.78
|
782.78
|
|
3/1/2015
|
-
|
782.78
|
782.78
|
|
4/1/2015
|
77,295.35
|
782.78
|
78,078.13
|
|
5/1/2015
|
-
|
653.95
|
653.95
|
|
6/1/2015
|
-
|
653.95
|
653.95
|
|
7/1/2015
|
77,684.20
|
653.95
|
78,338.15
|
|
8/1/2015
|
-
|
524.48
|
524.48
|
|
9/1/2015
|
-
|
524.48
|
524.48
|
|
10/1/2015
|
78,079.32
|
524.48
|
78,603.80
|
|
11/1/2015
|
-
|
394.35
|
394.35
|
|
12/1/2015
|
-
|
394.35
|
394.35
|
|
1/1/2016
|
78,476.45
|
394.35
|
78,870.80
|
|
2/1/2016
|
-
|
263.56
|
263.56
|
|
3/1/2016
|
-
|
263.56
|
263.56
|
|
4/1/2016
|
78,871.24
|
263.56
|
79,134.80
|
|
5/1/2016
|
-
|
132.11
|
132.11
|
|
6/1/2016
|
-
|
132.11
|
132.11
|
|
7/1/2016
|
79,268.02
|
132.11
|
79,400.13
|
|
TOTAL
|
$1,000,000
|
$33,685.37
|
$1,033,685.37
|
Example
2 - $1,000,000
Assumptions:
Interest rate: 2.0%
Loan date: 05/01/2013
Loan length: 5 years
|
Date Due
|
Principal
|
Interest
|
Total
|
|
5/1/2013
|
-
|
-
|
-
|
|
6/1/2013
|
-
|
1,666.67
|
1,666.67
|
|
7/1/2013
|
45,258.47
|
1,666.67
|
46,925.14
|
|
8/1/2013
|
-
|
1,591.24
|
1,591.24
|
|
9/1/2013
|
-
|
1,591.24
|
1,591.24
|
|
10/1/2013
|
45,488.67
|
1,591.24
|
47,079.91
|
|
11/1/2013
|
-
|
1,515.43
|
1,515.43
|
|
12/1/2013
|
-
|
1,515.43
|
1,515.43
|
|
1/1/2014
|
45,720.03
|
1,515.43
|
47,235.46
|
|
2/1/2014
|
-
|
1,439.23
|
1,439.23
|
|
3/1/2014
|
-
|
1,439.23
|
1,439.23
|
|
4/1/2014
|
45,947.50
|
1,439.23
|
47,386.73
|
|
5/1/2014
|
-
|
1,362.65
|
1,362.65
|
|
6/1/2014
|
-
|
1,362.65
|
1,362.65
|
|
7/1/2014
|
46,178.64
|
1,362.65
|
47,541.29
|
|
8/1/2014
|
-
|
1,285.69
|
1,285.69
|
|
9/1/2014
|
-
|
1,285.69
|
1,285.69
|
|
10/1/2014
|
46,413.52
|
1,285.69
|
47,699.21
|
|
11/1/2014
|
-
|
1,208.33
|
1,208.33
|
|
12/1/2014
|
-
|
1,208.33
|
1,208.33
|
|
1/1/2015
|
46,649.59
|
1,208.33
|
47,857.92
|
|
2/1/2015
|
-
|
1,130.58
|
1,130.58
|
|
3/1/2015
|
-
|
1,130.58
|
1,130.58
|
|
4/1/2015
|
46,881.68
|
1,130.58
|
48,012.26
|
|
5/1/2015
|
-
|
1,052.44
|
1,052.44
|
|
6/1/2015
|
-
|
1,052.44
|
1,052.44
|
|
7/1/2015
|
47,117.52
|
1,052.44
|
48,169.96
|
|
8/1/2015
|
-
|
973.91
|
973.91
|
|
9/1/2015
|
-
|
973.91
|
973.91
|
|
10/1/2015
|
47,357.17
|
973.91
|
48,331.08
|
|
11/1/2015
|
-
|
894.98
|
894.98
|
|
12/1/2015
|
-
|
894.98
|
894.98
|
|
1/1/2016
|
47,598.04
|
894.98
|
48,493.02
|
|
2/1/2016
|
-
|
815.65
|
815.65
|
|
3/1/2016
|
-
|
815.65
|
815.65
|
|
4/1/2016
|
47,837.50
|
815.65
|
48,653.15
|
|
5/1/2016
|
-
|
735.92
|
735.92
|
|
6/1/2016
|
-
|
735.92
|
735.92
|
|
7/1/2016
|
48,078.15
|
735.92
|
48,814.07
|
|
8/1/2016
|
-
|
655.79
|
655.79
|
|
9/1/2016
|
-
|
655.79
|
655.79
|
|
10/1/2016
|
48,322.69
|
655.79
|
48,978.48
|
|
11/1/2016
|
-
|
575.25
|
575.25
|
|
12/1/2016
|
-
|
575.25
|
575.25
|
|
1/1/2017
|
48,568.47
|
575.25
|
49,143.72
|
|
2/1/2017
|
-
|
494.30
|
494.30
|
|
3/1/2017
|
-
|
494.30
|
494.30
|
|
4/1/2017
|
48,810.10
|
494.30
|
49,304.40
|
|
5/1/2017
|
-
|
412.95
|
412.95
|
|
6/1/2017
|
-
|
412.95
|
412.95
|
|
7/1/2017
|
49,055.65
|
412.95
|
49,468.60
|
|
8/1/2017
|
-
|
331.19
|
331.19
|
|
9/1/2017
|
-
|
331.19
|
331.19
|
|
10/1/2017
|
49,305.16
|
331.19
|
49,636.35
|
|
11/1/2017
|
-
|
249.01
|
249.01
|
|
12/1/2017
|
-
|
249.01
|
249.01
|
|
1/1/2018
|
49,555.94
|
249.01
|
49,804.95
|
|
2/1/2018
|
-
|
166.42
|
166.42
|
|
3/1/2018
|
-
|
166.42
|
166.42
|
|
4/1/2018
|
49,802.48
|
166.42
|
49,968.90
|
|
5/1/2018
|
-
|
83.42
|
83.42
|
|
6/1/2018
|
-
|
83.42
|
83.42
|
|
7/1/2018
|
50,053.03
|
83.42
|
50,136.45
|
|
TOTAL
|
$1,000,000
|
$54,256.48
|
$1,054,256.48
|
Last Updated on 05/01/13
By Treasurer's Office
The PDF files on this page require the free Adobe Acrobat Reader.
|
|
This is an