Explore BrainMass
Share

Balance sheet formation to know working capital requirements

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

Mars Electronics is a distributor for the Global Electric Company [GEC], a large manufacturer of electrical and electronics products for consumer and institutional markets. Below are the annual financial statements of the company for the last 2 years .

Income Statements

$ thousands
12 months Ending
6/30/1999 12 Months Ending
6/30/2000

Net sales $10,655 $11,720
Cost of goods sold 8,940 9,834

Selling, general & administrative expenses 1,554 1,677
Depreciation expenses 44 76

Interest expenses 62 70

Corporate income tax 23 26

Earnings after tax $32 $37

Dividends to be paid 5 1

Balance Sheets

$ thousands
6/30/1999 6/30/2000
Assets
Cash $160 $70
Accounts Receivable 1,953 5,100
Inventories 1,986 2,085
Prepaid expenses 380 25
Net fixed assets 733 830
Total $5,212 $8,110

Liabilities & owners' equity
Short-term debt $50 $50
Accounts Payable 1,450 $1,650
Accrued Expenses 398 138
Long Term Debt 800 3,700
Owners' Equity 2,514 2,572
Total $5,212 $8,110

a. Compute Mars Electronics Working Capital Requirement (WCR) on June 30th 1999, and on June 30th 2000. Compute also the collection period and the inventories turnover for the period 6/30/99 and 6/30/00.

Working Capital - A company's current assets minus its current liabilities - considered a good measure of both a company's efficiency and its financial health. Also known as "net working capital".

1999: Current Assets - Current Liabilities = 5212 - 733 = 4479 - 1898 = 2581
2000: CA - CL = 8110 - 830 = 7280 - 1838 = 5442

1999: AR Turnover = Net Credit Sales / Avg AR = 10655 / 1953 = 5.46
2000: 11720 / 5100 = 2.30

1999: Inventory Turnover = Sales / Inventory = 10655 / 1986 = 5.37
2000: 11720 / 2085 = 5.62

b. Prepare Mars Electronics' managerial balance sheet on June 30th 1999,and on June 30th 2000.

Just do ITEM B only a managerial balance sheet in excel

© BrainMass Inc. brainmass.com October 16, 2018, 5:35 pm ad1c9bdddf
https://brainmass.com/business/working-capital-management/balance-sheet-formation-working-capital-requirements-57515

Solution Preview

Mars Electronics is a distributor for the Global Electric Company [GEC], a large manufacturer of electrical and electronics products for consumer and institutional markets. Below are the annual financial statements of the company for the last 2 years .

Income Statements

$ thousands
12 months Ending
6/30/1999 12 Months Ending
6/30/2000

Net sales $10,655 $11,720
Cost of goods sold 8,940 9,834

Selling, general & administrative expenses 1,554 1,677
Depreciation ...

Solution Summary

This solution explains how to make balance sheet in an alternate format of an organization to find out working capital.

$2.19
Similar Posting

Capital Structure Discussion

Guidelines for the answer ( 5.1 to 5.11 need to be answered taking into consideration the guidelines given below

1. A Contents page showing clearly the page number and /contents of each page of your project.
2. An executive summary showing the most important findings and research which was covered in the discussion.
3. An introduction to your topic and how you have carried out your research.

4. The discussion of your topic with -footnotes of all your source of research and websites that you have accessed.
5. A conclusion page which summarizes all your findings clearly referring to the topic.
6. A Bibliography showing all the books, websites, that you might have visited .

5. Topic and Research Analysis ( Question to be answered based on Financial statements attached )

5.1 ldentify any company in the listed on a Stock Exchange.

5.2 Go to the company's website and print out the Financial Statements for the last two years.
(Income Statements and Balance Sheet)

5.3 Analyze the Financial Report and include the following in your analysis:

5.4 Determine the composition of the Equity of the company (Common stock,
Preferred stock and Bonds issued by the company.

5.5 Calculate the average cost of Equity of the company.

5.6 Determine the Dividend policy of the company.

5.7 What is your opinion regarding the financial risk the company's
management is prepared to take.

If the company's management is prepared to take risk, does it reflect in the Return on Equity? think the management is not taking adequate financial risks by having the
optimum financial structure for optimum returns.

5.8 Assuming this company wish to expand their operations and become a
global player in their industry, how in your opinion must this company
finance its operations to achieve the lowest weighted cost of capital as well
as achieve maximum return on capital.

5.9 Did the company's shareholders become wealthier or poorer over the last
financial period as a result of the financial policy of the company?

5.10 Did the Debt position improve or worsen during the last financial
period. If the debts did increase, did the Return on Equity increase or
decrease.

5.11 Write a paragraph (as part of your conclusion) of at least a typed?
page as your future predictions for this company based on your findings ,/
after you have made the above observations. Also recommend to the
Board of directors a future financial policy that the company

View Full Posting Details