Hire a Tutor
Search

Tutor's Profile

Verified

Rahul (UAT 26449)

Male, 35 Years / (UAT 26449)

5 Years of Teaching Experience

Be First to Review

Location:
Jumeirah Lake Towers (JLT)
Qualification:
B.Tech from Indian Institute of Technology (IIT) and MBA from Indian School of Business(ISB)
Mobile:
xxxxxxxx80
Request a Callback
Whatsapp:
xxxxxxxx80
Request a Callback

Tutoring

Qualification
Qualification:
B.Tech from Indian Institute of Technology (IIT) and MBA from Indian School of Business(ISB)
Experience
Experience:

I have done B.Tech from IIT Kharagpur and MBA from ISB Hyderabad. I am having 5 years experience of offering tuition in subjects like

Corporate Finance, Mathematics, Economics, Solving Business Case studies for MBA students and GMAT

Options
Options:
Home Tuition Only
Approach
Approach:

I emphasise conceptual learning and understanding by solving problems. I plan my lessons based on the students and their needs. I include small exercises and use easy to understand examples. I try to understand the strengths and weakness of the student and then make suitable amendments to work on those areas where the student needs improvement.

Fees (AED)
Fees (AED)h:
100

Teaches

Business Training
Business Training:
Finance: Corporate, Finance: Banking, Economics, Business Studies
College Level
College Level:
Mathematics, Finance, Economics, Business
Exam Preparation
Exam Preparation:
SAT, Maths, IGCSE/AS/AL, GMAT

About

Area
Area:
Jumeirah Lake Towers (JLT)

By : Rahul Prasad - Karama, Dubai

  • Price:
  • Duration:
    9 days
  • Booking:
    Not Sheduled Yet
  • Segment:
    Business Training
  • Subject:
    Finance: Corporate

Overview

This program is specially designed to improve your efficiency in using Excel shortcuts and use several of the support tools and techniques in spreadsheet programs. By attending this program students will be able to analyse the results of the financial model.

Course Curriculum

4 day course

Day 1: Excel Tips

  • Understanding And Creating A Financial Model Template
  • Learning referencing (usage of $)Frame work in Excel
  • Learning Custom formatting in Excel
  • Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables
  • Implementing simple business modeling case in Excel
  • Simple exercise/models in excel

      Advance Function

  • Named Ranges
  • Index Match
  • Array Functions
  • Building Scenarios using Offset Functions
  • Creating growing models & Index functions
  • Usage of Indirect Functions
  • Usage of Goal Seek and Solver Functions

 Day 2: Charting

  • Building Primary & Secondary Axis in a Chart
  • Radar Charts - Showing the progress of Commercial Property Development
  • Waterfall Charts - Showing Funding Breakup for Renewable Energy project
  • Football Field - Showing Valuation Summary using Different Parameters
  • Gantt Chart - Tracking the status of an Ongoing Project

Day 3,4 : Business Modelling and Valuation

  • Data Collection and Data Structuring
  • Preliminary Scrutiny of the Data and Information
  • Understand the Business Model and Operating Model
  • Modeling the Historical Statement
  • Business Drivers Identification and Modeling
  • Modeling Assumptions for Future Action
  • Modeling Revenue Build-up - projecting the future revenues
  • Modeling Cost Build-up - projecting the future cost
  • Modeling the Asset Schedule
  • Modeling the Depreciation Schedule - Book and Income Tax Depreciation
  • Working Capital & Term Loan Modeling - Debt Infusion
  • Tax Modeling
  • Modeling MAT and MAT credit
  • Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble
  • Equity Modeling - Equity Infusion
  • Modeling Paid Up Capital and Share Premium Account
  • Modeling Retained Earning Schedule
  • Modeling the projected P/L and BS
  • Modeling the projected Cash Flow Statement
  • Conducting Covenant Testing
  • Performing Ratio Analysis
  • WACC and Cost of Equity Analysis
  • Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
  • Performing sensitivity/scenario analysis

Who can Join

MBA Students and finance professionals.

Online Tutoring

Experience
Prior Online Tutoring Experience:
No

Note Written by: Rahul Prasad

Prepared by: Rahul Prasad

Written by: Rahul Prasad

X

We use cookies to help provide you the best experience on our website. By continuing to use our site, you constent to our use of these cookies.
More Information I accept