πŸŽ“ First order? Get 25% OFF β€” use code BISHOPS at checkout  |  πŸ’¬ Chat on WhatsApp

To answer this question you will need to construct a simple 10 year DCF

πŸ“… February 26, 2025 ✍️ Writers Research ⏱ 1 min read

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

Our Key Guarantees

  • βœ“ 100% Plagiarism-Free
  • βœ“ On-Time Delivery
  • βœ“ Student-Friendly Pricing
  • βœ“ Human-Written Papers
  • βœ“ Free Revisions (14 days)
  • βœ“ 24/7 Live Support

Frequently Asked Questions About Our Essay Writing Service