Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ACC 204 Managerial Accounting

tag 0 Download 1 Pages / 249 Words tag 17-06-2021

Question:

 Go back to the Table of Contents for the entire 10k.   What Item # are ALWAYS the Financial Statements in a 10k What page contains the Index for Notes to the financial StatementsGo to the index.What page does your Note about Segments begin on Go to that page. Skim through the Note until you find the tables that contain the financial data for the 5 segments you listed earlier.

  1. In an Excel spreadsheet, set up four column headings:  Division; Assets; Operating Income; Revenue. Input the 2016 data (use division name abbreviations).  (Do not include the total of all divisions.)Expand column widths as needed.  
  2. Use the “Number” section of the menu bar to format the data as “currency”(dollar signs and commas).  Use the “decimal remove” button to delete unnecessary decimals.
  3. Use “Format as a Table” or shadingto improve the visual look of your data table.  Play around with the different design options.
  4. Next, you will be adding a graph to visually display this data.  To do this, highlight the entire table.  Then click on the “insert” tab on the menu bar.  Then click on the “Column” Chart.  Choose an appropriate layout from those available.  Add a title to your chart.  Expand the chart size if needed.
  5. Add a textbox (“Insert” on menu bar; “Textbox”) and answer the following questions:
    1. Briefly describe the segments.   Give some examples of the products or describe geographical territory.
    2. Comment on the graph:   What stands out to you Add a new table somewhere below the first section.  The second data table should have the following column headings:  Division, ROI and Sales Margin.  “Copy”and “paste” the division names into the new table.
  1. For the first company division listed, insert formula commands to calculate ROI and Sales MarginTo insert formulas, highlight the cell where you want to place the answer.Then, for example, type in  “=B2/B3” to divide the figure in cell B2 by the figure in cell B3.
  1. Use the “Copy” and “Paste” commands to copy the same formulas into the appropriate cell for each division.
  2. Use the “%”on the “Number” section of the menu bar to format the ROI and Sales Margin as percentages.  
  3. Add a column graph that compares the ROI of each division. Add a title and size the graph as needed.  (Only the graph of the ROI is required.   You do NOT need to make graphs of the other ratios.)
  1. Add one textbox for EACH of the following:
    1. ROI:   

What does ROI tell management

Which divisions have the best and worst or are they roughly the same How do they compare.

How could a division of this company improve its ROI? Give me an example of a specific action that could be taken to improve ROI.

  1. Sales Margin:

What does Sales Margin tell management

Which divisions have the best and worst or are they roughly the same  How do they compare

How could a division of this company improve its sales margin? Give me an example of a specific action that could be taken to improve sales margin.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 1 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). ACC 204 Managerial Accounting. Retrieved from https://myassignmenthelp.com/free-samples/acc204-advanced-financial-accounting/asset-utilisation.html.

My Assignment Help (2021) ACC 204 Managerial Accounting [Online]. Available from: https://myassignmenthelp.com/free-samples/acc204-advanced-financial-accounting/asset-utilisation.html
[Accessed 01 February 2023].

My Assignment Help. 'ACC 204 Managerial Accounting' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/acc204-advanced-financial-accounting/asset-utilisation.html> accessed 01 February 2023.

My Assignment Help. ACC 204 Managerial Accounting [Internet]. My Assignment Help. 2021 [cited 01 February 2023]. Available from: https://myassignmenthelp.com/free-samples/acc204-advanced-financial-accounting/asset-utilisation.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.