Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. can you please help me calculate a potential singl

Can you please help me calculate a potential single-tenant property investment using the DCF model...

80.2K

Verified Solution

Question

Finance

Can you please help me calculate a potential single-tenant property investment using the DCF model in Excel.

Please show calculations for 10 year holding period. STEP BY STEP

Data:

Initial Property value: $350,000

Operating income

Current monthly annual rent: $20,160 ($420 per week) ($1680 monthly rent)

Projected Annual rent Growth: 5%

Vacancy rate: 2.9%

Operating Expenses (Annual):

Property taxes: $1,800 per annum

Insurance costs: $1,200 per annum

Property Management fees: 6% of rental income

Maintenance and repair $1,500 per annum

Utilities: $2,200per annum

Capital Expenditures (Annual): Estimated CapEx: $2,000 (for regular upkeep and replacements)

Financing:

Loan Amount: $200,000

Interest Rate: 6.9%

Loan Term: 30 years

Closing Costs: $2,000

Market Assumptions:

Discount Rate: 8%

Terminal Cap Rate: 6%

Holding Period: 10 years

Property Sale Costs: 6% of the selling price

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Biology
1.2K views

A third haploid pink strain (strain # 3) of yeast is isolated and known to be...

Electrical Engineering
1.2K views

write sample code in VHDL Design and implementation of Pressetable ripple counter using behavioral style of...

Finance
1.2K views

1. In a debt service fund a. expenditures for interest are recognized as incurred b. fund transferred...

Biology
1.2K views

The stomach secretes one of the strongest acids known hydrochloric acid HCI a What is...

Biology
1.2K views

How does foraging improve an organism s overall fitness

Geometry
1.2K views

Question 1 Points 2 Find the measure of the side AB in the figure using...

Basic Math
1.2K views

Experimental or Observational: A group of students is interested in knowing if the number of...

Algebra
1.2K views

Erica was using the COMPLETING THE SQUARE method to solve the quadratic equation below 2x...

Algebra
1.2K views

5 Prove that the following statements are equivalent a P is a projective module b...

Accounting
1.2K views

i got the debit and credit values please help by making a journal entry for...

Accounting
1.2K views

Yesenia purchased a car for $22,241. She obtained a 6 year term loan at an...

Accounting
1.2K views

In February direct labor was 60% percent of conversion cost. If the manufacturing overhead cost...