Assume an industrial building can be purchased for $2,500,000 today. The investment is expected to yield...

Assume an industrial building can be purchased for $2,500,000 today. The investment is expected to yield cash flows of $300,000 a year for the next five years (the cash flows will be received at the end of the year). The building is expected to sell for $2,750,000 at the end of the fifth year. Calculate the internal rate of return (IRR) for this transaction. show work please

Solutions

Expert Solution

For solving the question we are going to use the IRR function in Excel:

Syntax of the IRR function in Excel is:

=IRR (values, [guess]), where values - Array or reference to cells that contain values & guess - [optional] An estimate for expected IRR

Total Cashflow in the year 5 would be = Cashflow in Year 5 + Building Selling Value

Total Cashflow in the year 5 would be = $300,000 + $2,750,000 = $3,050,000

For using the IRR function just select the Amount column and drag it from Intital Investment row to Cashflo in Year 5 row you will get the IRR for the transaction.

Internal rate of return (IRR) for this transaction is 13.53% (Rounded to two decimal places else 13.527%)

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

An apartment building has the following investment characteristics: Year 1 NOI $2,500,000

An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000 Year 3 NOI $2,704,000 Year 4 NOI $2,812,000 You plan to purchase the asset at a 5% initial cap rate and to sell it 3 years later, also at a 5% cap rate. You plan to use a loan at 60% LTV to purchase the asset. The loan will be interest only (no amortization) at a 4% annual interest rate....

Jensen Company owns a building in a suburban industrial park. It purchased the building four years...

Jensen Company owns a building in a suburban industrial park. It purchased the building four years ago for $3 million. It is now deciding whether to lease the building or to use it as a distribution center. It could be rented immediately. Given today’s market conditions, rental income of $120,000 per year would be expected. To convert the building to make it useful as a distribution center would require an immediate expenditure of $400,000. Having the distribution center at this...

Jensen Company owns a building in a suburban industrial park. It purchased the building four years...

Jensen Company owns a building in a suburban industrial park. It purchased the building four years ago for $3 million. It is now deciding whether to lease the building or to use it as a distribution center. It could be leased immediately. Given today’s market conditions, lease income of $120,000 per year would be expected. To convert the building to make it useful as a distribution center would require an immediate expenditure of $400,000. Having the distribution center at this...

A small industrial contractor purchased a warehouse building for storing equipment and materials that are not...

A small industrial contractor purchased a warehouse building for storing equipment and materials that are not immediately needed at construction job sites. The cost of the building was $100,000 and the contractor has just made an agreement with the seller to finance the purchase over a 5-year period. The agreement state that monthly payments will be made based on a 30-year amortization, but the balance owed at the end of year 5 must be paid in a lump-sum "balloon" payment....

A medium-sized industrial grade compressor can be purchased for $35,000. Annual O&M costs are expected to...

A medium-sized industrial grade compressor can be purchased for $35,000. Annual O&M costs are expected to increase $1,300 every year, with a 1st year O&M cost of $2,000. (MARR = AAA+15%, and planning horizon is 10 years) • The compressor salvage value for a given period t, is calculated based on the following equation: Salvage value (t) = $30,000– $3,000 * t a) Find the Optimum Replacement Interval for this Equipment b) Find the Optimum Replacement Interval for this Equipment...

A medium-sized industrial grade compressor can be purchased for $35,000. Annual O&M costs are expected to...

A medium-sized industrial grade compressor can be purchased for $35,000. Annual O&M costs are expected to increase $1,300 every year, with a 1st year O&M cost of $2,000. (MARR =16%, and planning horizon is 10 years) • The compressor salvage value for a given period t, is calculated based on the following equation: Salvage value (t) = $30,000– $3,000 * t a) Find the Optimum Replacement Interval for this Equipment b) Find the Optimum Replacement Interval for this Equipment if...

An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000...

An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000 Year 3 NOI $2,704,000 Year 4 NOI $2,812,000 You plan to purchase the asset at a 5% initial cap rate and to sell it 3 years later, also at a 5% cap rate. You plan to use a loan at 60% LTV to purchase the asset. The loan will be interest-only (no amortization) at a 4% annual interest rate. Answer the following: What is...

One research project will cost $500,000 today and is expected to yield benefits of $50,000 at...

One research project will cost $500,000 today and is expected to yield benefits of $50,000 at the end of each of the next 30 years. A second project will cost $400,000 and yield a single cash flow of $800,000 in 6 years. What is the difference in the IRR’s of these research projects?

Value and Returns A stock has an expected dividend yield of 3.8% a price today of...

Value and Returns A stock has an expected dividend yield of 3.8% a price today of $30 and an expected sale price in one year of $33. The stock has a beta of 1.2 and the expected return on the market is 10% while the risk free rate is 5%. This stock is _____________ by ________ basis points. overvalued; 143 undervalued; 280 undervalued; 143 overvalued; 280

5. A project requires an investment of $100m in two years. It is expected to yield...

5. A project requires an investment of $100m in two years. It is expected to yield $25m after the third year, $25m after the fourth year; in the fifth year it will yield $7m, which will grow at 1% per year over the next five years. What is the project’s NPV at a cost of capital of 15%?

Subjects