The following ratios have been computed for Pina Colada Company for 2010.
Profit margin 20% (net profit/revenue)
Times interest earned 15 times (income before interest expense and income taxes/interest expense)
Receivables turnover 5 times (net credit sales/average net receivables)
Acid-test ratio 1.60 : 1 (marketable net cash + securities + receivables/current liabilities)
Debt to total assets ratio 26% (total debts/total assets)
Pina Colada Company’s 2010 financial statements with missing information follow:
PINA COLADA COMPANY
Comparative
December 31,
Assets 2010 2009
Cash P 25,000 P 35,000
Short-term Investments 15,000 15,000
Inventory ? (8) 50,000
Property, plant, and equipment (net) 200,000 150,000
Total assets P ? (9) P310,000
Liabilities and
Accounts payable P ? (7) P 25,000
Short-term notes payable 35,000 30,000
Bonds payable ? (10) 20,000
Common stock 200,000 200,000
Total liabilities and stockholders' equity P ? (11) P310,000
PINA COLADA COMPANY
Income Statement
For the Year Ended December 31, 2009
Net sales P250,000
Cost of goods sold 125,000
Gross profit 125,000
Expenses:
Administrative expenses 15,000
Selling expenses 10,000
Interest expense 5,000
Total expenses ________ (4)
Income before income taxes ________ (2)
Income tax expense ________ (3)
Net income ________ (1)
Use the above ratios and information from the Bea Cortes Company financial statements to fill in the missing information on the financial statements. Follow the sequence indicated. Show computations that support your answers.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images
- 4. A Company has Net Sales of 2,000,000 for 2020, Accounts Recitable for 500,000 in 2020, and Accounts Receivable of 350,000 in 2019. Calculate the Accounts Receivable Turnover Ratio.arrow_forward1 Condensed financial statements for Games Galore are summarized below: 2 3 Balance Sheet 4 Cash 5 Accounts Receivable, Net 6 Inventory 7 Prepaid Insurance 8 Total Current Assets 9 Property and Equipment, Net 10 Total Assets 11 12 Current Liabilities 13 Long-term Liabilities 14 Total Liabilities 15 Contributed Capital 16 Retained Earnings 17 Total Stockholders' Equity 18 Total Liabilities and Stockholders' Equity 19 20 Income Statement 21 Net Sales (all on account) 22 Cost of Goods Sold 23 Gross Profit 24 Operating Expenses 25 Income from Operations 26 Interest Expense 27 Income before Income Tax Expense 28 Income Tax Expense 29 Net Income 30 READY Attempt(s) Sheet1 $ $ $ $ B $ 2016 185,000 $ 80,000 104,000 11,900 380,900 514,500 895,400 $ 85,300 284,000 369,300 299,000 227,100 526,100 895,400 $ $ 3,031,000 1,949,000 1,082,000 891,400 $ 190,600 14,500 176,100 47,000 129,100 4 C 2015 143,000 59,000 134,000 5,880 341,880 407,000 748,880 96,800 224,000 320,800 299,000 129,080 428,080…arrow_forwardFollowing is an incomplete current-year income statement. Determine Net Sales, Cost of goods sold and Net Income. Additional information follows: Return on total assets is 16% (average total assets is $62,500). Inventory turnover is 5 (average inventory is $7,800). Accounts receivable turnover is 8 (average accounts receivable is $7,700). Income Statement Net Sales Cost of goods sold Selling, general, and administrative expenses 8800 Income tax expenses 3800 Net Incomearrow_forward
- Please help. Thanksarrow_forwardSuppose the 2022 financial statements of 3M Company report net sales of $23.1 billion. Accounts receivable (net) are $3.2 billion at the beginning of the year and $3.25 billion at the end of the year. Compute 3M’s accounts receivable turnover. - Accounts Recievable turnover ratio=? (times) Compute 3M’s average collection period for accounts receivable in days - Average collection period =? (days)arrow_forwardCentral Bank has the following information (in $million). 2017 ($ million) 2018 ($ million) Revenue 780 890 Net income 240 375 Assets 22,450 27,850 Equity 2,250 2,980 Which of the following statements about Central Bank is CORRECT? Select one: a. From 2017 to 2018, its Return on Equity decreased, Return on Assets decreased, and Leverage Multiplier increased. b. From 2017 to 2018, its Return on Equity increased, Return on Assets increased, and Leverage Multiplier decreased. c. From 2017 to 2018, its Return on Equity increased, Return on Assets increased, and Leverage Multiplier increased. d. From 2017 to 2018, its Return on Equity increased, Return on Assets decreased, and Leverage Multiplier increased.arrow_forward
- JPJ Corp has sales of $1.00 million, accounts receivable of $50,000, total assets of $5.00 million (of which $3.00 million are fixed assets), inventory of $150,000, and cost of goods sold of $600,000. What is JPJ's accounts receivable days? Fixed asset turnover? Total asset turnover? Inventory turnover? What is JPJ's accounts receivable days? JPJ's accounts receivable days are days. (Round to two decimal places)arrow_forwardFlounder Company has been operating for several years, and on December 31, 2017, presented the following balance sheet. FLOUNDER COMPANY BALANCE SHEET DECEMBER 31, 2017 Cash $20,900 Accounts payable $80,000 Receivables 117,000 Long-term notes payable 181,000 Inventory 75,000 Common stock (no par) 110,000 Plant assets (net) 354,000 Retained earnings 195,900 $566,900 $566,900 The net income for 2017 was $43,000. Assume that total assets are the same in 2016 and 2017.arrow_forwardThe Moraine Company has net income of $167,850. There are currently 32.65 days' sales in receivables. Total assets are $856,000, total receivables are $148,100, and the debt-equity ratio is .65. a. What is the company's profit margin? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. What is the company's total asset turnover? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. What is the company's ROE? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. a. Profit margin b. Total asset turnover c. ROE % times %arrow_forward
- please anwer all the questions i have mentioned below : - A company has the following items for the fiscal year 2020: Cash = 2 million Marketable securities = 3 million Account receivables (A/R) = 1.5 million Inventories = 8.5 million Total current liabilities = 8 million Calculate the company’s current ratio and quick ratio 2. Write the formula for the following ratios and what each ratio measures: Asset turnover Inventory Turnover and Days Inventory Receivable Collection Period 3. Write down the DuPont framework. How would you explain to your non-MBA non-Finance friend about the DuPont framework and why it is important?arrow_forwardThe Cullumber Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.) Cullumber Supply CompanyIncome Statement for the Fiscal Year Ended June 30, 2017($ thousands) % of Net Sales Net sales $2,111,000 enter percentages of net sales % Cost of goods sold 1,464,000 enter percentages of net sales % Selling and administrative expenses 312,200 enter percentages of net sales % Nonrecurring expenses 27,600 enter percentages of net sales % Earnings before interest, taxes, depreciation, and amortization (EBITDA) $307,200 enter percentages of net sales % Depreciation 117,000 enter percentages of net sales % Earnings before interest and taxes (EBIT) 190,200 enter percentages of net sales % Interest expense 118,600 enter percentages of net sales % Earnings before taxes (EBT)…arrow_forward2.The Moon Company had net income in 2022 of AED 40 million. Here are some of the financial ratios from the annual report. Return on Assets = 5% Debt Assets Ratio = 55% Profit Margin = 4.5% Inventory in days = 20 days Using these ratios, calculate the following for the Remal Company: a) Salesb) Total assetsc) Total asset turnover d) Total debte) Stockholders' equity f) Return on equityg) Inventoryarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education