FIN 320 Module Three Excel Assignment Rubric

Asked by bizgrad
Dated: 9th Mar'18 08:12 AM
Bounty offered: $32.00

FIN 320 Module Three Excel Assignment Rubric

This is the first of two Excel assignments you will complete in this course. Before you get started, be sure to watch the Yahoo! Finance and Investor Relations video. For this assignment, consider the stock you own in your TDAU thinkorswim portfolio. Choose one of the companies from your portfolio and use Yahoo! Financeto complete the following steps:

  1. Financial Reports

For the company you have selected, find the most recent annual balance sheet, annual income statement, and annual statement of cash flows.

Copy each of these three reports to its own worksheet within a single Excel file. The first worksheet should be titled 20XX Balance Sheet; the second, 20XX Income Statement; the third, 20XX Cash Flow. (Replace the XX with the appropriate year.) The image below illustrates the way the file should be set up.

  1. Stock Prices

Create a fourth worksheet within the same Excel file for historical stock prices. (You can name the worksheet Stock Prices.)

· On the Yahoo! Finance page for your company, click the Historical Prices link on the left-hand side. Find the stock prices for the most recent seven weekdaysin the Adj Close column. The Adj Close stock price is adjusted for dividends and stock splits. In your Excel file, enter thoseseven prices.

· On the Stock Prices worksheet, use an Excel formula to calculate the stock price’s rate of return over that seven-day period. To do this,

1. Subtract the stock price of the first day from the stock price of the last day.

2. Divide this amount by the stock price from the first day.

3. Multiply by 100 to get the rate of return.


3. Professionalism

Format the data on all worksheets so that the file has a neat and professional appearance.

4. References

At the bottom of each data tab in the spreadsheet, include a link and a properly formatted citation referencing the location of the data used.

Guidelines for Submission:Submit an Excel file that meets the criteria described in the prompt. Citations should be formatted according to APA style.

Instructor Feedback:This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information,review these instructions.

Critical Elements

Proficient (100%)

Not Evident (0%)

Value

Financial Reports

Includes annual balance sheet, annual income statement, and

Does not include annual balance sheet, annual income statement,

25

annual statement of cash flows for the company selected

and annual statement of cash flows for the company selected

Stock Prices

Accurately calculates the stock’s rate of return over the seven-day

Does not accurately calculate the stock’s rate of return over the

45

period

seven-day period

Professionalism

Formats data with a neat and professional appearance

Does not format data with a neat and professional appearance

15

References

Includes properly formatted APA-style citations and links with

Does not include properly formatted APA-style citations or

15

minor errors or no errors

includes citations and links with noticeable errors

Earned Total

100%

FIN 320 Module Three Excel Assignment Rubric
Answered by bizgrad
Expert Rating: 2375 Ratings
Dated: 9th Mar'18 08:12 AM
5 words and 1 attachment(s).
Tutorial Rating: Not Rated
Sold 0 times.
(preview of the tutorial; some sections have been intentionally blurred)
…Please…

attachments

FIN-320-Module-Three-Excel-Assignment-Rubric.xlsx (16.22 KB)
Preview of FIN-320-Module-Three-Excel-Assignment-Rubric.xlsx
netTotal     debtDeferred   non-currentIncome taxes     long-term       (Note   equity:Convertible preferred     001       share,   shares authorized;     issued       Class   common stock,     C       additional   capital, $0     value       shares   9,000,000, Class     Class       (Class A   Class B     C       value   $680 (Class     Class       C   and 687,348     Class       C