Question

Perform a trend analysis for the years provided in their statements. Calculate as many of the...

  • Perform a trend analysis for the years provided in their statements.

  • Calculate as many of the following ratios as possible for each of the years provided in the financial statement.

Profitability ratios

  • Profit Margin
  • Return on Assets (Investment)

Return on Equity

  • Asset Utilization ratios
  • Receivable Turnover
  • Average Collection Period

Inventory Turnover

  • Fixed Asset Turnover
  • Total Asset Turnover

Liquidity ratios

  • Current Ratio
  • Quick Ratio

Debt Utilization ratios

  • Debt to Total Assets
  • Times Interest Earned
  • Fixed Charge Coverage
Breakdown 12/31/2019 12/31/2018 12/31/2017 12/31/2016
Assets
Current Assets
Cash
Cash and Cash Equivalents $1,466,000.00 $1,078,000.00 $1,185,000.00 $1,264,000.00
Short term Investments $37,000.00 $78,000.00 $0.00 $0.00
Total Cash $1,503,000.00 $1,156,000.00 $1,185,000.00 $1,264,000.00
Net Receivables $1,859,000.00 $1,235,000.00 $400,000.00 $311,000.00
Inventory $982,000.00 $845,000.00 $739,000.00 $751,000.00
Other Current Assets $0.00 $195,000.00 $188,000.00 $109,000.00
Total Current Assets $4,597,000.00 $3,540,000.00 $2,622,000.00 $2,530,000.00
Non-Current Assets
Property, plant & Equipment
Gross Property Plant & Equipment $1,473,000.00 $1,055,000.00 $1,001,000.00 $881,000.00
Accumulated Depreciation -$768,000.00 -$707,000.00 -$740,000.00 -$717,000.00
Net Property, Plant & Equipment $705,000.00 $348,000.00 $261,000.00 $164,000.00
Equity & Other Investments $58,000.00 $58,000.00 $58,000.00 $59,000.00
Goodwill $289,000.00 $289,000.00 $289,000.00 $289,000.00
Intangible Assets $210,000.00 $226,000.00 $239,000.00 $232,000.00
Other Long Term Assets $169,000.00 $95,000.00 $71,000.00 $47,000.00
Total Non-current Assets $1,431,000.00 $1,016,000.00 $918,000.00 $791,000.00
Total Assets $6,028,000.00 $4,556,000.00 $3,540,000.00 $3,321,000.00
Liabilities
Current Liabilities
Total Revenue $0.00 $136,000.00 $70,000.00 $0.00
Accounts Payable $988,000.00 $528,000.00 $384,000.00 $440,000.00
Accrued Liabilities $799,000.00 $499,000.00 $294,000.00 $251,000.00
Deferred Revenues $2,000.00 $0.00 $22,000.00 $63,000.00
Other Current Liabilities $29,000.00 $24,000.00 $57,000.00 $69,000.00
Total Current Liabilities $2,359,000.00 $1,984,000.00 $1,486,000.00 $1,346,000.00
Non Current liabilities
Long Term Debt $486,000.00 $1,114,000.00 $1,325,000.00 $1,435,000.00
other long term liabilities $157,000.00 $192,000.00 $118,000.00 $124,000.00
Total non-Current Liabilities $842,000.00 $1,306,000.00 $1,443,000.00 $1,559,000.00
Total Liabilities $3,201,000.00 $3,290,000.00 $2,929,000.00 $2,905,000.00
Stockholders Equity
Common Stock $12,000.00 $10,000.00 $9,000.00 $9,000.00
Retained Earnings -$7,095,000.00 -$7,436,000.00 -$7,760,000.00 -$7,803,000.00
Accumulated Other Comprehensive Income $0.00 -$8,000.00 $6,000.00 -$5,000.00
Total Stockholders Equity $2,827,000.00 $1,266,000.00 $611,000.00 $416,000.00
Total Liabilities and Stockholders Equity $6,028,000.00 $4,556,000.00 $3,540,000.00 $3,321,000.00
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

please note that as income statement was not provided , only below ratios could be calculated

current ratio current assets / current liabilities
2019 2018 2017 2016
Total Current Assets 4597000 3540000 2622000 2530000
Total Current Liabilities 2359000 1984000 1486000 1346000
current ratio 1.95 1.78 1.76 1.88
quick ratio (cash+receivables) / current liabilities
2019 2018 2017 2016
total cash 1503000 1156000 1185000 1264000
receivable 1859000 1235000 400000 311000
Total Current Liabilities 2359000 1984000 1486000 1346000
quick ratio 1.43 1.21 1.07 1.17
Debt to Total Assets total debt / total assets
2019 2018 2017 2016
long-term debt 486000 1114000 1325000 1435000
total assets 6028000 4556000 3540000 3321000
Debt to Total Assets 0.08 0.24 0.37 0.43
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for the Fiscal Year Ended July 31, 2017 Net sales $58,589 Cost of products sold 41,674 Gross profit $16,915 Selling, general, and administrative expenses 7,466 Depreciation 848 Operating income (loss) $8,601 Interest expense 519 Earnings (loss) before income taxes $8,082 Income taxes 2,829 Net earnings (loss) $5,253 Ivanhoe Corporation Balance Sheet as of July 31, 2017 Assets Liabilities and Stockholders’ Equity Cash and marketable securities...
Vertical Analysis of Balance Sheet Balance sheet data for a company for the years ended December...
Vertical Analysis of Balance Sheet Balance sheet data for a company for the years ended December 31, 20Y2 and 20Y1, are shown below. 20Y2 20Y1 Current assets $ 1,500,000 $ 1,200,000 Property, plant, and equipment 12,500,000 10,800,000 Intangible assets 2,000,000 2,000,000 Current liabilities 1,000,000 850,000 Long-term liabilities 3,000,000 2,400,000 Common stock 2,500,000 2,500,000 Retained earnings 9,500,000 8,250,000 Prepare a comparative balance sheet for 20Y2 and 20Y1, stating each asset as a percent of total assets and each liability and stockholders’...
Please calculate the following ratios: Current ratio debt to asset ratio quick ratio EXAMPLE COMPANY ASSETS...
Please calculate the following ratios: Current ratio debt to asset ratio quick ratio EXAMPLE COMPANY ASSETS LIABILITIES TOTAL CURRENT ASSETS=89,000 TOTAL CURRENT LIABILITIES = 61,000 INVESTMENT =36,000 TOTAL LONG TERM LIABILITIES = 420,000 PROPERTY,PLANT &EQUIP TOTAL LIABILITIES= 481,000 LAND = 5,500 STOCKHOLDERS EQUITY LAND IMPROVEMENTS = 6,500 COMMON STOCKS =110,000 BUILDINGS = 180,000 RETAINED EARNING = 220,000 EQUIPMENT = 201,000 ACCUM OTHER COMPREHENSIVE INCOME = 9,000 LESS: ACCUM DEPRECIATION = (56,000) LESS: TREASURY STOCK = (50,000) PROP,PLANT,EQUIP NET TOTAL= 337,000...
Common-Sized Balance Sheets The following end-of-the-year balance sheets (in millions) were adapted from recent financial statements...
Common-Sized Balance Sheets The following end-of-the-year balance sheets (in millions) were adapted from recent financial statements of Apple (AAPL). Year 1 Year 2 Current assets: Cash $13,844 $21,120 Marketable securities 11,233 20,481 Accounts receivable 27,219 30,343 Inventory 2,111 2,349 Other 14,124 15,085 Total current assets $68,531 $89,378 Long-term assets: Long-term marketable securities $130,162 $164,065 Property, plant, and equipment 20,624 22,471 Other long-term assets 12,522 14,565 Total long-term assets $163,308 $201,101 Total assets $231,839 $290,479 Current liabilities: Accounts payable and similar...
Do It! Review 2-1a Nash's Trading Post, LLC has collected the following information related to its...
Do It! Review 2-1a Nash's Trading Post, LLC has collected the following information related to its December 31, 2017, balance sheet. Accounts receivable $14,000 Equipment $170,000 Accumulated depreciation—equipment 45,000 Inventory 58,000 Cash 6,000 Supplies 5,000 Prepare the assets section of Nash's Trading Post, LLC’s balance sheet. (List current assets in order of liquidity.) Nash's Trading Post, LLC Balance Sheet (partial) For the Quarter Ended December 31, 2017December 31, 2017For the Year Ended December 31, 2017 Assets Current AssetsCurrent LiabilitiesIntangible AssetsLong-term...
Please construct a balance sheet for the following company for each year. Then calculate their debt-to-asset...
Please construct a balance sheet for the following company for each year. Then calculate their debt-to-asset ratios for each year. A) For December 31, 2010, the business had current assets of: $3,278 cash; $6,954 accounts receivable; $17,417 inventory. Plant and equipment totaled $144,500. Current liabilities were: accounts payable $9,250; wages payable $1,110; property and taxes payable $3,650. Long-term debt totaled $75,800; and owner's equity $82,339. B) For December 31, 2011, the business had current assets of: $1,844 cash, $11,807 accounts...
Seven metrics The following data were taken from the financial statements of Woodwork Enterprises Inc. for...
Seven metrics The following data were taken from the financial statements of Woodwork Enterprises Inc. for the current fiscal year. Assuming that there are no intangible assets. Property, plant, and equipment (net) $ 5,000,000 Liabilities: Current liabilities $ 400,000 Mortgage note payable, 5%, ten-year note issued two years ago 3,600,000 Total liabilities $4,000,000 Stockholders' equity: Preferred $1 stock, $10 par (no change during year) $1,000,000 Common stock, $5 par (no change during year) 2,000,000 Retained earnings: Balance, beginning of year...
Exercise 15-10 [Partially correct answer.] Your answer is partially correct. Try again. For a recent 2-year...
Exercise 15-10 [Partially correct answer.] Your answer is partially correct. Try again. For a recent 2-year period, the balance sheet of Buffalo Company showed the following stockholders’ equity data at December 31 (in millions). 2017 2016 Additional paid-in capital $ 960 $ 818 Common stock 669 663 Retained earnings 7,150 5,260 Treasury stock 1,900 900    Total stockholders’ equity $6,879 $5,841 Common stock shares issued 223 221 Common stock shares authorized 500 500 Treasury stock shares 38 25 (a) Answer the...
The condensed financial statements of Ness Company for the years 2019 and 2020 are presented below....
The condensed financial statements of Ness Company for the years 2019 and 2020 are presented below. Ness Company Balance Sheets December 31 (in thousands) 2020 2019 Current assets    Cash and cash equivalents $360 $320    Accounts receivable (net) 510 380    Inventory 430 420    Prepaid expenses 120 140       Total current assets 1,420 1,260 Property, plant, and equipment (net) 430 360 Investments 1 10 Intangibles and other assets 480 550       Total assets $2,331 $2,180 Current liabilities $870 $860 Long-term liabilities 411 270 Stockholders’...
The comparative statements of Blossom Company are presented here. BLOSSOM COMPANY Income Statements For the Years...
The comparative statements of Blossom Company are presented here. BLOSSOM COMPANY Income Statements For the Years Ended December 31 2022 2021 Net sales $1,512,400 $1,400,000 Cost of goods sold 847,000 804,800 Gross profit 665,400 595,200 Selling and administrative expenses 400,000 383,200 Income from operations 265,400 212,000 Other expenses and losses Interest expense 17,600 16,000 Income before income taxes 247,800 196,000 Income tax expense 74,340 58,800 Net income $ 173,460 $ 137,200 BLOSSOM COMPANY Balance Sheets December 31 Assets 2022 2021...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT