Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Using a spreadsheet. House Location: 7 Embarcadero #119 Purchase price: $399,000 Estimated Rental Rates: $2,274/month Along with the purchase price and estimated rental rates,

Please Using a spreadsheet.

House Location: 7 Embarcadero #119

Purchase price: $399,000

Estimated Rental Rates: $2,274/month

Along with the purchase price and estimated rental rates, please use the following assumptions for the purposes of your analysis:

  • Closing costs = 1% of purchase price
  • Interest Rate = 4%, 80% LTV, 30yr fully amortized
  • Home Price Appreciation = 5%
  • Annual Rent Increase = 4%
  • Homeowners Insurance = $1,000/yr (increases 4% each year)
  • Property Taxes = 1.2% of purchase price (increases 2% each year)
  • Water, Sewer, Garbage = $80/mo (increases 5% each year)
  • Annual Maintenance = $2,000 (increases 4% each year)
  • Depreciation: Tax Life = 27.5 years
  • Depreciation: Building = 80% of Total House Price
  • Marginal Tax Bracket = 40%
  • Capital Gains Tax Rate = 25%

  1. Shows a First Year Operating Projection, 10 Year Operating Projection, Sales Analysis After 10 Years and Rate of Return Analysis After 10 Yearsin the Spreadsheet.
  2. Once you have completed your spreadsheet and have found your IRR, play around with the variables for Appreciation, Annual Rent Increase and Interest Rate on the loan. Changing each of these variables up or down by 1%, which one makes the biggest impact on IRR?

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

Energy, Trade And Finance In Asia A Political And Economic Analysis

Authors: Justin Dargin, Tai Wei Lim

1st Edition

1317322711, 9781317322719

More Books

Students also viewed these Economics questions

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago

Question

Engage everyone in the dialogue

Answered: 1 week ago