Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make an estimated cash flow statement for period 2 using the below income statement and partial balance sheet, as well as the following info: -Capital

image text in transcribedimage text in transcribedimage text in transcribed

Make an estimated cash flow statement for period 2 using the below income statement and partial balance sheet, as well as the following info: -Capital Expenditures totaled $20MM in p2 -The company made 1 acquisition for $50MM in p2 -The acquisition was 80% financed with newly issued debt and 20% financed with newly issued equity -Apart from the acquisition debt, there was no other change in debt levels -Apart from the equity issued for acquisition, there was no other issuance or repurchase of shares -The company paid dividends totaling $0.50 per share during p2 Income Statement Total Revenue Period 1 $1,445 Period 2 $1,592 Cost of sales Gross profit $1,078 $367 $1,204 $387 SG&A expenses Depreciation and amortization Stock-based compensation EBIT, Adj. $290 $22 $4 $51 $295 $26 $4 $62 Interest expense, net Income before income taxes $20 $31 $18 $43 Provision for income taxes Net income, Adj. $8 $23 $11 $32 Earnings per Share, Adj. $0.78 $1.07 29.3 30.2 Weighted Avg. Share Count Sheet1 ady 34 35 Period 2 36 37 $175 $124 38 39 40 Balance Sheet Cash and cash equivalents Accounts receivable Inventories, net Total current assets Property and equipment, net Op. lease ROU assets Goodwill Other intangibles Other long-term assets Total assets Period 1 $42 $162 $113 $317 $85 $0 $184 $130 $4 $720 41 42 $93 $128 $198 $139 $4 43 44 45 46 47 48 $94 $30 $124 49 50 Accounts payable Accrued liabilities Total current liabilities Long-term debt Op. lease liabilities Deferred income taxes Other long-term liabilities Total liabilities $88 $25 $113 $278 $0 $10 $10 $411 51 52 $121 $11 $10 53 54 55 56 Shareholders' equity Total liabilities and sharehol $309 $720 57 58 59 60 61 62 Sheet1 G74 Jx A B C D E F G H . J K M 62 63 64 Statement of Cash Flows Period 2 65 66 67 68 69 Operating Cash Flows 70 71 72 73 Investing Cash Flows 74 75 76 77 78 Financing Cash Flows 79 80 81 Beginning Cash Net Cash Flow Ending Cash 82 83 84 25 86 87 88 89 90 91 Sheet1 + Poach Make an estimated cash flow statement for period 2 using the below income statement and partial balance sheet, as well as the following info: -Capital Expenditures totaled $20MM in p2 -The company made 1 acquisition for $50MM in p2 -The acquisition was 80% financed with newly issued debt and 20% financed with newly issued equity -Apart from the acquisition debt, there was no other change in debt levels -Apart from the equity issued for acquisition, there was no other issuance or repurchase of shares -The company paid dividends totaling $0.50 per share during p2 Income Statement Total Revenue Period 1 $1,445 Period 2 $1,592 Cost of sales Gross profit $1,078 $367 $1,204 $387 SG&A expenses Depreciation and amortization Stock-based compensation EBIT, Adj. $290 $22 $4 $51 $295 $26 $4 $62 Interest expense, net Income before income taxes $20 $31 $18 $43 Provision for income taxes Net income, Adj. $8 $23 $11 $32 Earnings per Share, Adj. $0.78 $1.07 29.3 30.2 Weighted Avg. Share Count Sheet1 ady 34 35 Period 2 36 37 $175 $124 38 39 40 Balance Sheet Cash and cash equivalents Accounts receivable Inventories, net Total current assets Property and equipment, net Op. lease ROU assets Goodwill Other intangibles Other long-term assets Total assets Period 1 $42 $162 $113 $317 $85 $0 $184 $130 $4 $720 41 42 $93 $128 $198 $139 $4 43 44 45 46 47 48 $94 $30 $124 49 50 Accounts payable Accrued liabilities Total current liabilities Long-term debt Op. lease liabilities Deferred income taxes Other long-term liabilities Total liabilities $88 $25 $113 $278 $0 $10 $10 $411 51 52 $121 $11 $10 53 54 55 56 Shareholders' equity Total liabilities and sharehol $309 $720 57 58 59 60 61 62 Sheet1 G74 Jx A B C D E F G H . J K M 62 63 64 Statement of Cash Flows Period 2 65 66 67 68 69 Operating Cash Flows 70 71 72 73 Investing Cash Flows 74 75 76 77 78 Financing Cash Flows 79 80 81 Beginning Cash Net Cash Flow Ending Cash 82 83 84 25 86 87 88 89 90 91 Sheet1 + Poach

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

Pioneers Of Critical Accounting A Celebration Of The Life Of Tony Lowe

Authors: Jim Haslam, Prem Sikka

1st Edition

113754211X, 9781137542113

More Books

Students also viewed these Accounting questions

Question

Describe several models for organizing a human resources department

Answered: 1 week ago