Question

ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! An office building is purchased with the...

ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU!

An office building is purchased with the following projected cash flows:

• NOI is expected to be $130,000 in year 1 with 5 percent annual increases.

• The purchase price of the property is $720,000.

• 100 percent equity financing is used to purchase the property.

• The property is sold at the end of year 4 for $860,000 with selling costs of 4 percent.

• The required unlevered rate of return is 14 percent.

a. Calculate the unlevered internal rate of return (IRR).

b. Calculate the unlevered net present value (NPV).

Homework Answers

Answer #1

Year

0

1

2

3

4

cost of machine

-720000

NOI - with 5% increase

130000

136500

143325

150491.3

selling price of building after selling cost of 4%

825600

total cash flow

-720000

130000

136500

143325

976091.3

Sum of present value of cash flow = total cash flow/(1+r)^n r = 14%

-720000

114035.1

105032.3

96740.29

577924.4

NPV = sum of present value of cash flow

173732.1

IRR = using irr function in ms excel =irr(-720000,130000,136500,143325,976091.3

21.88%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! You are considering the purchase of a...
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! You are considering the purchase of a quadruplex apartment building. Effective gross income during the first year of operations is expected to be $33,600 ($700 per month per unit). First-year operating expenses are expected to be $13,440 (at 40 percent of EGI). Ignore capital expenditures. The purchase price of the quadruplex is $200,000. The acquisition will be financed with $60,000 in equity and a $140,000 standard fixed-rate mortgage. The interest rate...
If your able to work out the problems instead of using excel since excel isnt accessible...
If your able to work out the problems instead of using excel since excel isnt accessible on the exam. Consider the following projects, for a firm using a discount rate of 10%. If the projects are mutually exclusive, which, if any, project(s) should the firm accept? Project                   NPV                                           IRR                                            PI E                               $200,000                                10.2%                                       1.04 F                               $(200,001)                            11%                                           .81 G                               $1                                                10%                                           1.01 H                              $(235,000)                            9%                                            .95 a.               E b.              F c.               H d.              F and H You are considering two...
An Office building is listed for sale at $500,000. You can borrow 80% at 6% interest...
An Office building is listed for sale at $500,000. You can borrow 80% at 6% interest amortized monthly for a 20 year term and put 20% down. Your required unleveraged IRR is 10% and you want to use a 9% terminal cap rate. You plan a five year holding period after the purchase. You have calculated the annual pre-debt service NOI for each year as: Yr. 1 = $40,000 Yr. 2 = $41,000 Yr. 3 = $42,000 Yr. 4 =...
The physician's office that you manage wants to buy equipment for $20,000, with projected cash flows...
The physician's office that you manage wants to buy equipment for $20,000, with projected cash flows of $3,000 per year over the equipment's ten-year useful life. Calculate the NPV/IRR at 10 percent.
You are contemplating the purchase of an office building. Next year net rental income will be...
You are contemplating the purchase of an office building. Next year net rental income will be $400,000, which will grow at 4% per year. You believe that in 10 years the office building could be sold for $7.4 million. The discount rate is 12%. What is the most you should be willing to pay for the office building today? Solve this problem using formulas and showing your work. DO NOT USE EXCEL or take shortcuts. Every step must be shown...
You have just completed the appraisal of an office building and have concluded that the market...
You have just completed the appraisal of an office building and have concluded that the market value of the property is $2,500,000. You expect potential gross income (PGI) in the first year of operations to be $450,000; vacancy and collection losses to be 12 percent of PGI; operating expenses to be 30 percent of effective gross income (EGI); and capital expenditures to be 4 percent of EGI. a. What is the EGI for the first year? b. What is the...
You are considering the purchase of a small office building. The office building specializes in offering...
You are considering the purchase of a small office building. The office building specializes in offering facilities to small startup firms who are looking to avoid long-term commitments while their businesses are growing. Tenants sign one-year leases and may renew at market rates, if they so desire. The building is configured with 25 suites. Five (5) suites each have 4,000 useable square feet and ten (10) each have 2,500 usable square feet. The remaining ten (10) suites each have 1,000...
Assume that an industrial building can be purchased for $1,500,000 today, is expected to yield cash...
Assume that an industrial building can be purchased for $1,500,000 today, is expected to yield cash flows of $90,000 for each of the next seven years (with the cash flows occurring at the end of each year), and can be sold at the end of the seventh year for $1,650,000. Calculate the internal rate of return (IRR) for this transaction.
You are considering building a shopping mall. The initial investment is ?$1.43. million. The cash flows...
You are considering building a shopping mall. The initial investment is ?$1.43. million. The cash flows are?$410,000 for year? 1,200,000 for year?2, $200,000 for year? 3, and ?$170,000 for year 4. What are the net present value? (NPV) and profitability index? (PI) of the project if the cost of capital is 12?%? Compute the internal rate of return? (IRR) for the project.
PLEASE ANSWER THE QUESTION IN PLAIN EXCEL FORMAT IN A WAY THAT IS EASILY UNDERSTOOD. THANK...
PLEASE ANSWER THE QUESTION IN PLAIN EXCEL FORMAT IN A WAY THAT IS EASILY UNDERSTOOD. THANK YOU. 10 [EXCEL] Average accounting rate of return (ARR): Capitol Corp. management is expecting a project to generate after-tax income of $63,435 in each of the next three years. The average book value of the project's equipment over that period will be $212,500. If the firm's investment decision on any project is based on an ARR of 37.5 percent, should this project be accepted?...