my assigned firm is sonic

Anonymous
timer Asked: Dec 1st, 2018

Question Description

For your assigned firm, download your financial statements into Excel:

1) create common-sized financial statements for Balance Sheet and Income Statement (25 pts)

2) Create a ratio analysis table with references to the appropriate cells: Note: you may use the attached template or create your own (50 pts)

The submitted worksheet, should have one tab for the common-sized income statement, one tab for the common-sized balance sheet, and one tab for the financial ratios

Name: Firm Name: For your assigned firm, download the balance sheet and income statement (see Tabs); compute the following ratios by referencing the cells. Repeat for each of the three (3) most current years. RATIO ANALYSIS SPREADSHEET Liquidity RATIOS: 1 Current Current Assets #DIV/0! Current Liabilities 2 Quick Current Assets - Inventory #DIV/0! Current Liabilities 3 Cash Ratio #DIV/0! Profitability RATIOS: Profitability (Earning Power) 4 Profit Margin Net Income #DIV/0! Sales 5 Return on Assets Net Income #DIV/0! Total Assets 6 Return on Equity #DIV/0! Asset Management RATIOS: 9 Inventory Turnover Cost of Goods Sold #DIV/0! Inventory 10 Average Days in Inventory 360 Inventory Turnover 11 Accounts Receivable Turnover 1 360 #DIV/0! #DIV/0! 12 Accounts Receivable Turn-Days 360 360 #DIV/0! Solvency (Debt) RATIOS: 13 Debt-to-Equity Total Debt #DIV/0! Total Equity 14 Times Interest Earned #DIV/0! 2 3 4
FIN 343 – MS Excel Assignment #1 Assignment: (1) For your assigned company and its competitor, create a common-sized balance sheet and income statement for the three most current years. NOTE: download or insert the actual financial statements. (2) For each item on the balance sheet and income statement, using MS Excel compute the percentage change between years 1 and 2; and years 2 and 3. (3) Discuss the trends observed. Discuss whether the firm is getting better or worse. (4) Upload your MS Excel Spreadsheet (one file) via Blackboard. Include your name and the company’s name on the spreadsheet. You name and company must be on the spreadsheet to receive any points. EXAMPLES of Common-sized Balance Sheet and Income Statement.
FIN 343 Helpful Hints for Excel Assignments 1) For Excel Assignment #1, view the YouTube video (Under Course Materials) on how to download an income statement from Yahoo Finance into Excel). You may get the financial statements from Yahoo!Finance or Bloomberg. Use the ratio template to "reference the cells" from the downloaded finance statements; For your assigned firm, download your financial statements into Excel:  Create common-sized financial statements for Balance Sheet and Income Statement (25 pts)  Create a financial ratio analysis table with references to the appropriate cells from your downloaded financial statements. Note: you may use the template provided or create your own (50 pts)  The submitted worksheet, should have one tab for the commonsized income statement, one tab for the common-sized balance sheet, and one tab for the financial ratios table. 2) For Excel #2, view the YouTube video (Under Course Materials) on how to compute average return and standard deviation from stock prices downloaded from Yahoo Finance. You may get stock price data from Yahoo!Finance or Bloomberg. Make sure your data is in descending order by date, as shown in the video. Also, view the YouTube video (Under Course Material) on how to create a multi-line “line chart” in Excel. For your assigned firm, using Excel, complete the following:  Download 5 years of monthly stock data;  Graph the stock price trend;  Compute standard deviation, arithmetic mean (average), and coefficient of variance (see risk and return lecture);  List the firm's beta and discuss its meaning.

This question has not been answered.

Create a free account to get help with this and any other question!

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors