To answer this question you will need to construct a simple 10 year DCF in excel and calculate the NPVs and IRR for the following tenancy.Building A Is an industrial Warehouse with a Gross Lettable Area of 10,000m2 which was let on a ten year lease of which two years have expired. The face rent in the lease is $200/m2 and there is a fixed 4% per annum escalation of rent throughout the term. A terminal yield of 8% is considered appropriate. Current market rent for the property is $210/m2 and is predicted to grow at 2%pa. At the end of the current lease a new lease will be signed at the market rent with a 2% per annum escalation.You have just purchased the factory for $22million and have a target rate of return of 12%%. From your spreadsheet which of the following are the closest figures to your answer for NPV = $200,000$500,000$600,000$1,200,000$2,500,000$3,500,000101314151820 with an IRR of $200,000$500,000$600,000$1,200,000$2,500,000$3,500,000101314151820%.May i please have the excel sheet attached. Thank you

Published by
Essays Scribe
View all posts