Question

Take a look at this new companies projected balance sheet. Analyze and describe the health of...

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

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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.

Add a comment
Know the answer?
Add Answer to:
Take a look at this new companies projected balance sheet. Analyze and describe the health of...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Take a look at this companies balance sheet. Analyze and describe the health of the company....

    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...

    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    &nb...

    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...

  • Conduct a horizontal analysis (comparative analysis) for the balance sheets of Gian’s Italian Cuisine as of...

    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...

  • Balance sheet. Use the data from the financial statements of a company shown below. Use it...

    Balance sheet. Use the data from the financial statements of a company shown below. Use it to answer the 7 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign and place it in front of first digit of your answer when your answer is a negative number. Round to the nearest dollar. Income Statement year...

  • Balance Sheet: Use the following financial information to prepare a balance sheet: Burger Shack, Inc.; Balance...

    Balance Sheet: Use the following financial information to prepare a balance sheet: Burger Shack, Inc.; Balance Sheet Inventory 335,000 Accounts Receivable Accounts Payable 40.000 Buildings Furniture and Fixtures 16,000 Trademark Mortgage 325,000 Note Payable (6 month) Equipment and Vehicles 40,000 Retained Earnings Notes Receivable (3 month) 50,000 Land Common Stock (1,000,000 shares) 100,000 Cash Salaries Payable 90,000 192,000 110,000 20,000 150,000 113,000 40,000 15,000 Assets Current Assets Total Current Assets Fixed Assets Total Fixed Assets Intangible Assets Total Intangible Assets...

  • The following incomplete balance sheet for the Sanderson Manufacturing Company was prepared by the company's controller....

    The following incomplete balance sheet for the Sanderson Manufacturing Company was prepared by the company's controller. As accounting manager for Sanderson, you are attempting to reconstruct and revise the balance sheet. $ 1,750 4,500 (900) 6,500 1,700 13,550 SANDERSON MANUFACTURING COMPANY Balance Sheet At December 31, 2021 ($ in 000 s) Assets Current assets: Cash Accounts receivable Allowance for uncollectible accounts Finished goods inventory Prepaid expenses Total current assets Long-term assets: Investments Raw materials and work in process inventory Equipment...

  • Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments...

    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,...

    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...

  • Identify and Compute Net Operating Assets Following is the balance sheet for Lowe's Companies Inc. $511...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT