Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please show me how to do a DCF for the following problem? All the information and assumptions you need are provided below Thank

Can someone please show me how to do a DCF for the following problem? All the information and assumptions you need are provided below Thank You! Best answer gets a Thumbs up!

image text in transcribed

Retail Homework Summer Place Retail Mall - Number of tenants:32 Price = $58 million Rentable area 245,000 sq ft Common area: 80,000 sq ft Base rent: $16 per sq ft of rentable area Overage rents for 6 tenants: 35,000 sq ft @$8.00 per sq ft CAM and other expenses recoverable: $4.65 per sq ft of rentable area Vacancy 5% of rentable area base rent; Concessions/Default: 1% Operating Expense: Utilities: 584,700.00 Mgmt/admin/overhead expenses: 340,000.00 Property Taxes: 1,000,000.00 Insurance 66,000.00 Other: 35,000.00 Recurring ST repairs allowance: 160,000.00 . DCF Assumptions 5 year horizon increase base rent by 50 cents/sq ft per year increase overage rent by 50 cents/sqft per year increase CAM roverable by 3% per year Vacancy and default stays the same rate OPEX wil go up by 3% per year CAPEX expected year 3 for $500,000 Discount rate = 9% Terminal Cap rate = 5% Cost of Sale = 5%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Financial Intermediation And Banking

Authors: Anjan V. Thakor, Arnoud Boot

1st Edition

0444515585, 978-0444515582

More Books

Students also viewed these Finance questions