Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Choose your own publicly-traded company (which can include a B corporation that is publicly-traded). You can get the data from MSN Money at MSN Market

Choose your own publicly-traded company (which can include a B corporation that is publicly-traded). You can get the data from MSN Money at MSN Market Summary. To retrieve the data for your company, go to the Stocks area and enter the ticker symbol. Finally, choose Financials, and then the statement type.

Conduct your own analysis using this data:

  1. On the page that appears on the MSN Money website, click on the link for the income statement, and copy the data to a new Excel worksheet. Repeat for the balance sheet. You need only use only the last three years worth of data.
  2. Recreate the income statement and balance sheet. Each statement should be on a separate worksheet.
    1. Try to duplicate the formatting exactly (as displayed within the chapter).
    2. Reformat the data so that it is more readable.
    3. Insert formulas in place of the numbers where applicable.
    4. Be sure all the data is well labeled and presentable.
  3. On a third worksheet, create a statement of cash flows.
    1. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets.
    2. Confirm your information is accurate by comparing it to the available statement of cash flows.
    3. Using Excels outlining feature, create an outline on the statements of cash flows that, when collapsed, shows only the subtotals for each section.
  4. Submit a short narrative that discusses the steps you went through to complete this assignment, including a conclusion discussing your results. Embed the Excel statements into your narrative write-up. Cite your work in MLA format.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

9th Edition

73530700, 978-0073530703

More Books

Students also viewed these Finance questions