What is holding-period return

Assignment Help Accounting Basics
Reference no: EM132191218

Question - The following problems in an Excel file. All problems must be using the functions in Excel. Should be able to see your formulas in the "bar" at the top of the spreadsheet.

1) Using CAPM, calculate the following Reasonable Rate of Return for Company QWE, whose Beta is .88. The Risk-free rate of return is 0.75% and Market-rate is 4.75%.

2) What is a portfolio's beta with the following:

Stock

Stock Weight

Beta

Apple

38%

1.50

Target

15%

1.44

Disney

27%

1.15

Walmart

20%

1.20

Q3) What is a portfolio's beta with the following:

Stock

Stock Weight

Beta

Samsung

10%

1.09

CVS

15%

0.97

Walgreens

31%

0.32

Amazon

19%

1.27

Sony

5%

0.86

JetBlue

10%

-0.21

4) What is Holding-period return?

5) Calculate the holding period returns for periods 2 - 4 for both Jazman & Solomon as a percent.

Period

Jazman

Solomon

1

$9

$27

2

$11

$28

3

$10

$32

4

$13

$29

6) What would the present value be of $3,000 to be received 12 years from now discounted back at 8%?

7) You are offered $1,000 today, $10,000 in 12 years, or $25,000 in 25 years. Assuming that you can earn 11 percent on your money, which offer should you choose?

8) Selma and Patty are saving for retirement in two different ways. Who will save more money for retirement at the end? Show your work. They will both receive 8% annual return on their investment over the next 35 years. Selma invests $2,000 at the end of each year only for first 10 years of the 35 year period - for a total of $20,000 saved. Patty doesn't start saving for 7 years and then saves $2,000 per year at the end of each year for 28 years -for a total of $56,000 saved.

9) You invested $100,000 5 years ago at 7.5% annual interest rate. If you invest an additional $1,500 a year, at the beginning of each year for 20 years at the same 7.5% annual rate, how much will you have 20 years from now?

Reference no: EM132191218

Questions Cloud

Recall being part of that was positive experience : We've all been part of many teams. Share with the class a bit about a team you recall being a part of that was a positive experience.
Distinguish between the concepts of mission and vision : Distinguish between the concepts of mission and vision. Provide examples in your explanation.
Discuss the root cause of the data quality issues : Discuss the root cause of the data quality issues, and outline the solution to the poor data quality.
Small or too large to be impacted by csr : How size matters-are companies too small or too large to be impacted by CSR?
What is holding-period return : What would the present value be of $3,000 to be received 12 years from now discounted back at 8%? What is Holding-period return
Discuss the four basic functions of management : Identify and discuss the 4 basic functions of management. Also, explain which function you feel is most important and why.
What bargaining tactics you prefer : How you feel this information can be useful to you as you negotiate with others. When your style is appropriate and inappropriate.
Describe methods used for fire cause determination : OM 2017 Command and Management - Describe methods used for fire cause determination and Critically review the attached fire investigation report in terms
Three factors make advertising appeals effective : Explain how these three factors (being meaningful, believable, and distinctive) make advertising appeals effective?

Reviews

Write a Review

Accounting Basics Questions & Answers

  What will do to the Ecuadorean banking system

Ecuador is currently dollarized: Bank accounts are denominated in U.S. dollars, for example. If Ecuadoreans believe rumors that the country is going to go.

  Togos purchased all the assets at the beginning of 2010 3

togos sandwich shop had the following long-term asset balances as of january 1 2012cost accumulated

  How much the mimi rightfully recover

Mimi had $40,000 in federal income taxes withheld in 2013. How much of the $16,000 will Mimi rightfully recover

  A scholarship fund is started on january 1 2000 with an

a scholarship fund is started on january 1 2000 with an initial deposit of 100000 in an account earning i2.08 with

  An individual from the marketing department of wholesale

draw a document flowchart to depict each of the following situations a an individual from the marketing department of

  What transfer price should be set for pepsi transferred

What transfer price should be set for Pepsi transferred from the soft drink division of PepsiCo to a PepsiCo restaurant such as Taco Bell

  Determine the unit contribution margin

Total fixed manufacturing and operating costs (per month) - 360,000, Determine the unit contribution margin. Determine the number of units

  Calculate the cost of the ending inventory and the cost of

yount company reports the following for the month of june. date explanation units unit cost total cost june 1 inventory

  Howell petroleum is considering a new project that

howell petroleum is considering a new project that complements its existing business. the machine required for the

  During 2013 its first year of operations hollis industries

during 2013 its first year of operations hollis industries recorded sales of 10600000 and experienced returns of

  What is a prepaid expense

What type of assets require adjusting entries to record depreciation?

  Null and alternative hypotheses used to test

For this assignment, we are interested in finding out whether participation in a creative writing course results in increased scores of a creativity assessment. For this part of the activity, you will be using the data file "Activity 4a.sav". In ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd