Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Financing Financial Instruments And Risk Management

Authors: Frank J Fabozzi, Carmel De Nahlik

1st Edition

9811231494, 9789811231490

More Books

Students also viewed these Finance questions