Use the given information to solve the following questions. You have purchased a building for $12,000,000....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the given information to solve the following questions. You have purchased a building for $12,000,000. There are ongoing NNN leases that will create a constant annual PGI of 1,700,000 with a Vacancy and Collection loss of 10%. Operating Expenses will be constant at 575,000 per year, and Capital Expenditures a constant 120,000 per year. You have obtained a 5-year, 4.5% partially amortizing loan at 65% LTV with 1.5 points that has a 25-year amortization period. You expect to sell this building for a net of $14,500,000 (i.e. after selling expense are paid) five years from today. What is your loan amount? What is your initial investment? What is your monthly loan payment? What is your loan balance after 5 years? What is your ADS? What is your year 1 NOI? What is your Year 1 before tax cash flow from operations? What is your going in cap rate? What is the first year cash on cash return for this investment? What is the first year Debt Coverage Ratio for this loan? What is the first year Debt Yield for this loan? What is the first year Break Even Occupancy for this loan? What is your before tax cash flow from selling this building? What is the before tax IRR of this investment? What is the before tax IRR of this investment? For a 14% equity hurdle rate, what is the before tax NPV of this investment? If your lender was satisfied with a 1.5 Debt Coverage Ratio (regardless of LTV), what is the maximum loan amount you could have obtained? Use the given information to solve the following questions. You have purchased a building for $12,000,000. There are ongoing NNN leases that will create a constant annual PGI of 1,700,000 with a Vacancy and Collection loss of 10%. Operating Expenses will be constant at 575,000 per year, and Capital Expenditures a constant 120,000 per year. You have obtained a 5-year, 4.5% partially amortizing loan at 65% LTV with 1.5 points that has a 25-year amortization period. You expect to sell this building for a net of $14,500,000 (i.e. after selling expense are paid) five years from today. What is your loan amount? What is your initial investment? What is your monthly loan payment? What is your loan balance after 5 years? What is your ADS? What is your year 1 NOI? What is your Year 1 before tax cash flow from operations? What is your going in cap rate? What is the first year cash on cash return for this investment? What is the first year Debt Coverage Ratio for this loan? What is the first year Debt Yield for this loan? What is the first year Break Even Occupancy for this loan? What is your before tax cash flow from selling this building? What is the before tax IRR of this investment? What is the before tax IRR of this investment? For a 14% equity hurdle rate, what is the before tax NPV of this investment? If your lender was satisfied with a 1.5 Debt Coverage Ratio (regardless of LTV), what is the maximum loan amount you could have obtained?
Expert Answer:
Answer rating: 100% (QA)
Loan amount 12000000 x 65 7800000 Initial investment 12000000 7800000 4200000 Monthly loan payment 7... View the full answer
Related Book For
Financial Markets and Institutions
ISBN: 978-0077861667
6th edition
Authors: Anthony Saunders , Marcia Cornett
Posted Date:
Students also viewed these accounting questions
-
Five years ago a consulting engineer purchased a building for company offices constructed of bricks that were not properly fired. As a result, some of the bricks were deteriorated from their exposure...
-
On January 1, 2012, Ravioli, Inc., purchased a building for a cash price of $192,000 and accrued property taxes of $14,950. The building is estimated to have a useful life of 10 years and no salvage...
-
On January 1, 2011, Klinefelter Company purchased a building for $520,000. The building had an estimated life of 20 years and an estimated residual value of $20,000. The company has been depreciating...
-
In April 2016, Vanessa bought 100 shares in Entagon plc at a cost of 5 per share. The company went into liquidation and Vanessa received a first distribution of 40p per share in July 2020. The shares...
-
Given the following: Project A: CF0 = $23,000; CF1 = $6,000; CF2 = $9,000; CF3 = $15,600 Project B: CF0 = $20,000; CF1 = $4,000; CF2 = $8,000; CF3 = $15,000 What is the crossover rate (r)?
-
Claim: The mean pulse rate (in beats per minute, or bpm) of adult males is equal to 69 bpm. For the random sample of 153 adult males in Data Set 1 Body Data in Appendix B, the mean pulse rate is 69.6...
-
A vertical shaft passes through a bearing and is lubricated with an oil having a viscosity of \(0.2 \mathrm{~N} \cdot \mathrm{s} / \mathrm{m}^{2}\) as shown in Fig. P6.85. Assume that the flow...
-
In divisional income statements prepared for Mills Construction Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll checks, and the...
-
Two sound sources generate pure tones of 81 Hz and 56 Hz. What is the beat frequency?
-
Earth and Artistry, Inc. provides commercial landscaping services. Sasha Cairns, the firm's owner, wants to develop cost estimates that she can use to prepare bids on jobs. After analyzing the firm's...
-
In figure, sides QP and RQ of ?PQR are produced to points S and T, respectively. If ?SPR = 135 and ?PQT = 110, find ?PRQ. T 110% Q P 135 R
-
You are shown a video clip of a dog running in front of a blank wall. The observations are to be plotted using the horizontal and vertical axes labeled with seconds and meters, respectively. How many...
-
A car's speed during the interval \(t=0.5 \mathrm{~s}\) to \(t=20 \mathrm{~s}\) is given by \(t=c \sqrt{t}\), where \(c\) is a constant. Over the interval \(t=10 \mathrm{~s}\) to \(t=20...
-
The position of a cart on a low-friction track can be represented by the equation \(x(t)=b+c t+e t^{2}\), where \(b=4.00 \mathrm{~m}, c=6.00 \mathrm{~m} / \mathrm{s}\), and \(e=0.200 \mathrm{~m} /...
-
Four traffic lights on a stretch of road are spaced \(300 \mathrm{~m}\) apart. There is a 10-s lag time between successive green lights: The second light turns green \(10 \mathrm{~s}\) after the...
-
A rocket's \(x\) component of acceleration is given by \(a_{x}=b t\), where \(b=1.00 \mathrm{~m} / \mathrm{s}^{3}\). The rocket begins accelerating from rest at \(t=0\). (a) What is its \(x\)...
-
Space X constructed a satellite that is expected to revolve (circle) around the earth 8.7 times every 28.8 hours. The satellite is expected to travel in a uniform circular motion at a distance of...
-
Proposals have been made to ?sail? spacecraft to the outer solar system using the pressure of sunlight, or even to propel interstellar spacecraft with high-powered, Earth-based lasers. Sailing...
-
How does an FI evaluate its credit risks with respect to consumer and small business loans?
-
You have purchased a put option on Pfizer common stock. The option has an exercise price of $ 27 and Pfizers stock currently trades at $ 29. The option premium is $ 0.50 per contract. a. What is your...
-
You have purchased a put option on Kimberly Clark common stock. The option has an exercise price of $ 95.00 and Kimberly Clarks stock currently trades at $ 96.18. The option premium is $ 1.25 per...
-
Natural gas (methane) flows from a 3-in.-diameter gas main, through a 1-in.-diameter pipe, and into the burner of a furnace at a rate of \(100 \mathrm{ft}^{3} /\) hour. Determine the pressure in the...
-
SAE 30 oil at \(60^{\circ} \mathrm{F}\) flows through a 2-in.-diameter pipe with a mean velocity of \(5 \mathrm{ft} / \mathrm{s}\). Determine the value of the Reynolds number (see Example 1.4)....
-
Calculate the Reynolds numbers for the flow of water and for air through a 4-mm-diameter tube, if the mean velocity is \(3 \mathrm{~m} / \mathrm{s}\) and the temperature is \(30^{\circ} \mathrm{C}\)...
Study smarter with the SolutionInn App