Take a look at this new companies projected balance sheet. Analyze and describe the health of the company.
|
2020 |
2021 |
2022 |
|
|
Cash |
$593,561 |
$674,051 |
$1,169,755 |
|
Accounts Receivable |
$54,538 |
$84,079 |
$138,615 |
|
Inventory |
|||
|
Other Current Assets |
$0 |
$0 |
|
|
Total Current Assets |
$648,098 |
$758,130 |
$1,308,369 |
|
Long-Term Assets |
|||
|
Accumulated Depreciation |
|||
|
Total Long-Term Assets |
|||
|
Total Assets |
$648,098 |
$758,130 |
$1,308,369 |
|
Accounts Payable |
$11,437 |
$57,239 |
$88,618 |
|
Income Taxes Payable |
$18,095 |
$5,556 |
$30,107 |
|
Sales Taxes Payable |
$11,537 |
$19,403 |
$31,988 |
|
Short-Term Debt |
$0 |
$0 |
$0 |
|
Prepaid Revenue |
|||
|
Total Current Liabilities |
$41,069 |
$82,198 |
$150,713 |
|
Long-Term Debt |
$20,000 |
$0 |
$0 |
|
Total Liabilities |
$61,069 |
$82,198 |
$150,713 |
|
Paid-In Capital |
$514,650 |
$514,650 |
$514,650 |
|
Retained Earnings |
$72,379 |
$161,282 |
|
|
Earnings |
$72,379 |
$88,903 |
$481,724 |
|
Total Owner's Equity |
$587,029 |
$675,932 |
$1,157,656 |
|
Total Liabilities & Equity |
$648,098 |
$758,130 |
$1,308,369 |
With the help of Financial Ratios, we can determine the health of the company:
1) Working Capital = Current Assets - Current Liabilities
For 2020, WC = 6,48,098- 41,069 = 6,07,029 $
For 2021, WC = 758130- 82198 = 6,75,932$
For 2022, WC = 1308369 - 150713 = 11,57,656$
The company has good working capital which means that the company will be able to pay the current obligations (bills, payroll, etc)
2) Current Ratio = Current Assets/ Current Liabilities
For 2020, CR = 648098/ 41069 = 15.78
For 2021, CR = 758130/ 82198 = 9.22
For 2022, CR = 1308369/ 150713 = 8.68
The current ratio, although decreasing over a period of time is quite high, which means the health of the company is okay
3) Debt to Equity Ratio = Total Liabilities / Total Shareholder's Equity
For 2020 , Debt to Equity Ratio = 61069/ 587029 = 0.10
For 2021, Debt to Equity Ratio = 82198/ 675932 = 0.12
For 2022, Debt to Equity Ratio = 150713/ 1157656 = 0.13
The Debt to Equity Ratio should always be low, so the health of the company is good. Although, the low ratio indicates that company is not taking advantage of increased profits, that is something which can be looked in to.
From these ratios, the health of the company looks good however the ratios Inventory Turnover Ratio, Receivable turnover ratio ,Payable Turnover Ratio and Asset Turnover Ratio gives a better indication of the health of the company, in this case it cannot be calculated since the value of Inventory and Net sales has not been specified directly.
Take a look at this new companies projected balance sheet. Analyze and describe the health of...
Take a look at this companies balance sheet. Analyze and describe the health of the company. 2020 2021 2022 Cash $625,025 $1,648,231 $3,697,402 Accounts Receivable $54,538 $84,079 $138,615 Inventory Other Current Assets $0 $0 Total Current Assets $679,562 $1,732,310 $3,836,016 Long-Term Assets Accumulated Depreciation Total Long-Term Assets Total Assets $679,562 $1,732,310 $3,836,016 Accounts Payable $8,815 $8,732 $8,649 Income Taxes Payable $24,912 $64,111 $126,782 Sales Taxes Payable $11,537 $19,403 $31,988 Short-Term Debt $0 $0 $0 Prepaid Revenue Total Current Liabilities $45,264...
Take a look at this companies cash flow statement. Analyze and describe the health of the company. 2020 2021 2022 Net Cash Flow from Operations Net Profit $99,648 $1,025,766 $2,028,534 Depreciation & Amortization $96,000 $96,000 Change in Accounts Receivable ($54,538) ($29,542) ($54,536) Change in Inventory Change in Accounts Payable $8,815 ($84) ($83) Change in Income Tax Payable $24,912 $39,199 $62,671 Change in Sales Tax Payable $11,537 $7,866 $12,585 Change in Prepaid Revenue Net Cash Flow from Operations $90,375 $1,139,206 $2,145,171...
Using the following balance sheet, prepare and analyze the common size balance sheet: Assets Liabilities and stockholders’ equity Current assets Current liabilities Cash 4 Accounts payable 28 Short term investments 9 Current portion of long term debt 12 Accounts receivable 32 Total current liabilities 40 Inventory 41 Prepaid expenses 2 Long term liabilities Deferred taxes, current 7 Long term debt 48 Total current assets 95 Total liabilities 88 Long term assets Stockholders equity Property & equipment 53 Common stock...
Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 640,000 530,000 2,280,000 220,000 $3,670,000 $ 440.000 830,000 2,400,000 $3,670,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $160,000; accounts receivable (net). $210,000; inventory, $235,000; and prepaid insurance, $35,000 b. Investments: investment in equity securities, short term,...
The data listed below are taken from a balance sheet of Trident Corporation at December 31, 2021. Required: 1. Determine the missing amounts. 2. Prepare Trident's classified balance sheet. Complete this question by entering your answers in the tabs below. Determine the missing amounts. (Enter the answers in thousands of dollars.) $ in One 241,286 356,700 507,944 86,259 1,624,927 113,800 Cash and cash equivalents Short-term investments Accounts receivable Inventory Prepaid expenses (current) Total current assets Long-term receivables Equipment (net) Total...
Conduct a horizontal analysis (comparative analysis) for the balance sheets of Gian’s Italian Cuisine as of November 30 and December 31, 2016. November December Current Assets: Cash 9,000 14,000 Accounts Receivable 10,000 11,500 Food Inventory 4,000 3,538 Beverage Inventory 6,000 3,950 Prepaid Rent 18,000 20,000 Total Current Assets Fixed Assets: Furniture, Fixture & Equipment (FF&E) 7,500 9,870 Accumulated Depreciation (FF&E) (3,030) (4,000) Building 20,000 20,000 Long term Investments 5,000 8,580 Long Term Assets 29,470 34,450 Total Assets Current...
Identify and Compute Net Operating Assets Following is the balance sheet for Lowe's Companies Inc. $511 218 LOWE'S COMPANIES INC. Consolidated Balance Sheet $ millions, except par value Feb. 1, 2019 Current assets Cash and cash equivalents Short-term investments Merchandise inventory_net Other current assets Total current assets Property, less accumulated depreciation Long-term investments Deferred income taxes-net Goodwill 12,561 938 14.228 18,432 256 294 303 Other assets 995 $34,508 $722 Total assets Current liabilities Short-term borrowings Current maturities of long-term debt...
1.) Use the Income Statement and Balance Sheet below to calculate the companies free cash flow. Income Statement 2017 Net Sales 675 Cost of goods sold 210 Depreciation 50 EBIT 415 Interest Paid 15 EBT 400 Taxes (30%) 120 Net Income 280 Dividends 105 Addition to Retained Earnings 175 Assets 2016 2017 Liabilities and Shareholders equity 2016 2017 Current Assets Current Liabilities Cash 100 125 Accounts Payable 200 250 Accounts Receivable 250 350 Notes Payable 150 225 Inventory 400 375...
Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 604,000 503,000 2,028,000 202,000 $3,337,000 $ 404,000 1,073,000 1,860,000 $3,337,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $151,000; accounts receivable (net), $201,000; inventory, $226,000; and prepaid insurance, $26,000. b. Investments: investment in equity securities, short term,...
1) Based on the balance sheet and income statement information
given below, calculate the following financial ratios and explain
briefly what the number you calculated means:
a) Current ratio
b) Acid-test ratio
c) Days in receivables
d) Debt ratio
e) Return on equity
Assets: Cash and marketable securities Accounts receivable Inventories Prepaid expenses Total current assets Fixed assets Less: accum. depr. Net fixed assets Total assets $600,000 900,000 1,500,000 75,000 $3,075,000 8,000,000 (2,075,000) $5,925,000 $9,000,000 Liabilities: Accounts payable Notes payable...