Project #30119 - Financial Accounting

  1. MY COMPANY: Dollar General

     

     

    Follow the example provided “financial ratio project demo.xlsx” and create an excel file including three worksheets: income statement, balance sheet, and ratios.

  2. please visit SEC EDGAR website

    http://www.sec.gov/edgar/searchedgar/companysearch.html

  3. Use fast search and type in the ticker symbol of your company provided in the company assignment excel file.

  4. Search filing type “10-k”

  5. Find the most recent 10-K form and click “interactive data”

  6. Copy the consolidated statement of income and consolidated balance sheet to the relevant worksheets of the excel file you created for this project.

  7. Reformat the income statement and balance sheet to ensure both financial statements are in good format.

  8. On the ratio worksheet, using the data from income statement and balance sheet calculate six major ratios given in the “financial ratio project demo.xlsx”

  9. Name your excel file as “financial ratio project-LastName.xlsx” for example “financial ratio project-Zhang.xlsx”

  10. Submit your excel file (no other file format will be accepted) to Sakai by the deadline

Grading:

  1. Copy income statement correctly including all necessary information and in good format

    ( 1 point)

  2. Copy balance sheet correctly including all necessary information and in good format (1

    point)

  3. Calculating all ratios correctly and shows original data from financial statement ( 7.5

    points, please see the demo excel file for detailed points allocation )

  4. Name excel file correctly (0.5 points)

  5. Total 10 points will be added to your highest exam grade

  6. Your instructor reserves the right to change the weight of extra credit, only to increase the

    weight, not to lower it. 

Subject Business
Due By (Pacific Time) 05/06/2014 12:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy