Purchase Solution

Microsoft Excel

Not what you're looking for?

Ask Custom Question

Using Microsoft Excel perform the following:

Presented below is financial information related to Vi-Gro Corporation for the year 2002. Unless otherwise stated, all balances are ending balances.

Vi-Gro Corporation had 88,000 shares of common stock outstanding for the entire year. Its effective income tax rate for state and federal income taxes combined is 35 percent.

Instructions
(a) Prepare a multiple-step income statement.
(b) Prepare a single-step income statement.
(c) Prepare a retained earnings statement.
(d) Prepare a classified balance sheet.

(e) Compute the following balance sheet relationships:
(1) current ratio.
(2) the amount of working capital.
(3) debt to total assets ratio.
What insights do these relationships provide to the reader of the financial statements?

(Please see attachment for table)

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Introduction to Finance

This quiz test introductory finance topics.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

View More Free Quizzes
Related BrainMass Solutions

  • Capabilities of Excel

    Microsoft Excel is a spreadsheet application available from the Microsoft Office suite of products. (Microsoft, 2011).

  • MS Excel and Quattro Pro Application

    It is usually bundled in Microsoft Office suite that also contains the famous word processing Microsoft Word and slide presentation editor Microsoft Powerpoint. The latest version of Microsoft Excel is the 2007 version.

  • Research software licensing in general

    This version offers every Office application: Microsoft Office Word 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, Microsoft Office Outlook 2007 with Business Contact Manager, Microsoft Office Access 2007, Microsoft Office Publisher

  • Hypothesis Tests in Excel

    TEST #2 -Extrinsic variable by Position Type -State the null and an alternate statement for the test -Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test.

  • Typical Seasonal Demand for Summer Highs

    Compute the standard deviation in Microsoft Excel using the data (raw data from years 1-4) 2. Generate a normal distribution of the data using Microsoft Excel. 3. Compare the range with the standard deviation of the data.

  • Calculation of Descriptive Statistics using the Excel

    This solution is comprised of a detailed explanation of descriptive statistics using the Microsoft Excel.

  • PERT, CPM, Gantt, Work Breakdown Structures

    Cost calculations can be used by utilizing Microsoft Excel. Cost analysis can be also done by utilizing Microsoft Excel.

  • Antitrust claim against Microsoft

    The actions taken by Microsoft were required to excel in a competitive marketplace.

  • Interview one in business or research who uses Microsoft

    491829 Using Microsoft Excel, Word and Powerpoint Please help with the following posting. Interview someone who works in business or research on the Internet about the use of Microsoft Excel, Word, and PowerPoint in their business.

  • Frequency Distribution and a Z-scores using Microsoft Excel

    368240 Generate a Frequency Distribution and a Z-scores using Microsoft Excel How to Generate a Frequency Distribution and a Z-scores using Microsoft Excel?

View More Related Solutions