Statement of Cash Flows on Excel - You will also prepare an Excel document that will show
Question:
Statement of Cash Flows on Excel - You will also prepare an Excel document that will show a year-to-year Statement of Cash Flows of your company, along with relevant analytical data that will be described below. Your Excel document must include all necessary formulas. For example, the document should have a formula in a cell where you are adding up numbers in a column. Calculating on a hand-held calculator then typing in the sum will result in a loss of points. The page should be presented in a manner consistent with what a financial statement looks like. Inconsistencies/sloppiness in fonts, font size, justification, negative number presentation, dollar signs, bold versus no bold, number presentation, and underlining, to name a few, will result in a loss of points. This document must look perfect.
Statement of Cash Flows:
Your Statement of Cash Flows does not have to look exactly like the one presented by the company, however you must include all the data. For example, you might combine a number of lines into one common one.
Analysis:
You will identify the year-to-year changes in the various lines and calculate a percentage change.