Question

In: Finance

Suppose you have developed the following information for a potential investment: current market value is $1,200,000;...

Suppose you have developed the following information for a potential investment: current market value is $1,200,000; anticipated loan to value ratio is .80 with 2 points; and predicated cash flows of ATCF1 = $38,560, ATCF2 = $41,780, ATCF3 = $37,210, ATCF4 = $39,127, and ATER4 = $191,730. Further, assume the investor's minimum required after-tax rate of return on equity is 12%.

a. What is the internal rate of return on this potential investment?

b. What is the profitability index on this investment?

Solutions

Expert Solution

Greetings,

A) Internal Rate of Return on an Investment is the rate that investor earns over a period of time (4 years in this question) on the investment made by him. In this case, 1200000 is the total investment size out of which 80% ie 960000 will be the debt investment and balance 240000 will be equity investment to be provided by investor.

So now you can feed the above figures in the excel worksheet and get the answer as under :-

240000 = (38560/1+r)+(41780/(1+r)^2)+(37210/(1+r)^3)+({39127+191730}/(1+r)^4)

Solve for r and it will throw up the answer =12.14% approx.

Note- Debt Investment of 960000 will be repaid at the end, if it is a bullet repayment and last CF of 191730 is after deducting that payment only.

B) Profitability Index shows Inflows per dollar of outflow. Suppose if PI is 1.5, it means investor is earning $1.5 for every dollar invested.

PI = present value of cash inflows/ present value of cash outfloes

In the given case, PV if outflows is 240000 and PV of inflows can be found out as under -

(38560/1.12)+(41780/1.12^2)+(37210/1.12^3)+(39127+191730)/(1.12^4)

PV of inflows = 240934

So PI = 240934/240000= 1.004 approx


Related Solutions

Suppose you have developed the following information for a potential investment: current market value is $1,000,000;...
Suppose you have developed the following information for a potential investment: current market value is $1,000,000; anticipated loan to value ratio is 0.75 with two discount points; and predicted cash flows of ATCF1 = 38,560, ATCF2 = $41,780, ATCF3= $45,210, and ATER3= $201,730. Assume the investor's minimum required after-tax rate of return is 15%. What is the net present value is investment? -$37,511 2) -$22,511 3) $62,280 4) none of the above The Tax Act of 1993 raised the marginal...
Merrill Corp. has the following information available about a potential capital investment:    Initial investment $ 1,200,000...
Merrill Corp. has the following information available about a potential capital investment:    Initial investment $ 1,200,000 Annual net income $ 120,000 Expected life 8 years Salvage value $ 130,000 Merrill’s cost of capital 10 % Assume straight line depreciation method is used. Required: 1. Calculate the project’s net present value. 2. Without making any calculations, determine whether the internal rate of return (IRR) is more or less than 10 percent. 3. Calculate the net present value using a 13 percent...
You are considering an investment in the stock market and have identified two potential stocks
Risk and return You are considering an investment in the stock market and have identified two potential stocks, they are Rio Tinto (NYSE: RIO) and Amazon (NASDAQ: AMZN). The year-end historical prices for the years 2010 to 2018 are shown in the table below. YearRio TintoAmazon201048.51125.41201169.48169.64201260.46194.44201356.47264.27201453.15358.69201544.13354.53201624.65587.00201744.79823.48201856.111450.891. Which stocks would you prefer to own? Would every rational investor make the same choice? Explain your answer(s). 2. Calculate the covariance and correlation coefficient between the two stocks. Does it appear that a portfolio consisting of...
You are considering an investment in the stock market and have identified two potential stocks, they...
You are considering an investment in the stock market and have identified two potential stocks, they are Rio Tinto (NYSE: RIO) and Amazon (NASDAQ: AMZN). The historical prices for the past 10 years are shown in the table below. Year Rio Tinto Amazon 2010 48.51 125.41 2011 69.48 169.64 2012 60.46 194.44 2013 56.47 264.27 2014 53.15 358.69 2015 44.13 354.53 2016 24.65 587.00 2017 44.79 823.48 2018 56.11 1450.89 1. Which stocks would you prefer to own? Would everyone...
You are considering an investment in the stock market and have identified three potential stocks, they...
You are considering an investment in the stock market and have identified three potential stocks, they are Crown (ASX: CWN), Tencent (HKG: 0700) and Commonwealth Bank (ASX: CBA). The historical prices for the past 10 years are shown in the table below. Assume no dividend is distributed during this period. Year Crown Tencent Commonwealth (CBA) 2010 7.76 29.04 53.63 2011 8.57 40.40 52.15 2012 8.09 37.94 50.39 2013 11.59 54.28 64.10 2014 16.68 108.70 73.83 2015 13.61 132 88.85 2016...
Suppose that you have U.S. $1,000,000 to invest in the market. Considering the following information, you...
Suppose that you have U.S. $1,000,000 to invest in the market. Considering the following information, you have decided to engage in triangular arbitrage. What is your profit from triangular arbitrage? Value of Australian dollar in U.S. dollars = U.S. $ 0.90 Value of New Zealand dollar in U.S. dollars = U.S. $ 0.30 Value of Australian dollar in New Zealand dollars = NZ $ 3.02 A. $8,255 B. $1,008,255 C. $6,667 D. $1,006,667 E. $4,111
You want to create a portfolio equally as risky as the market, and you have $1,200,000...
You want to create a portfolio equally as risky as the market, and you have $1,200,000 to invest. Consider the following information:    AssetInvestmentBeta Stock A$420,0000.70 Stock B$360,0001.25 Stock C 1.55 Risk-free asset      Required: (a)What is the investment in Stock C? (Do not round your intermediate calculations.)       (Click to select)   $279,484   $305,962   $294,194   $213,028   $282,426    (b)What is the investment in risk-free asset? (Do not round your intermediate calculations.)       (Click to select)   $130,838   $119,516   $125,806   $206,972   $120,774
You want to create a portfolio equally as risky as the market, and you have $1,200,000...
You want to create a portfolio equally as risky as the market, and you have $1,200,000 to invest. Consider the following information: Asset Investment Beta Stock A $240,000 0.60 Stock B $360,000 1.25 Stock C 1.60 Risk-free asset Required: (a) What is the investment in Stock C? (Do not round your intermediate calculations.) (b) What is the investment in risk-free asset? (Do not round your intermediate calculations.)
Suppose you manage a portfolio with a current market value of $58,715,000. You and your analyst...
Suppose you manage a portfolio with a current market value of $58,715,000. You and your analyst team actively manage a long/short equity fund, which is benchmarking the S&P 500. Over the past three years, your fund exhibits an annual continuously compounded return of 13.27%. Over the same period of time, the S&P 500 returned an average annual continuously compounded return of 14.17%. You and your team estimate the beta of the portfolio over the same time period using daily returns...
Suppose you are an investment advisor in an investment bank. A potential client is interested in...
Suppose you are an investment advisor in an investment bank. A potential client is interested in Apple Inc’s stock. However, this client is very sensitive to investment risk. How will you explain Apple’s risk to your client if you use the Yahoo Finance Webpage as information resource? Your client might ask you whether Apple’s stock is over-priced now. Since Apple just announced its new iPhone and i-watch products, you anticipate its sales revenues and dividend will grow at 20% in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT