Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Property Assumptions: Purchase price: $27,500,000 Acquisition costs: $1,000,000 Property Type: Multi-Family Year one potential rental income: $3,505,512 Annual PGI growth rate: 1.75 percent Vacancy and

Property Assumptions:

  • Purchase price: $27,500,000
  • Acquisition costs: $1,000,000
  • Property Type: Multi-Family
  • Year one potential rental income: $3,505,512
  • Annual PGI growth rate: 1.75 percent
  • Vacancy and credit losses: 5.25 percent of rental income ONLY
  • Other income: $12,200
  • Other income annual growth rate: 1.25 percent
  • Operating expenses: 45% of EGI
  • Land/improvement allocation:
    • Land: 20 percent
    • Improvements: 80 percent
  • Disposition price: capitalize sixth year NOI at 5.50 percent to determine EOY five disposition price
  • Disposition cost of sale: 6 percent
  • Purchase in January and sell in December of respective years.

Financing Assumptions:

  • Loan amount: the loan will be the lesser of the amounts calculated using LTV ratio and DSCR
  • Maximum LTV ratio: 70 percent
  • Minimum DSCR: 1.30
  • Interest rate: 4.25 percent
  • Amortization period: 20 years
  • Loan term: 7 years
  • Payments per year: 12
  • Loan costs
    • Lenders discount points: 1.2 percent of loan amount
    • Third party cost: $75,000

Investor Assumptions:

  • Anticipated holding period: 5 years
    • Investors tax rates
    • Ordinary income: 37 percent
    • Capital gain from cost recovery taken: 25 percent
    • Capital gain from appreciation:20 percent
    • Weighted Cost of Capital: 11%

Provide a full financial model and analysis with Levered and Unlevered NPV, and IRR for Before, Levered After Tax of the same and Cash on Cash for Before Tax Levered and Unlevered (No need to provided unlevered After Tax NPV, IRR or Cash on Cash). Then state if this is a financially wise investment.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

South Western Federal Taxation 2015 Essentials Of Taxation Individuals And Business Entities

Authors: James Smith, William Raabe, David Maloney, James Young

18th Edition

9781285438290

Students also viewed these Finance questions