Question

The following are the financial statements of Chromium Ltd for the period ended 31 December 2014.

Statement of comprehensive income for Chromium Ltd for period ended 31 December 2014

Item	Amount (R)
Sales revenue	300 000
Cost of sales	195 000
Gross profit	105 000
Selling expenses	40 000
General and administration expenses	11 000
Depreciation	10 000
Total operating expenses	61 000
Profit before interest and taxes	44 000
Interest paid	12 000
Profit before taxes	32 000
Taxes (40%)	12 800
Profit after taxes	19 200

Statement of the financial position for Chromium Ltd as at 31 December 2014

Item	Amount (R)
Assets
Cash	1500
Accounts receivables	60 000
Inventory	95 000
Total current assets	156 500
Net non-current assets	150 000
Total assets	306 500
Liabilities and owners equity
Accounts payable	45 500
Notes payable	55 000
Short-term bank loans	5000
Total current liabilities	105 500
Long-term debt	55 000
Ordinary share capital	71 000
Retained earnings	75 000
Total shareholders equity	146 000
Total liabilities and shareholders equity	306 500

The following additional information relates to the firm's financial projections for the year 2015. Please read the additional information carefully.
• The firm's sales target for 2015 is R330 000
• Accounts receivable represent 20% of sales
• A minimum cash balance of R1 650 will be maintained
• Inventory represents 32% of sales
• Fixed asset outlays in 2015 will be R20 000 and the total depreciation expense for the year will be R15 000
• Accounts payable represent 15% of sales
• No long-term debt will be retired in 2015
• No ordinary shares will be repurchased in 2015
• The firm will pay dividends equal to 50% of its earnings after taxes

REQUIRED
You are a financial analyst representing a major credit company and have been requested to prepare a pro forma statement of comprehensive income and a statement of the financial position for the period ended 31 December 2015. Using the percent-of-sales method, prepare the pro forma statements for this company and discuss the resulting external financing required. Use the space provided below to conduct your preliminary calculations and fill in the templates provided below

Projected statement of comprehensive income for Chromium Ltd for the period ended 31 December 2015

ITEM	ITEM	Amount (R)
Sales
Cost of goods sold
Gross profit
Less Operating expenses
	Selling expenses
	General and administrative expenses
	Depreciation
Profit before interest and taxes
Interest paid
Profit before taxes
Taxes (40%)
Profit after taxes
Dividends paid
Accumulated profits for the year/retained earnings

Projected statement of financial position for Chromium Ltd as at 31 December 2015

ITEM	Amount (R)
ASSETS
Current assets
Cash
Accounts receivable
Inventory
Total current assets
Non-current assets
Net plant and equipment
Total non-current assets
Total assets
LIABILITIES AND OWNERS EQUITY
Current liabilities
Accounts payable
Notes payable
Short-term bank loans
Total current liabilities
Ordinary share capital
Retained earnings
Total shareholders equity
Long-term debt
External financing required (plug figure)
Total liabilities and shareholders equity

Answer 1

Answer:-

Projected statement of comprehensive income for Chromium Ltd for the period ended 31 December 2015

ITEM	AMOUNT (R)
Sales	330,000
Less: Cost of Goods Sold [65% of Sales]	214,500
Gross Profit [35% of sales]	115,500
Less: Operating Expenses
Selling Expenses*	44,000
General and Administration Expenses**	12,100
Depreciation	15,000
Profit before Interest and Taxes	44,400
Less:- Interest Expense	12,000
Profit before Tax	32,400
Less: Tax @ 40%	12,960
Profit after Tax	19,440
Less: Dividends paid [50% of Earnings after Tax]	9,720
Retained Earnings	9,720

• Selling Expenses and General & Administration Expenses together make 17% of sales in 2014 [(40000+11000)/300000].

* Selling Expenses in 2015 = 330000*17/100*40/51 = 44,000

** General & Administration Expenses in 2015 = 330000*17/100*11/51 = 12,100

• Interest Expense is taken as same as last year since no debt is retired.

Projected statement of comprehensive income for Chromium Ltd for the period ended 31 December 2015

ITEM	AMOUNT (R)
Assets
Current Assets:
Cash	1,650
Accounts Receivable [20% of sales]	66,000
Inventory [32% of sales]	105,600
Total Current Assets	173,250
Non-Current Assets:
Net Plant and Equipment [150000+20000-15000]	155,000
Total Non-Current Assets	155,000
TOTAL ASSETS	328,250
Liabilities & Owners Equity
Current Liabilities:
Accounts Payable [15% of sales]	49,500
Short Term Bank Loan	5,000
Notes Payable	55,000
Total Current Liabilities	109,500
Ordinary Share Capital	71,000
Retained Earnings [75000+9720]	84,720
Total Shareholders Equity	155,720
Long Term Debt	55,000
External Financing Required (Plug Figure)	8,030
TOTAL LIABILITIES AND SHAREHOLDRES EQUITY	328,250