Answered step by step
Verified Expert Solution
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:
- 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.
- Recreate the income statement and balance sheet. Each statement should be on a separate worksheet.
- Try to duplicate the formatting exactly (as displayed within the chapter).
- Reformat the data so that it is more readable.
- Insert formulas in place of the numbers where applicable.
- Be sure all the data is well labeled and presentable.
- On a third worksheet, create a statement of cash flows.
- Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets.
- Confirm your information is accurate by comparing it to the available statement of cash flows.
- Using Excels outlining feature, create an outline on the statements of cash flows that, when collapsed, shows only the subtotals for each section.
- 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started