it is a real estate property valuation coursework. need calculation ability. I provide the excel which u should use the calculation method. and this is the resit coursework. I provided the last coursework feedback( answer/what the professor wants) please read it first. and also, I provide the resit coursework tips PDF, please read all files first, then start work.

the word limit first question is 1000 words, the second question is 2000 words.

question1:
‘The conventional method of valuing leaseholds is deeply flawed. A growth explicit model is the only
defensible approach.’
Critique this statement using examples to illustrate your answer.

question2:
An office property, Holborn Court, was constructed some 50 years ago on ground and 4 floors over. It is located in London WC1 and has reasonable connectivity (i.e. under 10 minutes’ walk) to public transport.
It has a total net lettable area as follows:
Ground floor: 300 square metres.
1st – 3rd floors: 350 square metres per floor.
4th floor: 200 square metres.

The property is in need of refurbishment. It is currently let on a full repairing lease at an historic rent passing of £250 per square metre to an insurance company on a full repairing lease with an unexpired term of 8 years; there is an upwards only rent review due in 3 years. When the lease was granted some 7 years ago it was agreed that there would be no rent review until year 10 in view of the condition of the building. At the date of grant, there was an EPC of E. The tenancy is not contracted out of the Landlord and Tenant Act 1954.
Using your knowledge of this area in relation to yields and rental values (backed up by evidence) and making relevant assumptions prepare a short report for a potential purchaser
as follows:
a) A market valuation using whatever method you consider appropriate.
b) An investment worth value advising as to a potential purchase offer price.

In preparing the report you should consider the likely impact of both the EPC rating and legislative position on value. Make all necessary and reasonable assumptions.