Share
Explore BrainMass

Santanderio Inc.: Consolidated Financial Statements

Please assist showing the math. The below chart which is already completed attached is needed to complete.

SANTANDERIO INC.
1.This small New York Company is a distributor of special electronic lamps.

These lamps are purchased by laboratories and research centers throughout the country.

Retained Earnings, 12/31/2000 (Beg.Bal.) $41,000

Net Income $37,000

Paid in Capital (PIC) NONE

Dividends Paid $12,000

Show "Formulas" and "Math" for every answer hereunder:

Inventory =

Land =

A/P =

Total Liabilities =

Retained Earnings =

Common Stock =

Total L + OE =

2.Complete the Consolidated Balance Sheet of Santanderio Inc. for 2002 knowing the following:
Cash Increased by $2,000

Advertising Costs increased by $1,500

Short Term Debt decreased by $1,000

Accounts Receivable was reduced by $2,000

Show "Formulas" and "Math" for every answer hereunder:

Cash =

Advertising =

Short Term Debt =

Accounts Receivable =

Total Current Assets =

Total Prop., Plant & Equipment =

Total Current Liabilities =

Total Liabilities =

Total O/E =

3.Complete the Consolidated Balance Sheet of Santanderio Inc. for 2003 knowing the following:
The Company purchased merchandise during the year as follows:

Date Merchandise Item Price

January 6 400 $51.50

February 9 150 $53.00

June 14 200 $49.00

July 16 250 $50.00

September 22 300 $51.00

Beginning Inventory: 1,300 lamps (All lamps purchased at $50.00)

Ending Inventory: 1,100 lamps

The company uses FIFO for the inventory cost

Depreciation: The company purchased a machine in 2002 for $60,000

and uses the double declining balance depreciation method.

The depreciation is based on 5 years.

Cash Increased by $5,000

Accrued Compensation Increase by $ 700

Accounts Payable Increased by $4,000

Show "Formulas" and "Math" for every answer hereunder:

Cash =

Accrued Compensation =

Accounts Payable =

Merchandise Inventory (FIFO)

Beginning Inventory =

Available Inventory =

Sales =

COGS =

End Inventory =

Total Current Assets =

Depreciation (Double Declining Depreciation)

Book Value =

Year 1 (2002)=

Year 2 (2003)=

accumulated Depreciation (This year + prior years) =

Total Assets =

Total Current Liabilities =

L/T Debt =

Retained Earnings =

Total L + O/E =

4.Do an explicit trend analysis for:
(Your analysis must cover ALL three years)

Cash =

2001

2002

2003

Accounts Payable =

2001

2002

2003

Retained Earnings =

2001

2002

2003

Attachments

Solution Summary

This solution shows step-by-step data computations for Santanderio Inc.'s consolidated financial statements and also includes full explanations in a tutorial.

$2.19