Explore BrainMass
Share

Collins and Wilson Company Financial Analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1. Condensed data taken from the ledger of Collins Company at December 31, 2006, and 2007, are as follows:

2007 2006

Current assets $ 200,000 $ 180,000

Property, plant and equipment 450,000 400,000

Intangible assets 20,700 30,000

Current liabilities 70,000 80,000

Long-term liabilities 200,000 250,000

Common Stock 275,000 200,000

Retained Earnings 125,700 80,000

Prepare a comparative balance sheet, with horizontal analysis, for December 31. 2006 and 2007. (Round percents to one decimal point.)

2. Revenue and expense data for Wilson Company are as follows:

2006 2005

Administrative expenses $ 24,750 $ 18,000

Cost of goods sold 487,500 375,000

Income Tax 15,000 12,000

Net sales 750,000 600,000

Selling expenses 182,500 154,800

(a) Prepare a comparative income statement, with vertical analysis, stating each item for both 2006 and 2005 as a percent of sales.

(b) Comment upon the significant changes disclosed by the comparative income statement.

© BrainMass Inc. brainmass.com October 25, 2018, 4:36 am ad1c9bdddf
https://brainmass.com/business/financial-statements/collins-and-wilson-company-financial-analysis-385429

Solution Summary

1. Condensed data taken from the ledger of Collins Company at December 31, 2006, and 2007, are as follows:

2007 2006

Current assets $ 200,000 $ 180,000

Property, plant and equipment 450,000 400,000

Intangible assets 20,700 30,000

Current liabilities 70,000 80,000

Long-term liabilities 200,000 250,000

Common Stock 275,000 200,000

Retained Earnings 125,700 80,000

Prepare a comparative balance sheet, with horizontal analysis, for December 31. 2006 and 2007. (Round percents to one decimal point.)

2. Revenue and expense data for Wilson Company are as follows:

2006 2005

Administrative expenses $ 24,750 $ 18,000

Cost of goods sold 487,500 375,000

Income Tax 15,000 12,000

Net sales 750,000 600,000

Selling expenses 182,500 154,800

(a) Prepare a comparative income statement, with vertical analysis, stating each item for both 2006 and 2005 as a percent of sales.

(b) Comment upon the significant changes disclosed by the comparative income statement.

$2.19
See Also This Related BrainMass Solution

Deep financial statement analysis- Tech Data Corporation

I have to develop a deep financial statement analysis as described in the outline uploaded. I can provide information related to the company, the authorized source for obtaining the company financial statements are: Standard and Poor's, Moody, or SEC. or the one that I can provide sourced from my school database.

there has to be performed vertical and horizontal analysis, all calculations and tables are considered appendices, the explanations and interpretations of the results is what constitutes the responses

View Full Posting Details