Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
