Purchase Solution

Financial Analysis using Excel (Big Company's Annual Sales data)

Not what you're looking for?

Ask Custom Question

Can you help me get started with this assignment?

You are the Controller/CFO and have been asked to prepare a chart of Big Company's Annual Sales data for insertion into the annual report. Design an appropriate presentation of the data. The data is contained in the attached file.

Selection of the type, format, and complexity of the graphical presentation is up to you.

However, my preference is for simple, non-complex, colorful and Bar Graphs.

The chart should be a stand-alone and not embedded. Don't use excel 2007.

** See ATTACHED file(s) for complete details **

Attachments
Purchase this Solution
Solution Summary

The expert uses of chart to represent financial data has been illustrated.

Solution Preview

** See ATTACHED file(s) for complete details **

Note: Two ...

Purchase this Solution
Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Financial Overview

    531861 Financial Overview Complete a financial analysis of McDonalds over the last two years (2009 and 2010) available in annual reports. Replace the numbers provided in the Excel file that is attached.

  • Financial Analysis of Landry's Restaurants

    This file contains a formatted MS Excel spreadsheet with financial analysis data, including a thorough ratio analysis for Landry's Restaurants.

  • Performance Measurement Calculations

    Then, I will proceed to create an excel file which will include Home Depot's Financial Statements (note that data will be included for 2009 and 2008, and you will be required to fill in the data for 2007) and a financial analysis of 2009 and 2008.

  • A Revised Income Statement, The Contribution Margin Approach

    in sales for company-owned restaurants using actual data from the 2010 Annual Report for McDonalds.

  • Analysis of annual reports and SEC filings

    Analyze the data in your selected organization's annual reports and SEC filings. In your analysis, be sure to address the following: I need 200 words for this section.

  • 3M and Dell Co.

    s=DELL&annual This solution is comprised of a detailed explanation to evaluate each firm's financial performance for the two most recent years available by (1) performing financial ratio analysis using Microsoft® Excel® Ratio Analysis Worksheet, (

  • Key financial information for Caribou Coffee and Fazer Group

    Caribou is more profitable using all three classic profitability measures: return on sales, return on assets and return on equity (see Excel attached).

  • Compute NPV and IRR

    Save yourself a big headache by not trying to incorporate other financial statement data exhibited in the case. Also, list your assumptions and build the spreadsheet by incorporating the assumption value cells into the spreadsheet.

  • Evaluating Target Corporation's Annual Report

    You can go to www.annualreports.com to retrieve Target's '06 and '07 reports Prepare a 1,750- to 2,100-word paper,that includes performance ratios based on the company's last two annual reports and data available on the company's Web site.

View More Related Solutions