Burrows C Analysis

Balance Sheet                                                                                                         Income Statement                                        ($ in millions)                                                                                                                 ($ in millions)  Assets                                                         LIABILITIES                                                                                                               Cash & Marketable Securities   449.90       Accounts Payable         1,611.20                                  Revenue       28,681.10 Accounts Receivable               954.80       Salaries Payable                225.20                      Cost Of Goods Sold   20,768.80       Inventories                              3,645.20    Other Current Liabilities  1,118.80                       Gross Profit              7,912.30            Other Current Assets              116.60       Total…

($ in 000s) Cash and cash equivalents $247,286 Short-term investments 362,700 Accounts receivable 513,944 Inventory 468,738 Prepaid expenses (current) 92,259 Total current assets 1,684,927 Long-term receivables 119,800 Equipment (net)   Total assets   Notes payable (current) 40,116 Accounts payable 41,072 Accrued liabilities 430,772 Other current liabilities 190,604 Total current liabilities 702,564 Long-term debt 343,576 Total liabilities 1,046,140 Common stock 460,627 Retained earnings 1,000,000   1. Find Equipment (net) 2. Find Total Assests

Item Prior year Current year Accounts payable 8,109.00 7,758.00 Accounts receivable 6,059.00 6,782.00 Accruals 1,036.00 1,609.00 Cash ??? ??? Common Stock 11,891.00 11,189.00 COGS 12,683.00 18,018.00 Current portion long-term debt 4,980.00 4,993.00 Depreciation expense 2,500 2,813.00 Interest expense 733 417 Inventories 4,192.00 4,777.00 Long-term debt 13,329.00 13,523.00 Net fixed assets 50,636.00 54,376.00 Notes payable 4,329.00 9,999.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,278.00 29,801.00 Sales 35,119 47,221.00 Taxes 2,084 2,775 What is the firm's total change in cash from the prior year to the current year?

Item Prior year Current year Accounts payable 8,109.00 7,758.00 Accounts receivable 6,059.00 6,782.00 Accruals 1,036.00 1,609.00 Cash ??? ??? Common Stock 11,891.00 11,189.00 COGS 12,683.00 18,018.00 Current portion long-term debt 4,980.00 4,993.00 Depreciation expense 2,500 2,813.00 Interest expense 733 417 Inventories 4,192.00 4,777.00 Long-term debt 13,329.00 13,523.00 Net fixed assets 50,636.00 54,376.00 Notes payable 4,329.00 9,999.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,278.00 29,801.00 Sales 35,119 47,221.00 Taxes 2,084 2,775 What is the firm's cash flow from investing?

BALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS Cash & Marketable Securities LIABILITIES Revenue Cost Of Goods Sold 28,681. 10 Accounts Payable Salaries Payable 449.90 1,611.20 20,768.80 Accounts Receivable 954.80 225.20 Gross Profit 7.912.30 Inventories 3,645.20 Other Current Liabilities 1,118.80 Operating Expenses: Selling, General & Admin. Depreciation Operating income Other Current Assets Total Current Assets 116.60 5,166.50 Total Current Liabilities 2,955.20 5,980.80 Other Liabilities 693.40 307.30 1,688.90 1,129.70 2,348.40 (575.60) Machinery & Equipment Land 1,624.20 Total Liabilities 3,648.60 Buildings Depreciation Property, Plant & Equip. - Net Other Long Term Assets Total Long-Term Assets Interest SHAREHOLDER'S EQUITY Other Expense (Income) (13.10) 4,591.40 120.90 828.50 5.401.70 1,637.30 618.10 1,019.20 Common Stock Income Before Taxes Retained Earnings Total Shareholder's Equity Income Taxes 4,712.30 6,230.20 Net Income Total Assets 9,878.80 Total…

Item Prior year Current year Accounts payable 8,194.00 7,893.00 Accounts receivable 6,066.00 6,786.00 Accruals 977.00 1,572.00 Cash ??? ??? Common Stock 11,869.00 12,264.00 COGS 12,616.00 18,108.00 Current portion long-term debt 5,038.00 5,064.00 Depreciation expense 2,500 2,825.00 Interest expense 733 417 Inventories 4,145.00 4,778.00 Long-term debt 13,680.00 14,055.00 Net fixed assets 50,966.00 54,551.00 Notes payable 4,331.00 9,956.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,104.00 29,983.00 Sales 35,119 45,456.00 Taxes 2,084 2,775 What is the firm's net income in the current year?       . .

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

Category Prior Year Current Year Accounts payable 3,159.00 5,955.00 Accounts receivable 6,974.00 8,952.00 Accruals 5,771.00 6,100.00 Additional paid in capital 19,965.00 13,214.00 Cash ??? ??? Common Stock 2,850 2,850 COGS 22,509.00 18,563.00 Current portion long-term debt 500 500 Depreciation expense 1,044.00 984.00 Interest expense 1,285.00 1,168.00 Inventories 3,015.00 6,719.00 Long-term debt 16,894.00 22,766.00 Net fixed assets 75,882.00 73,989.00 Notes payable 4,022.00 6,500.00 Operating expenses (excl. depr.) 19,950 20,000 Retained earnings 35,811.00 34,391.00 Sales 46,360 45,993.00 Taxes 350 920 What is the firm's cash flow from operations? Submit Answer format: Number: Round to: 0 decimal places. unanswered not_submitted Attempts Remaining: Infinity

Item Prior year Current year Accounts payable 8,174.00 7,997.00 Accounts receivable 6,053.00 6,627.00 Accruals 985.00 1,669.00 Cash ??? ??? Common Stock 11,632.00 12,699.00 COGS 12,739.00 18,024.00 Current portion long-term debt 4,909.00 4,968.00 Depreciation expense 2,500 2,846.00 Interest expense 733 417 Inventories 4,157.00 4,806.00 Long-term debt 14,646.00 14,472.00 Net fixed assets 51,341.00 54,892.00 Notes payable 4,311.00 9,948.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,728.00 30,469.00 Sales 35,119 46,331.00 Taxes 2,084 2,775 What is the firm's cash flow from financing?

Required information [The following information applies to the questions displayed below.] Current Year ed Cash $ 11,500 Prior Year $ 14,200 Accounts receivable 61,500 27,000 Equipment, net Land Total assets 59,000 99,000 52,000 73,500 $ 231,000 $ 166,700 Express the items in common-size percents. Note: Round your percentage answers to one decimal place. Current Year Prior Year Cash % % ces Accounts receivable % % Equipment, net % % Land Total assets % % 0.0 % 0.0 %

need the calculation for debt to assets ratio, debt equity ratio, long-term debt to equity and times interest earned ratio. CURRENT ASSETS     Cash and cash equivalents  $ 5,910  $ 5,238 Marketable securities 406 503 Accounts receivable 10,888 9,645 Less: Allowance for credit losses (138) (93) Accounts receivable, net 10,750 9,552 Assets held for sale 1,197 0 Other current assets 1,953 1,810 Total Current Assets 20,216 17,103 Property, Plant and Equipment, Net 32,254 30,482 Operating Lease, Right-of-Use Asset 3,073 2,856 Goodwill 3,367 3,813 Intangible Assets, Net 2,274 2,167 Investments and Restricted Cash 25 24 Deferred Income Tax Assets 527 330 Other Non-Current Assets 672 1,082 Total Assets 62,408 57,857 Current Liabilities:     Current maturities of long-term debt, commercial paper and finance leases 2,623 3,420 Operating Lease, Liability, Current 560 538 Accounts payable 6,455 5,555 Accrued wages and withholdings 3,569 2,552…

Category Accounts payable Accounts receivable Accruals Additional paid in capital Cash Common Stock COGS Current portion long-term debt Depreciation expense Interest expense Inventories Long-term debt Net fixed assets Notes payable Operating expenses (excl. depr.) Retained earnings Sales Taxes Prior Year Current Year 3,106.00 5,972.00 6,919.00 8,940.00 5,691.00 6,099.00 20,212.00 13,343.00 ??? ??? 2,850 18,751.00 500 2,850 22,826.00 500 965.00 1,016.00 1,259.00 1,123.00 3,086.00 6,750.00 16,982.00 22,296.00 75,731.00 73,844.00 4,053.00 6,596.00 19,950 20,000 35,937.00 34,762.00 46,360 45,530.00 350 920 What is the firm's cash flow from operations? Submit Answer format: Number: Round to: 0 decimal places.

What is average payment period using balance sheet below? BALANCE SHEET   INCOME STATEMENT ($ in millions)   ($ in millions)               ASSETS     LIABILITIES     Revenue  28,681.10  Cash & Marketable Securities  449.90    Accounts Payable  1,611.20    Cost Of Goods Sold  20,768.80  Accounts Receivable  954.80    Salaries Payable  225.20      Gross Profit  7,912.30  Inventories  3,645.20    Other Current Liabilities  1,118.80        Other Current Assets  116.60    Total Current Liabilities  2,955.20    Operating Expenses:     Total Current Assets  5,166.50        Selling, General & Admin.  5,980.80        Other Liabilities  693.40    Depreciation  307.30  Machinery & Equipment  1,688.90          Operating income  1,624.20  Land  1,129.70      Total Liabilities  3,648.60        Buildings  2,348.40        Interest  -    Depreciation  (575.60)   SHAREHOLDER'S EQUITY     Other Expense (Income)  (13.10) Property, Plant & Equip. - Net…

# 3 Category. Prior Year Current Year Accounts payable 3,136.00 5,904.00 Accounts receivable 6,838.00 9,068.00 Accruals 5,663.00 6,026.00 Additional paid in capital 20,182.00 13,570.00 Cash ??? ??? Common Stock 2,850 2,850 COGS 22,844.00 18,591.00 Current portion long-term debt 500 500 Depreciation expense 955.00 1,036.00 Interest expense 1,275.00 1,169.00 Inventories 3,020.00 6,732.00 Long-term debt 16,947.00 22,144.00 Net fixed assets 75,056.00 74,173.00 Notes payable 4,022.00 6,569.00 Operating expenses (excl. depr.) 19,950 20,000 Retained earnings 35,957.00 34,753.00 Sales 46,360 45,431.00 Таxes 350 920 What is the firm's total change in cash from the prior year to the current year? Submit Answer format: Number: Round to: 0 decimal places.

At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Current Year 1 Year Ago $ 28,952 85,608 105,504 9,512 266,097 $ 33,842 61,019 78,261 9,153 245,029 $ 427,304 $ 495,673 $ 123,423 $ 70,770 Long-term notes payable Common stock, $10 par value Retained earnings 92,255 162,500 117,495 Total liabilities and equity $ 495,673 $ 427,304 99,263 163,500 93,771 For both the current year and one year ago, compute the following ratios: 2 Years Ago $ 35,979 49,426 52,128 4,038 225,529 $ 367,100 $ 49,426 81,940 162,500 73,234 $ 367,100 Exercise 17-7 (Algo) Analyzing liquidity LO P3 (1-a) Compute the current ratio for each of the three years. (1-b) Did the current ratio improve or worsen over the three-year period? (2-a) Compute the acid-test ratio for each of the three years. (2-b) Did the acid-test ratio improve or worsen over the three-year period? Complete this question by entering your…

Current Year Previous Year Current assets: Cash $532,000 $439,200 Marketable securities 616,000 494,100 Accounts and notes receivable (net) 252,000 164,700 Inventories 554,400 297,700 Prepaid expenses 285,600 190,300 Total current assets $2,240,000 $1,586,000 Current liabilities: Accounts and notes payable (short-term) $406,000 $427,000 Accrued liabilities 294,000 183,000 Total current liabilities $700,000 $610,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 1. Working capital $ 2. Current ratio 3. Quick ratio

Liabilities Liquid assets Monthly credit payments Monthly savings $ 8,800 $ 5,000 24668 $ 150 Net worth Current liabilities Take-home pay Gross income $ 59, 000 $ 1,350 $ 2,600 2,900 a. Debt ratio b. Current ratio

#2 Category. Prior Year Current Year Accounts payable 3,136.00 5,904.00 Accounts receivable 6,838.00 9,068.00 Accruals 5,663.00 6,026.00 Additional paid in capital 20,182.00 13,570.00 Cash ??? ??? Common Stock 2,850 2,850 COGS 22,844.00 18,591.00 Current portion long-term debt 500 500 Depreciation expense 955.00 1,036.00 Interest expense 1,275.00 1,169.00 Inventories 3,020.00 6,732.00 Long-term debt 16,947.00 22,144.00 Net fixed assets 75,056.00 74,173.00 Notes payable 4,022.00 6,569.00 Operating expenses (excl. depr.) 19,950 20,000 Retained earnings 35,957.00 34,753.00 Sales 46,360 45,431.00 Таxes 350 920 What is the firm's cash flow from investing? Submit Answer format: Number: Round to: 0 decimal places.

What is the financial performance summary for this balance sheet? BALANCE SHEET   INCOME STATEMENT ($ in millions)   ($ in millions)               ASSETS     LIABILITIES     Revenue  28,681.10  Cash & Marketable Securities  449.90    Accounts Payable  1,611.20    Cost Of Goods Sold  20,768.80  Accounts Receivable  954.80    Salaries Payable  225.20      Gross Profit  7,912.30  Inventories  3,645.20    Other Current Liabilities  1,118.80        Other Current Assets  116.60    Total Current Liabilities  2,955.20    Operating Expenses:     Total Current Assets  5,166.50        Selling, General & Admin.  5,980.80        Other Liabilities  693.40    Depreciation  307.30  Machinery & Equipment  1,688.90          Operating income  1,624.20  Land  1,129.70      Total Liabilities  3,648.60        Buildings  2,348.40        Interest  -    Depreciation  (575.60)   SHAREHOLDER'S EQUITY     Other Expense (Income)  (13.10) Property, Plant & Equip. - Net…

Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45.   20Y3 20Y2 20Y1 Accounts receivable, end of year $725,000   $650,000   $600,000   Sales on account 5,637,500   4,687,500       a.  For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year.   20Y3 20Y2 1.  Accounts receivable turnover         2.  Number of days' sales in receivables   days   days b.  The collection of accounts receivable has  . This can be seen in both the   in accounts receivable turnover and the   in the collection period.

Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45.   20Y3 20Y2 20Y1 Accounts receivable, end of year $725,000 $650,000 $600,000 Sales on account 5,637,500 4,687,500   a.  For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year.   20Y3   20Y2   1.  Accounts receivable turnover ?   ?   2.  Number of days' sales in receivables ? days ? days

6

Assets: Cash and marketable securities Accounts receivable Inventories Prepaid expenses Total current assets Fixed assets Balance Sheet 2,800,000 Less: accum. depr.(1,087,500) Net fixed assets Total assets Liabilities: Accounts payable Notes payable Accrued taxes Total current liabilities Long-term debt Owner's equity Total liabilities and owner's equity 2) Debt ratio. Income Statement $400,000 Net sales (all credit) 1,415,000 Less: Cost of goods sold Selling and administrative 1,847,500 expense 24,000 Depreciation expense 3,686,500 Interest expense Earnings before taxes Income taxes 1.712.500 Net income $5,399,000 $600,000 875,000 92,000 $1,567,000 900,000 2,932,000 $5,399,000 Based on the information in the above table, calculate the following ratios. 1) Current ratio. $6,375,000 (4,375,000) (1,000,000) (135,000) (100,000) $765,000 (306,000) $459,000