Synopsis: How do the three key financial documents, Balance Sheet, Income Statement and Statement of Cash Flows connect together using Excel?

Review Sections 14.4, 14.5 and 14.6 to understand the criteria, purpose, and contribution to financial knowledge of each of the three key financial documents: Balance Sheet, Income Statement and Statement of Cash Flows.

Then view the comprehensive video which explains step-by-step how Excel can be used to connect these three important sources of information together to yield one integrated picture of the financial health of an organization. If you are not comfortable with the program Excel, it is highly recommended that you take this free “crash” training course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance

No application is as universally used and needed as Excel to produce spreadsheets as a reporting and analytical tool. All levels of businesspeople, financial professionals, government agencies and investors need at least basic level skill using Excel. Proficiency as a spreadsheet power user however is likely to enhance your career as it will boost your value as both a candidate and an employee at most organizations, so please add this important competence to your personal toolbox if you do not already have it.

Link the 3 Financial Statements in Excel