Posted: July 19th, 2015

Excel Project ( Financial Statement )

Summary Balance Sheet, Statement of Cash Flows, and Income Statement (Use appropriate excel spreadsheet template tab).
Table of Financial Ratios (Use appropriate excel spreadsheet template tab)
Provide a basic analysis of the financial condition of the company.
Calculate comparable ratios for competing companies or the industry.
Compare the company�s ratios with the ratios of the competitors or industry.

Save the completed submission as a MS Excel document or as a PDF file. If you only have a Mac, you may use a campus computer to complete the assignment as an Excel document or you may save the document as a PDF.
All answers should adhere to sound grammar principles and have proper spelling, be written in complete sentences, have well-reasoned and supported arguments, and should look professional (consistent formatting, clear answers, etc.).
Double-check the rubricPreview the documentView in a new window to ensure you are abiding by the grading standard.

Instructions

Review the Financial Management rubricPreview the documentView in a new window to understand

more detailed expectations for this assignment.

Search the company�s website for an annual report or other source of financial information for the

company. Pay special attention to accessing the Balance Sheet, Statement of Cash Flows, and Income

Statement. Make sure you are using the most recent ANNUAL numbers (or the end of the fiscal year

for the Statement of Cash Flows).

Copy and Paste the financial statements into the appropriate worksheet within the Excel template

(use appropriate excel spreadsheet tab). Make sure the resulting document is easy to read and

understand (one piece of information per cell, columns are expanded to show all text and numbers,

etc.). Alternatively, you may download the financial statements as individual graphics, one per page.

Calculate the following financial ratios using formulas in Excel:

Current Ratio

Acid-test Ratio

Debt to owner�s equity Ratio

Return on sales

Return on equity

Note: It is important to use the formulas for the ratios in the Excel template. It will also help me to understand where potential

errors may have arisen.

 

Evaluate the above ratios based on the following:

Determine the normal levels for each ratio and compare them to the figures calculated. Can you

make assessments of the financial stability of this organization based on these ratios? How does this

information help to establish a clear picture of the business from a financial aspect? Make sure to be

detailed in your response.

 

Identify specific company competitors or locate industry-specific information for the appropriate

industry.

 

Identify specific company competitors or locate industry-specific information for the appropriate

industry.

Compare the financial performance of your company with the performance of its competitors or

industry.

Save the completed assignment file as �[company name] Financials.xls� (or �.xlsx� if using MS

Excel 2007 or 2010). Make sure to replace [company name] with your company�s real name

 

Do you want your assignment written by the best essay experts? Order now, for an amazing discount.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Live Chat+1-631-333-0101EmailWhatsApp