HomeMy WebLinkAbout6.B. Consideration of Tax Abatement Res. No. 7337, a Minnesota Investment Fund Forgivable Loan, and Sewer Access Charge Credits for Shutterfly, Inc. �� Public Hearings (. B.
�►�.��c»��.t-
TO: Mayor and City Council
Mark McNeill, City Administrator
FROM: Samantha DiMaggio, Economic Development Coordinator
DATE: 08/07/2013
SUBJECT: Consideration of Tax Abatement Res. No. 7337, a Minnesota Investment Fund
Forgivable Loan, and Sewer Access Charge Credits for Shutterfly, Inc. (B,D)
Action Sought
Council should approve Resolution No. 7337, a resolution granting a Property Tax Abatement, a
Minnesota Investment Fund and Sewer Access Charge Credits for Shutterfly, Inc. in the City of
Shakopee. These funds will be used to facilitate the start-up of a production facility in the Dean
Lakes Subdivision.
The EDA will be asked to pass Resolution No. 13-4, authorizing a Minnesota Investment Fund
Application to the Department of Employment and Economic Development.
Background
Shutterfly, Inc. is an Internet-based social expression and personal publishing service that was
founded in December of 1999. It is a publicly traded company that is headquartered in Redwood
City, CA with manufacturing facilities in Phoenix, AZ and Fort Mill, SC. Shutterfly offers free
on-line photo storage, storing billions of pictures for millions of customers. Shutterfly, Inc.
generates the majority of its revenues by producing and selling professionally-bound photo books,
greeting cards, as well as stationery, personalized calendars, other photo-based merchandise
and photo prints. Recent growth activity of the company from Apri12011 to April, 2013 includes
the acquisition of Kodak Gallery, My Publisher, This Life, and Tiny Prints.
The site under consideration in Shakopee is in the Dean Lakes development. The site is 22.8
acres in size; the building is planned to be 217,000 square feet and would provide space for new
and expanded production/manufacturing operations, a call center, and general administrative
functions. Shutterfly is proposing to break ground on the site at the end of 3 rd Quarter 2013 with
construction completion planned for 3rd Quarter 2014.
The total proposed project investment is $60,366,714, of which Ryan Co. will invest
approximately $26 million, while Shutterfly. will invest $34 million. Shutterfly will enter into a
triple net lease with Ryan Companies, which requires them to pay rent as well as all taxes,
insurance, and maintenance expenses that arise from the use of the property.
Shutterfly anticipates the creation of approximately 329 jobs over the next 2-5 years, with 201 of
those being hired in 2014. The average annual wage (unloaded) per hour is $18.78. It also
anticipates an additional 425,000 annual hours to be filled by seasonal employees. These
seasonal jobs equate to an additiona1204 full time equivalent positions. Annual payroll at full
ramp up is estimated at just under $12.9 million.
Shutterfly has asked for 100% abatement for a nine (9) year term. Based on the preliminary
building assessed values of between $12 million, and $16 million, the City of
Shakopee's estimated abatement value is between $569,078 to $758,771 over the nine (9) year
term.
Up to 60 Metropolitan Council sewer access charges, and city Sewer access charge credits have
been offered as part of the incentive package. The total value for these incentives is approximately
$174,600.
Shutterfly has also requested a 100% nine (9) year abatement from Scott County, which would
have a value between $551,159 to $734,878 over the nine year term. Additionally County staff
have been working with Shutterfly to discuss utilizing the County's fiber infrastructure. The
estimated cost to construct a redundant fiber loop would be approximately $80,000 and the
electronics to initiate the services at $20,000, for a total of$100,000. Access Communications
has agreed to provide fiber connectivity services, which would provide 10 gigabytes of service, at
a monthly fee of$1,000.
The Minnesota Department of Employment and Economic Development has preliminarily
committed to a Minnesota Investment Fund (MIF)forgivable loan of up to $1,000,000, and up to
$400,000 in the Minnesota Job Skills Partnership (MJSP) matching grant program.
Recommendation
Based on the number of jobs that Shutterfly will create, staff recommends the approval the
attached Resolution 7337.
Budget Impact
The Abatement will have a maximum term of nine years and shall be collected in the years 2016
through 2024. The maximum abatement amount for the City to consider would be $758,771.
More detailed information regarding abatement from the City's financial consultant Springsted is
attached.
This would be a "Pay As You Go" arrangement, meaning that if Shutterfly, Inc. does not pay
property taxes for whatever reason, or if the amount of taxes paid varies for any reason, it impacts
the abatement amount back to the company.
Relationship to Vision
This supports Goal B, "Positively manage the challenges and opportunities presented by growth,
development, and change", and Goal D, " Maintain improve and create strong partnerships with
other public and private sector entities".
Requested Action
Following the Public Hearing, if the Council concurs, it should, by motion ,approve the following
Resolution:
Resolution No. 7337, A Resolution granting a Property Tax Abatement, Sewer Access
Charge Credits
and a Minnesota Investment Fund Forgivable Loan for Shutterfly, Inc. in the City of
Shakopee.
Attachments: Resolution No. 7337
Econ. Impact Study
Springsted Analysis
CITY OF SHAKOPEE,MINNESOTA
RESOLUTION NO.7337
RESOLUTION GRANTING A PROPERTY TAX ABATEMENT
FOR CERTAIN PROPERTY IN THE CITY OF SHAKOPEE
BE IT RESOLVED by the City Council (the "City Council") of the City of Shakopee, Minnesota
(the"City")as follows:
Section 1. Recitals.
1.01. Ryan Companies US, Inc., a Minnesota corporation, or one of its affiliates has proposed
to construct an approximately 217,006 square foot building for use as a manufacturing facility, office, and
call center(the "Minimum Improvements") on real property located in the City and legally described as set
forth in E�ibit A attached hereto (the "Properiy"). Shutterfly, Inc., a Delaware corporation, or any of its
affiliates (the "Developer"), has proposed to lease the Minimum Improvements and purchase equipment for
the Minimum Improvements in order to operate a manufacturing facility with related office and call center
space.
1.02. Pursuant to Minnesota Statutes, Sections 469.1812 through 469.1815 (the "Abatement
Act"), the City has determined a need to grant a property tax abatement on the Properly (the
"Abatement")to the Developer in order to finance a portion of the costs of the construction and equipping
of the Minimum Improvements.
1.03. Scott County, Minnesota (the "County") will also be asked to conduct a duly noticed
public hearing on property tax abatements proposed to be provided by the County and consider granting
the Developer a property tax abatement on the Property.
1.04. The City has also determined to provide additional assistance to the Developer including
sewer access charge credits in the amount of up to $174,600 and a Minnesota Investment Fund loan in the
approximate amount of$1,000,000(the"City Development Assistance").
1.05. The Abatement and City Development Assistance proposed to be provided to the
Developer by the City to help finance the Minimum Improvements constitute business subsidies under
Minnesota Statutes, Sections 116J.993 to 116J.995 (the"Business Subsidy AcY').
1.06. The City Council has reviewed information concerning the above-referenced Minimum
Improvements.
1.07. On the date hereof, the City Council conducted a duly noticed public hearing on the
Abatement proposed to be granted by the City and the business subsidy to be provided to the Developer.
The views of all interested persons were heard and considered at the public hearing.
1.08. The City intends to enter into a Contract for Private Development (the "Contract for
Private Development") with the Developer, which shall set forth the terms of the Abatement and City
Development Assistance proposed to be provided by the City to the Developer.
Section 2. Findin�s.
2A1. The recitals set forth above are incorporated into this Resolution.
428637v2 JAE SH155-316
2.02. It is hereby found and determined that the Minimum Improvements would not be
economically feasible without the City Development Assistance.
2.03. It is hereby found and determined that the benefits to the City from the Abatement will be
at least equal to the costs to the City of the Abatement, because (a)the City believes that the development
to be facilitated is not reasonably likely to occur absent the Abatement, (b) the development to be
facilitated by the Abatement will likely encourage additional development within the area, and (c) the
long-term taxes collected from the Property after termination of the Abatement will exceed the amount of
the Abatement returned to the Developer.
2.04. It is hereby found and determined that the Abatement and City Development Assistance
are in the public interest because such actions will increase the City's tax base and provide additional
employment opportunities in the City.
2.05. It is further specifically found and determined that the Abatement is expected to result in
the following public benefits:
(a) Creation of an estimated $16,000,000 increase in market value for property tax purposes,
which will be available to all taxing jurisdictions after expiration of the Abatement (commencing
in 2025); and
(b) Provision of an estimated 258 new jobs in the City within two years.
Section 3. Actions Ratified; Abatement Approved
3.01. The City Council hereby ratifies all actions of the City's staff and consultants in
arranging for approval of this Resolution in accordance with the Abatement Act and the Business Subsidy
Act.
3.02. Subject to the provisions of the Abatement Act, the Abatement is hereby approved and
adopted subject to the following terms and conditions:
(a) The term "Abatement" means the real property taxes generated in any tax-payable year
by extending the City's total tax rate for that year against the tax capacity of the Minimum
Improvements constructed on the Property, excluding the tax capacity of the land (as established
each year during the Abatement) and excluding the portion of the tax capacity attributable to the
areawide tax under Minnesota Statues, Chapter 473F,all as of January 2 in the prior year.
(b) The Abatement will be paid by the City to the Developer on the dates and in accordance
with all the terms and conditions of the Contract for Private Development.
(c) In accordance with Section 469.1813, subdivision 8 of the Abatement Act, in no year
shall the Abatement, together with all other abatements approved by the City under the
Abatement Act and paid in that year exceed the greater of 10% of the net tax capacity of the City
for that year or$200,000(the"Abatement Cap"). The City may grant other abatements permitted
under the Abatement Act after the date of this Resolution, provided that to the extent the total
abatements in any year exceed the Abatement Cap,the allocation of Abatement Cap to such other
abatements is subordinate to the Abatement granted pursuant to this Resolution.
428637v2 JAE SH155-316 2
(d) The Abatement will have a maximum term of nine years and shall be collected in the
years 2016 through 2024.
(e) In no event shall the total payments of Abatement to the Developer exceed $758,771 or
continue to be paid for more than nine years.
(fl The Abatement is subject to modification in accardance with the Abatement Act, subject
to the terms of the Contract for Private Development.
(g) In accordance with Section 469.1815 of the Abatement Act, the City will add to its levy
in each year during the term of the Abatement the total estimated amount of current year
Abatement granted under this Resolution.
(h) The City makes no warranties or representations regarding the amount or availability of
the Abatement.
(i) The Abatement shall be provided to the Developer pursuant to the terms and conditions
of the Contract for Private Development, as approved by the City Council.
3.03 The City Development Assistance shall be provided to the Developer pursuant to the
terms and conditions of the Contract for Private Development, including the subsidy agreement, to be
approved by the City Council.
Section 4. Restrictions on Abatement. The Abatement granted pursuant to this Resolution
shall not commence until the following conditions are satisfied:
(a) The City and Developer mutually agree on the terms and conditions of a Contract for Private
Development.
(b) If the County approves an abatement for the Properly and joins as a pariy to the Contract for
Private Development, the City, the Developer, and the County mutually agree on the terms and
conditions of a Contract for Private Development.
(c) The Developer purchases the Property and locates a portion of its operations to the City.
Section 5. Countv Participation. The Mayor and City Administrator are authorized to work
with the County if it chooses to abate a portion of their portion of the property ta�ces for the benefit of the
Developer, including but not limited to drafting the Contract for Private Development and administering the
payment of the County's abatement dollars.
Section 6. Implementation. The Mayor and City Administrator are authorized and directed
to execute and deliver any additional agreements, certificates ar other documents that the City determines
are necessary to implement this Resolution.
Section 7. Effective Date. This Resolution is effective upon execution in full of the
Contract for Private Development.
428637v2 JAE SH155-316 3
Approved by the City Council of the City of Shakopee,Minnesota this 7"'day of August, 2013.
Mayor
ATTEST:
Finance Director/City Clerk
428637v2 JAE SH155-316 4
EXHIBIT A TO ABATEMENT RESOLUTION
PROPERTY
273990030: Section 10 Township 115 Range 022 Subdivision Name RLS 199 Lot TCT Block
OOC Subdivision Cd 27399
274080060: Section 10 Township 115 Range 022 Subdivision Name DEAN LAKES STH
ADDN Lot 001 Block 002 Subdivision Cd 27408
274080070: Section 10 Township 115 Range 022 Subdivision Name DEAN LAKES STH
ADDN Lot 002 Block 002 Subdivision Cd 27408
274080080: Section 10 Township 115 Range 022 Subdivision Name DEAN LAKES STH
ADDN Lot 003 Block 002 Subdivision Cd 27408
428637v2 JAE SH155-316 A-1
GREATER MSPi"'
Minneapolis Saint Paul Regional Ecorwmic Developmerrt Partnership
Shutterly, Inc. — Economic Impact
As requested, economic impact estimates have been compiled for the proposed Shutterly Inc.
facility on the Minneapolis-St. Paul metropolitan area. This memo enumerates the total (direct,
indirect and induced)1 economic impact.
There are two pieces to this impact estimate. The construction phase is a one-time impact that
creates economic activity during the building process, but then goes away once building is
complete. The operations phase impact estimate examines a five year scale up of operations.
If the company maintains the level of business operations as projected, the operations phase
has ongoing impact.
Summary
• The results indicate that for every 1 job created at Shutterfly, another 1.7 jobs are
created elsewhere in the economy.
• Over the construction and 5 year scale up phase, over$172 million in wages will be paid
out and about $7.6 million in new tax revenue generated.
• There is an estimated $1,800 per full time job in new tax revenue generated for the
state. Approximately$645 of that is estimated to be new local tax revenue.
Based on previous experience with firms, approximately 15-30% of employees are likely
to reside in the local community. This suggests approximately$88,000-$175,000 in
new local tax revenue annually when the firm is at full employment levels. When part-
time workers are included, estimated potential local tax revenue increases to $115,000-
$230,000.
• The wages of the direct jobs will average in the low$40,000 range, while the indirect
and induced jobs will average in the $37,000 range.
1 In what is often called either a ripple effect or multiplier effect,increased economic adivity triggers additional spending. The total economic
impact of the economic activity is the sum of three effects: The direct effect(the change in activity that stimulates other activity,in this case
construction or an increase in employment),the indirect effect(resulting from industries purchasing from other industries due to increased
demand)and induced effects(resulting from the expenditure of new household income generated by the direct and indirect effects).
GREATER MSPT"'
Mirv�eapolis Saint Pau!Regional Economic Devdopment Partnership
Project Overview
Construction Phase: Construction-related costs for the project, as provided by Shutterfly, are
estimated to be $12 million (renovation and construction) with $48 million in new equipment
and fixture related purchases.
Operations Phase: When construction is complete, Shutterfly estimates they will employ 201
full time new workers in year 1, another 57 in year 2 and 57 again in year 3, as well as 7 hired
each year in years 4 and 5. A total of 329 full time workers will be employed by 2018.
Shutterfly estimates an average wage of approximately$41,000 for those workers.
Additionally, Shutterfly estimates they will employ 400 to 700 part time seasonal workers.
For the purposes of this analysis, these positions are reduced to the full time equivalent of
200 positions. The ramp up of part time positions is assumed to emulate that of the full time
positions. The part time positions will have a full time equivalent salary of approximately
$31,000.
Economic Impact of the Shutterfly,Inc. Facility(Full-Time Workers Only)
Constructio Operetions: Scale Up
2013 2014 2015 2016 2017 2018
Employment(Direct) 131 201 258 315 322 329
Employment(Indirect,Induced) 126 345 452 551 564 576
Wages and Salaries(Direct,$M) $6.7 $8.4 $11.1 $13.5 $13.8 $14.1
Wa es and Salaries(Indirect,Induced,$M) $4.6 $13.8 $18.0 $22.0 $22.5 $23.0
GDP(Direct,$M) $13.5 $21.8 $28.6 $34.9 $35.6 $36.4
GDP (Indirect,Induced,$M) $11.2 $33.4 $43.7 $53.4 $54.6 $55.8
Estimated State Tax Revenue Generated by
Employees($M) $0.5 $1.0 $13 $1.6 $1.6 $1.6
Dollars are not adjusted for inflation.This analysis excludes changes in government spending from reduced revenue wllections,and assumes that wnrkers W�II either be(a)moving in from o ut of state
and living in nevAy bullt housing or(b)are currenUy unemployed,buy no ta�ble goods,and live in untaxed pro perty.
So urce:Analysis conduc�ed w�th IM P LAN 3.0;20A Tax Incidence Study,M innesota DepaRment oF Revenue.
Prepared by:Research 8 Analysis,M inneapolis Sainl Paul Regional Economic Development Partnership(GREATER M SP).Analysis dated:July 5,20Ti.
Economic Impact of the Shutterfly,Inc. Facility(Full-Time and Part-Time Workers)
Construdio Operations: Scale Up
2013 2014 2015 2016 2017 2018
Employment(Direct) 131 323 414 505 516 529
Employment(Indirect,Induced) 126 565 725 884 903 926
Wages and Salaries(Direct,$M) $6.7 $10.3 $13.2 $16.0 $16.4 $16.8
Wages and Salaries(Indirect,Induced,$M) $4.6 $19.4 $24.8 $30.3 $30.9 $31.7
GDP(Direct,$M) $13.5 $35.8 $45.8 $55.9 $57.1 $58.6
GDP(Indirect,Induced,$M) $11.2 $54.8 $70.2 $85.6 $87.5 $89.7
Estimated State Tax Revenue Genereted by
Employees($M) $0.5 $1.3 $1.7 $2.0 $2.1 $2.1
Dollars are not adjusted for inflation.This analysis excludes changes in govemment spending from reduced revenue collections.and assumes tha�v.orkers will either be(a)moving in from out of state
and Ilving in nevAy bullt housing or(b)are cuventlyunemployed,buy no tarable goods,and live in untazed pro perty.
So urce:A nalysis co nductetl wil h IM P LA N 3.0;20A Tax Incitlence Study,M innesota Oepartment o f Revenue.
Prepared by Research&Analysis,M inneapolis Saint Paul Regional Economic Development Partnership(GREATER M SP�.Analysis dated:Juty 5,20II.
Springsted Incorporated
380 Jackson Street, Suite 300
Saint Paul,MN 55101-2887
Sprir��sted
Tel: 651-223-3000
Fax: 651-223-3002
www.springsted.com
DRAFT MEMORANDUM
T0: Mark McNeill, City Administrator
Julie Linnihan, Finance Director
Samantha DiMaggio, Economic Development Coordinator
FROM: Mikaela Huot,Vice President/Consultant
CC: Renee Christianson, Business Development, Senior Analyst, Scott County CDA
Paul Steinman,Vice PresidentlClient Representative
DATE: July 8,2013
SUBJECT: Preliminary Tax Abatement Financing Projections for proposed new development project
The City has requested that Springsted provitle preliminary tax abatement revenue projections for a proposetl new
project that includes the acquisition of land and construction of an approximate 250,000 square foot facility within the
City of Shakopee. Springsted has prepared a preliminary analysis basetl on certain value assumptions of the project
using providetl information from the City, County and potential business. The purpose of this memo is to provide a
summary of the tax abatement projections and assumptions used.
Development assumptions include the construction of an approximate 250,000 square foot building,for which a tax
abatement project would be created to capture taxes generated from the new building through an annual abatement
levy. The anticipatetl build-out of the facility is projected to commence in fall of 2013 antl be complete by spring of
2014. Based on the construction schedule,we assume the first abatement year woultl be taxes payable 2016.
The City of Shakopee has traditionally provitled up to 9 years of tax abatement assistance similar to the terms of an
economic tlevelopment district for proposed new projects. However, in certain cases in which a particular company
that has located within the Dean Lakes business park has provided greater employment opportunities with higher
wages,the City of Shakopee has considered providing up to 15 years of tax abatement assistance.
Public Sector Advisors
City of Shakopee, Minnesota
Proposed New Tax Abatement Project:Shutterfly
July 8,2013
Page 2
For purposes of the updated preliminary analysis we are including two alternate market values scenarios, Scenario 1:
Low EMV with$12M of new building value and Scenario 2: High EMV with$16M of new building value, based on
preliminary value information providetl by Scott County. For both value scenarios we are illustrating the potential
revenue generated by both the City and Scott County. Participation by each taxing entity is subject to policy review
and approval. Additional assumptions and terms of the proposed abatement are outlined further below.
The purpose of this memo is to provide financial projections for proposed tax abatement assistance based on 100%
of the annual tax abatement revenues for 9 years,with City and County participation.
Tax Abatement Assumptions
Springsted matle certain assumptions to calculate the estimated amount of tax abatement revenues generated by the
proposed project. Those assumptions include the following:
Tax Abatement
A city may grant a tax abatement, by contract or otherwise, of the taxes imposed by the city on a parcel of property,
which may include personal property and machinery, or defer the payments of the taxes and abate the interest antl
penalty that otherwise would apply, if:
• it expects the benefits to the city of the proposed abatement agreement to at least equal the costs to the city
of the proposed agreement or intentls the abatement to phase in a property tax increase, as provided in
clause(2)(vii); and
• it finds that doing so is in the public interest because it will:
o increase or preserve tax base;
o provide employment opportunities in the political subdivision;
o provide or help acquire or construct public facilities;
o help redevelop or renew blightetl areas;
o help provide access to services for residents of the political subdivision;
o finance or provide public infrastructure;
o phase in a property tax increase on the parcel resulting from an increase of 50 percent or more in
one year on the estimated market value of the parcel, other than increase attributable to
improvement of the parcel; or
o stabilize the tax base through equalization of property tax revenues for a specified period of time
with respect to a taxpayer whose real and personal property is subject to valuation under
Minnesota Rules,chapter 8100.
Public Sector Advisors
City of Shakopee,Minnesota
Proposed New Tax Abatement Project:ShutterFly
July 8,2013
Page 3
For our preliminary tax abatement scenarios we used the following assumptions:
• Abate new building value only
• Revenue projections were prepared for two market value estimates
o Scenario 1: Low EMV with incremental market value of$12M
o Scenario 2: High EMV with incremental market value of$16M
■ Estimated market value information provided by Scott County
• Existing land and building value would not be abated
o ParceIID:27-399003-0
■ Payable 2013 EMV of$1,500,000
o ParceIID:27-408006-0
■ Payable 2013 EMV of$875,000
o ParceIID:27-408007-0
■ Payable 2013 EMV of$780,000
o ParceIID:27-408008-0
■ Payable 2013 EMV of$795,000
• Proposed abatement term
0 9 years
• Both scenarios illustrate potential City and County participation
• Abatement participation
0 100%participation City and County
• Construction schedule
o Construction commences in 2014 antl completes in spring 2014
■ 100%assessed in January of 2015 for taxes payable in 2016
• Payable 2013 tax rates remain constant through abatement term
o City: 41.996%
o County: 40.674%
o School: 39.715%
o Other: 5.701%
o Total: 128.086%
• Current class rates remain constant through abatement term
• Fiscal Disparities contribution rate
0 2013 contribution rate of 39.1355°/o
o Contribution matle from new tax abatement project
• Phased in annual market value inflator assumed
0 0%years 1-3
0 1°/o years 4-6
0 2%years 7-9
• Present value date of August 1,2013
• Present value(discount rate)of 4%
Public Sector Advisors
City of Shakopee,Minnesota
Proposed New Tax Abatement Project:Shutterfly
July 8,2013
Page 4
Tax Abatement Revenue Estimates
Scenario 1: Scenario 2:
Low EMV Hi h EMV
Estimated Incremental New Buildin Market Value $12,000,000 $16,000,000
2016 Annual Abatement Revenue: $61,346 $81,794
Cit share u on com letion in 2014
2016 Annual Abatement Revenue: $59,414 $79,219
Count share u on com letion in 2014
2016 Total Annual Abatement Revenue upon $120,759 $161,013
com letion in 2014
Estimated Total City Abatement Revenue over 9 years $569,078 $758,771
Estimated Total County Abatement Revenue over 9 years $551,159 $734,878
Estimated Total Tax Abatement Revenue over 9 years $1,120,237 $1,493,649
Estimated Present Value of Revenues Combined City and gg61,536 $1,148,715
Count 4°/o discount rate and Au ust 1, 2013 date
Estimated Total Property Tax Payment commencing 2016
based u on buildin com letion in 2014 $630,205 $788,609
Thank you for the opportunity to be of assistance to the City of Shakopee. Please let us know how we can best
assist you as this project moves forward and should you have any questions please feel free to contact us.
Public Sector Advisors
City of Shakopee,Minnesota
Proposed New Tax Abatement Project:Shutterfly
July 8,2013
Page 5
Tax Abatement Revenue Projections for Scenario 1: Low EMV with Estimated Bui/ding Market Va/ue of$12M with 9-Year Term and 100%
Annual Abatement Revenues Available for Project
Projected Tax Abatement Report
City of Shakopee,Minnesota
Proposed New Tax Abatement Project -Shuttertly
City and County Participation:Low Value Scenario Building Value of$12M
9 year term,FD Cont properties within and incremental MV Inflator-100°/ofvalue abated
Less:
Non- Less: Retained Times: City County School District PV Total PV City PV County Total
Mnual Total Total Abated Fiscal Captured Tax Mnual Abatement Abatement Abatement Total Abatemenl Abatement Abatement Estimated
Period Market Net Tax Net Tax Disp.@" Net Tax Capacity Total Revenues"" Revenues""'" Revenues Tax Revenues Revenues Revenues Property
Ending Value Capacity Capacily ' 39.1355% Capacily Rate"' Tax 42.00% 40.67% 39.72% Abatement 08/01/13 08/01/13 08/01/13 TaxPymt
1 2 3 4 5 6 7 8 9 10 11 12 4.00% 4.00% 4.00%
12/31/13 3,950,000 78,250 78,250 0 0 128.086% 0 0 0 0 0 0 0 0 154,994
12/31/14 3,950,000 78,250 78,250 0 0 128.086% 0 0 0 0 0 0 0 0 154,994
12/31/15 5,150,000 102,250 7$250 9,393 14,607 128.086% 18,710 0 0 0 0 0 0 0 202,515
12/31/16 15,950 000 318,250 78 250 93 925 146 075 128.086% 187101 61 346 59 414 0 120 759 108,413 55 073 53 339 630 205
12/31/17 15,950,000 318,250 78.250 93,925 146,075 128.086% 187,101 61,346 59,414 0 120,759 104,243 52,955 51,288 630,205
12/31/18 15,950,000 318,250 78,250 93,925 146,075 128.086% 187,101 61,346 59,414 0 120,759 100,233 50,918 49,315 630,205
12/31/19 16,070,000 320,650 78,250 94,864 147,536 128.086% 188,972 61,959 60,008 0 121,967 97,342 49,450 47,893 634,957
12/31/20 16,191,200 323,074 78,250 95,813 149,011 128.086% 190,862 62,579 60,608 0 123,187 94,534 48,023 46,511 639,757
12/31/21 16,313,612 325,522 78,250 96,771 150,501 128.086% 192,770 63,204 61,214 0 124,418 91,807 46,638 45,169 644,604
12/31/22 16,560,884 330,468 78,250 98,707 153,511 128.086% 196,626 64,469 62,439 0 126,907 90,042 45,741 44,301 654,397
12/31/23 16,813,102 335,512 78,250 100,681 156,581 128.086% 200,558 65,758 63,687 0 129,445 88,310 44,861 43,449 664,385
12/31/24 17,070,364 340,657 78,250 102,694 159,713 128.086% 204,569 67,073 64,961 0 132,034 86,612 43,999 42,613 674,572
$1,754,370 $569,078 $551,159 $0 $1,120,237 $861,536 $437,658 $423,878 $6,315,792
'Base value based on exisfing land and bulding value. Abated value includes newestimated land building of$12M PID:273990030 $1,500,000
'*Fisca/dispanties contribution from incremental building growth PID:274080060 $875,000 State C-I Tax Rate 52.52%
"'Final payable 2013 tax rate based on in/o�mation provided by County(taxing code 2204 PID:274080070 $780,000
""Estimated 100%o/annual revenues abated for project PID:274080080 $795,000
2013 Existing Market Value $3,950,000
Public Sector Advisors
City of Shakopee,Minnesota
Proposed New Tax Abatement Project:Shutterfly
July 8,2013
Page 6
Tax Abatement Revenue Projections for Scenario 2: High EMV with Estimated Building Market Value of$16M with 9-Year Term and 100%
Annual Abatement Revenues Availab/e for Project
Projected Tax Abatement Report
City of Shakopee,Minnesota
Proposed New Tax Abatement Project -ShutterFly
City and County Participation:High Value Scenario Building Value of E16M
9 year term,FD Cont properties within and incremental MV Inflator-100%of value abated
Less:
Non- Less: Retained Times: City County School Districl PV Total PV City PV County Total
Mnual Total Total Abated Fiscal Captured Tax Mnual Abatement Abatemenl Abatement Tolal Abatement Abatement Abalement Estimated
Period Market Net Tax Net Tax Disp.@" Nel Tax Capacity Total Revenues"'" Revenues"" Revenues Tax Revenues Revenues Revenues Property
Ending Value Capacity Capacity' 39.1355% Capacity Rate"' Tax 42.00% 40.67% 39.72% Abatement OS/01/13 08/01/13 08/01/13 Tax Pymt
1 2 3 4 5 6 7 8 9 10 11 12 4.00% 4.00% 4.00%
12/31/13 3,950,000 78,250 78,250 0 0 128.086% 0 0 0 0 0 0 0 0 154,994
12/31/14 3.950,000 78,250 78,250 0 0 128.086% 0 0 0 0 0 0 0 0 154,994
12/31/15 5,550,000 110,250 78,250 12,523 19,477 128.086% 24,947 0 0 0 0 0 0 0 218,356
12/31/16 19,950,000 398,250 78,250 125,234 194,766 128.086% 249,468 81,794 79,219 0 161,013 144,550 73,431 71119 788,609
12/31/17 19,950,000 39$250 78,250 125,234 194,766 128.086% 249,468 81,794 79,219 0 161,013 138,990 70,607 68,384 788,609
12/31/18 19,950,000 398,250 78,250 125,234 194,766 128.086% 249,468 81,794 79,219 0 161,013 133,645 67,891 65,753 788,609
12/31/19 20,110,000 401,450 78250 126,486 196,714 128.086% 251,963 82,612 80,011 0 162,623 129,789 65,933 63,857 794,945
12/31/20 20,271,600 404,682 78,250 127,751 198,681 128.086% 254,482 83,438 80,811 0 164,249 126,046 64,031 62,015 801,344
12/31/21 20,434,816 407,946 78,250 129,028 200,668 128.086% 257,027 54,272 81,619 0 165,891 122,410 62,184 60,226 807,807
12/31/22 20,764,512 414,540 78,250 131,609 204,681 128.086% 262,167 55,958 83,251 0 169,209 120,056 60,988 59,068 820,864
12/31/23 21,100,803 421,266 78,250 134,241 208,775 128.086% 267,411 87,677 84,916 0 172,593 117,747 59,815 57,932 834,181
12/31/24 21,443,819 428,126 78,250 136,926 212,950 128.086% 272,759 89,431 56,615 0 176,045 115,482 58,665 56,818 847,765
$2,339,160 $758,771 $734,878 $0 $1,493,649 $1,148,715 $583,545 $565,172 $7,801,077
'Base value based on existing land and bulding value. Abated va/ue includes newestimated/and building of$12M PID:273990030 $1,500,000
"Fiscal dispanties contribution from incremental bui/ding growfh PID:274080060 $875,000 State C-I Tax Rate 52.52%
"'Final payable 2013 tax rate based on in(ormation provided by County(taxing code 2204 PID:274080070 $780,000
"*`Estimated f00%of annual revenues abated(or project PID:274080080 $795,000
2013 Existing Market Value $3,950,000
Public Sector Advisors