FIN320 Module Four Excel Assignment Rubric

Asked by bizgrad
Dated: 9th Mar'18 11:42 AM
Bounty offered: $22.00

FIN320 Module Four Excel Assignment Rubric

This assignment builds on the work you did for the Excel assignment in Module Three. To get started, find and open the file you submitted. From there, complete the following steps:

  1. Financial Data

Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to review for historical analysis. In all, your Excel file must include the following:

o Three worksheets of annual balance sheet data

o Three worksheets of annual income statement data

o Three worksheets of annual statement of cash flow data

Important Note:Be sure to label each worksheet in Excel with the appropriate year, as you did in the Module Three assignment.

  1. Ratio Calculation

On each data tab, use formulas to calculate the following financial indicators for each year of data:

o Current ratio

o Debt/equity ratio

o Free cash flow

o Earnings per share

o Price/earnings ratio

o Return on equity

o Net profit margin

  1. Written Responses

Using the Write Submission area of Blackboard for this part of the assignment, respond to the following:

o Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease? Why?

o Describe how three of the ratios you calculated for your company compare to the general industry. Find general industry data by entering your specific company’s ticker symbol here. If you are not familiar with the Write Submission feature, see the screen shot below.


4. Professionalism, References, and Mechanics

Format the data on all worksheets so that the file has a neat and professional appearance. Include links and properly formatted citations referencing the location of the data used. Your written responses should be free of errors in organization, grammar, and style.

Guidelines for Submission:Submit an Excel file that meets the criteria described in the prompt. The written responses should be done in the Write Submissionarea of Blackboard. 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

Exemplary (100%)

Proficient (85%)

Needs Improvement (55%)

Not Evident (0%)

Value

Financial Data

Meets “Proficient” criteria and

Includes three years of financial

Includes three years of financial

Does not include three years of

20

presents information in a well-

statement data (three annual

statement data (three annual

financial statement data (three

organized manner with clearly

balance sheets, three annual

balance sheets, three annual

annual balance sheets, three

labeled tabs and data sections

income statements, and three

income statements, and three

annual income statements, and

annual statements of cash flows)

annual statements of cash flows)

three annual statements of cash

for the company selected, with

for the company selected, with

flows) for the company selected

minor errors or no errors

noticeable errors

Ratio Calculation

Meets “Proficient” criteria and

Accurately calculates the

Calculates the financial indicators

Does not calculate the financial

40

presents information in a clear

financial indicators (current ratio,

(current ratio, debt/equity ratio,

indicators (current ratio,

and well-organized manner

debt/equity ratio, free cash flow,

free cash flow, earnings per

debt/equity ratio, free cash flow,

earnings per share,

share, price/earnings ratio,

earnings per share,

price/earnings ratio, return on

return on equity, and net profit

price/earnings ratio, return on

equity, and net profit margin),

margin), with noticeable errors

equity, and net profit margin)

with minor errors or no errors


Written Responses:

Meets “Proficient” criteria and

Describes how and why each of

Describes how and why each of

Does not describe how and why

15

Changes in Ratios

includes supporting details and

the ratios has changed over the

the ratios has changed over the

each of the ratios has changed

data

three-year period in a clear and

three-year period but presents

over the three-year period

logical manner

some information in an unclear

or illogical manner

Written Responses:

Meets “Proficient” criteria and

Describes how the selected

Describes how the selected

Does not describe how the

15

Comparison to Industry

includes supporting details and

ratios compare to the general

ratios compare to the general

selected ratios compare to the

data

industry in a clear and logical

industry but presents some

general industry

manner

information in an unclear or

illogical manner

Professionalism,

Meets “Proficient” criteria, and

Formats data with a neat and

Formats data and provides

Does not format data with a neat

10

References, and

the material is presented in an

professional appearance and

citations and links, but there are

and professional appearance or

Mechanics

especially polished and easy to

includes properly formatted

deficiencies in the appearance of

include properly formatted APA-

read format

APA-style citations and links with

the data and/or flaws in the

style citations and links; there

minor errors or no errors; any

citation formatting; there are

are major errors related to

errors related to organization,

some errors related to

organization, grammar, and style

grammar, and style are minor

organization, grammar, and style

Earned Total

100%

FIN320 Module Four Excel Assignment Rubric
Answered by bizgrad
Expert Rating: 2387 Ratings
Dated: 9th Mar'18 11:42 AM
5 words and 2 attachment(s).
Tutorial Rating: Not Rated
Sold 0 times.
(preview of the tutorial; some sections have been intentionally blurred)
…refer…

attachments

FIN320-Module-Four-Excel-Assignment-Rubric.xlsx (48.32 KB)
Preview of FIN320-Module-Four-Excel-Assignment-Rubric.xlsx
Financial     1   + 1     3       6T4   0 99T5     Working       Assets   liquid assets     to       the   T2 =     /       profitability   reflects the     and       =   Before Interest     /       operating   apart from     leveraging       operating   as being     long-term       Market   of Equity     Value       Adds   dimension that     up       as   possible red    
FIN320-Module-Four-Excel-Assignment-Rubric.docx (78.99 KB)
Preview of FIN320-Module-Four-Excel-Assignment-Rubric.docx
of     2013),   1974, pp     PolicyGoogle       dividend   its stock,     growth       is   investing all     profits       to   future gains     is       on   it requires     expenditure       Development   but to     dividend       Google   provided huge     to       past   on the     had       policy   not paying     but       its   reached $     has       dividend   is currently     to       In   it has     28%       profit   dividends (Morningstar,     is       has   to shape     of       Google   become essential     lives       has   financial with     margin       current   above 4     well       only   where Google     is       debt   its capital     will       reducing   cost of     on       after   demise of     is       innovative   in the     company       but   recent