Question

Answer ALL the questions. Show your calculations. The following data is taken from the financial statements...

Answer ALL the questions. Show your calculations.

The following data is taken from the financial statements of company Fairuz Sdn Bhd.

Based on the data below, calculate the following. Show all your calculations:

Sales

640,000

Cost of Goods Sold

380,000

Cash

30,000

Marketable Securities

40,000

Account Receivable

70,000

Inventory

150,000

Net Fixed Assets

300,000

Current Liabilities

120,000

Operating Expenses

25,000

Interest

    6,000

Notes Payable

70,000

Equities :

Ordinary Shares

Preference Shares

Retained Earnings

150,000

100,000

20,000

Tax

     40%

  1. Ratios:
  1. Current Ratio   
  2. Quick Ratio
  3. Net Working Capital   
  4. Average Collection Period (assume 365 days)
  5. Inventory Turnover
  6. Time Interest Earned
  7. Gross Profit Margin
  8. Net Profit Margin   
  9. Operating Profit Margin

                                                           

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the following selected financial information for Wilcox Corporation to answer questions 3-13. Show your calculations....
Use the following selected financial information for Wilcox Corporation to answer questions 3-13. Show your calculations. Wilcox Corporation Income Statement For the Year Ended December 31, 2015 Net sales                                              $2,870 Cost of goods sold                                 1,985 Gross profit                                         $   885 Operating expenses                                   620 Operating profit                                   $   265 Interest expense                                          40 Earnings before taxes                           $   225 Income tax expense                                    80 Net profit                                             $   145 Wilcox Corporation Balance Sheet December 31, 2015 Assets                                                            Liabilities and stockholders' equity...
Eleanor’s Computers is a retailer of computer products. Using the financial data provided, financial ratio calculations...
Eleanor’s Computers is a retailer of computer products. Using the financial data provided, financial ratio calculations for 2016. Advise management of any ratios that indicate potential problems and provide an explanation of possible causes of the problems. 2016 Current ratio 725,000/ 475,000 = 1.53X vs Industry Average 1.70X Quick ratio 400,000/475,000 = 0.84X vs Industry Average 0.95X Average collection period 275,000 – 1,500,000/ 365 days = 67 Days vs Industry Average 65 Day Inventory turnover 1,200,000/325,000 = 3.69X vs Industry...
please compare 2 companies 5 ratios and analysis which is better 2017 Brahim's Holdings Bhd BRAHIMS...
please compare 2 companies 5 ratios and analysis which is better 2017 Brahim's Holdings Bhd BRAHIMS (Malaysia)A Saudee Group Bhd SAUDEE (Malaysia)B Liquidity Current Ratio=Current Asset/Current Liability Current Assets 98,028.00 76,041.80 Current Liabilities 59,232.00 51,821.10 Current Ratio(times) 1.65 1.47 Quick Ratio=(Current Asset-Inventories)/ Current Liability Inventories 6,259.00 Quick Ratio(times) 1.55 0.74 Asset Management Inventory Turnover Ratio=Sales/Inventories Sales 291,563.00 133,510.70 Inventories 6,259.00 37,813.70 Inventory Turnover Ratio 46.58 3.53 Days Sales Outstanding=Account Receivables/Average Sales Per Day Receivables 63,138.00 Average Sales Per Day=Sale/365 798.80...
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $330,600 $260,000   Marketable securities 382,800 292,500   Accounts and notes receivable (net) 156,600 97,500   Inventories 957,000 701,500   Prepaid expenses 493,000 448,500   Total current assets $2,320,000 $1,800,000 Current liabilities:   Accounts and notes payable   (short-term) $336,400 $350,000   Accrued liabilities 243,600 150,000   Total current liabilities $580,000 $500,000 a. Determine for each year (1) the working capital, (2)...
Use the statements below to answer the questions that follow: Income Statement for the Year Ended,...
Use the statements below to answer the questions that follow: Income Statement for the Year Ended, December 31, 2017 Sales 150,000 Expenses Cost of Goods Sold 80,000 Operating Expenses 30,000 EBIT (aka Operating Profit) 40,000 Interest 8,000 Income Tax 13,000 Total Expenses 131,000 Net Operating Income 19,000 Other Income Gain on Sale of Equipment 10,000 Net income 29,000 Balance Sheet 31-Dec-17 31-Dec-16 Assets Current Assets Cash 95,000 78,000 Accounts Receivable 60,000 82,000 Finished Goods 25,000 50,000 Materials Inventory 110,000 80,000...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $646,800 $537,600   Marketable securities 748,900 604,800   Accounts and notes receivable (net) 306,300 201,600   Inventories 732,600 429,400   Prepaid expenses 377,400 274,600   Total current assets $2,812,000 $2,048,000 Current liabilities:   Accounts and notes payable   (short-term) $429,200 $448,000   Accrued liabilities 310,800 192,000   Total current liabilities $740,000 $640,000 a. Determine for each year (1) the...
The following data are taken from the balance sheet at the end of the current year....
The following data are taken from the balance sheet at the end of the current year. Determine the (a) working capital, (b) current ratio, and (c) quick/acid-test ratio. Present figures used in your computations. Round ratios to the nearest tenth. Accounts payable $145,000 Accounts receivable 110,000 Accrued liabilities 4,000 Cash 80,000 Income tax payable 10,000 Inventory 140,000 Marketable securities 250,000 Notes payable, short-term 85,000 Prepaid expenses 15,000
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $649,000 Cost of goods sold 363,000 Gross profit $286,000 Selling and administrative expense 100,000 Operating income $186,000 Interest expense 50,000 Income before tax $136,000 Income tax expense (40%) 54,400 Net income $81,600 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Cedar...
Return Ratios and Leverage The following selected data are taken from the financial statements of Cedar Industries: Sales revenue $642,000 Cost of goods sold 365,000 Gross profit $277,000 Selling and administrative expense 100,000 Operating income $177,000 Interest expense 50,000 Income before tax $127,000 Income tax expense (40%) 50,800 Net income $76,200 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Instructions a) Calculate the value or the ratio of items in the boxes b) Show your...
Instructions a) Calculate the value or the ratio of items in the boxes b) Show your work by specifiying the formula you used for each of these calculations. c) For $ values, no need to leave any decimals, e.g Gross Profit = $34,000. d) Leave ratios and percentages in 2 decimal place, e.g. TIE = 2.81; ROA = 4.83%; etc. Suggestion: calculate the yellow subtotals before going on to answer individual questions (e.g. the current assets, etc.). These are intermediate...