Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP WITH ALL THE BOLD FILL IN THE BLANK THANK YOU ! ! ! ! Excel Activity: Financial Statements, Cash Flow, and Taxes Laiho

PLEASE HELP WITH ALL THE BOLD FILL IN THE BLANK THANK YOU !!!!
image text in transcribed

Excel Activity: Financial Statements, Cash Flow, and Taxes Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Laiho Industries: Balance Sheets as of December 31 (thousands of dollars) Cash Accounts receivable Inventories Total current assets $ Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity 2021 106,632 99,734 36,550 242,916 66,301 309,217 $30,809 31,190 17,240 $79,239 78,467 $157,706 95,000 56,511 $151,511 $309,217 2020 $ 88,800 83,661 33,463 $205,924 42,639 $248,563 $22,890 22,750 , 940 $60,580 64,917 $125,497 85,000 38,066 $123,066 $248,563 Enter your answers in thousands. For example, an answer of $1 thousand should be entered as 1, not 1,000. Round your answers to the nearest whole number. Use a minus sign to enter negative values, if any. Sales for 2021 were $464, 150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 19% of net fixed assets, interest was $9,503,000, the corporate tax rate was 25%, and Laiho pays 48.25% of its net income as dividends. Given this information, construct the firm's 2021 income statement. Laiho Industries: Statement of Cash Flows for 2021 (thousands of dollars) 2021 Operating Activities Net income $ fill in the blank Depreciation and amortization: Increase in accounts payable: fill in the blank fill in the blank Increase in accruals: fill in the blank Increase in accounts receivable: fill in the blank Increase in inventories: fill in the blank Net cash provided by operating activities: $ fill in the blank Investing Activities Additions to property, plant, and equipment: $ fill in the blank $ fill in the blank Net cash used in investing activities: Financing Activities Increase in notes payable $ fill in the blank Increase in long-term debt fill in the blank Increase in common stock fill in the blank Payment of common dividends fill in the blank Net cash provided by financing activities $ fill in the blank Summary Net increase/decrease in cash Cash at the beginning of the year $ fill in the blank fill in the blank Cash at the end of the year $ fill in the blank Excel Activity: Financial Statements, Cash Flow, and Taxes Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Laiho Industries: Balance Sheets as of December 31 (thousands of dollars) Cash Accounts receivable Inventories Total current assets $ Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity 2021 106,632 99,734 36,550 242,916 66,301 309,217 $30,809 31,190 17,240 $79,239 78,467 $157,706 95,000 56,511 $151,511 $309,217 2020 $ 88,800 83,661 33,463 $205,924 42,639 $248,563 $22,890 22,750 , 940 $60,580 64,917 $125,497 85,000 38,066 $123,066 $248,563 Enter your answers in thousands. For example, an answer of $1 thousand should be entered as 1, not 1,000. Round your answers to the nearest whole number. Use a minus sign to enter negative values, if any. Sales for 2021 were $464, 150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 19% of net fixed assets, interest was $9,503,000, the corporate tax rate was 25%, and Laiho pays 48.25% of its net income as dividends. Given this information, construct the firm's 2021 income statement. Laiho Industries: Statement of Cash Flows for 2021 (thousands of dollars) 2021 Operating Activities Net income $ fill in the blank Depreciation and amortization: Increase in accounts payable: fill in the blank fill in the blank Increase in accruals: fill in the blank Increase in accounts receivable: fill in the blank Increase in inventories: fill in the blank Net cash provided by operating activities: $ fill in the blank Investing Activities Additions to property, plant, and equipment: $ fill in the blank $ fill in the blank Net cash used in investing activities: Financing Activities Increase in notes payable $ fill in the blank Increase in long-term debt fill in the blank Increase in common stock fill in the blank Payment of common dividends fill in the blank Net cash provided by financing activities $ fill in the blank Summary Net increase/decrease in cash Cash at the beginning of the year $ fill in the blank fill in the blank Cash at the end of the year $ fill in the blank

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Nurse Managers And Executives

Authors: Cheryl Jones, Steven A. Finkler, Christine T. Kovner, Jason Mose

5th Edition

ISBN: 0323415164, 9780323415163

More Books

Students also viewed these Finance questions