Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Questions 13-30will use the assumptions as explained below: Purchase $45,000,000 Office space - Max 60% LTV loan DSCR requirement: 1.3 - Debt Yield Ratio must

Questions 13-30will use the assumptions as explained below:

Purchase $45,000,000 Office space - Max 60% LTV loan

DSCR requirement: 1.3 - Debt Yield Ratio must be above 10%

PGI: 15% of acquisition price. Increases at 2% a year for entire hold period

Vacancy: 18% and decreases to 10% yr 2-5

CAPEX: 7% for entire hold period

OPEX: 35% of EGI

WACC: 9.5% - Reinvestment Rate: 13%

Mortgage Rate: 5.25% 5/1 ARM - Mortgage Term: 20 yr.

Closing costs: 2% of L/A- Future Selling costs: 4%

Going in Market Cap rate is 6.48. Going out CAP rate is 6.48

5 Year Hold - Tax rate 20%

Investor requires a Before Tax IRR of 19%


What is the Before TaxIRR?


What is the DSCR?

What is the loan balance after 60months?

What is the projected future sales price in year 5?

 






Step by Step Solution

There are 3 Steps involved in it

Step: 1

a Before Tax IRR To calculate the Before Tax IRR we need to look at the cash flows over the 5year ho... 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

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Finance questions

Question

a. Find VU.

Answered: 1 week ago