Loading
Home › Business Help › A firm's beta can be estimated from the slope of the char...
Status: Completed
 View Work

A firm's beta can be estimated from the slope of the characteristic line. The first step is to plot the return on the firm's stock (Y axis) vs. the return on a broad market index (X axis). Next, a regression line is estimated to find the slope. Go to finance.yahoo.com, enter the symbol for Citigroup Inc, and click on "Get Quotes". On the left-side menu, click on "Historical Prices", then enter starting and ending dates that correspond to the most recent two years. Select the "Daily" option. Save the data to a spreadsheet. Repeat the process to get comparable data for the S&P 500 Index (symbol ^GSPC). Download the data and copy it into the same spreadsheet as your firm's data with dates aligned. Sort the data from earliest to latest. Calculate the return on the stock and the return on the index for each day using the adjusted closing prices. Prepare an XY scatter plot with no line inserted. Be sure that the firm's returns represent the Y variable and the market's returns represent the X variable. Select one of the data points by pointing to it and clicking the left mouse button. While the point selected, right-click to pull up a shortcut menu. Select "Add Trendline", choose the linear type, then click on the Options tab and select "Display equation on chart". When you click on "OK" the trendline and the equation appear. The trendline represents the regression equation. What is the firm's beta? There is a follow up question as well. Can email picture

Date Posted: 10/03/2017
Category: Business
Due Date: 10/03/2017
Instruction
A firm's beta can be estimated from the slope of the characteristic line. The first step is to plot the return on the firm's stock (Y axis) vs. the return on a broad market index (X axis). Next, a regression line is estimated to find the slope.
Need the questions completed with data from Citigroup instead of Alcoa.
Questions found in upload
Attached
Download File 1 (jpg)
Tutor Uploads
No File uploaded yet.
Bidders
expert4u 8 years, 12 months ago
Rated 9.0 earned 77109.21 around 2331 assignments.
Please assign me this task and be assured of quality and timely work. 100% satisfaction guaranteed. Thanks in advance.
$60.00
  • How long would you need to complete? DUe later this afternoon
    User_11533 | Oct 03, 2017, 18:33 PM
  • this afternoon????? please by tomorrow morning for perfection
    expert4u | Oct 03, 2017, 18:35 PM
  • 100% satisfaction guaranteed. Thanks in advance.
    expert4u | Oct 03, 2017, 18:38 PM
  • Unfortuantly I have to have it turned in in 6 hours to get credit for the assignment.
    User_11533 | Oct 03, 2017, 18:42 PM
  • Am sorry please i love giving perfect work to my clients for treasure them so much. please next time please poet the assignment earlier. thanks for understanding.
    expert4u | Oct 03, 2017, 18:45 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
1stclasshonour 8 years, 12 months ago
Rated 9.22 earned 30856.96 around 773 assignments.
hi
$60.00
  • How long do you think it will take?
    User_11533 | Oct 03, 2017, 18:07 PM
  • utmost 12 hours , is that ok with you
    User_10376 | Oct 03, 2017, 18:20 PM
  • kindly assign me so that i can start working on it asap
    User_10376 | Oct 03, 2017, 18:22 PM
  • Unfortunatly it is due later this afternoon. cant complete myself due to me not having my computer with me and dont have access to excel on my tablet
    User_11533 | Oct 03, 2017, 18:22 PM
  • Unfortunatly it is due later this afternoon. cant complete myself due to me not having my computer with me and dont have access to excel on my tablet
    User_11533 | Oct 03, 2017, 18:22 PM
  • lo, dont worry , will assist you another time
    User_10376 | Oct 03, 2017, 18:23 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
phoniextutor 8 years, 12 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
I am an experienced writer, editor, and proofreader ready to help you write, edit and proofread your academic paper. If you are looking for someone with excellent research and writing skills, look no more because I will work over and above to deliver a high-quality paper that will exceed your expectations. I can guarantee you original, high quality and properly referenced papers delivered on time no matter how short the deadline Kindly reply me to discuss the details.
$70.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
harvardtutor 8 years, 12 months ago
Rated 8.93 earned 38096.91 around 1156 assignments.
Hello, am, one of the company's top writers and I am interested in working on your paper. I will ensure the delivery of a high quality product within given deadline. I have worked on similar papers in the past and I can assure you of an A grade paper. I am an excellent and experienced academic writer. I have been writing academic papers thus essays, course works, thesis, term papers, dissertations, research proposals among others for the last 4 years. I write plagiarism free work that has good grammar that flows. In addition all my work is attainable long before deadline. Upon keenly going through the work you have posted, I acknowledge that it is to the best of my knowledge and that I can have it done professionally; free of plagiarism, free of any grammatical mistakes. THIS IS EVIDENT BECAUSE I ALSO PROVIDE MY CLIENTS WITH A PLAGIARISM REPORT OF THE WORK. Moreover, it is attainable long before the deadline. Kindly allow me to work on it and am so sure you will love using me each and every time.
$55.00
  • Its not a paper. Its two excel questions
    User_11533 | Oct 03, 2017, 18:30 PM
  • Yeah i have looked at them. Please assign me them
    harvardtutor | Oct 03, 2017, 19:02 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
WBURO 8 years, 12 months ago
Rated 9.25 earned 75605.06 around 2167 assignments.
Hello, I assure to provide quality work that is free from plagiarism and in time, kindly consider my bid
$70.00
  • How long will it take to complete? Two excel questions due later tonight
    User_11533 | Oct 03, 2017, 18:49 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
accountspro 8 years, 12 months ago
Rated 9.03 earned 41229.00 around 1104 assignments.
Hello, I can complete this assignment for you. I have read and understood the requirements of the assignment and I guarantee excellent work. Kindly assign me and I won't disappoint. Thank you in advance
$60.00
  • Due in 5 hours. Willing to pay extra if it can be done before then. THanks for your help
    User_11533 | Nov 03, 2017, 00:46 AM
  • Have you finished the assignment?
    User_11533 | Dec 03, 2017, 17:42 PM
  • Hey, I wasn't online by the time you assigned me. By the time I saw it 5hrs had already elapsed so I was waiting for further instructions. So how much time do I have now??
    User_3964 | Dec 03, 2017, 17:46 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}