FINANCIAL MODELING USING ADVANCE EXCEL

This module is designed to provide student sound knowledge of Derivative Market.In this course we cover all the sub segments of derivative market and various option strategies.

MODULES

Introduction

INTRODUCTION

  • Basic concepts of Financial Modeling
  • Various types of Models
  • Basic Excel.

Microsoft Excel Functions used in FM

MICROSOFT EXCEL FUNCTIONS USED IN FM

  • Financial Function in excel.
  • Sensitivity Analysis
  • NPV Formula
  • IRR vs ROI
  • Break Even Point
  • Profitability Index
  • Cash Burn Rate
  • Effective Interest Rate
  • Cost Benefit Analysis
  • Future Value Formula
  • Rule of 72
  • Time Value of money
  • Geometric Mean Return
  • Weighted average formula

Get A Best Startup with Inspire Education