Loading...
HomeMy WebLinkAbout3.b.Others Community Facilities Task Force, Rosewood Estates_-e, YYl . City of Rosemount Annual Interest Rate Earned f 10 Beginning Balance $ 1,300,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015. 2016 2017 Interest Earnings $ 130,000 S 130,000 S 130,000 $ 130,000 $ 130,000 $ 130,000 S 130,000 S 130,000 $ 130,000 S 130,000 $ 130,000 $ 130,000 5 130,000 Annual Distribution (inflated L 3 %) $ (1(10,00(1 5 11(13,0(10 $ _ (106,()q() $ (109,273 $ (112,551 $ (115,927 $ (119,405 $ (122,981 $ (126,677 $ (130,477 $ (134,392 $ (138,423 $`142,5711) Available Funds $ 30,000 5 27,000 $ 23,910 $ 20,721 S 17,449 $ 14,073 $ 10,595 S 7,013 $ 3,323 $ (477) $ (4,392) $ (8,423) $ (12,SIE3) Annual Interest Rate Earned Beginning Balance $ 1,300,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2.017 Interest Earnings $ 104,000 S 104,000 S 104,000 $ 104,000 S 104,000 $ 104,000 S 104,000 $ 104,000 $ 104,000 S 104,000 $ 104,000 $ 104,000 S 1(A,000 Annual Distribution (inflated C 3 °6) $ (100,000 $ (103,000 S (106,090 $ (109,273 $ (112,551 $ (115.927 $ (119,405 $ (122,987 $ (126,677 S (130,477 $ (134,392 $ (138,423 $ (': 42,576) Available Funds $ 4,000 $ 1,000 $ (2.090) $ (5,273) $ (8,551) $ (11,927) 5 (15,405) $ (18,987) $ (22,677) $ (26,477) $ (30.392) $ (34,423) S (±6.576) Annual Interest Rate Earned F 6,1 Beginning Balance $ 1,300,000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Interest Earnings $ 78,000 S 78,000 $ 78,000 $ 78,000 S 78,000 $ 78.000 S 78,000 S 78,000 $ 78.000 S 78,000 $ 78,000 $ 78,000 $ 18,000 Annual Distribution (inflated ra 3%) $ (100,000 5 (103,000 $ (106,090 $ (109,273 $ (112,551 $ (115,927 $ (119,405 5 (122.987 $ (126,677 $ (130,477 $ (134,392 $ (138,423 $ (1 42,576) Available Funds $ (22,000) $ (25,000) S (28,090) $ (31,273) S (34,551) $ (37,927) $ (41,405) $ (44.987) $ (48,677) $ (52,477) $ (56,392) $ (60,423) $ (64,576) Annual Interest Rate Earned Beginning Balance $ 1,300.000 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Beginning Balance S 1,300,000 S 1,477,000 $ 1,661,030 $ 1,852,523 $ 2,051,624 S 2,256,689 S 2,474,037 $ 2,697,998 S 2.930,918 $ 3,173.155 $ 3,425,091 S 3.687,084 $ 3.959,568 Interest Earnings (on piev.yi ending balance) $ 52,000 S 59.080 $ 66,443 $ 74,101 $ 82,065 S 90,346 $ 98,961 $ 107,920 S 117,237 $ 126,926 $ 137,003 S 117,483 $ 156.383 Annual Addaon $ 225,000 S 225.000 $ 225,000 $ 225,000 $ 225,000 S 225,000 $ 225,000 $ 225,000 S 225.000 $ 225,000 $ 225,000 $ 2 ?5.000 $ 225,000 Annual Distribution S - -- -- '-- 1( CO,O W 1_00,000) $ _ 5 "� �o�ooc) s _..�? $ G" 100,000) $ 1100_000' S__ .. r _ " {1�JO,000j $ L100,000) $ (100_000' -- / -.- 1(1000) Available Funds $ 1.300,000 S 1,477,000 $ 1,661,080 $ 1,652,523 S 2,051.624 $ 2,258,689 $ 2.474,037 S 2,697,998 $ 2,930,916 $ 3,173,155 $ 3,425.081 $ . ---- 3,687,084 S "_ -( 3,959,568 . (t00,OnC1 $ 4,242,950 10 -Year Treasury @ 4.384 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Annual Distribution (inflated @ 3%) $ (100,000) S (103,000) $ (106,090) $ (109,273) $ (112,551) $ (115,927) $ (119,405) S (122,987) $ (126,677) $ (130,477) $ (134.3132) $ (138,423) $ (142,5761 Annual Amount to be Invested $ 2,281,022 $ 2,349,453 $ 2,419,936 $ 2,492,534 $ 2,567,310 $ 2,644,330 S 2,723,659 $ 2,805,369 $ 2,889,530 $ 2,976,216 $ 3,065,503 $ 3,157,468 $ 3,252,192 Amount Available $ 1,300,000 $ 1,300,000 $ 1,300.000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,3 Additional Amount Needed $ 981,022 $ 1,049,453 $ 1,119,936 $ 1,192,534 $ 1,267,310 $ 1,344,330 $ 1,423,659 $ 1,505,369 $ 1,589,530 $ 1,676,216 $ 1,765,503 $ 1,857,468 $ 1,952,192 10 -Year Agency @ 5.100 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Annual Distribution (inflated @ 3 %) $ (100,000) S (103,000) $ (106,090) $ (109.273) $ (112,551) $ (115,927) $ (119,405) $ (122.987) $ (126,677) $ (130,477) $ (134.392) $ (138,423) $ (142,576) Annual Amount to be invested S 1,960,784 $ 2,019,608 $ 2,080,196 $ 2,142,602 $ 2,206,880 $ 2,273,086 S 2,341,279 $ 2,411,517 $ 2,483,863 S 2,558,379 $ 2,635,130 $ 2,714,184 $ 2.795,610 Amount Available S 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 S 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,300,000 Additional Amount Needed $ 660,784 $ 719,608 $ 780,196 $ 842,602 S 906,880 $ 913,086 5 1,041,279 $ 1,111,517 $ 1,183,863 $ 1,258,379 S 1,335,130 $. 1,414,184 $ 1,495,610 Prepared by Springsled Incorporated Advisors to the Public Sector oil 0 I