Excel Case #$3-$ Chapters $13$ and $14$: Statement of Cash Flows and Financial Statement Analysis

All $"?"$ must be replaced with a formula to calculate the number that should be in the statement

Required $1$: Using the indirect method, prepare a statement of cash flows for the year. A $?$ is in each cell you need to enter a formula into.

$*$Check figures you can use: given label for the three activities sections $($cash provided by or used in indicates a positive or negative subtotal$)$;

beginning and ending cash from the balance sheet $($and therefore the change in cash$).*$

Required $2$: Complete the following financial statement ratios.

Statement of Cash Flows Use two decimals where necessary.

$($dollars in millions$)(365$ and $2$ are the only plug numbers you should have!$)$