Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

0 Page
Managerial Accounting

...

Course

WMBA613

Subject

Finance

University

The Regents of the University of Michigan

Season

spring

260 Pages
Leadership In Several

Every G ood E ndea vor A LSO BY T IMOTHY K ELLER THE REASON FOR GOD: Belief in an Age of Skepticism THE PRODIGAL GOD: Recovering the Heart of the Christian Faith COUNTERFEIT GODS: The Emp ...

Course

WMBA613

Subject

Finance

University

The Regents of the University of Michigan

Season

spring

31 Pages
The Working Capital Management

LO 3 (i) Working Capital Management 1 A credit risk is the risk of default on a debt that may arise from a borrower failing to make required payments. 2 Credit risk assessment refers to the e ...

Course

GBUS514

Subject

Finance

University

Victoria University of Wellington

Season

Spring

12 Pages
Actual Operating Profit

Dear Expert, I have done this example for you to get to know what I am actually looking in terms of calculation for every small items in the task 1, task 2 and task 3 Releva ...

Course

GBUS514

Subject

Finance

University

Victoria University of Wellington

Season

Spring

COMM1503 Introduction to Quantitative Decision Making

Question

Answered

 

The Preparation

For this project, you will access YAHOO! Finance to get the stock prices of the Toyota Motor Corporation. On the YAHOO! Finance start page ), Enter “TM” (i.e., this is the stock ticker of Toyota Motor Corp.) in the search field, and click search. Then click on the Historical Data tab. You then need to set the Time Period from January 1st, 2006 up to December 31, 2018. Please select the ‘Monthly’ option for Frequency and ‘Historical Prices’ for Show, and then click Apply. Once the table appears, click on the Download Data link and save the data file, which will be in the .csv format (csv – comma separated values). Open the .csv file using Excel and save it as an .xlsx file using the Save As option.

Once you have brought the market prices (these are the company stock prices for each month for the thirteen years, i.e., 2006 - 2018) to Excel you are now ready to perform some operations on the imported data (20 points):

(Note: Please make sure you are doing the following operations in the .xlsx file)

1) Delete the “Adj Close” and “Volume” columns

2) Adjust the width of all columns to avoid displaying “####” error messages;

3) Align all columns to the left;

4) Make the table presentable using a professional table style;

5) Set cells that display prices to Currency format

6) Insert a header to the worksheet to indicate the name of the company and the date range for the stock prices (i.e., “Toyota Motor Corporation (TM) Stock Prices 2006 – 2018”).

7) Insert a footer to the worksheet to indicate the data source (i.e., “YAHOO! Finance”).

8) Sort the data based on the Date so that it starts with the January 2006 prices.

9) The table should have a title, i.e., “TM Stock Price Analysis 2006 – 2018” at the first row and columns neatly labeled.

10) Rename this worksheet to “Q1-Stock Price”

Hint: This table should appear in one worksheet.

 

The Task

Q1: (Still in the Q1-Stock Price worksheet) Calculate the average, minimum, maximum, and median of the open, high, low, and close stock prices for each month of the 13 years. (10 points)

· Average of (open, high, low, and close stock prices)

· Minimum of (open, high, low, and close stock prices)

· Maximum of (open, high, low, and close stock prices)

· Median of (open, high, low, and close stock prices)

Hint 1: It is all done in one table in one sheet. You simply need to create additional columns (one for average, one for median, etc.) and then, horizontally, calculate the stats for each row using Excel functions (for example, average of low, high, open, and close).

Hint 2: Now your table should include 9 columns (i.e., Date, Open, High, Low, Close, Average, Minimum, Maximum, Median) and 158 rows (the first row is table title, second row is column titles, rest of rows are data).

 

Q2: Create a pivot table in a new worksheet (rename the new worksheet as “Q2-Pivot Table & Chart”). The pivot table should display the stock values (average of close, average of open, average of high and average of low) for all years. Using the filtering option present on “Row Labels” column in the pivot table (Cell A3), select the years from 2011-2018. Then, on the PivotTable Fields panel, drag the ‘Date’ field and drop it to the Filter area. From the filter, which is now shown in the first row of the worksheet (above the pivot table), choose December. Change the number format of the pivot table to ‘Currency’ with two decimal places and displaying ‘$’ symbol. Create a line pivot chart from the pivot table. Put the pivot chart next to the pivot table. (15 points)

Hint 1: when you drag a field to the Values area of the PivotTable Fields, Excel calculates Sum by default. You need to change this to Average as appropriate.

Hint 2: The heading of the rows in the PivotTable should include the years (2011, 2012, …, 2018) and the heading of the columns should include Average of Open, Average of High, Average of Low and Average of Close.

 

Important Tips about the Pivot Table:

If you have a problem with finding the "Years" field in the pivot table's Field Pane, that this probably happens when you are using an older MS Excel version. In the latest version, Excel automatically performs time grouping in the pivot table. With time grouping, "relationships across time-related fields are automatically detected and grouped together when you add rows of time fields to your PivotTables. Once grouped together, you can drag the group (in this case Year) to your PivotTable and start your analysis." However, in the older versions, you may need to do the grouping manually. It is thus advisable to use most recent MS Excel. If you have to use an older version, here is a link that tells you how to do the manual grouping:

* If you still don’t see Years in the field panel, drag and drop Date to Rows. It should automatically create two new fields, Quarters and Years. Keep the Years in Rows, remove Quarters from Rows and move Date to Filter.

Here is a (very) short video from Prof. Soliman on how to create a pivot table in Excel: 

 

Q3: Copy the “Q2-Pivot Table & Chart” worksheet. Rename it as “Q3-Pivot Table & Chart”. In the worksheet, Q3-Pivot Table & Chart, remove the Date field from Filters area on PivotTable Fields. Using the filtering option in Cell A3, select all years (from 2006-2018). Comment on the updated pivot chart when compared to the pivot chart with only 2011-2018 stock prices. What could have happened to cause this dip in Toyota’s stock prices in 2008/2009? Type your answer in the same worksheet (i.e., Q3-Pivot Table & Chart) below the pivot table and pivot chart. Merge multiple cells to create a large textbox to put your answer in. You can do research on the Internet to help you figure what happened in 2008/2009 that significantly affect Toyota’s stock price

 

Q4: Visit Canada’s Greenest Employer website  which lists Canada’s Greenest 100 Employers and check the 2020 winners. You can see that Toyota Motor Manufacturing Canada Inc. / TMMC is listed among Canada’s top 100 employers for 2019. Click on the Toyota link and read about why they were selected (You might need scroll down to see the section). Visit Toyota’s webpage , see what efforts Toyota has made to improve sustainability. Based on the information you read, answer the question: Why do you think that Toyota deserves this Greenest Employer award? Create a new worksheet and rename it as “Q4-Toyota Sustainability Effort”. In this worksheet, merge multiple cells to create a large textbox to put your answer in. You answer should be 3-5 paragraphs long and should demonstrate your ability to gather and analyze qualitative information presented in corporate websites and other sources and arrive at a conclusion

COMM1503 Introduction to Quantitative Decision Making

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

84 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com boasts a team of talented and highly skilled coursework writers based in UK who assist students in the best possible manner. Students, who need coursework help, find our services fulfilling and effective because we provide high quality help at affordable price. So, students who often search can someone do my coursework cheap or can experts Write my coursework for cheap get perfect solution at MyAssignmenthelp.com. They pay for best coursework and get it from us.

More COMM1503 COMM1503 Introduction to Quantitative Decision Making: Questions & Answers

Q
icon

We aren't endorsed by this University

Managerial Accounting

...

View Answer
Q
icon

We aren't endorsed by this University

Leadership In Several

Every G ood E ndea vor A LSO BY T IMOTHY K ELLER THE REASON FOR GOD: Belief in an Age of Skepticism THE PRODIGAL GOD: Recovering the Heart of the Christian Faith COUNTERFEIT GODS: The Empty Promises of Money , Sex, and Power, and the Only Hope That Matters GENEROUS JUSTICE: How God ...

View Answer
Q
icon

We aren't endorsed by this University

The Working Capital Management

LO 3 (i) Working Capital Management 1 A credit risk is the risk of default on a debt that may arise from a borrower failing to make required payments. 2 Credit risk assessment refers to the evaluation of the borr ower’s ability to repay a loan. The financial position and trading histor ...

View Answer
Q
icon

We aren't endorsed by this University

Actual Operating Profit

Dear Expert, I have done this example for you to get to know what I am actually looking in terms of calculation for every small items in the task 1, task 2 and task 3 Relevant Example of Task 3 Bruno Ltd makes a standard product. Which is budgeted to sell at 16$ a un ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?