Reading the chart give a financial summary Team Information Team Name Team Number Location Footprint and Use Allocation Check Is any block overbuilt? Yes/No Are existing buildings overallocated? Yes/No Affordable Housing Creation Townhouses (Moderate Income) Podium Apartments (Low Income) Rehab (Very Low Income) Luxury Condos Total Affordable Housing Units Market-Rate Residential Phoenix Hotel York Dry Goods Victorian Row Townhouses Podium Apartments Luxury Condos Office Phoenix Hotel York Dry Goods Victorian Row Low-Rise Office Mid-Rise Office Retail Phoenix Hotel York Dry Goods Victorian Row Mid-Rise Office 2 Podium Apartments 2 Luxury Condos 2 Neighborhood Retail Supermarket Q-Mart Community Facilities York Dry Goods Branch Library (7,500 SF) Community Art Space (2,500 SF) Community Space with Resilience Hub (7,000 SF) Day Care Center (3,500 SF) Drug Treatment Center (1,500 SF) Police Sub-Station (1,500 SF) Public Health Clinic (5,000 SF) Senior Center (6,000 SF) Small Business Incubator (4,000 SF) Teen Center (5,000 SF) Yorktown Bike Share (5,500 SF) Artist Studios (10,000 SF) University Classrooms (15,000 SF) Victorian Row Artists Studios (10,000 SF) University Classroom (15,000 SF) Total Community Facilities Name Number Location No No Total Units 24 24 Total Units/SF Total Units Total SF 56 5,000 13,000 Total SF 135,000 120,000 80,000 7,500 7,000 3,500 1,500 10,000 In Neigh. Ret 5,000 In Neigh. Ret -In Neigh. Ret 5,000 Neigh. Ret 5,000 In Neigh. Ret. 5,000 Neigh Ret 35,000 1,500 5,000 0% 20% 0% 0% 10% 4,000 Years to Absorb 30,000 in Podium In Podium in Podium 1 1.32 1.60 Rent Paying SF Rent Free SF In Low Rise In Low Rise In Low Rise 1.91 1.71 2.95 2.67 a proposal that is profitable enough to attract the investor capital required to build your high-risk project and generat- sufficient tax revenues to pay back the city's contributi Developer Return Summary Market Value Costs/Subsidies: -Construction Costs -Land Payment -Absorption Penalty +City Construction Cost Subsidy -Net Zero Building Cost -Shelter: Relocation Fee Total Costs/Subsidies Developer Net Profit Rate of Return City Revenue Summary City Revenue +City Tax Revenue (10-Year) -City Operating Costs (10-Year) +Sale of Land to Developer -Cost of Land Acquisition -City Construction Cost Subsidy City Net Revenue City Fee Summary Fee to City for relocating shelter Open Space Park/Plaza Sports Courts Skate Park Total Open Space Net Zero Buildings Fee Jobs Creation Summary Job Creation Part-Time Entry Level Full-Time Entry Level Mid-Paying High-Paying Total Jobs Total Housing Summary Market-Rate Housing Creation Affordable Housing Creation Total Housing Units Jobs to Housing Ratio Total Number of Jobs Total Number of Housing Units Ratio (Jobs to Housing) Parking Surface Structured Subterranean Total SF 40,000 20,000 60,000 Units 220 24 $ 297,821,000 $(242,715,000) (20,000,000) 244 5,333,000 (1,092,218) $(258,474,218) $ 39,346,783 15% $ $ 23,890,000 (5,689,000) 20,000,000 (25,000,000) (5.333,000) $ 7,868,000 15.2% % of Site Area 1,092,218 % 0% 4% 12% #of Jobs 309 559 529 98 1,495 90% 10% 100% 1,495 244 6 to 1 Stalls 132 705 393 1,230

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter19: Variable Costing (varcost)
Section: Chapter Questions
Problem 5R: Click the Chart sheet tab. This chart is based on the problem data and the two income statements....
icon
Related questions
Question
Financial Statements (Financial Analyst)
Reading the chart give a
financial summary
Team Information
Team Name
Team Number
Location
Footprint and Use Allocation Check
Is any block overbuilt? Yes/No
Are existing buildings overallocated? Yes/No
Affordable Housing Creation
Townhouses (Moderate Income)
Podium Apartments (Low Income)
Rehab (Very Low Income)
Luxury Condos
Total Affordable Housing Units
Market-Rate Residential
Phoenix Hotel
York Dry Goods
Victorian Row
Townhouses
Podium Apartments
Luxury Condos
Office
Phoenix Hotel
York Dry Goods
Victorian Row
Low-Rise Office
Mid-Rise Office
Retail
Phoenix Hotel
York Dry Goods
Victorian Row
Mid-Rise Office 2
Podium Apartments 2
Luxury Condos 2
Neighborhood Retall
Supermarket
Q-Mart
Community Facilities
York Dry Goods
Branch Library (7,500 SF)
Community Art Space (2,500 SF)
Community Space with Resilience Hub (7,000 SF)
Day Care Center (3,500 SF)
Drug Treatment Center (1,500 SF)
Police Sub-Station (1,500 SF)
Public Health Clinic (5,000 SF)
Senior Center (6,000 SF)
Small Business Incubator (4,000 SF)
Teen Center (5,000 SF)
Yorktown Bike Share (5,500 SF)
Artist Studios (10,000 SF)
University Classrooms (15,000 SF)
Victorian Row
Artists Studios (10,000 SF)
University Classroom (15,000 SF)
Total Community Facilities
Name
Number
Location
No
No
Total Units
24
Total Units/SF
Total SF
24
Total Units
Total SF
36
32
96
56
5,000
13,000
135,000
120,000
80,000
7,500
7,000
3,500
1,500
10,000 In Neigh. Ret
5,000 In Neigh. Ret
In Neigh. Ret.
5,000 In Neigh. Ret.
5,000 In Neigh. Ret.
5,000 In Neigh. Ret.
35,000
2.95
1,500
5,000
0%
20%
0%
0%
10%
4,000
Years to
Absorb
30,000
In Podium
In Podium
In Podium
Rent Paying SF Rent Free SF
1
1.32
1.60
In Low Rise
In Low Rise
In Low Rise
1.91
1.71
2.67
a proposal that is profitable enough to
attract the investor capital required to
build your high-risk project and generate
sufficient tax revenues to pay back the
city's contributi
Developer Return Summary
Market Value
Costs/Subsidies:
-Construction Costs
-Land Payment
-Absorption Penalty
+City Construction Cost Subsidy
-Net Zero Building Cost
-Shelter: Relocation Fee
Total Costs/Subsidies
Developer Net Profit
Rate of Return
City Revenue Summary
City Revenue
+City Tax Revenue (10-Year)
-City Operating Costs (10-Year)
+Sale of Land to Developer
-Cost of Land Acquisition
-City Construction Cost Subsidy
City Net Revenue
City Fee Summary
Fee to City for relocating shelter
Open Space
Park/Plaza
Sports Courts
Skate Park
Total Open Space
Net Zero Buildings
Fee
Jobs Creation Summary
Job Creation
Part-Time Entry Level
Full-Time Entry Level
Mid-Paying
High-Paying
Total Jobs
Total Housing Summary
Market-Rate Housing Creation
Affordable Housing Creation
Total Housing Units
Jobs to Housing Ratio
Total Number of Jobs
Total Number of Housing Units
Ratio (Jobs to Housing)
Parking
Surface
Structured
Subterranean
Total
40,000
20,000
60,000
Units
220
24
$ 297,821,000
$(242,715,000)
(20,000,000)
244
5,333,000
(1,092,218)
$(258,474,218)
$ 39,346,783
15.2%
15% $
$ 23,890,000
(5,689,000)
20,000,000
(25,000,000)
(5,333,000)
$ 7,868,000
% of Site Area
8%
0%
4%
12%
1,092,218
# of Jobs
%
309
559
529
98
1,495
90%
10%
100%
1,495
244
6 to 1
Stalls
132
705
393
1,230
Transcribed Image Text:Financial Statements (Financial Analyst) Reading the chart give a financial summary Team Information Team Name Team Number Location Footprint and Use Allocation Check Is any block overbuilt? Yes/No Are existing buildings overallocated? Yes/No Affordable Housing Creation Townhouses (Moderate Income) Podium Apartments (Low Income) Rehab (Very Low Income) Luxury Condos Total Affordable Housing Units Market-Rate Residential Phoenix Hotel York Dry Goods Victorian Row Townhouses Podium Apartments Luxury Condos Office Phoenix Hotel York Dry Goods Victorian Row Low-Rise Office Mid-Rise Office Retail Phoenix Hotel York Dry Goods Victorian Row Mid-Rise Office 2 Podium Apartments 2 Luxury Condos 2 Neighborhood Retall Supermarket Q-Mart Community Facilities York Dry Goods Branch Library (7,500 SF) Community Art Space (2,500 SF) Community Space with Resilience Hub (7,000 SF) Day Care Center (3,500 SF) Drug Treatment Center (1,500 SF) Police Sub-Station (1,500 SF) Public Health Clinic (5,000 SF) Senior Center (6,000 SF) Small Business Incubator (4,000 SF) Teen Center (5,000 SF) Yorktown Bike Share (5,500 SF) Artist Studios (10,000 SF) University Classrooms (15,000 SF) Victorian Row Artists Studios (10,000 SF) University Classroom (15,000 SF) Total Community Facilities Name Number Location No No Total Units 24 Total Units/SF Total SF 24 Total Units Total SF 36 32 96 56 5,000 13,000 135,000 120,000 80,000 7,500 7,000 3,500 1,500 10,000 In Neigh. Ret 5,000 In Neigh. Ret In Neigh. Ret. 5,000 In Neigh. Ret. 5,000 In Neigh. Ret. 5,000 In Neigh. Ret. 35,000 2.95 1,500 5,000 0% 20% 0% 0% 10% 4,000 Years to Absorb 30,000 In Podium In Podium In Podium Rent Paying SF Rent Free SF 1 1.32 1.60 In Low Rise In Low Rise In Low Rise 1.91 1.71 2.67 a proposal that is profitable enough to attract the investor capital required to build your high-risk project and generate sufficient tax revenues to pay back the city's contributi Developer Return Summary Market Value Costs/Subsidies: -Construction Costs -Land Payment -Absorption Penalty +City Construction Cost Subsidy -Net Zero Building Cost -Shelter: Relocation Fee Total Costs/Subsidies Developer Net Profit Rate of Return City Revenue Summary City Revenue +City Tax Revenue (10-Year) -City Operating Costs (10-Year) +Sale of Land to Developer -Cost of Land Acquisition -City Construction Cost Subsidy City Net Revenue City Fee Summary Fee to City for relocating shelter Open Space Park/Plaza Sports Courts Skate Park Total Open Space Net Zero Buildings Fee Jobs Creation Summary Job Creation Part-Time Entry Level Full-Time Entry Level Mid-Paying High-Paying Total Jobs Total Housing Summary Market-Rate Housing Creation Affordable Housing Creation Total Housing Units Jobs to Housing Ratio Total Number of Jobs Total Number of Housing Units Ratio (Jobs to Housing) Parking Surface Structured Subterranean Total 40,000 20,000 60,000 Units 220 24 $ 297,821,000 $(242,715,000) (20,000,000) 244 5,333,000 (1,092,218) $(258,474,218) $ 39,346,783 15.2% 15% $ $ 23,890,000 (5,689,000) 20,000,000 (25,000,000) (5,333,000) $ 7,868,000 % of Site Area 8% 0% 4% 12% 1,092,218 # of Jobs % 309 559 529 98 1,495 90% 10% 100% 1,495 244 6 to 1 Stalls 132 705 393 1,230
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning