Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This chart is created for the commercial building that locates in Brisbane city. Can you spot any errors? Physical Performance metrics Sensitivities - Levered IRR
This chart is created for the commercial building that locates in Brisbane city. Can you spot any errors?
Physical | Performance metrics | Sensitivities - Levered IRR | Sensitivities - Equity Multiple | ||||||||||||||||||||||||||
Gross internal area | 18,362 | Unlevered | Levered | ||||||||||||||||||||||||||
Net internal area | 18,360 | IRR | -26.9% | -36.2% | |||||||||||||||||||||||||
Gross-to-net ratio | 100% | Equity multiple | 0.33 | 0.18 | Purchase Price | Purchase Price | |||||||||||||||||||||||
Equity invested | 228,018,000 | 220,109,362 | -36.2% | 18,325,892 | 18,425,892 | 18,525,892 | 18,625,892 | 18,725,892 | 0.18 | 18,325,892 | 18,425,892 | 18,525,892 | 18,625,892 | 18,725,892 | |||||||||||||||
Profit | (153,786,180) | (179,532,999) | Exit Yield | 4.50% | -17.1% | -17.1% | -17.1% | -17.1% | -17.1% | Exit Yield | 4.50% | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | |||||||||||||
Acquisitions | 4.75% | -17.1% | -17.1% | -17.1% | -17.1% | -17.1% | 4.75% | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | |||||||||||||||||
5.00% | -17.1% | -17.1% | -17.1% | -17.1% | -17.1% | 5.00% | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | ||||||||||||||||||
% | AUD | AUD psf NIA | Senior facility | 5.25% | -17.1% | -17.1% | -17.1% | -17.1% | -17.1% | 5.25% | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | ||||||||||||||
Purchase price | 210,000,000 | 11,438 | Facility amount | 60% | 5.50% | -17.1% | -17.1% | -17.1% | -17.1% | -17.1% | 5.50% | 0.53 | 0.53 | 0.53 | 0.53 | 0.53 | |||||||||||||
SDLT | 5.75% | 12,075,000 | 658 | Actual amount drawn | 136,810,800 | ||||||||||||||||||||||||
Legal advice | 0.75% | 1,575,000 | 86 | ||||||||||||||||||||||||||
Acquisition | 1.25% | 2,625,000 | 143 | Term | 20 | years | |||||||||||||||||||||||
Surveys | 0.36% | 756,000 | 41 | Drawdown date | 12/31/2023 | ||||||||||||||||||||||||
Tax & Structuring | 0.45% | 945,000 | 51 | Maturity | 12/31/2043 | LTV | LTV | ||||||||||||||||||||||
Valuation | 0.02% | 42,000 | 2 | -36.2% | 70% | 65% | 60% | 55% | 50% | 0.18 | 70% | 65% | 60% | 55% | 50% | ||||||||||||||
Total acquisition costs | 8.58% | 228,018,000 | 12,419 | Margin | 4.00% | p.a. | Marign | 2.50% | -31.5% | -31.8% | -32.1% | -32.4% | -32.6% | Margin | 2.50% | 0.25 | 0.24 | 0.24 | 0.24 | 0.23 | |||||||||
Base rate | 0.10% | p.a. | 2.75% | -32.3% | -32.5% | -32.7% | -32.9% | -33.1% | 2.75% | 0.24 | 0.23 | 0.23 | 0.23 | 0.23 | |||||||||||||||
Purchase date | 12/31/2023 | All in rate | 4.10% | p.a. | 3.00% | -33.1% | -33.3% | -33.4% | -33.5% | -33.6% | 3.00% | 0.23 | 0.22 | 0.22 | 0.22 | 0.22 | |||||||||||||
Yield on cost | Current interest rate | 4.10% | p.a. | 3.25% | -34.0% | -34.0% | -34.1% | -34.1% | -34.1% | 3.25% | 0.21 | 0.21 | 0.21 | 0.21 | 0.21 | ||||||||||||||
Net initial yield | 5.43% | 3.50% | -34.9% | -34.8% | -34.8% | -34.7% | -34.6% | 3.50% | 0.20 | 0.20 | 0.20 | 0.20 | 0.20 | ||||||||||||||||
Borrower legal costs | 126,000,000 | ||||||||||||||||||||||||||||
Lender legal costs | 850,000 | ||||||||||||||||||||||||||||
Operations | Arrangement fee | 1.50% | |||||||||||||||||||||||||||
Rental income | 12,371,970 | Exit fee | 2.00% | ||||||||||||||||||||||||||
Exit | |||||||||||||||||||||||||||||
Hold period | 20 | years | |||||||||||||||||||||||||||
Sales date | 12/31/2043 | ||||||||||||||||||||||||||||
Exit yield | 6.10% | ||||||||||||||||||||||||||||
Purchasers costs | 7.00% | ||||||||||||||||||||||||||||
Sales costs | 7.00% | ||||||||||||||||||||||||||||
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