In this article, we will take you through the fantastic journey for learning accounting and finance using Microsoft Excel, but firstly we need to understand the topics that we covered in this entire session and we hope after the completion of this all sections with us, you will called as master of accounting and finance, so be ready for upcoming sections and learn with bliss smile.
#Happy Learning
Section A : Advance Glimpses of Microsoft Excel
In this section, we will discuss the topics below:
- Table and It’s uses
- Conditional Formatting
- Custom Number Formatting
- What if Analysis
- Advance Functions
- Lookup Functions
- Advance Features
- Dynamic Range
- Pivot Table and Charts
Section B: Preparing Financial Statements Smartly
In this section, we will discuss the topics below:
- What is Financial Statement
- Advantages and Disadvantages of Financial Statement
2. Categories of Financial Statement
- Balance Sheet
- Income Statement
- Cash Flow Statement
3. Balance Sheet
- Equity and Liabilities
- Shareholder’s Fund
- Share Capital
- Reserve and Surplus
- Current Liabilities
- Non-Current Liabilities
- Assets
- Current Assets
- Non-Current Assets
4. Income Statement
- Terms Related to Income Statement
5. Cash Flow Statement
- Operating Activities
- Investment Activities
- Financial Activities
6. Depreciation and Amortization
7. Accounting and Financial Terms
8. Equity
- Public Equity
- Private Equity
Section C: Calculating and Projecting Various Financial Ratios
In this section, we will discuss the topics below:
- Financial Ratios And It’s Types
- Importance of Financial Ratio
- Liquidity Ratio
- Solvency Ratio
- Profitability Ratio
- Return on Sales Ratio
- Return on Investment Ratio
- Turnover Ratio
- Valuation Ratio
Section D: Working Capital Modeling
In this section, we will discuss the topics below:
- What is Working Management
- Importance of Working Capital
- Categories of Working Capital
- Trade Receivable
- Trade Payable
- Inventory
- Cash Conversion Cycle
- Working Capital Assessment
Section E: Business Valuation Modeling (BVM)
In this section, we will discuss the topics below:
- Time Value of Money
- NPV and IRR
- Payback Period
- Accounting Rate of Return
- Capital Assets Pricing Model
- WACC Calculation
- Business Valuation Modeling
- Discounted Cash Flow
- Free Cash Flow
Section F: Financial and Cash Flow Modeling
In this section, we will discuss the topics below:
- What is Financial Modeling
- Creating a Financial Modeling
Section G: Capital Budgeting and Leverage Buyout Modeling
In this section, we will discuss the topics below:
- Capital Budgeting
- Introduction to Leverage
- Operating Leverage
- Financial Leverage
- Combined Leverage
- Leverage Buyout
Section H: Dashboard With Excel
In this section, we will discuss the topics below:
- Excel Dashboard and It’s Uses
- Procedure For Creating Dashboard
- Selection of Data
- Layout of Data
- Use of Pivot Table
- Creation of Pivot Chart
- Insertion of Slicers
- Finalization of Dashboard
Conclusion
“The best way to predict the future is to create it”, by this amazing quote is enough for understanding the power of taking knowledge from anywhere and we also keep in mind that thing, we taking a best learning package that provides you financial as well as organization oriented knowledge that help you grow and always be on fire.
