Course Overview

Financial Modeling (45h) হলো একটি Practical & Career-Focused Course, যেখানে financial data, assumptions এবং business logic ব্যবহার করে financial performance forecast ও analyse করার skills শেখানো হবে।

এই course-এ Excel, Financial Statements, Revenue Forecasting, Cash Flow, Financial Ratios, Three-Statement Modeling, DCF Valuation, NPV, IRR, Scenario Analysis, Sensitivity Analysis, Debt Modeling এবং Business Valuation শেখানো হবে।

Practical Projects-এর মাধ্যমে learners business assumptions থেকে একটি complete, dynamic ও decision-ready financial model তৈরি করার দক্ষতা অর্জন করবে।

What You Will Learn

✔ Financial Modeling Fundamentals
✔ Excel for Financial Modeling
✔ Spreadsheet Structure
✔ Financial Model Best Practices
✔ Financial Statements
✔ Income Statement Modeling
✔ Balance Sheet Modeling
✔ Cash Flow Statement Modeling
✔ Revenue Forecasting
✔ Cost & Expense Forecasting
✔ Working Capital Modeling
✔ Depreciation Modeling
✔ CapEx Modeling
✔ Debt Modeling
✔ Interest Calculation
✔ Three-Statement Model
✔ Financial Ratios
✔ Scenario Analysis
✔ Sensitivity Analysis
✔ Data Tables
✔ DCF Valuation
✔ NPV
✔ IRR
✔ Terminal Value
✔ Enterprise Value
✔ Equity Value
✔ Comparable Company Analysis Fundamentals
✔ Investment Analysis
✔ Business Valuation
✔ Model Audit & Error Checking
✔ Dashboard & Financial Reporting
✔ Complete Financial Model Project

---

Course Curriculum

Module 1 — Introduction to Financial Modeling

• What is Financial Modeling?
• Why Financial Models Matter
• Types of Financial Models
• Business vs Investment Models
• Financial Model Structure
• Model Inputs
• Assumptions
• Calculations
• Outputs
• Model Design Principles
• Common Modeling Mistakes

---

Module 2 — Excel Fundamentals for Financial Modeling

• Excel Interface
• Worksheets & Workbooks
• Cell References
• Relative References
• Absolute References
• Mixed References
• Basic Financial Functions
• SUM
• AVERAGE
• MIN & MAX
• IF
• SUMIF / SUMIFS
• COUNTIF / COUNTIFS
• INDEX & MATCH
• XLOOKUP
• Basic Date Functions
• Error Handling

---

Module 3 — Financial Modeling Spreadsheet Design

• Model Layout
• Input Section
• Calculation Section
• Output Section
• Historical Data
• Forecast Period
• Assumption Management
• Formula Consistency
• Formatting Principles
• Model Readability
• Model Navigation
• Best Practices

---

Module 4 — Financial Statements Fundamentals

• Income Statement
• Balance Sheet
• Cash Flow Statement
• Relationship Between Statements
• Revenue
• COGS
• Gross Profit
• Operating Expenses
• EBITDA
• EBIT
• Net Income
• Assets
• Liabilities
• Equity
• Operating Cash Flow
• Investing Cash Flow
• Financing Cash Flow

---

Module 5 — Historical Financial Data Analysis

• Collecting Historical Data
• Organizing Financial Statements
• Historical Revenue
• Historical Expenses
• Margin Analysis
• Growth Analysis
• Balance Sheet Analysis
• Cash Flow Analysis
• Financial Ratio Analysis
• Identifying Trends
• Preparing Historical Model

---

Module 6 — Revenue Forecasting

• Revenue Drivers
• Revenue Growth
• Unit-Based Forecasting
• Price × Volume Model
• Customer-Based Forecasting
• Subscription Revenue
• Sales Pipeline
• Growth Assumptions
• Monthly Forecast
• Annual Forecast
• Forecast Validation

---

Module 7 — Cost & Expense Modeling

• Fixed Costs
• Variable Costs
• Semi-Variable Costs
• COGS
• Operating Expenses
• Salary Costs
• Marketing Expenses
• Administrative Costs
• Cost as % of Revenue
• Expense Growth
• Margin Forecasting

---

Module 8 — Working Capital Modeling

• What is Working Capital?
• Accounts Receivable
• Accounts Payable
• Inventory
• Working Capital Drivers
• DSO
• DPO
• Inventory Days
• Cash Conversion Cycle
• Working Capital Forecast
• Impact on Cash Flow

---

Module 9 — Depreciation & CapEx Modeling

• Fixed Assets
• Capital Expenditure
• Depreciation
• Useful Life
• Straight-Line Depreciation
• Asset Additions
• Asset Disposal
• Depreciation Forecast
• CapEx Forecast
• Impact on Financial Statements

---

Module 10 — Three-Statement Financial Model

• Linking Income Statement
• Linking Balance Sheet
• Linking Cash Flow Statement
• Revenue to Net Income
• Net Income to Cash Flow
• Working Capital Links
• CapEx Links
• Depreciation Links
• Debt Links
• Retained Earnings
• Balance Sheet Check
• Integrated Three-Statement Model

---

Module 11 — Debt & Interest Modeling

• Types of Debt
• Opening Debt Balance
• New Borrowing
• Principal Repayment
• Closing Debt
• Interest Expense
• Interest Rate
• Debt Schedule
• Loan Amortization
• Debt Service
• Interest Coverage
• Debt Impact on Cash Flow

---

Module 12 — Financial Ratios & Performance Analysis

• Liquidity Ratios
• Current Ratio
• Quick Ratio
• Profitability Ratios
• Gross Margin
• Operating Margin
• EBITDA Margin
• Net Profit Margin
• ROA
• ROE
• Leverage Ratios
• Debt-to-Equity
• Interest Coverage
• Efficiency Ratios
• Financial Performance Interpretation

---

Module 13 — Cash Flow Modeling

• Operating Cash Flow
• Investing Cash Flow
• Financing Cash Flow
• Free Cash Flow
• Unlevered Free Cash Flow
• Levered Free Cash Flow
• Cash Flow Forecast
• Cash Flow Drivers
• Cash Balance
• Cash Burn
• Cash Runway

---

Module 14 — DCF Valuation

• What is DCF?
• DCF Framework
• Free Cash Flow
• Discount Rate
• WACC Fundamentals
• Present Value
• Forecast Period
• Terminal Value
• Enterprise Value
• Equity Value
• DCF Valuation
• DCF Interpretation

---

Module 15 — NPV & IRR

• NPV Fundamentals
• Discounted Cash Flows
• Initial Investment
• Project Cash Flows
• NPV Interpretation
• IRR Fundamentals
• IRR Calculation
• NPV vs IRR
• Project Comparison
• Investment Decision

---

Module 16 — Business Valuation

• What is Business Valuation?
• Enterprise Value
• Equity Value
• Revenue Multiples
• EBITDA Multiples
• P/E Ratio
• Valuation Drivers
• Growth & Margin Impact
• DCF Valuation
• Basic Relative Valuation
• Valuation Interpretation

---

Module 17 — Comparable Company Analysis

• What is Comparable Company Analysis?
• Selecting Comparable Companies
• Revenue Multiples
• EBITDA Multiples
• EV/Revenue
• EV/EBITDA
• P/E
• Benchmarking
• Valuation Range
• Practical Company Comparison

---

Module 18 — Scenario Analysis

• What is Scenario Analysis?
• Base Case
• Best Case
• Worst Case
• Revenue Scenarios
• Cost Scenarios
• Margin Scenarios
• Growth Scenarios
• Cash Flow Scenarios
• Valuation Scenarios
• Decision Making

---

Module 19 — Sensitivity Analysis

• What is Sensitivity Analysis?
• Key Model Drivers
• Revenue Sensitivity
• Margin Sensitivity
• Discount Rate Sensitivity
• Growth Rate Sensitivity
• Terminal Value Sensitivity
• Two-Way Sensitivity
• Data Tables
• Valuation Sensitivity

---

Module 20 — Startup Financial Modeling

• Startup Financial Model
• Revenue Model
• Customer Acquisition
• Customer Growth
• Pricing
• Operating Expenses
• Hiring Plan
• Cash Burn
• Cash Runway
• Break-Even Analysis
• Funding Requirement
• Investor Financial Model

---

Module 21 — Break-Even Analysis

• Fixed Costs
• Variable Costs
• Contribution Margin
• Break-Even Point
• Break-Even Revenue
• Break-Even Units
• Margin of Safety
• Pricing Impact
• Cost Impact
• Business Decision Making

---

Module 22 — Investment & Project Modeling

• Initial Investment
• Project Revenue
• Project Expenses
• Capital Expenditure
• Cash Flows
• NPV
• IRR
• Payback Period
• Scenario Analysis
• Investment Decision

---

Module 23 — Model Audit & Error Checking

• Financial Model Audit
• Formula Checking
• Circular References
• Error Detection
• Balance Sheet Check
• Cash Flow Check
• Assumption Validation
• Formula Consistency
• Sensitivity Testing
• Model Quality Control

---

Module 24 — Financial Dashboard & Reporting

• Financial KPI Dashboard
• Revenue Dashboard
• Profitability Dashboard
• Cash Flow Dashboard
• Financial Ratios
• Charts & Graphs
• Management Reporting
• Investor Reporting
• Key Financial Insights
• Presenting Financial Models

---

Module 25 — Professional Financial Modeling Best Practices

• Model Structure
• Assumption Discipline
• Consistent Formulas
• Documentation
• Version Control
• Model Flexibility
• Scenario Management
• Error Prevention
• Model Review
• Professional Presentation

---

Practical Financial Modeling Projects

Course-এর practical sessions-এ learners complete financial models build করবেন।

📊 Project 1 — Company Financial Model

একটি sample company-এর historical financial data ব্যবহার করে—

• Income Statement
• Balance Sheet
• Cash Flow Statement
• Financial Ratios

তৈরি ও analyse করা হবে।

📈 Project 2 — Revenue Forecasting Model

Company-এর business drivers ব্যবহার করে 5-year revenue forecast তৈরি করা হবে।

Revenue model-এ থাকবে:

• Customers
• Price
• Sales Volume
• Growth Rate
• Revenue Forecast

💰 Project 3 — Expense & Profit Forecast

Revenue assumptions-এর ওপর ভিত্তি করে—

• COGS
• Operating Expenses
• EBITDA
• EBIT
• Net Income

forecast করা হবে।

🏦 Project 4 — Working Capital Model

Accounts Receivable, Inventory এবং Accounts Payable-এর ভিত্তিতে working capital এবং cash-flow impact calculate করা হবে।

🧾 Project 5 — Three-Statement Model

Income Statement, Balance Sheet এবং Cash Flow Statement fully linked করে একটি integrated financial model তৈরি করা হবে।

💳 Project 6 — Debt Schedule

একটি company-এর loan/debt-এর জন্য—

• Opening Balance
• Borrowing
• Repayment
• Interest
• Closing Balance

সহ complete debt schedule তৈরি করা হবে।

📉 Project 7 — DCF Valuation Model

একটি company-এর জন্য—

• Free Cash Flow
• WACC
• Terminal Value
• Enterprise Value
• Equity Value

ব্যবহার করে complete DCF Valuation Model তৈরি করা হবে।

📊 Project 8 — Scenario & Sensitivity Model

Base, Best এবং Worst Case scenarios তৈরি করে valuation ও financial performance-এর পরিবর্তন analyse করা হবে।

🚀 Project 9 — Startup Financial Model

একটি hypothetical startup-এর জন্য—

• Revenue
• Expenses
• Hiring
• Cash Burn
• Cash Runway
• Break-Even
• Funding Requirement

সহ complete startup financial model তৈরি করা হবে।

🏆 Final Project — Complete Professional Financial Model

Course শেষে একটি complete company financial model তৈরি করা হবে:

Historical Data → Assumptions → Revenue Forecast → Expense Forecast → Working Capital → CapEx → Debt → Three Statements → Cash Flow → DCF → Valuation → Scenario Analysis → Sensitivity Analysis → Dashboard

---

Course Features

✅ 45 Hours Professional Training

✅ বাংলা + English Explanation

✅ Intermediate to Advanced Level

✅ Excel for Financial Modeling

✅ Financial Statement Modeling

✅ Revenue Forecasting

✅ Expense Forecasting

✅ Working Capital Modeling

✅ CapEx & Depreciation

✅ Debt & Interest Modeling

✅ Three-Statement Financial Model

✅ Cash Flow Modeling

✅ Financial Ratio Analysis

✅ DCF Valuation

✅ NPV & IRR

✅ Enterprise Value & Equity Value

✅ Comparable Company Analysis Fundamentals

✅ Startup Financial Modeling

✅ Break-Even Analysis

✅ Scenario Analysis

✅ Sensitivity Analysis

✅ Financial Dashboard

✅ Model Audit & Error Checking

✅ Real-World Business Cases

✅ Practical Excel Projects

✅ Complete Financial Model

✅ Instructor Support

✅ Class Recording (যদি প্রযোজ্য হয়)

✅ Certificate of Completion (যদি প্রদান করা হয়)

---

Who Can Join?

• Finance Students
• Accounting Students
• Economics Students
• Financial Analysts
• Investment Analysts
• Business Analysts
• Accountants
• Banking Professionals
• Corporate Finance Professionals
• Investment Professionals
• Entrepreneurs
• Startup Founders
• Business Owners
• Management Professionals
• Equity Research Learners
• যারা Professional Financial Modeling শিখতে চান

Basic Excel এবং basic Finance knowledge recommended। Advanced programming knowledge প্রয়োজন নেই।

---

After Completing This Course

এই course শেষ করার পর আপনি—

Advanced Investment Banking, Equity Research, Corporate Finance ও Valuation-এর জন্য strong foundation তৈরি করতে পারবেন।

Financial Model-এর structure ও components বুঝতে পারবেন।

Excel ব্যবহার করে professional financial models তৈরি করতে পারবেন।

Historical financial statements organize ও analyse করতে পারবেন।

Revenue এবং expense drivers identify করতে পারবেন।

Business assumptions ব্যবহার করে revenue forecast তৈরি করতে পারবেন।

COGS এবং operating expenses forecast করতে পারবেন।

Working capital এবং cash conversion cycle model করতে পারবেন।

CapEx এবং depreciation forecast করতে পারবেন।

Debt schedule এবং interest expense model করতে পারবেন।

Income Statement, Balance Sheet এবং Cash Flow Statement link করতে পারবেন।

একটি integrated Three-Statement Financial Model তৈরি করতে পারবেন।

Free Cash Flow calculate করতে পারবেন।

DCF valuation model তৈরি করতে পারবেন।

NPV ও IRR ব্যবহার করে investment projects evaluate করতে পারবেন।

Enterprise Value এবং Equity Value-এর fundamentals বুঝতে পারবেন।

Comparable company valuation-এর basic analysis করতে পারবেন।

Startup-এর revenue, cost, burn rate ও runway model করতে পারবেন।

Break-even analysis করতে পারবেন।

Base, Best এবং Worst Case scenarios তৈরি করতে পারবেন।

Sensitivity Analysis ব্যবহার করে key assumptions-এর impact analyse করতে পারবেন।

Financial model audit এবং common errors identify করতে পারবেন।

Management ও investor-friendly financial dashboards তৈরি করতে পারবেন।

Real-world business ও investment decisions-এর জন্য financial models ব্যবহার করতে পারবেন।