Question: 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

1 Expert Approved Answer
Step: 1 Unlock

a Before Tax IRR To calculate the Before Tax IRR we need to look at the cash flows over the 5year ho... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Q:

Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...

Q:

Scenario: Purchase of Office Space in Alabama: Investor requires a 18% Before Tax IRR $15,000,000 total cost of project. 70% LTV PGI: Price per square foot = $6 annually. 50k Square feet Vacancy: 25%...

Q:

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:...

Q:

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:...

Q:

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:...

Q:

QUESTION 11 Calculate the Gross Sale Price assuming a property is sold at the end of year five if the following information is known: Year 1 NOI = $102,500, Year 6 NOI = $134,500, Going in cap rate =...

Q:

QUESTION 10 To overcome the potential shortcomings of single-year decision making metrics, many investors in real estate also perform multiyear discounted cash flow (DCF) valuation. DCF valuation...

Q:

Questions 13-25 will use the assumptions as explained below. In this scenario, the acquisition price of a hotel in NYC is $600,000,000. The LTV is 70%. The closing costs to acquire the property are...

Q:

From the case study, create an argument for the use of principles-based accounting for leases over rules-based accounting under GAAP, based on the financial statement restatements in the restaurant...

Q:

During the summer vacation, Julie's daughter Sarah attends a school camp and is left in a vegetative state after she goes for a swim during a period when the children were left unattended while the...

Q:

What is the purpose of testing whether 1 = 0? If we reject 1 = 0, does it imply a good fit?

Q:

When addressing any significant risk related to inventories, auditors _ _ _ _ _ _ . Multiple select question. may not rely solely on analytical procedures to address the risk may rely on evidence...

Q:

Springfield Companys master budget includes estimated costs and expenses of $325,000 for its third quarter of operations. Of this amount, $300,000 is expected to be financed with current payables....

Q:

The completed financial statement columns of the worksheet for Fleming Company are shown below. Instructions (a) Prepare an income statement, an owners equity statement, and a classified balance...

Q:

Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy:...

Q:

Diane Bernick has opened Bernicks Consulting. Journalize the following transactions that occurred during January of the current year. Use the following journal pages: January 110, page 1, and January...

Q:

SkyChefs, Inc., prepares in-flight meals for a number of major airlines. One of the companys products is grilled salmon in dill sauce with baby new potatoes and spring vegetables. During the most...

Q:

A previously developed item of supply used exclusively for the government purposes is what type of item? a. Nondevelopmental Item (NDI). b. Commercial-off-the Shelf (COTS) item. c. Developmental Item...

Q:

Using the following key, identify the effects of the following transactions or conditions on the various financial statement elements: I = increases; D = decreases; NE = no effect. Note that the...

Q:

Explain the theory behind the free cash flows valuation approach. Why are free cash flows value-relevant to common equity shareholders when they are not cash flows to those shareholders, but rather...

Q:

Describe valuation settings in which the appropriate discount rate to use is the required rate of return on equity capital versus settings in which it is appropriate to use a weighted average cost of...

Q:

a. Find VU.

Q:

E3-11 A partial adjusted trial balance of Sila Company at January 31,2008,shows the following. SILA COMPANY Adjusted Trial Balance January 31 , 2008 Debit Credit Supplies $ 850 Prepaid Insurance...

Q:

E3-15 The following data are taken from the comparative balance sheets of Girard Billiards Club, which prepares its financial statements using the accrual basis of accounting.