User Account

All Pages

Discuss vertical and horizontal analysis are important

Assignment Help Accounting Basics
Reference no: EM131755310

The company is "General Motors". If you are interested in this project, please accept.

Prepare a DRAFT financial analysis in Excel. The spreadsheet should include 4 worksheets as follows:

1. Company information
2. Income Statement
3. Balance Sheet

4. Financial statement ratios related to accounts specific to cost accounting for your corporation. Vertical and horizontal analysis are important, particularly for the income statement. Consider cost components. How are they changing from year to year? How is the balance sheet, especially stockholders' equity, changing? For example, ratios related to the three inventory accounts, calculation of cost of goods sold, different product line sales in relation to total sales, etc. Be creative and create meaningful cost accounting ratios to assist management's decision making.

a. Formulas must be embedded into the cells (preferable) or written beside the cells.

b. If you do not know how to create formulas in Excel, click the following link and take a free 40-50 minute training course offered by Microsoft

Reference no: EM131755310

Questions Cloud

Strengthen inter-organizational coordination : What could be done to strengthen inter-organizational coordination, both vertically and horizontally, based on the information obtained from lectures
Discuss together information to prepare a financial report : A fire has destroyed many of the financial records are WeBuild Associates. You are assigned to piece together information to prepare a financial report
Characterize level of horizontal and vertical integration : Characterize the level of horizontal and vertical integration observed, including their effect on specific outcomes.
Create an apa style formatted word document : Segmentation approach and rationale ?e.g., Demographic, geodemographic, behavioral, psychographic, etc.
Discuss vertical and horizontal analysis are important : Financial statement ratios related to accounts specific to cost accounting for your corporation. Vertical and horizontal analysis are important
Social manifesto-confronting cultures of injustice : This week's writing is one of your two manifestos-Confronting Cultures of Injustice. You will follow the guidelines provided below as you write your own 5-7
Describe strategic planning techniques : Describe strategic planning techniques used to formulate alternative strategies designed to achieve stated business goals.
Starting with an introduction and main point : Try starting with an introduction and main point (thesis statement), followed by the body of the paper which should include support paragraphs and wrap of the p
Discuss the adjustment on the financial statements : explain the impact of the adjustment on the financial statements

Reviews

Write a Review

Accounting Basics Questions & Answers

  Constructing a normal probability plot

Comparing data characteristics to theoretical properties. Constructing a normal probability plot. Constructing a histogram.

  Osborn construction company began operations january 2, 2013

Osborn Construction Company began operations January 2, 2013. During the year, Osborn entered into a contract with Redbeard Razor Corporation to construct a manufacturing facility.

  What amount should alpha company record

What amount should Alpha Company record the equipment purchase at if payment is made by July 11

  Compute an estimate of the ending balance of accounts

Compute an estimate of the ending balance of accounts receivable from customers that should appear in the ledger and any apparent shortages

  What is the yield today for 2-year treasury securities

If the pure expectations theory is correct, what is the yield today for 2-year Treasury securities?

  Marsden manufactures a cat food product called special

marsden manufactures a cat food product called special export. marsden currently has 10000 bags of special export on

  Question regarding monthly compounding

How much would you have to invest today at 12% annual interest, compounded monthly, in order to end up with $1,000 in your investment account at the end of 12 months?

  Computing materials price variance

In July the company purchased and used 22,500 pounds of direct material at an actual cost of $53,000; the materials quantity variance was $1,875 Unfavorable; and the standard quantity of materials allwed for July production was 21,750 pounds. What..

  Center corporation reported net sales of 200000 350000 and

center corporation reported net sales of 200000 350000 and 550000 in the years 2012 2013 and 2014 respectively. if 2012

  Money multiplier certificates

A leading broker has advertised money multiplier certificates that will triple your money in nine years; that is, if you buy one for $333.33 today, it will pay you $1,000 at the end of nine years. What rate of return will you earn on these money m..

  Why different pricing policies appropriate in circumstances

Explain why different pricing policies may be appropriate in different circumstances, illustrating your answer by reference to Leisure Furniture Ltd and Home Furniture Ltd

  Sugarland company sells a single product and anticipates

sugarland company sells a single product and anticipates opening a new facility in charlotte on may 1 of the current

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd