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
Basics of corporate finance

These questions will test you on your knowledge of finance.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

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.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

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.

  • Calculation of Descriptive Statistics using the Excel

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

  • 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.

  • 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