Sources of Cell Values Orange INPUTS Sheet Red Scenarios/Changes Blue: Copy from Base (Column) Yellow from BldgEnv
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
Posted Date: