the housebuilder for the 120 homes (assume land is roughly 10% of the Total Purchase Price)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
the housebuilder for the 120 homes (assume land is roughly 10% of the Total Purchase Price) A range of inputs have been provided for you with some inputs left to populate at your discretion, please provide a very brief summary of your rationale for the values you input. If you have time, please run some sensitivity analysis to answer questions 1-3 below. A rod border indicates a calculation you need to provide: General Inputs Start & Acquisition Date Hold (years) Exit Date Construction Start Date 31/12/2023 5 years 31/12/2028 31/12/2023 Construction Handover Profile (Homes) Jun-24 Sep-24 Dec-24 Mar-25 Jun-25 Rental Underwrite & Plot Schedule No. of 2 Bedroom Homes No. of 3 Bedroom Homes No. of 4 Bedroom Homes Scheme Total 17 17 17 17 17 17 2 Bedroom Homes Day-1 ERV 950 18 3 Bedroom Homes Day-1 ERV 1,175 120 4 Bedroom Homes Day-1 ERV 1,300 Blended Average Rental Growth per annum 3.00% Construction Period (months) Construction End Date 24 months 31/12/2025 Sep-25 Dec-25 Total Handovers Land Purchase Price (EMM) 2,900 -10% from asking price Construction Cost Construction Handover Profile (E) Total Purchase Price 2,900 SDLT Site Specific Legal Cost Quantity Surveyor Cost Date Dec-23 Land 2,900 Construction Total 2,900 Mar-24 Jun-24 Gross Development Cost 2,900 Gross Yield on Cost on Entry Sep 24 Dec-24 Net Yield on Cost on Eatry Mar-25 Average Property Cost on Entry Jun 25 Net Yield at Exit Sep-25 4.25% Dec-25 Purchaser's Costs 6.80% Total Seller's Costs 1.50% Average Property Cost at Exit Asset Management Fee (NOI) 2,900 2,900 Operational Expenditure (% of Gross Rent per annum) Lettings & Management Fees 9.00% Maintenance Fees 7.50% Insurance Void & Bad Debt Total Operational Expenditure 1.50% 3.00% 21.00% Acquisition For Corporate Income Tax Capital Gains Tax IRR Profit Multiple 1. What would be the impact on the offer price if the exit yield was 4.50% instead of 4.25% to achieve a 10% retum? 2. What would be the impact on the offer price if rental growth per annum was 4.00% instead of 3.00% to achieve a 10% retum? 3. What would be the impact on returns if the scheme was only held for 4 years instead of 5? the housebuilder for the 120 homes (assume land is roughly 10% of the Total Purchase Price) A range of inputs have been provided for you with some inputs left to populate at your discretion, please provide a very brief summary of your rationale for the values you input. If you have time, please run some sensitivity analysis to answer questions 1-3 below. A rod border indicates a calculation you need to provide: General Inputs Start & Acquisition Date Hold (years) Exit Date Construction Start Date 31/12/2023 5 years 31/12/2028 31/12/2023 Construction Handover Profile (Homes) Jun-24 Sep-24 Dec-24 Mar-25 Jun-25 Rental Underwrite & Plot Schedule No. of 2 Bedroom Homes No. of 3 Bedroom Homes No. of 4 Bedroom Homes Scheme Total 17 17 17 17 17 17 2 Bedroom Homes Day-1 ERV 950 18 3 Bedroom Homes Day-1 ERV 1,175 120 4 Bedroom Homes Day-1 ERV 1,300 Blended Average Rental Growth per annum 3.00% Construction Period (months) Construction End Date 24 months 31/12/2025 Sep-25 Dec-25 Total Handovers Land Purchase Price (EMM) 2,900 -10% from asking price Construction Cost Construction Handover Profile (E) Total Purchase Price 2,900 SDLT Site Specific Legal Cost Quantity Surveyor Cost Date Dec-23 Land 2,900 Construction Total 2,900 Mar-24 Jun-24 Gross Development Cost 2,900 Gross Yield on Cost on Entry Sep 24 Dec-24 Net Yield on Cost on Eatry Mar-25 Average Property Cost on Entry Jun 25 Net Yield at Exit Sep-25 4.25% Dec-25 Purchaser's Costs 6.80% Total Seller's Costs 1.50% Average Property Cost at Exit Asset Management Fee (NOI) 2,900 2,900 Operational Expenditure (% of Gross Rent per annum) Lettings & Management Fees 9.00% Maintenance Fees 7.50% Insurance Void & Bad Debt Total Operational Expenditure 1.50% 3.00% 21.00% Acquisition For Corporate Income Tax Capital Gains Tax IRR Profit Multiple 1. What would be the impact on the offer price if the exit yield was 4.50% instead of 4.25% to achieve a 10% retum? 2. What would be the impact on the offer price if rental growth per annum was 4.00% instead of 3.00% to achieve a 10% retum? 3. What would be the impact on returns if the scheme was only held for 4 years instead of 5?
Expert Answer:
Answer rating: 100% (QA)
1 If the exit yield was 450 instead of 425 the offer price would decrease to achieve a 10 return Thi... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Use the formula A= P(1+) to find the total amount of money accumulated for an initial investment $600 at 8% compounded semiannually after 7 years. Round to the nearest cent (in dollars and cents)....
-
You are the public relations director for a company that recently announced its decision to close its factory in the United States and outsource the work to manufacturers in Asia and Latin America....
-
The equilibrium fraction of lattice sites that are vacant in silver (Ag) at 700 o C is 2 10 -6 . Calculate the number of vacancies (per meter cubed) at 700oC. Assume a density of 10.35 g/cm3 for Ag?
-
Fill in the Blanks. Numerical methods are to be used when the equations of motion cannot be solved in ____________ form.
-
Flight Caf is a company that prepares in-flight meals for airlines in its kitchen located next to the local airport. The companys planning budget for July appears below: In July, 17,800 meals were...
-
Activity 1: The Components of a Vector Rx = Ax+ Bx Open the Vector Addition simulation (https://phet.colorado.edu/en/simulation/vector-addition) and select the Explore 2D screen. The a few minutes to...
-
Throughout the course, you will be working on a Wealth Management Analyst Project For this project, imagine you are a new hire at a wealth management firm and tasked with determining the location of...
-
5 ways that it could infuse Diversity and Inclusion into Your Organization. For this assignment, I am looking for you to provide original strategies that could be implemented within your organization...
-
Use block diagram reduction rules to find C(s) for the system shown in Fig. D3.5. R(s) G (s) R(s) + H(s) + + R4(s) R(s) G (s) H(s) C(s)
-
Investigate stability of unity feedback system whose open-loop transfer function is Ans. Stable for \(\mathrm{T} <1\) \[ \mathrm{G}(s)=\frac{e^{-s \mathrm{~T}}}{s(s+1)} \]
-
For signal flow graph shown below, the transmittance between \(x_{2}\) and \(x_{1}\) is (a) \(\frac{r s u}{1-s t}+\frac{e f h}{1-f g}\) (b) \(\frac{r s u}{1-f g}+\frac{e f h}{1-s t}\) (c) \(\frac{e f...
-
If the open-loop transfer function is a ratio of a numerator polynomial of a degree ' \(m\) ' and a denominator polynomial of a degree ' \(n\) ', then the integer \((n-m)\) represents the number of:...
-
The signal flow graph of system is shown below. In this graph, the number of three non-touching loops is (a) zero (b) 1 (c) 2 (d) 3. R(s) -O C(s)
-
Strong, moderate, and weak nucleophiles can be categorized as follows: A strong nucleophile contains more unsaturation, such as a double bond or triple bond, or it may be a cyclic structure. Strong...
-
Establish identity. cos( + k) = (-1)k cos , k any integer
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19-year-old nanny $125 per week for 48 weeks during the current year. a. What is the employer's portion...
-
Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...
-
In 2012, Lou has a salary of $54,000 from her job. She also has interest income of $1,700. Lou is single and has no dependents. During the year, Lou sold silver coins held as an investment for a...
-
Determine the displacement of point \(C\). The beam is made from A992 steel and has a moment of inertia of \(I=53.8 \mathrm{in}^{4}\). 8 kip A B -5 ft- -10 ft 5 ft-
-
Determine the slope at \(B\). The beam is made from A992 steel and has a moment of inertia of \(I=53.8 \mathrm{in}^{4}\). 8 kip A B -5 ft- 10 ft- -5 ft-
-
Determine the displacement at point \(D\). The A992 steel beam has a moment of inertia of \(I=125\left(10^{6} ight) \mathrm{mm}^{4}\). 18 kNm A 4m- D B3m 3m 41 4 m- 18 kNm
Study smarter with the SolutionInn App