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<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8558,8557,8560,8561,8559],"tags":[8207,8206,8208,8211,8210,8209],"class_list":["post-46877","post","type-post","status-publish","format-standard","hentry","category-apa-citation-format-assignment-help-online","category-assignment-writers-australia-for-college-students","category-buy-essay-usa","category-uk-cheap-essay-writing-service","category-write-my-essay-fast-plagiarism-free-ai-writing-tool","tag-1-dissertation-writing-and-essay-services","tag-best-assignment-help-for-academic-papers","tag-cheap-essay-writing-with-online-tutoring","tag-dissertation-writing-and-write-my-essay-solutions","tag-online-assignment-help-and-paper-writing-services","tag-write-my-paper-fast-homework-assistance"],"_links":{"self":[{"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/posts\/46877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/comments?post=46877"}],"version-history":[{"count":0,"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/posts\/46877\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/media?parent=46877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/categories?post=46877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.colapapers.com\/us\/wp-json\/wp\/v2\/tags?post=46877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}