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 rents. Operating expenses will be 35% of effective gross income. A 70% loan can be obtained at 11% interest for 30 years. The property is expected to appreciate in value at 3% per year and will be sold in 5 years. You determine that the building represents 90% of value and would be depreciated over 39 years (use 1/39th per year). The potential investor indicates that she is in the 36% 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% and depreciation recapture will be taxed at 25%. The discount rate is 14%.
Please answer in excel
What is the investor’s expected before-tax internal rate of return on equity invested (BTIRR)? What is the investor’s expected after-tax internal rate of return on equity invested (ATIRR)? What is the first year debt coverage ratio? What is the terminal capitalization rate?
Homework Answers
Add Answer to:
You have recently graduated from University and have started
your new job at Rang Consulting LLC....
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...
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...
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...
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...
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...
New Product Analysis You have recently graduated from the University of North Georgia with a BBA...
New Product Analysis You have recently graduated from the University of North Georgia with a BBA degree, and you have taken a job with a local manufacturing company. Your boss has asked you to analyze n potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the product's net present value and internal...
Retirement Planning at J&J Bagel You recently graduated from Suffolk University, and your job search led...
Retirement Planning at J&J Bagel You recently graduated from Suffolk University, and your job search led you to J&J Bagel, Inc. As you are finishing your employment paperwork, Jerry Chen, one of the co-owners of J&J Bagel, informs you about the company's new 401(k) plan. A 401(k) is a type of retirement plan, offered by many companies. A 401(k) is tax deferred, which means that any deposits you make into the plan are deducted from your current income, so no...
Use the following to answer questions 9-12. Five years later, you are offered your dream...
Use the following to answer questions 9-12. Five years later, you are offered your dream job in Costa Rica. You need to sell this house in order to purchase a new one where you are moving. Rents have increased since you purchased the home and you estimate that the home will rent for $1700 per month (net). You have found a high quality tenant willing to sign a five year lease under the following conditions. Rent will be $1,700...
Retirement Planning at J&J Bagel You recently graduated from Suffolk University, and your job search led...
Retirement Planning at J&J Bagel You recently graduated from Suffolk University, and your job search led you to J&J Bagel, Inc. As you are finishing your employment paperwork, Jerry Chen, one of the co-owners of J&J Bagel, inform you about the company's new 401(k) plan. A 401(k) is a type of retirement plan, offered by many companies. A 401(k) is tax deferred. which means that any deposits you make into the plan are deducted from your current income, so no...
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...
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...
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...
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...
New Product Analysis You have recently graduated from the University of North Georgia with a BBA degree, and you have taken a job with a local manufacturing company. Your boss has asked you to analyze n potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the product's net present value and internal...
Retirement Planning at J&J Bagel You recently graduated from Suffolk University, and your job search led you to J&J Bagel, Inc. As you are finishing your employment paperwork, Jerry Chen, one of the co-owners of J&J Bagel, informs you about the company's new 401(k) plan. A 401(k) is a type of retirement plan, offered by many companies. A 401(k) is tax deferred, which means that any deposits you make into the plan are deducted from your current income, so no...
Retirement Planning at J&J Bagel You recently graduated from Suffolk University, and your job search led you to J&J Bagel, Inc. As you are finishing your employment paperwork, Jerry Chen, one of the co-owners of J&J Bagel, inform you about the company's new 401(k) plan. A 401(k) is a type of retirement plan, offered by many companies. A 401(k) is tax deferred. which means that any deposits you make into the plan are deducted from your current income, so no...
Most questions answered within 3 hours.
-
A sample of gas has a mass of 0.550 g . Its volume is 118 mL...
asked 5 minutes ago -
Facts:
For many years, New York City has had to deal with vandalism and
defacement of...
asked 7 minutes ago -
Consider copper wire with a cross-sectional area 7.85 × 10–5 m2.
Caculate the required length of...
asked 14 minutes ago -
A 2.10 nF capacitor with an initial charge of 4.55 µC is
discharged through a 1.18...
asked 20 minutes ago -
Programming Problem:
SUMMING ARRAY ELEMENTS -
Use Assembly Language x86
(MASM) Write an assembly code...
asked 23 minutes ago -
Learning Goal:
To practice Problem-Solving Strategy 8.1 Static equilibrium
problems.
When you lift an object by...
asked 26 minutes ago -
Six Sigma class. List 5 important customer key process output
categories. Give an example of a...
asked 32 minutes ago -
Create a new file (in Dev C++)
Modify program above to use a vector instead of...
asked 35 minutes ago -
This assignment focuses on writing functions. These functions
will be used to make the structure of...
asked 40 minutes ago -
How many different combinations of toppings can be put on a
pizza if you select three...
asked 1 hour ago -
In addition to the
numbers given in number question 2 ,
r = 100
q =...
asked 1 hour ago -
A population is normally distributed with a mean of 61 and a
standard deviation of 15....
asked 1 hour ago