Assignment instructions are as follows:

$1.$ The company used for this project will be CAMPBELL SOUP CO $($CPB$).$

$2.$ Pull the Company$$s TWO most recent $10$Ks $($Annual Reports$)$ from the Edgar Database on the

SEC$$s website. $($www$.$sec$.$gov$/$edgar$/$searchedgar$/$companysearch$.$html$)$ The $10$K information

can also be found in the investor relations section of each company$$s website.

$3.$ What is downloaded from the SEC website will be very rough and poorly$$formatted$.$ Use the

information downloaded to create ONE Excel Workbook with $4$ tabs:

a$.$ Tab $1$: Income Statement for most recent three years.

b$.$ Tab $2$: Balance Sheet for most recent three years.

c$.$ Tab $3$: Statement of Cash Flows for most recent three years.

d$.$ Tab $4$: Ratio Analysis

$4.$ Financial Analysis:

a$.$ Using Excel formulas, calculate the subtotals and totals for each financial statement.

b$.$ Using Excel formulas, prepare a Horizontal Analysis for each financial statement by calculating

the Dollar Change and Percent Change between each year.

c$.$ Using Excel formulas, prepare a Vertical Analysis by calculating the Common Size Percents:

i$.$ Use Total Assets as the base amount for the Balance Sheet.

ii$.$ Use Sales as the base amount for the Income Statement.

iii. No Common Size Percents must be calculated for the Statement of Cash Flows.

d$.$ Using Excel formulas, calculate the following ratios for EACH of the three years presented:

i$.$ Current ratio

ii$.$ Acid$$test ratio

iii. Accounts receivable turnover $($for two most recent years only, not required for

third year$)$

iv$.$ Inventory turnover $($for two most recent years only, not required for third year$)$

v$.$ Days$$ sales uncollected

vi$.$ Total asset turnover $($for two most recent years only, not required for third year$)$

vii. Debt$$to$$equity ratio

viii. Profit Margin

ix$.$ Return on total assets $($for two most recent years only, not required for third year$)$

x$.$ Earnings per share $($may be obtained from $10$K$)$

$5.$ Save your Excel workbook as last name $\_$ Project $1.($For example: Koss$\_$Project$1.$xls$).$

$6.$ Upload the completed assignment to Canvas using the link provided.

GRADING RUBRIC:

FORMATTING $(10\%)$

Excel spreadsheets should be formatted and easy to read$/$follow$.$ This includes:

$$ Underlining totals and subtotals for financial statements. $($Total Assets, Total Liabilities,

Total Equity, Net Income, etc.$)$

$$ Consistency in formatting for dollar and percent cells. $($i$.$e$.$ if decimals are used, they

should be consistently. Are dollar signs used consistently?$)$

ACCURACY$/$COMPLETENESS $(22\mathrm{.}5\%)$

All required financial statements were included and were accurately pulled from the SEC

website. NOTE: Some students get confused due to different naming of the financial

statements. Ensure that the financial statements you have pulled include the information that

you would expect. For example, the Income Statement should include some version of

revenues less expenses equals net income. If you don$$t see revenues $($or sales$)$ and expenses,

then you probably have the wrong financial statements. Use what you know about the format

of the statements.

RATIOS $(22\mathrm{.}5\%)$

All required ratios were accurately calculated $($using Excel formulas$),$ unless impossible given the

information provided.

HORIZONTAL ANALYSIS $$ $$/\%$ Changes $(22\mathrm{.}5\%)$

All $ and $\%$ changes were accurately calculated $($using Excel formulas$)$ for the Balance Sheet,

Income Statement, and Statement of Cash Flows. Ensure that $ and $\%$ changes are appropriately

shown as positive or negative.

VERTICAL ANALYSIS $(22\mathrm{.}5\%)$

Vertical Analysis $($Common Size Percents$)$ were accurately calculated $($using Excel formulas$)$ for

Balance Sheet and Income Statement.