|
ATTACHMENT 3
<br />Attachment 3: Costco Sales Tax Share Analysis
<br />Amount
<br />Interest Rate
<br />Maximum Term
<br />Fiscal Year
<br />Year
<br />2019/20 1
<br />2020/21 2
<br />2021/22 3
<br />2022/23 4
<br />2023/24 5
<br />2024/25 6
<br />2025/26 7
<br />2026/27 8
<br />2027/28 9
<br />2028/29 10
<br />2029/30 11
<br />2030/31 12
<br />2031/32 13
<br />2032/33 14
<br />2033/34 15
<br />2034/35 16
<br />2035/36 17
<br />2036/37 18
<br />2037/38 19
<br />2038/39 20
<br />2039/40 21
<br />2040/41 22
<br />2041/42 23
<br />2042/43 24
<br />2043/44 25
<br />Totals
<br />6,800,000
<br />1.50%
<br />25
<br />Regular Payment Schedule
<br />Prepayment Schedule (Based on
<br />Projected Costco Sales Tax
<br />Revenues)
<br />Total
<br />City
<br />Projected
<br />Total -
<br />Principal
<br />Interest
<br />Total
<br />Costco Sales
<br />Principal
<br />Interest
<br />40% of
<br />Allocation -
<br />Tax
<br />Sales Tax
<br />60% of Sales
<br />Revenues
<br />Tax
<br />$226,191
<br />$102,000
<br />$328,191
<br />$926,709
<br />$268,684
<br />$102,000
<br />$370,684
<br />$556,025
<br />229,584
<br />98,607
<br />328,191
<br />954,510
<br />283,834
<br />97,970
<br />381,804
<br />572,706
<br />233,028
<br />95,163
<br />328,191
<br />983,146
<br />299,546
<br />93,712
<br />393,258
<br />589,887
<br />236,524
<br />91,668
<br />328,191
<br />1,012,640
<br />315,837
<br />89,219
<br />405,056
<br />607,584
<br />240,071
<br />88,120
<br />328,191
<br />1,043,019
<br />332,726
<br />84,481
<br />417,208
<br />625,811
<br />243,672
<br />84,519
<br />328,191
<br />1,074,310
<br />350,233
<br />79,491
<br />429,724
<br />644,586
<br />247,328
<br />80,864
<br />328,191
<br />1,106,539
<br />368,379
<br />74,237
<br />442,616
<br />663,923
<br />251,037
<br />77,154
<br />328,191
<br />1,139,735
<br />387,183
<br />68,711
<br />455,894
<br />683,841
<br />254,803
<br />73,388
<br />328,191
<br />1,173,927
<br />406,667
<br />62,904
<br />469,571
<br />704,356
<br />258,625
<br />69,566
<br />328,191
<br />1,209,145
<br />426,854
<br />56,804
<br />483,658
<br />725,487
<br />262,504
<br />65,687
<br />328,191
<br />1,245,419
<br />447,767
<br />50,401
<br />498,168
<br />747,252
<br />266,442
<br />61,749
<br />328,191
<br />1,282,782
<br />469,428
<br />43,684
<br />513,113
<br />769,669
<br />270,439
<br />57,753
<br />328,191
<br />1,321,265
<br />491,863
<br />36,643
<br />528,506
<br />792,759
<br />274,495
<br />53,696
<br />328,191
<br />1,360,903
<br />515,096
<br />29,265
<br />544,361
<br />816,542
<br />278,613
<br />49,579
<br />328,191
<br />1,401,731
<br />539,154
<br />21,539
<br />560,692
<br />841,038
<br />282,792
<br />45,400
<br />328,191
<br />1,443,782
<br />564,062
<br />13,451
<br />577,513
<br />866,269
<br />287,034
<br />41,158
<br />328,191
<br />1,487,096
<br />332,686
<br />4,990
<br />337,677
<br />1,149,419
<br />291,339
<br />36,852
<br />328,191
<br />1,531,709
<br />1,531,709
<br />295,709
<br />32,482
<br />328,191
<br />1,577,660
<br />1,577,660
<br />300,145
<br />28,047
<br />328,191
<br />1,624,990
<br />1,624,990
<br />304,647
<br />23,544
<br />328,191
<br />1,673,740
<br />1,673,740
<br />309,217
<br />18,975
<br />328,191
<br />1,723,952
<br />1,723,952
<br />313,855
<br />14,336
<br />328,191
<br />1,775,670
<br />1,775,670
<br />318,563
<br />9,629
<br />328,191
<br />1,828,940
<br />1,828,940
<br />323,341
<br />4,850
<br />328,191
<br />1,883,809
<br />1,883,809
<br />$6,800,000
<br />$1,404,787
<br />$8,204,787
<br />$33,787,128
<br />$6,800,000
<br />$1,009,502
<br />$7,809,502
<br />$25,977,626
<br />
|