21. Fill in the blank boxes in the spread sheet below (20pts) Real Estate Investment Analysis...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
21. Fill in the blank boxes in the spread sheet below (20pts) Real Estate Investment Analysis INPUT Asking price S1,100,000.00 rent year 1 growth rent vacancy & coll. Loss $200,000.00 3.00% 0.00% of rents 25.00% of EGI (no stops ) 80.00% еxpenses loan-to-value loan interest 7.50% loan term 30 years payments per year 12 Assume value of property will grow at Appreciation rate holding period 4.00% this rate 3 years 0.00% of sales selling costs Building value depreciation 80.00% of asking price 29 years tax rate 35.00% (All taxes) loan equity annual loan pymt mortgage bal Year 3 summary of loan information end of year 3 раyment mortgage balance interest Principal Before tax cash flow PGI vacancy EGI expenses NOI debt service before tax CF 21. Fill in the blank boxes in the spread sheet below (20pts) Real Estate Investment Analysis INPUT Asking price S1,100,000.00 rent year 1 growth rent vacancy & coll. Loss $200,000.00 3.00% 0.00% of rents 25.00% of EGI (no stops ) 80.00% еxpenses loan-to-value loan interest 7.50% loan term 30 years payments per year 12 Assume value of property will grow at Appreciation rate holding period 4.00% this rate 3 years 0.00% of sales selling costs Building value depreciation 80.00% of asking price 29 years tax rate 35.00% (All taxes) loan equity annual loan pymt mortgage bal Year 3 summary of loan information end of year 3 раyment mortgage balance interest Principal Before tax cash flow PGI vacancy EGI expenses NOI debt service before tax CF
Expert Answer:
Related Book For
Business Law and the Legal Environment
ISBN: 978-1111530600
6th Edition
Authors: Jeffrey F. Beatty, Susan S. Samuelson, Dean A. Bredeson
Posted Date:
Students also viewed these general management questions
-
For a satellite to be in a circular orbit 780 km above the surface of the earth, (a) What orbital speed must it be given, and (b) What is the period of the orbit (in hours)?
-
Is there any good reason to be in a partnership? If so, for what sort of business would it make sense?
-
There are several components needed to be in a project management plan, what are they? Be sure to define and state how they are used in the document? What is the overall relevance?
-
What are the roles and responsibilities of civil society in relation to the Sustainable Development Goals? In your country, how has civil society been engaged in the dialogue or discussion on...
-
George Stigler and Claire Friedland studied both unregulated and regulated electric utilities and found no difference in the rates they charged. One could draw the conclusion that regulation is...
-
Use economics to explain why mens and womens restrooms tend to be located near each other in airports and other public buildings.
-
A set of nonredundant (1oo1) safety equipment, with all component devices certified as having systematic capability SC 3, is used in a low-demand application. The longest DTI of the equipment set is...
-
Jennelle and Paula are equal partners in the J&P Manufacturing Partnership. The partnership will form J&P Corporation by exchanging the assets and liabilities of the J&P Manufacturing Partnership for...
-
From a lawsuit, you have been awarded a 31-payment, constant growth annuity. The first payment is at Year O and is equal to $380, and each subsequent payment will be paid in 16 month intervals, with...
-
Employees sometimes make mistakes and errors in recording accounting transactions. Is this considered fraud?
-
A coupon-bearing bond purchased when issued at par value was held until maturity during which time interest rates rose. The ex-post realized return of the bond investment most likely was: a) above...
-
v Review the formula for the debt ratio. Using this formula, look carefully at the balance sheet to locate the information you need. Calculate the debt ratio for each of the 3 years. When reporting...
-
What is the difference between net present value and internal rate of return?
-
what is the answer Warren proposes a tax on the monetary lobbying efforts and contributions of corporations and interest groups to limit their influence. Why is this unlikely to completely limit the...
-
Why is the Statement of Owner's Equity prepared after the Income Statement?
-
Accepted date on Instrument below should read "March 15, 2018"; (2) Joe Jonas is the President for Midwestern Style Fabrics - the company's name should be closer to his name) Given the instrument...
-
How does functional differentiation, as posited by functionalist theorists like Talcott Parsons, contribute to the structural cohesion and stability of complex societies by delineating specialized...
-
Explain what is meant by vicarious liability and when it is available?
-
In his most famous novel, The Red and the Black, the French author Stendhal (1783 1842) wrote: There is no such thing as natural law: this expression is nothing but old nonsense. Prior to laws, what...
-
Did Hessler cover reasonably? The facts are provided in the chapter opening. The trial court awarded Hessler $29,853; representing the difference between his contract with Crystal Lake and the sum he...
-
Suzy Tomlinson, 74, met a tragic endshe drowned, fully clothed, in her bathtub after a night out partying with 36-year-old J. B. Carlson. He had taken her home at 1 a.m. and was the last person to...
-
For the composite properties and environmental conditions described in Examples 3.6, 4.7, and 5.3, determine the hygrothermally degraded values of the longitudinal and transverse tensile strengths....
-
The filament-wound E-glass/epoxy pressure vessel described in Example 4.4 is to be used in a hot-wet environment with temperature \(T=100^{\circ} \mathrm{F}\) \(\left(38^{\circ} \mathrm{C} ight)\)...
-
A carbon/epoxy lamina is clamped between rigid plates in a mold (Figure 5.17), while curing at a temperature of \(125^{\circ} \mathrm{C}\). After curing, the lamina/mold assembly (still clamped...
Study smarter with the SolutionInn App