Comparison and Sensitivity: Ranking Options and Testing Exit Yields
This lesson is part of the course
In this lesson
You compare three fictional investment options by initial yield and IRR rank with RANK.EQ, build a two-way sensitivity of exit value to income and exit yield, and chart the IRRs for the committee.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Building Basics: Gross vs Lettable Area, Office Share and Site Coverage Locked
- Clear Height and Storage Capacity: Racking Levels and Pallet Positions Locked
- Docks and Yard: Dock Ratios, Trailer Parking and Benchmark Checks Locked
- Rent Metrics: per m², per Pallet Position and per m³ Locked
- Lease Income: Capped and Collared Indexation and Recoverable Costs Locked
- Development Yield on Cost: Total Cost, Rent and the Margin over Market Locked
- Hold-Period Cash Flows: Exit Value and IRR over Seven Years Locked
- Comparison and Sensitivity: Ranking Options and Testing Exit Yields Locked