Financial Statements, Cash Flow, and Taxes-ab6873

xlsx

School

Northern Arizona University *

*We aren’t endorsed by this school

Course

120

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

5

Uploaded by MegaResolve8522

Report
Financial Statements, Cash Flow, and Taxes Laiho Industries: Balance Sheets as of December 31 (in thousands of dollars) 2021 2020 Assets Cash $104,979 $91,530 Accounts receivable 104,651 86,523 Inventories 39,005 35,575 Total current assets $248,635 $213,628 Net fixed assets 69,223 44,014 Total assets $317,858 $257,642 Liabilities and equity Accounts payable $29,253 $21,190 Accruals 28,822 21,746 Notes payable 17,156 14,246 Total current liabilities $75,231 $57,182 Long-term debt 75,043 63,793 Total liabilities $150,274 $120,975 Common stock 105,500 93,000 Retained earnings 62,084 43,667 Total common equity $167,584 $136,667 Total liabilities and equity $317,858 $257,642 a. Constructing the firm's 2021 income statement Laiho Industries: financial information for 2021 (in thousands of dollars) Sales $464,150 EBITDA as a percentage of sales 15% Depr. as a % of fixed assets 19% Tax rate 25% Interest expense $9,019 Dividend payout ratio 48.25% A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
Laiho Industries: Income Statement for Year Ending December 31, 2021 (in thousands of dollars) 2021 Formulas Sales $464,150 =C31 394,528 =C41-C43 EBITDA $69,623 =C41*C32 Depreciation and amortization 13,152 =C11*C33 EBIT $56,470 =C43-C44 Interest 9,019 =C35 EBT $47,451 =C45-C46 Taxes (25%) 11,863 =C47*C34 Net Income $35,588 =C47-C48 Common dividends $17,171 =C49*0.4825 Addition to retained earnings $18,417 =C49-C51 b. Constructing the statement of stockholders' equity for the year ending Decemb and the 2021 statement of cash flows (in thousands of dollars) Retained Earnings Balances, December 31, 2020 $93,000 $43,667 Common stock issue 12,500 2021 Net income 35,588 Cash dividends -17,171 Addition to retained earnings Balances, December 31, 2021 $105,500 $62,084 Operating costs excluding depreciation and amortization Laiho Industries: Statement of Stockholders' Equity, December 31, 2021 Common Stock A B C D 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
(in thousands of dollars) Operating Activities 2021 Formulas Net income $35,588 =C49 Depreciation and amortization 13,152 =C44 Increase in accounts payable 8,063 =C15-D15 Increase in accruals 7,076 =C16-D16 Increase in accounts receivable -18,128 =-(C8-D8) Increase in inventories -3,430 =-(C9-D9) Net cash provided by operating activities $42,322 =SUM(C70:C75) Investing Activities Additions to property, plant, and equipment -$38,361 =-(C11-D11+C44) Net cash used in investing activities -$38,361 =C79 Financing Activities Increase in notes payable $2,910 =C17-D17 Increase in long-term debt 11,250 =C19-D19 Increase in common stock 12,500 =C21-D21 Payment of common dividends -17,171 =-C51 Net cash provided by financing activities $9,489 =SUM(C83:C86) Summary Net increase/decrease in cash $13,449 =C76+C80+C87 Cash at the beginning of the year 91,530 =D7 Cash at the end of the year $104,979 =C90+C91 c. Calculating 2020 and 2021 net operating working capital (NOWC) and 2021 free Excesss cash $0 $170,692 =(D10-0)-(D18-D17) $190,560 =(C10-0)-(C18-C17) -$2,724 =C45*(1-C34)+C44-( e. Calculating the firm's 2021 EVA After-tax cost of capital 10.5% $15,075 =C45*(1-C34)-(C17+ f. Calculating the firm's MVA at year-end 2021 Stock price $21 Shares outstanding 10,000 $42,416 =C105*C106-C23 Laiho Industries: Statement of Cash Flows for 2021 NOWC 2020 (in thousands of dollars) NOWC 2021 (in thousands of dollars) FCF 2021 (in thousands of dollars) EVA 2021 (in thousands of dollars) MVA 2021 (in thousands of dollars) A B C D 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ber 31, 2021, $136,667 =D21 12,500 =C65-C60 18,417 $167,584 =C21 Total Stockholders' Equity E F 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
e cash flow (FCF) (-C80+C97-C96) +C19+C23)*C101 E F 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107