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

Short Term Debt decreased by \$1,000

Accounts Receivable was reduced by \$2,000

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

Cash =

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

#### 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