Treasurer's Office

POOL Loan Example

Share |

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.