Question

In: Finance

Consider the balance sheets and selected data from the income statement of Keith Corporation that follow...

Consider the balance sheets and selected data from the income statement of Keith Corporation that follow LOADING.... Keith Corporation Balance Sheets December 31 Assets 2019 2018 Cash $ 1,470 $ 970 Marketable securities 1, 750 1 comma 150 Accounts receivable 1 comma 970 1 comma 770 Inventories 2 comma 880 2 comma 820 Total current assets $ 8 comma 070 $ 6 comma 710 Gross fixed assets $ 29 comma 460 $ 28 comma 100 Less: Accumulated depreciation 14 comma 650 13 comma 050 Net fixed assets $ 14 comma 810 $ 15 comma 050 Total assets $ 22 comma 880 $ 21 comma 760 Liabilities and Stockholders' Equity Accounts payable $ 1 comma 630 $ 1 comma 520 Notes payable 2 comma 820 2 comma 220 Accruals 210 320 Total current liabilities $ 4 comma 660 $ 4 comma 060 Long-term debt $ 4 comma 800 $ 4 comma 920 Total liabilities $ 9 comma 460 $ 8 comma 980 Common stock $ 10 comma 000 $ 10 comma 000 Retained earnings 3 comma 420 2 comma 780 Total stockholders' equity $ 13 comma 420 $ 12 comma 780 Total liabilities and stockholders' equity $ 22 comma 880 $ 21 comma 760 Income Statement Data (2019 ) Depreciation expense $ 1 comma 600 Earnings before interest and taxes (EBIT) 2 comma 710 Interest expense 369 Net profits after taxes 1 comma 849 Tax rate 21 % a. Calculate the firm's net operating profit after taxes (NOPAT) for the year ended December 31, 2019. b. Calculate the firm's operating cash flow (OCF) for the year ended December 31, 2019. c. Calculate the firm's free cash flow (FCF) for the year ended December 31, 2019. d. Interpret, compare and contrast your cash flow estimate in parts (b) and (c). Interpret, compare and contrast your cash flow estimate in parts (b) and (c). (Select all that apply.)

A. Depreciation is approximately the same size as net operating profit after tax, so the operating cash flow is about twice the NOPAT. B. Keith Corporation has negative cash flows from operating activities. C. Keith Corporation has positive cash flows from operating activities. D. The FCF value is very meaningful because it shows that the cash flows from operations are adequate to cover both operating expense plus investment in fixed and current assets. E. The OCF value is very meaningful because it shows that the cash flows from operations are adequate to cover both operating expense plus investment in fixed and current assets.

Solutions

Expert Solution

A. To calculate the firm's net operating profit after tax we must add back all non-operating expenses to the Profit after tax.

here we have only one such item, i.e. , interest expense.

Therefore, NOPAT = profit after tax + interest expense = 1849 + 369 = $ 2218

B. in order to calculate the firm's operating cash flow(OCF) we must add back all expenses that are non cash in nature to the NOPAT. (here only depriciation) as well as adjust for changes in working capital

first we calcuate changes in working capital

change in A/C receivables = 1170 - 1970 = -800

change in inventories = 2820 - 2880 = -60

change in current liabilites = -4060 - (-4660) = 600

Therefore, Operating cash flow = NOPAT + Depriciation + changes in working capital= 2218 +1600 + (-800 -60 +600)= $ 3558

C. To calculate Free Cash Flow(FCF) we must also include non-operating cash expenses as well as changes in fixed assets in the equation

subtracting interest expense from operating cash flow(OCF) and adding changes in gross fixed assets and gross fixed liabilities

FCF = OCF - interest expense = changes in fixed assets - changes in fixed liabilites = 3558 - 369 +(-1360) -(-120) = $ 1949

D. The difference between answers for b and c stem from the presence of interest expenditure as well as changes in fixed assets/liabilites which is non operational in nature. therefore, while it will not be considered for only operating cash flow and thus has to be added back to the profit it has to be considered and therefore must not be added back to the profit figure.

As far as the multiple choice is concerned from what we can observe.

option C and E are correct.

Also Please leave a like if you liked the answer.

friendly tip- next time please post the balance sheet and income statement in table format(it becomes easier to comprehend and hence, we may give a solution to your question must faster).


Related Solutions

The comparative balance sheets and an income statement for Raceway Corporation follow. Balance Sheets As of...
The comparative balance sheets and an income statement for Raceway Corporation follow. Balance Sheets As of December 31 Year 2 Year 1 Assets Cash $ 71,084 $ 41,770 Accounts receivable 30,368 22,270 Merchandise inventory 156,692 172,360 Prepaid rent 2,460 4,920 Equipment 260,140 287,240 Accumulated depreciation (148,440 ) (239,840 ) Land 192,720 80,320 Total assets $ 565,024 $ 369,040 Liabilities Accounts payable (inventory) $ 61,746 70,040 Salaries payable 33,367 28,600 Stockholders’ equity Common stock, $50 par value 251,500 198,500 Retained earnings...
The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow:
The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow:Marine CorporationBalance SheetAssets20182019Cash$45,000$50,000Marketable Securities175,000160,000Accounts Receivable240,000220,000Inventories230,000275,000Investments70,00055,000Total current assets$760,000$760,000Plant and Equipment1,300,0001,550,000Less Accumulated Amortization450,000600,000Net plant and Equipment$850,000$950,000Total Assets1,610,0001,710,000LIABILITIES AND SHAREHOLDERS’ EQUITYAccounts payable$110,000$85,000Notes payable65,00010,000Accrued Expenses30,0005,000Income Taxes Payable5,00010,000Bonds Payable (2016)800,000900,000Common Stock (100,000 shares)200,000200,000Retained Earnings400,000500,000Total Liabilities’ and Shareholders’ Equity$1,610,000$1,710,000Marine CorporationIncome StatementFor the Year Ended December 31, 2019Sales$ 5,500,000Less: Cost of Goods Sold4,200,000Gross Profit1,300,000Less: Selling, General & Administrative Expenses260,000Operating profit1,040,000Less: Amortization Expense150,000Earnings Before Interest and Taxes890,000Less: Interest Expense90,000Earnings Before Taxes800,000Less: Taxes (50%)400,000Net Income$...
Finding operating and free cash flows   Consider the balance sheets and selected data from the income...
Finding operating and free cash flows   Consider the balance sheets and selected data from the income statement of Keith Corporation that follow . a. Calculate the​ firm's net operating profit after taxes​ (NOPAT) for the year ended December​ 31, 20192019. b. Calculate the​ firm's operating cash flow​ (OCF) for the year ended December​ 31, 20192019. c. Calculate the​ firm's free cash flow​ (FCF) for the year ended December​ 31, 20192019. d.​ Interpret, compare and contrast your cash flow estimate in...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2008 2007 2006 Sales $ 61,471 $ 57,878 $ 51,271 Credit card revenues 1,896 1,612 1,349 Total revenues 63,367 59,490 52,620 Cost of sales 41,895 39,399 34,927 Selling, general and administrative expenses 13,704 12,819 11,185 Credit card expenses 837 707 776 Depreciation and amortization 1,659 1,496 1,409 Earnings before interest and income taxes 5,272 5,069 4,323 Net interest...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended ($ millions) 2006 2005 2004 Sales $ 51,271 $ 45,682 $ 40,928 Credit card revenues 1,349 1,157 1,097 Total revenues 52,620 46,839 42,025 Cost of sales 34,927 31,445 28,389 Selling, general and administrative expenses 11,185 9,797 8,657 Credit card expenses 776 737 722 Depreciation and amortization 1,409 1,259 1,098 Earnings before interest and income taxes 4,323 3,601 3,159 Net interest...
Rainbow Company’s income statement and comparative balance sheets follow.
  Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company’s income statement and comparative balance sheets follow. RAINBOW COMPANYIncome StatementFor Year Ended December 31, 2016   Sales   $750,000   Dividend Income   15,000   Total Revenue   765,000   Cost of Goods Sold $440,000     Wages and Other Operating Expenses 130,000     Depreciation Expense 39,000     Patent Amortization Expense 7,000     Interest Expense 13,000     Income Tax Expense 44,000     Loss on...
89) Following are selected data from the comparative income statement and balance sheet for Owens Corporation...
89) Following are selected data from the comparative income statement and balance sheet for Owens Corporation for the years ended December 31, 2014, and 2013: Selected Data                                    2014                      2013 Net sales (all on credit)                $96,000                $93,000 Cost of goods sold                           51,300                  52,500 Gross margin                                    44,700                  40,500 Income from operations                 16,300                  15,000 Interest expense                                 3,000                    3,500 Net income                                          9,800                    9,000 Cash                                                      2,700                    3,500 Accounts receivable, net                10,700                  12,500 Inventory                                           25,000                  30,000 Prepaid expenses                               1,000                       900 Total current assets                         39,400                  46,900 Total...
Condensed balance sheet and income statement data for Landwehr Corporation appear below. LANDWEHR CORPORATION Balance Sheets...
Condensed balance sheet and income statement data for Landwehr Corporation appear below. LANDWEHR CORPORATION Balance Sheets December 31 2018 2017 2016 Cash $ 25,000 $ 20,000 $ 18,000 Accounts receivable (net) 50,000 45,000 48,000 Other current assets 90,000 95,000 64,000 Investments 75,000 70,000 45,000 Plant and equipment (net) 400,000 370,000 358,000 Total Assets $640,000 $600,000 $533,000 Current liabilities $ 75,000 $ 80,000 $ 70,000 Long-term debt 80,000 85,000 50,000 Common stock, $10 par 340,000 310,000 300,000 Retained earnings 145,000 125,000...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing retailer in the high-end market) and TJX Companies (clothing retailer in the value-priced market). (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (example: 0.2345 = 23.5%). Income Statement ($ millions) ANF TJX Sales $3,469 $21,942 Cost of goods sold 1,257 Answer% 16,040 Answer% Gross profit 2,212...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing in the high-end market) and TJX Companies (clothing retailer in the value priced market), for the fiscal year ended January 30, 2016. (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (ex: 0.2345 = 23.5%) Income Statement ($ thousands) ANF TJX Sales $3,518,680 $30,944,938 Cost of goods...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT