Question

In: Finance

eBook Problem 7-31 Use a financial calculator or a program such as Excel to answer the...

eBook

Problem 7-31

Use a financial calculator or a program such as Excel to answer the questions. Round your answers to the nearest whole number.

  1. You purchase a stock for $9,000 and collect $300 at the end of each year in dividends. You sell the stock for $10,500 after five years. What was the annual return on your $9,000 investment?
      %

  2. You purchase a building for $850,000, collect annual rent (after expenses) of $110,000, and sell the building for $950,000 after seven years. What is the annual return on this investment?
      %

  3. You buy a stock for $1,000 and expect to sell it for $850 after five years but also expect to collect dividends of $130 a year. Calculate the return on this investment and prove that it is less than 13 percent.
      %

Solutions

Expert Solution

a) Answer- The annual return on $9,000 investment is 6%

Particulars Value
Initial Stock Price $9,000
Capital Appreciation $1,500*
Dividend for 5 year[$300*5) $1,500
No. of Years 5

* Capital appreciation=$10,500-$9,000=$1,500

Ending Value = Initial Value + Capital Appreciation + Dividends Earned=$9,000+$1,500+$1,500=$12,000

Annual Return is calculated using the formula given below

Annual Return = [(Ending Value / Initial Value) ^(1 / No. of Years)] - 1

Annual Return=[($12,000/$9,000)^(1/5)]-1=5.9% or 6%(approx).

b) Answer- The annual return on this investment is 11%

Particulars Value
Initial Price of Building $850,000
Capital appreciation[Selling price-Initial price] $100,000*
Rent for 7 years[$110,000*7) $770,000
No. of Years 7

* Capital appreciation=$9,50,000-$8,50,000=$1,00,000

Ending Value = Initial Value + Capital Appreciation + Rent=$850,000+$100,000+$770,000=$1,720,000

Annual Return is calculated using the formula given below

Annual Return = [(Ending Value / Initial Value) ^(1 / No. of Years)] - 1

Annual Return=[($1,720,000/$850,000)^(1/7)]-1=10.6% or 11%(approx).

c) The return on investment is 8% & hence less than 13%

Particulars Value
Initial Stock Price $1,000
Capital Appreciation[Selling price-Initial price] ($150)*
Dividend for 5 year[$130*5) $650
No. of Years 5

* Capital appreciation=$850-$1,000=($150)

Ending Value = Initial Value + Capital Appreciation + Dividends Earned=$1,000-$150+$650=$1,500

Annual Return is calculated using the formula given below

Annual Return = [(Ending Value / Initial Value) ^(1 / No. of Years)] - 1

Annual Return=[($1,500/$1,000)^(1/5)]-1=8.4% or 8%(approx).


Related Solutions

use a financial calculator or a program such as Excel to answer the questions run your...
use a financial calculator or a program such as Excel to answer the questions run your answers to the nearest whole number. A. you purchase a stock for $9,500 and collect $350 at the end of each year in dividends. you sell the stock for $11,000 after 6 years what was the annual return on your $9, 500 investment? B. You purchased a building for a $750,000 collect annual rent (after expenses) of $110,000 and sell the building for $800,000...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following investments. Investment A B Initial Investment $                8,500.00 $      9,500.00 End of Year Income 1 $                2,500.00 $      2,000.00 2 $                2,500.00 $      2,500.00 3 $                2,500.00 $      3,000.00 4 $                2,500.00 $      3,500.00 5 $                2,500.00 $      4,000.00
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the...
Use a financial calculator or an Excel spreadsheet to estimate the IRR for each of the following​ investments: The Yield for Investment A: The Yield for Investment B: A B Initial Investment 6,400 9,535 Year 1 $1,822.65 $2,200 Year 2 $1,822.65 $2,500 Year 3 $1,822.65 $3,100 Year 4 $1,822.65 $3,600 Year 5 $1,822.65 $4,100
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided capital budgeting problem (sample questions and solutions are provided for guidance). Problem: Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years....
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i)...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (iii) Calculate...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital...
You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years. (i) Develop...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT