Answer parts a through e using a Financial Calculator and display all work: You are an...
Answer parts a through e using a Financial Calculator and display all work:
You are an employee of University Consultants, Ltd. and have been given the following assignment. You are to present an investment analysis of a small income-producing office property for sale to a potential investor. The asking price for the property is $1,250,000; rents are estimated at $200,000 during the first year and are expected to grow at 3 percent per year thereafter. Vacancies and collection losses are expected to be 10 percent of the rents. Operating expenses will be 35% of effective gross income. A fully amortizing 70 percent loan can be obtained at an 11 percent interest for 30 years. The loan requires constant monthly payments and is a fixed rate mortgage. The mortgage has no prepayment penalties. Interest accrues on a monthly basis. The property is expected to appreciate in value at 3 percent per year and is expected to be owned for three years and then sold.
You determine that the building represents 90% of the acquisition price. The building should be depreciated using the straight line method over 39 years. The potential investor indicates that she is in the 36 percent tax bracket and has enough passive income from other activities so that any passive losses from this activity would not be subject to any passive activity loss limitations.
Capital gains from price appreciation will be taxed at 20 percent and depreciation recapture will be taxed at 25%.
a) What is the investor’s after tax internal rate of return (ATIRR) on equity invested?
b) The investor has an alternative investment opportunity of similar risk that brings her an annualized after-tax return of 15%. Should she invest in this office building? Describe the rationale behind your recommendation.
c) What is the NPV of this investment, assuming a 15% discount rate?
d) What is the going-in capitalization rate? What is the terminal or going-out capitalization rate?
Now assume the investment is financed with a 70% loan-to-value ratio interest-only mortgage. The interest rate on this mortgage will remain at 11%.
e) Find the IRR under this alternative assumption?
Homework Answers
answer:-Hope its helps you.
Add Answer to:
Answer parts a through
e using a Financial
Calculator and display all work:
You are an...
You have recently graduated from University and have started your new job at Rang Consulting LLC....
You have recently graduated from University and have started your new job at Rang Consulting LLC. You have been given the following assignment. You are to present an investment analysis of a new residential income producing property an investor is considering purchasing. The asking price for the property is $1,200,000; rents are estimated at $201,000 during the first year and are expected to grow at 3.5% per year thereafter. Vacancies and collection losses are expected to be 11 percent of...
please answer only if you know the answers, and explain the process, thank you An investor...
please answer only if you know the answers, and explain the
process, thank you
An investor would like to purchase a new apartment property for $2 million. However, she faces the decision of whether to use 70 percent or 80 percent financing. The 70 percent loan can be obtained at 10 percent interest for 25 years. The 80 percent loan can be obtained at 11 percent interest for 25 years, NOI is expected to be $190,000 per year and increase...
The asking price for the property is $1.000.000 rents are estimated at $200,000 during the 1st...
The asking price for the property is $1.000.000 rents are estimated at $200,000 during the 1st year and are expected to grow at 5 percent ner vear. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35 percent of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan for 70 percent of the purchase price can be obtained at 10 percent interest rate. The property is...
please help with explanation An investor would like to purchase a new apartment property for $2...
please help with explanation
An investor would like to purchase a new apartment property for $2 million. However, she faces the decision of whether to use 70 percent or 80 percent financing. The 70 percent loan can be obtained at 10 percent interest for 25 years. The 80 percent loan can be obtained at 11 percent interest for 25 years. NOI is expected to be $190,000 per year and increase at 3 percent annually, the same rate at which the...
The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first...
The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first year and are expected to grow at 5% per year. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35% of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan fro 70 percent of the purchase price can be obtained at 10% interest rate. The property is expected to appreciate...
The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first...
The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first year and are expected to grow at 5 percent per year. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35 percent of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan for 70 percent of the purchase price can be obtained at 10 percent interest rate. The operty is...
An investor is planning to purchase a new apartment property for $1.5 million. He can obtain...
An investor is planning to purchase a new apartment property for $1.5 million. He can obtain an 80% loan for 30 years at 10%. NOI is expected to be $500,000 in the first year and grow at a rate of 2% for the next three years along with the underlying value of the building. The building and improvements represent 80% of value and are depreciated over a 27.5 useful life for an annual depreciation allowance of $43,636. The project is...
You are considering the purchase of a small existing office building for $2,575,000 today. Below, you...
You are considering the purchase of a small existing office building for $2,575,000 today. Below, you are given the information you need to analyze the investment and decide how to proceed. Remember: Your submission for this assignment should be calculated in Microsoft Excel. Please show all your formulas in the spreadsheet. I can only give you partial credit if I see how you did each calculation. Your expectations for this stabilized property include the following: first-year gross potential income of...
Property Assumptions: Purchase Price:  ...
Property Assumptions: Purchase Price: $4,000000 Year 1 PGI: $540,000 PGI Growth Rate (Annual): 3% Annual Vacancy and Collection Loss (VCL): 10% Year 1 Operating Expenses (OER): 35% OPEX growth rate after first year 2% Sales Price: -Capitalize HP+1 NOI at 9% $3,895,042 Anticipated Holding Period: 3 Years Maximum LTV: 70% Interest Rate: 5% Amortization Rate: 30 Years Payments Per Year: 12 Investor Hurdle Rate (Unleveraged): ...
You are considering the purchase of an apartment complex. The following assumptions are made: The purchase...
You are considering the purchase of an apartment complex. The following assumptions are made: The purchase price is $2,000,000 There are 30 units and the market rent is $850/month Market rents are expected to increase 4% per year Vacancy and collection loss is 10% Real Estate Taxes are expected to be $20,000 in year 1 and increase 5% per year Insurance is expected to be $10,000 in year 1 and increase 7% per year Utilities are expected to be 9%...
please answer only if you know the answers, and explain the
process, thank you
An investor would like to purchase a new apartment property for $2 million. However, she faces the decision of whether to use 70 percent or 80 percent financing. The 70 percent loan can be obtained at 10 percent interest for 25 years. The 80 percent loan can be obtained at 11 percent interest for 25 years, NOI is expected to be $190,000 per year and increase...
The asking price for the property is $1.000.000 rents are estimated at $200,000 during the 1st year and are expected to grow at 5 percent ner vear. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35 percent of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan for 70 percent of the purchase price can be obtained at 10 percent interest rate. The property is...
please help with explanation
An investor would like to purchase a new apartment property for $2 million. However, she faces the decision of whether to use 70 percent or 80 percent financing. The 70 percent loan can be obtained at 10 percent interest for 25 years. The 80 percent loan can be obtained at 11 percent interest for 25 years. NOI is expected to be $190,000 per year and increase at 3 percent annually, the same rate at which the...
The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first year and are expected to grow at 5 percent per year. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35 percent of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan for 70 percent of the purchase price can be obtained at 10 percent interest rate. The operty is...
Most questions answered within 3 hours.
-
(CO 2) A field can be added to a report to
values for two or more...
asked 1 minute ago -
Identify 3 research scenarios that might provide a low,
medium, and high degree of variability in...
asked 24 minutes ago -
how
does gravity affect the trajectory of projectile? what would be the
shape of the trajactory...
asked 1 hour ago -
Two small plastic spheres are given positive electrical charges.
When they are a distance of 15.4...
asked 1 hour ago -
An acidic solution containing gold ions is
electrolyzed, producing gaseous oxygen (from water) at the anode...
asked 1 hour ago -
Assume that the population of Mexico is 128
million and that the population increases 1.01
percentannually....
asked 2 hours ago -
Can someone please help me add appropriate descriptive
comments to each line of code in the...
asked 2 hours ago -
Romeo wishes to throw a bouquet of flowers to Juliet, who is on
a second-story balcony,...
asked 3 hours ago -
Why is QE a controversial monetary policy tool.
A. It may lead to excessive inflation.B. By...
asked 3 hours ago -
Principles of Programming midterm study guide help!
1.)
______ Which of the following would reference the...
asked 3 hours ago -
A finite potential well has depth U0 = 2.78 eV . What is the
penetration distance...
asked 4 hours ago -
1. The bus bars of a power station are in two sections A and B
separated...
asked 4 hours ago