can you please provide me with the calculated metrics for the sample file using balance sheet and income satement.
this is all the information provided to me
Page of 2 thousands current year last year $5,566 654,542 23,191 85,656 90.412 859.367 $5,961 653 795 50,626 55,660 95 457 861499 2,701,329 75.871 2.777.200 2,482,532 34455 2516.987 $3.636.567 $3.378.486 4841_XYZ_Find_Transport_Corp Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Prepaid expenses Other current assets Total current assets Long term assets Property, Plant and Equipment (net) Other long term assets Total long term assets Total assets Liabilities Current liabilities Current portion of long term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities Long term liabilities Long term notes payable Deferred income taxes Other long term liabilities Total long term liabilities Total liabilities Stockholders' equity Common stock Additional paid in capital Other equity inc treasury stock Retained earnings Total stockholders' equity 340,332 87,865 104 220 532 417 250,000 325,838 98,513 96.719 771070 1,005.026 740 220 58.552 1803,798 683,539 659,793 59.561 1.402.893 $2,336 215 S2,173,963 1,671 268,728 (1,855,890) 2.885.843 1.300.352 1,671 247.641 (1,600,761) 2555.972 1.204.523 Total liabilities and stockholders' equity $3.636.567 $3.278.486 4841_XYZ Find Transport Corp thousands Retained earnings statement Retained eamings, 11 Add net income Less dividends paid Retained earnings 12/31 $2,555,972 427,235 97364 $2.885.843 Consolidated income statement Net sales Less cost of goods sold (without depreciation) Gross margin General and administrative expenses Other operating expenses Depreciation Operating income Interest income Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (rofund) Net income thousands $6,187,646 0 6,187,646 4,994,978 137,361 339.613 715,694 86 715,780 25,577 690,203 262.968 $427.235 Sampled firm #1 (If your firm does not have CGS, please read information on the payables turnover in Part 4.) Calculated metrics for Sampled firm #1 using balance sheet and income statement: working capital inventory turnover receivables turnover payables turnover cash cycle assets turnover ROA average income tax rate days' sales in inventory days' sales in receivables days' cost in payables average tax rate capital intensity ratio ROE 4841_XYZ Find Transport Corp thousands Retained earnings statement Retained earnings, 11 Add net income Less dividends paid Retained earnings 12/31 $2,555,972 427,235 97.364 $2.885.843 Consolidated income statement Net sales Less cost of goods sold (without depreciation) Gross margin General and administrative expenses Other operating expenses Depreciation Operating income Interest income Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (refund) Net income thousands $6,187,646 0 6,187,646 4,994,978 137,361 339.613 715,694 86 715,780 25,577 690,203 262.968 $427 235 4841_XYZ_Find Transport_Corp thousands current year last year Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Prepaid expenses Other current assets Total current assets $5,566 654,542 23,191 85,656 90.412 859.367 $5,961 653 795 50,626 55,660 95457 861499 Long term assets Property, Plant and Equipment (net) Other long term assets Total long term assets 2,701,329 75,871 2.777.200 2,482,532 34.455 2.516.987 Total assets $2.636.567 $3.3782486 Liabilities Current liabilities Current portion of long term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities 340,332 87,865 104,220 532 417 250,000 325,838 98,513 96 719 771.070 Long term liabilities Long term notes payable Deferred income taxes Other long term liabilities Total long term liabilities 1,005,026 740,220 58.552 1.803.798 683,539 659,793 59.561 1.402.893 Total liabilities $2,336,215 $2,173,963 Stockholders' equity Common stock Additional paid in capital Other equity inc treasury stock Retained earnings Total stockholders' equity 1,671 268,728 (1.855,890) 2.885.843 1.300.352 1,671 247,641 (1,600,761) 2.555.972 1.204.523 Total liabilities and stockholders' equity $3.636.567 $3.378.486 Page of 2 thousands current year last year $5,566 654,542 23,191 85,656 90.412 859.367 $5,961 653 795 50,626 55,660 95 457 861499 2,701,329 75.871 2.777.200 2,482,532 34455 2516.987 $3.636.567 $3.378.486 4841_XYZ_Find_Transport_Corp Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Prepaid expenses Other current assets Total current assets Long term assets Property, Plant and Equipment (net) Other long term assets Total long term assets Total assets Liabilities Current liabilities Current portion of long term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities Long term liabilities Long term notes payable Deferred income taxes Other long term liabilities Total long term liabilities Total liabilities Stockholders' equity Common stock Additional paid in capital Other equity inc treasury stock Retained earnings Total stockholders' equity 340,332 87,865 104 220 532 417 250,000 325,838 98,513 96.719 771070 1,005.026 740 220 58.552 1803,798 683,539 659,793 59.561 1.402.893 $2,336 215 S2,173,963 1,671 268,728 (1,855,890) 2.885.843 1.300.352 1,671 247.641 (1,600,761) 2555.972 1.204.523 Total liabilities and stockholders' equity $3.636.567 $3.278.486 4841_XYZ Find Transport Corp thousands Retained earnings statement Retained eamings, 11 Add net income Less dividends paid Retained earnings 12/31 $2,555,972 427,235 97364 $2.885.843 Consolidated income statement Net sales Less cost of goods sold (without depreciation) Gross margin General and administrative expenses Other operating expenses Depreciation Operating income Interest income Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (rofund) Net income thousands $6,187,646 0 6,187,646 4,994,978 137,361 339.613 715,694 86 715,780 25,577 690,203 262.968 $427.235 Sampled firm #1 (If your firm does not have CGS, please read information on the payables turnover in Part 4.) Calculated metrics for Sampled firm #1 using balance sheet and income statement: working capital inventory turnover receivables turnover payables turnover cash cycle assets turnover ROA average income tax rate days' sales in inventory days' sales in receivables days' cost in payables average tax rate capital intensity ratio ROE 4841_XYZ Find Transport Corp thousands Retained earnings statement Retained earnings, 11 Add net income Less dividends paid Retained earnings 12/31 $2,555,972 427,235 97.364 $2.885.843 Consolidated income statement Net sales Less cost of goods sold (without depreciation) Gross margin General and administrative expenses Other operating expenses Depreciation Operating income Interest income Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (refund) Net income thousands $6,187,646 0 6,187,646 4,994,978 137,361 339.613 715,694 86 715,780 25,577 690,203 262.968 $427 235 4841_XYZ_Find Transport_Corp thousands current year last year Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Prepaid expenses Other current assets Total current assets $5,566 654,542 23,191 85,656 90.412 859.367 $5,961 653 795 50,626 55,660 95457 861499 Long term assets Property, Plant and Equipment (net) Other long term assets Total long term assets 2,701,329 75,871 2.777.200 2,482,532 34.455 2.516.987 Total assets $2.636.567 $3.3782486 Liabilities Current liabilities Current portion of long term debt Accounts payable Accrued liabilities Other current liabilities Total current liabilities 340,332 87,865 104,220 532 417 250,000 325,838 98,513 96 719 771.070 Long term liabilities Long term notes payable Deferred income taxes Other long term liabilities Total long term liabilities 1,005,026 740,220 58.552 1.803.798 683,539 659,793 59.561 1.402.893 Total liabilities $2,336,215 $2,173,963 Stockholders' equity Common stock Additional paid in capital Other equity inc treasury stock Retained earnings Total stockholders' equity 1,671 268,728 (1.855,890) 2.885.843 1.300.352 1,671 247,641 (1,600,761) 2.555.972 1.204.523 Total liabilities and stockholders' equity $3.636.567 $3.378.486
