Spooky Company's sales, current assets and current liabilities (all inthousands of pesos) have been reported as follows over the last five years(Year 5 is the most recent year):Year 5Year 4Year 3Year 2Year 1Sales..P5,625P5,400P4,950P4,725P4,500Current assets:Cash .Accounts receivable..Inventory ...P 72496P 88P 8040064P.84560432416.....896880816864800....Total current assets.. . PL.520PL.448P1,332P1,368P1.280Current liabilities.. . P 390P 318Р 324P 330Р 300Requirements:1. Express all of the asset, liability, and sales in trendpercentages. (Show percentages for each item.)Use Year 1 as the base year, and carrycomputations to one decimal place.2. Comment on the result of your analysis.

Name: Spooky Company's sales, current assets and current liabilities (all i
Uploaded: 2024-03-05T11:47:04.000Z
Channel: Bartleby
Description: Spooky Company's sales, current assets and current liabilities (all inthousands of pesos) have been reported as follows over the last five years(Year 5 is the most recent year):Year 5Year 4Year 3Year 2Year 1Sales..P5,625P5,400P4,950P4,725P4,500Curre

The financial statements prepared by the management may contain misstatements, and any other…

Business

Accounting

Spooky Company's sales, current assets and current liabilities (all in thousands of pesos) have been reported as follows over the last five years (Year 5 is the most recent year): Year 3 P4,950 Year 5 Year 4 Year 2 Year 1 Sales.. PS,625 P5.400 P4,725 P4,500 Current assets: P 72 496 P 84 P 88 P 80 ... P 560 896 64 Cash. Accounts receivable.. Inventory .... 432 416 400 .... 880 816 864 800 Total current assets.. PL.520 PL.448 P1.332 P1,368 P1.280 Current liabilities. P 390 P 318 P 324 P 330 P 300 Requirements: 1. Express all of the asset, liability, and sales in trend percentages. (Show percentages for each item.) Use Year 1 as the base year, and carry computations to one decimal place. 2. Comment on the result of your analysis.

Spooky Company's sales, current assets and current liabilities (all in thousands of pesos) have been reported as follows over the last five years (Year 5 is the most recent year): Year 3 P4,950 Year 5 Year 4 Year 2 Year 1 Sales.. PS,625 P5.400 P4,725 P4,500 Current assets: P 72 496 P 84 P 88 P 80 ... P 560 896 64 Cash. Accounts receivable.. Inventory .... 432 416 400 .... 880 816 864 800 Total current assets.. PL.520 PL.448 P1.332 P1,368 P1.280 Current liabilities. P 390 P 318 P 324 P 330 P 300 Requirements: 1. Express all of the asset, liability, and sales in trend percentages. (Show percentages for each item.) Use Year 1 as the base year, and carry computations to one decimal place. 2. Comment on the result of your analysis.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 4PB

See similar textbooks

Similar questions

Calculate the following for Co. XYZ: c. Average collection period (365 days) d. Times interest earned Assets: Cash and marketable securities $400,000Accounts receivable 1,415,000Inventories 1,847,500Prepaid expenses 24,000Total current assets $3,686,500Fixed assets 2,800,000Less: accumulated depreciation 1,087,500Net fixed assets $1,712,500Total assets $5,399,000Liabilities: Accounts payable $600,000Notes payable 875,000Accrued taxes Total current liabilities $1,567,000Long-term debt 900,000Owner's equity Total liabilities and owner's equity Co. XYZ Income Statement: Net sales (all credit) $6,375,000Less: Cost of goods sold 4,375,000Selling and administrative expense 1,000,500Depreciation expense 135,000Interest expense Earnings before taxes $765,000Income taxes Net income Common stock dividends $230,000Change in retained earnings
The following data were taken from the balance sheet of Albertini Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash Marketable securities Accounts and notes receivable (net) Inventories Prepaid expenses Total current assets Current liabilities: Accounts and notes payable (short-term) Accrued liabilities Total current liabilities. $620,500 718,500 294,000 749,800 386,200 $2,769,000 1. Working capital 2. Current ratio 3. Quick ratio b. The liquidity of Albertini has in current assets relative to current liabilities. $411,800 298,200 $710,000 $496,000 558,000 186,000 529,500 338,500 $2,108,000 $434,000 186,000 $620,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year from the preceding year to the current year. The working capital, current ratio, and quick ratio have all Most of these changes are the result of an
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current assets: Cash Marketable securities Accounts and notes receivable (net) Inventories Prepaid expenses Total current assets Current liabilities: Accounts and notes payable (short-term) Accrued liabilities Total current liabilities 1. Working capital 2. Current ratio 3. Quick ratio Current Year Current Year $347,700 402,600 164,700 603,900 311,100 $1,830,000 $353,800 256,200 $610,000 Previous Year $254,400 286,200 95,400 420,300 268,700 $1,325,000 Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. $371,000 159,000 $530,000 Previous Year
Motorola Credit Corporation's annual report: Net revenue (sales) Net earnings Total assets Total liabilities Total stockholders' equity a. Find the total debt to total assets ratio. Note: Round your answer to the nearest hundredth percent. Total debt to total assets Return on equity b. Find the return on equity ratio. Note: Round your answer to the nearest hundredth percent. (dollars in millions) $ 297 163 2,175 1,880 295 Asset turnover c. Find the asset turnover ratio. Note: Round your answer to the nearest cent. Profit margin % % % d. Find the profit margin ratio on net sales. Note: Round your answer to the nearest hundredth percent.
The Butler-Huron Company's balance sheet and income statement for last year are as follows: Balance Sheet (in Millions of Dollars) Assets Cash and marketable securities Accounts receivable* Inventories** Other current assets Total current assets Plant and equipment (net) Other assets Total assets $82 820 1,507 22 $2,431 3,967 6,460 $6,460 Liabilities and Equity Accounts payable****** Accrued liabilities (salaries and benefits) Other current liabilities Total current liabilities Long-term debt and other liabilities Earnings before taxes Taxes Earnings after taxes (net income) Common stock Retained earnings Net sales Cost of sales Selling, general, and administrative expenses Other expenses Total expenses Total stockholders' equity Total liabilities and equity **Assume that average inventory over the year was the same as ending inventory. ***Assume that average accounts payable are the same as ending accounts payable. Income Statement (in Millions of Dollars) *Assume that all sales are…
At the end of the current year, the entity reported the following financial data: Total Assets 1,200,000 Total assets turnover ratio 1.7x Fixed assets turnover ratio 2x Current ratio 2.5x Days Sales outstanding 30 days Inventory turnover ratio 4x Gross profit margin on sales 20% Note: Calcuation is based on a 365-day year. How much should be the accounts receivable balance?
Denna Company's working capltal accounts at the beginning of the year follow Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Accounts payable Notes due within one year Accrued liabilities $ 85,eee $ 25,600 S 386,000 $ 499, 000 S 18, See $ 227,000 $ 130,eee $ 73,500 During the year, Denna Company completed the following transactions: x. Paid a cash dividend previously declared, $45,000. a. Issued additional shares of common stock for cash. $230,000. b Sold inventory costing $82.000 for $115,000, on account c. Wrote off uncollectible accounts in the amount of $16,000, reducing the accounts recelvabie balance accordingly d. Declared a cash dividend, $45.000. e Paid accounts payable, $124,000. f Borrowed cash on a short-term note with the bank, $82,500 g. Sold inventory costing $19,500 for $13,000 cash. h. Purchased Inventory on account. $61.250. 1. Pald off all short-term notes due, $212,500. J. Purchased equipment for cash, $87,000. k. Sold marketable…
[The following information applies to questions displayed below. Simon Company's year-end balance sheets follow. Current Yr 1 Yr Ago 2 Yrs Ago At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets , net Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings liabilities and equity $ 31,224 89,900 115,000 10,055 277,807 $523,986 $ 36 , $ 37, 266 62,200 50,400 84,000 9,581 4,141 259,433 223,893 $ 451,712 $ 372,700 \$131 49,688 99, 494 162,500 130,215 $ 523,986 104,933 162,500 102,176 $ 451, 712 83, 190 162,500 77,322 , 700
Current Attempt in Progress XYZ provided the following financial information: XYZBalance SheetAs of 12/31/19 Assets: Liabilities and Equity: Cash and marketable securities $27,476 Accounts payable and accruals $154,860 Accounts receivable $143,519 Short-term notes payable $21,255 Inventory $212,379 Total current liabilities $176,115 Total current assets $383,374 Long term debt $155,510 Net plant and equipment $602,704 Total liabilities $331,625 Goodwill and other assets $42,422 Common stock $312,719 Retained earnings $384,156 Total assets $1,028,500 Total liabilities and equity $1,028,500 In addition, it was reported that the firm had a net income of: $158,402 and net sales of: $4,272,431 Calculate the following ratios for this firm (Use 365 days for calculation. Round answers to 2 decimal places, e.g.…
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 Marketable securities Accounts and notes receivable (net) Inventories Prepaid expenses Total current assets Current liabilities: Accounts and notes payable (short-term) Accrued liabilities Total current liabilities 1. Working capital 2. Current ratio $310,100 359,000 146,900 570,200 293,800 $1,680,000 3. Quick ratio $278,400 201,600 $480,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year $ $252,000 283,500 94,500 358,700 229,300 $1,218,000 $294,000 126,000 $420,000
help me
A.2 Starkey Company's sales, current assets, and current liabilities (all in thousands of dollars) have reported as follow over the last five years (Year 5 is the most recent year): Sales Current assets: Cash Accounts receivable Inventory Total current assets Current liabilities Required: Year 5 $5,625 $ Year 4 $5,400 64 $ 560 896 Year 3 Year 2 $4,950 $4,725 72 $ 84 496 880 $ 88 416 864 Year 1 $ 4,500 80 432 400 816 800 $ 1,332 $1,368 $ 1,280 300 $1,520 $1,448 $ 390 $ 318 $ 324 $ 330 $ 1. Express all of the asset, liability, and sales data in trend percentages. (Show percentages for each item.) Use Year 1 as the base year, and carry computations to one decimal place. 2. Comment the results of your analysis.