Reference no: EM13333809
1. Develop a five year proforma statement for a 40,000 sq.ft. office building based on the following information
a. 92 percent of the building is lease able.
b. Management fees are 6 percent of Effective Gross Income
c. Utilities are $1.50 per square foot and growing at 3.5 percent per year.
d. Maintenance expenses are 14 percent of Total Income
e. Property taxes are 10 percent of Total Income
f. Insurance expenses are $5,000 per year
g. Reserve requirements are $6,500 per year
h. Assume a 5 percent vacancy rate
i. Tenant information
ABC Consultants 6,800 sq.ft. $13.20/sq.ft. 2.5% per year
Credit Inc. 12.000 sq.ft. $12.30/sq.ft. None
Camby Insurance 9,000 sq.ft. $12.70/sq.ft 3% per year
EK Imports 9,000 sq.ft. $12.70/sq.ft. 2% per year
Bench marks:
Capitalization rate of 9.8 percent
Interest rate 7.25 percent
LTV 70 percent
Term 25 years
Compute:
Monthly payment
Mortgage balance at time of sale
Net Present Value based on discount rate of 11 percent
Leveraged IRR
Unleveraged IRR
Debt Coverage ratio
Breakeven point
Sale price based on going-out cap rate of 10.5 percent and 3 percent selling expenses
Sensitivity analysis: Separate runs for each and explanation
1. EK Imports leaves in the third year and space is not rented
2. Capitalization rate is change to 11.2 percent.
|
Explain how language of preamble reflects idea
: Explain how the language of the Preamble reflects the idea of the social contract.
|
|
Explain the basictechnology that makes residential
: Explain the basictechnology that makes residential/SPHO firewall appliances effective in protecting a local network. Why is this adequete protection?
|
|
Job satisfaction is a positive feeling about a job
: Job satisfaction is a positive feeling about a job. This is a subjective phenomenon; still there are some discrete factors that play an important role in job satisfaction. Read the below mentioned situation and answer the questions accordingly.
|
|
Different aspects of digital photography composition
: I need help and I'm low on sources for my speech on Different Aspects of Digital Photography Composition. I need to find source material preferably from Beginners and instructional manuals for beginner digital photographers.
|
|
Mortgage balance at time of sale-monthly payment
: Develop a five year proforma statement for a 40,000 sq.ft. office building based on the following information. Compute: Monthly payment, Mortgage balance at time of sale, Net Present Value based on discount rate of 11 percent.
|
|
What philosophical principle
: What philosophical principle did Google's managers adopt when deciding that the benefits of operating in China outweighed the costs? Do you think that Google should have entered China and engaged in self-censorship, given the company's long-standing ..
|
|
Discuss two dominant values from each of two cohort groups
: Name and discuss two dominant values from each of two "cohort groups" in today's workplace. Provide examples from a present or past employer to illustrate your points.
|
|
Type of instrumental music not associated with story-poem
: Concerto for Orchestra by Bartok follows the same stricture of the Concerto Grosso of the Baroque period. Which of the following is a type of instrumental music not associated with a story, poem, or title?
|
|
The selling price per unit decreasd
: In response to a request from your immidiate supervisor, you have prepared a CVP graph portraying the cost and revenue characteristics of your company's product and operations. explain how the lines on the graph and the break-even point would change ..
|