Accounting & Financial Statement Analysis: Practical Example

Automate accounting transactions, year-end adjustments, trial balance, financial statements & ratio analysis in Excel.

What you'll learn

Learn how to post journal entries for various transactions.

Learn how to post and adjust year-end journal entries.

Generate Trial Balance and financial statements from journal entries.

Analyze and interpret financial statement statements.

Master financial ratio analysis and its application.

Requirements

No prior experience required. Basic accounting and Excel knowledge is helpful.

Description

This course will guide you step-by-step through the entire accounting cycle, from posting different accounting transactions to generating comprehensive financial reports and conducting financial analysis—all automated in Excel. You’ll start by learning how to accurately book various accounting transactions and post year-end adjustments. You will then prepare the trial balance, close the accounts, and open the new year's balance sheet.Next, you will automate the creation of key financial statements, including the Income Statement, Balance Sheet, and Cash Flow Statement, directly in Excel. Through this process, you will gain the skills to streamline your accounting workflow, ensuring accuracy and efficiency.In the second part of the course, you will focus on financial ratio analysis. You will automate the calculation of important financial ratios, enabling you to compare a company's performance against competitors and industry standards. This practical approach will help you interpret financial data effectively, making it easier to assess business health and profitability.By the end of this course, you will be proficient in automating the entire accounting process and performing financial ratio analysis, providing valuable insights for strategic decision-making. Whether you're an accounting professional or a business owner, this course will enhance your financial reporting and analysis skills, all within Excel.

Overview

Section 1: Introduction

Lecture 1 Course introduction

Lecture 2 Creating accounting process in excel

Section 2: Core Accounting Transactions

Lecture 3 recording the first transaction company creating

Lecture 4 Purchased properly planned and equipment

Lecture 5 Purchase inventory in cash

Lecture 6 Make credit sales

Lecture 7 Pay for rent

Lecture 8 Another transaction for sales on credit

Lecture 9 Booking office suppliers and utilities, Bank loan transactions

Lecture 10 Transaction related to salaries

Lecture 11 Marketing and advertising costs

Section 3: Year-End Adjustments

Lecture 12 Year-End Adjustments

Lecture 13 Next year opening balance fy 2025

Section 4: Second years transactions

Lecture 14 Various transactions FY 2025.

Section 5: Adjustments for the year 2025.

Lecture 15 Depreciation calculation and posting

Lecture 16 Bad debt expenses

Lecture 17 Prepaid insurance.

Lecture 18 Corporate taxes provision calculation and booking

Section 6: Financial Analysis Introduction

Lecture 19 Introduction to Financial analysis

Section 7: Horizontal analysis

Lecture 20 Horizontal analysis for income statement

Lecture 21 Horizontal analysis for balance sheet and cash flow statement

Section 8: Profitability ratio analysis

Lecture 22 Profitability ratio analysis

Section 9: Liquidity ratio analysis

Lecture 23 Liquidity ratio analysis

Section 10: Efficiency ratio analysis

Lecture 24 Efficiency ratio analysis_inventory tunover and days

Lecture 25 Receivable turnover and days ratio

Lecture 26 Account payable turnover and days Ratios

Lecture 27 Asset turnover ratio

Section 11: Solvency ratios

Lecture 28 Solvency ratios

Section 12: Cash Flow Ratios

Lecture 29 Cash Flow Ratios

Section 13: Course Conclusion

Lecture 30 course Conclusion

This course is for accounting professionals, students, or anyone interested in learning how to automate journal entries, generate financial statements, and analyze financial ratios using Excel.