Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sources of Cell Values Orange INPUTS Sheet Red Scenarios/Changes Blue: Copy from Base (Column) Yellow from BldgEnv White: Calculated TRCm EREP Quiz 2(b) Part 2
| Sources of Cell Values | Orange INPUTS Sheet | |||||||
| Red Scenarios/Changes | ||||||||
| Blue: Copy from Base (Column) | ||||||||
| Yellow from BldgEnv | ||||||||
| White: Calculated | ||||||||
| TRCm | ||||||||
| EREP Quiz 2(b) Part 2 | Change the Land $/SF, Building $, Builder's Profit %, Construction Interest Rate, LV Ratio | |||||||
| Component Size | Base Case | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | ||
| Bldg Envelope | Land | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | 55,000 | |
| Building | 26,462 | 26,462 | 26,462 | 26,462 | 26,462 | 26,462 | ||
| Parking | 42,340 | 42,340 | 42,340 | 42,340 | 42,340 | 42,340 | ||
| Open Space | 8,250 | 8,250 | 8,250 | 8,250 | 8,250 | 8,250 | ||
| Cost Schedule | ||||||||
| Land $/SF | 30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | ||
| Bldg $/SF | $160.00 | $$160.00 | $160.00 | $160.00 | $160.00 | $160.00 | ||
| Pkg $/SF | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | ||
| Land Imps | $1.80 | $1.80 | $1.80 | $1.80 | $1.80 | $1.80 | ||
| Other Imps | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | ||
| Known Fees | ||||||||
| General Requirements | 5.20% | 5.20% | 5.20% | 5.20% | 5.20% | 5.20% | ||
| Builder's Overhead | 2.20% | 2.20% | 2.20% | 2.20% | 2.20% | 2.20% | ||
| Builder's Profit | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | ||
| Architect's Design | 5.75% | 5.75% | 5.75% | 5.75% | 5.75% | 5.75% | ||
| Architect's Inspection | 2.00% | 2.00% | 2.00% | 2.00% | 2.00% | 2.00% | ||
| Bond Fee | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | ||
| Unknown Fin Costs | ||||||||
| Commitment Fee | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | ||
| Financing Fee | 2.00% | 2.00% | 2.00% | 2.00% | 2.00% | 2.00% | ||
| Inspection Fee | 0.60% | 0.60% | 0.60% | 0.60% | 0.60% | 0.60% | ||
| Const Fin Fees | ||||||||
| Const Rate | 5.50% | 5.50% | 5.50% | 5.50% | 5.50% | 5.50% | ||
| Const Term | 18 | 18 | 18 | 18 | 18 | 18 | ||
| Avg Bal | 65% | 65% | 65% | 65% | 65% | 65% | ||
| Unknown F-Fee% | 8.96% | 9% | 9% | 9% | 9% | 9% | ||
| LV Ratio | 80% | 80% | 80% | 80% | 80% | 80% | ||
| TRCm Components | Base Case | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | ||
| Total Land Costs | $1,650,000 | $1,650,000 | $1,650,000 | $1,650,000 | $1,650,000 | $1,650,000 | ||
| Total Const. Costs | $4,956,888 | $4,956,888 | $4,956,888 | $4,956,888 | $4,956,888 | $4,956,888 | ||
| Total Known Fees | $1,147,520 | $1,147,520 | $1,147,520 | $1,147,520 | $1,147,520 | $1,147,520 | ||
| Known Soft Costs | $ 104,800 | $ 104,800 | $ 104,800 | $ 104,800 | $ 104,800 | $ 104,800 | ||
| Unknown Fees | $758,786 | $758,786 | $758,786 | $758,786 | $758,786 | $758,786 | ||
| Total Replacement Cost Market | $8,466,236 | $8,466,236 | $8,466,236 | $8,466,236 | $8,466,236 | $8,466,236 | ||
| Fully Loaded Cost/Bsf | $319.94 | $319.94 | $319.94 | $319.94 | $319.94 | $319.94 | ||
| Question 2 | What did you learn from the Sensitivity Analysis? Change numbers with the checkmark cells and observe changes. Note, some inputs from INPUTS sheet, some from BldgEnv |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Strategic Marketing
Authors: Nigel Piercy and David Cravens
10th edition
78028906, 978-0078028908
