View Single Post
  #12  
Old Wednesday, June 30, 2010
irum's Avatar
irum irum is offline
Senior Member
Qualifier: Awarded to those Members who cleared css written examination - Issue reason: CE 2008 - Roll no 0281
 
Join Date: Jul 2006
Location: Ajnabi Rastay
Posts: 198
Thanks: 136
Thanked 62 Times in 44 Posts
irum is on a distinguished road
Default Q # 3, Paper 1

Solution
Balance Sheet as of December 31 2007
Cash $30,000
marketable securities 25,000
Accounts Receivable 200000
Inventories 3,00,000
Current Assets 555000

Net fixed assets 9,45,000



Total Assets 1500,000

Accounts Payable $120,000
Bank Loan 2,06,875
Accruals 20,000
Current Liabilities 3,46,875
Long term debts 5,53,725
Common Stock and retained earnings 600,000
Total Liabilities and Equity 1500,000
(W-1) Inventory turnover ratio=6.0

Inventory turnover ratio= sales/average inventories
6.0= 1800, 000/ average inventories
Average inventories= 1800, 000 /6.0
Average inventories= 300,000

(W-2) Average collection Period=40 days
Average collection Period=Average Account Receivable * 360 days/ sales
40 days= Average Account Receivables*360/18, 00,000
18, 00,000*40/360 = Average Account Receivables
Avg. Account Receivables= 200,000

(W-3) Total Asset Turnover Ration=1.20
1.20= sales/Total Assets
Total Asset = sales/TAT
=18, 00,000/1.20
=15, 00,000

(W-4) Fixed assets= Total Asset- Current Asset
=15, 00,000-5, 55,000
=9, 45,000

(W-5) Current Ratio= Current asset/Current Liabilities
1.60 =5, 55, 000/CL
CL= 5, 55, 000/1.60
= 3, 46,875

(W-6) Total debt = C liabilities +Long term debts
900,000 =3, 46,875 + ?
Long term Debt = 900,000 -3, 46,875
553185

(W-7)Total debt can be find out as
Total debt= Total Liabilities and Equity- Common Stock and retained earnings
900,000 =1500, 000-600,000

(W-8) Bank Loan= Current liabilities - Accounts Payable- Accruals
206875 =3, 46,875- 120,000-20,000

Provided information in question no 3, PAPER-1, are not correct, the actual data comprises as under (SOURCE Financial Management by Gitman)
Complete the 2007 balance sheet for Premier Industries using the information that follows it.
Balance Sheet as of December 31 2007
Cash & marketable securities 55,000
Accounts Receivable
Inventories
Current Assets
Net fixed assets
Total Assets

Accounts payable $120,000
Bank Loan ?
Accruals 20,000
Current Liabilities ?
Long term debts ?
Common Stock and retained earnings 600,000
Total Liabilities and Equity ?

Last edited by irum; Wednesday, June 30, 2010 at 04:55 PM.
Reply With Quote
The Following User Says Thank You to irum For This Useful Post:
mianzahidiqbal (Sunday, October 24, 2010)