accounting problem dovetown parking to. be solved in excel

profileankitd09
DovetownParking.xlsx
Home>Business & Finance homework help>Accounting homework help>accounting problem dovetown parking to. be solved in excel

Assumptions

Assumptions on Building the Garage
Multi-level parking capacity 850
Increased Revenue from Sales Tax $ 11,000.00
Revenue From Retail Rent $ 230,000.00
Project Lifetime 15
Cost of Construction $ 8,500,000.00
Cost of Site Demolition and Cleanup $ 1,200,000.00
Assumptions on selling the site
Sale Amount of Elm Streem Site $ 6,000,000.00
Yearly Revenue of Property Tax $ 280,000.00
Assumptions on Discount Rate
Discount Rate for Developer
Discount Rate for City
Assumptions of Parking Usage
Parking Usage by Weekdays all-day parkers 80%
Parking Usage on Saturday Days 80%
Parking Usage on Sunday Days 70%
Parking Usage by Weekdays short-stay parkers After working Hours 100%
Parking Usage by Saturday Evening 100%
Assumptions for transportation to CBD
Passenger per Car 1.50
Percent of lost subway ridership 67%
Average Subway Fare $ 2.20
Other Assumptions
City Sales Tax 3.50%
Net Present Value (NPV) of Building Garage
Net Present Value (NPV) of Selling Site $ - 0
IRR 0.00%
BCR - 0
Parking Usage by Weekdays all-day parkers
$0.00 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80%
Parking Usage by Weekdays short-stay parkers After working Hours 30%
35%
40%
45%
50%
55%
60%
65%
70%
75%
80%
85%
90%
95%
100%
Discount Rate for City
$0.00 10% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.5% 3.0% 2.5%
Discount Rate for Developer 20%
19%
18%
17%
16%
15%
14%
13%
12%
11%
10%
9%
8%
7%
6%
5%
$0.00 $0.00 $0.00
Project Lifetime 10 Increased Revenue from Sales Tax $ 10,000.00 Percent of lost subway ridership 70%
11 $ 9,000.00 65%
12 $ 8,000.00 60%
13 $ 7,000.00 55%
14 $ 6,000.00 50%
15 $ 5,000.00 45%
16 $ 4,000.00 40%
17 $ 3,000.00 35%
18 $ 2,000.00 30%
19 $ 1,000.00 25%
20 $ - 0 20%

NPV

REVENUES Number of Spaces % of Use Average Hours per Car Average Rate Hours Total Hours Turnover Cars per Day Revenue per Day Days in a Year Annual Financial Amount
Revenues from Parking Fees 850
Weekdays all-day parkers
Weekdays short-stay parkers During working Hours
Weekdays short-stay parkers After working Hours
Saturday Days
Saturday Evening
Sundays
Total revenues from parking fees $ - 0
Other Sources of Revenue Increased Revenue from Sales Tax City Sales Tax
Revenue from Increased Sales Tax
Revenue From Retail Rent
Total Revenue $ - 0
EXPENSES
Garage Operating Cost
Management Fee
Revenue Sharing with Management Firm
Total Paid to the Management Firm $ - 0
Loss Due to Mass Transit Cars per Day Days in a Year Total Cars Passenter per Car Total Persons Percent of lost subway ridership Average Subway Fare
Weekdays all-day parkers
Weekdays short-stay parkers During working Hours
Weekdays short-stay parkers After working Hours
Saturday Days
Saturday Evening
Sundays
Total Loss Due to Mass Transit $ - 0
Total Expense $ - 0
OPERATING INCOME $ - 0
Operating Income During Project Lifetime
Cost of Site Demolition and Cleanup
Cost of Construction
Net Present Value (NPV) of Building Garage $0.00
If City Sells Parking Site
Sale Amount of Elm Streem Site
Revenue of Increased Property Tax
Net Present Value (NPV) of Selling Site $ - 0

NPV Sensitivity Analysis

Min $ - 0
Max $ - 0
Parking Usage by Weekdays all-day parkers
NPV (Build) - NPV (Sell) 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80%
Parking Usage by Weekdays short-stay parkers After working Hours 30%
35%
40%
45%
50%
55%
60%
65%
70%
75%
80%
85%
90%
95%
100%
Min $ - 0
Max $ - 0
Discount Rate for City
NPV (Build) - NPV (Sell) 10% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.5% 3.0% 2.5%
Discount Rate for Developer 20%
19%
18%
17%
16%
15%
14%
13%
12%
11%
10%
9%
8%
7%
6%
5%
NPV (Build) - NPV (Sell) NPV (Build) - NPV (Sell) NPV (Build) - NPV (Sell)
Project Lifetime 10 Increased Revenue from Sales Tax $ 10,000.00 Percent of lost subway ridership 70%
11 $ 9,000.00 65%
12 $ 8,000.00 60%
13 $ 7,000.00 55%
14 $ 6,000.00 50%
15 $ 5,000.00 45%
16 $ 4,000.00 40%
17 $ 3,000.00 35%
18 $ 2,000.00 30%
19 $ 1,000.00 25%
20 $ - 0 20%

NPV Half Utilization Scenario

Min $ - 0
Max $ - 0
Discount Rate for City
$0.00 10% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.5% 3.0% 2.5%
Discount Rate for Developer 20%
19%
18%
17%
16%
15%
14%
13%
12%
11%
10%
9%
8%
7%
6%
5%
$0.00 $0.00 $0.00
Project Lifetime 10 Increased Revenue from Sales Tax $ 10,000.00 Percent of lost subway ridership 70%
11 $ 9,000.00 65%
12 $ 8,000.00 60%
13 $ 7,000.00 55%
14 $ 6,000.00 50%
15 $ 5,000.00 45%
16 $ 4,000.00 40%
17 $ 3,000.00 35%
18 $ 2,000.00 30%
19 $ 1,000.00 25%
20 $ - 0 20%

IRR

Year
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Total revenues from parking fees
Total Other Sources of Revenue
Total Annual Revenue
Total Expenses Paid to the Management Firm
Total Loss Due to Mass Transit
Total Annual Expense
Cost of Site Demolition and Cleanup
Cost of Construction
Net Cash Flow
IRR
IRR in Half Utilization Scenario
Parking Usage by Weekdays all-day parkers
IRR 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80%
Parking Usage by Weekdays short-stay parkers After working Hours 30%
35%
40%
45%
50%
55%
60%
65%
70%
75%
80%
85%
90%
95%
100%
IRR IRR
Yearly Revenue of Property Tax $ 10,000.00 Percent of lost subway ridership 70%
$ 9,000.00 65%
$ 8,000.00 60%
$ 7,000.00 55%
$ 6,000.00 50%
$ 5,000.00 45%
$ 4,000.00 40%
$ 3,000.00 35%
$ 2,000.00 30%
$ 1,000.00 25%
$ - 0 20%

BCR

Total Annual Revenue
Total Annual Expenses
Total Initial Expense
PV of all benefits
PV of all Expenses
BCR
IRR in Half Utilization Scenario
Min $ - 0
Max $ - 0
Parking Usage by Weekdays all-day parkers
BCR 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80%
Parking Usage by Weekdays short-stay parkers After working Hours 30%
35%
40%
45%
50%
55%
60%
65%
70%
75%
80%
85%
90%
95%
100%
Min $ - 0
Max $ - 0
Discount Rate for City
BCR 10% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.5% 3.0% 2.5%
Discount Rate for Developer 20%
19%
18%
17%
16%
15%
14%
13%
12%
11%
10%
9%
8%
7%
6%
5%
BCR BCR BCR
Project Lifetime 10 Increased Revenue from Sales Tax $ 10,000.00 Percent of lost subway ridership 70%
11 $ 9,000.00 65%
12 $ 8,000.00 60%
13 $ 7,000.00 55%
14 $ 6,000.00 50%
15 $ 5,000.00 45%
16 $ 4,000.00 40%
17 $ 3,000.00 35%
18 $ 2,000.00 30%
19 $ 1,000.00 25%
20 $ - 0 20%