International Finance

What you will Learn

COMPUTER BASICS

Introduction : Computer Basic

• Creating Folder, Paint
• Directories, input units, Output unit
• Central Processing Units, What is OS, what is hardware & Software
• Windows shortcut keys

MS WORD

Module 1: Home Tab

• Clipboard, Font, Paragraph
• Styles, Editing

Module 2: Inster Tab

• Pages, Tables
• Illustrations, Links
• Header & Footer
• Text, Symbols

Module 3: Design Tab

• Document Formating
• Page Background

Module 4: Layout Tab

• Page steup, Paragraph
• Arrange

Module 5: References Tab

• Table of contents, Footnotes
• Citations and Bibliography, Captions

Module 6: Mailings Tab

• To create customized mailings and documents using a pre-existing list

Module 7: Review Tab

• Proofing Proofing
• Speech and Language
• Comments, Track changes
• Combine & Compare, Protect

Module 8: View Tab

• Views, Page movement
• Zoom, Window arrange, Macros

MS EXCEL

Module 8: Introduction

• The Excel environment Navigating a worksheet Spreadsheet terminology Getting help

Module 9: Data Entering and editing

• Entering and editing data Entering and editing text and values Entering and editing formulas Saving and updating workbooks

Module 10: Modifying a worksheet

• Moving and copying data Moving and copying formulas Inserting and deleting ranges, rows, and columns Cell comments

Module 11: Using functions

• Entering functions AutoSum Other common functions

Module 12: Formatting

• Text formatting Row and column formatting Number formatting Conditional formatting Additional formatting options

Module 13: Pivot Tables

• Prepare data in a table format and name the table Create a PivotTable for analyzing

Module 14: Charts

• Chart basics Pie Chart Bar Chart etc

Module 15: Modifying & Hyperlink

• Case Study Modifying existing worksheet Use shortcut keys Create and link worksheet

Module 16: Review

• Basics Downloading from Account Reconciliation The Excel environment & Modify or re-arrange fields

Module 17: Subtotal Functions

• Create an outline and consolidate data Create subtotals in a list Use multiple subtotal functions – SUBTOTAL, SUMIF Create custom views to save different sets of worksheet display and print settings

Module 18: Filter

• Range names and Filter date Define and apply cell and range names Use names in Formulas Filter data based on complex criteria Use conditional filters Copy filtered results to another range

Module 19: Data Tools

• Text coloum, Remove duplicates, Data Validation

Module 20: Functions

• Functions Using IF and SUMIF functions to calculate a value based on specified criteria Use ROUND function to round off numbers Use VLOOKUP to find values in worksheet data Use HLOOKUP to find values in worksheet data

Module 21: Import/Export

• Import/Export Data Export data from Excel to other formats Import data from a text file into an Excel workbook

Module 22: Printing

• Preparing to print Page Setup options in worksheets

MS POWERPOINT

Module 23: Home Tab

• Find / replace
• Quick Access Toolbar
• Format Painter
• Save to .pdf
• Zoom Options

Module 24: Design Themes

• UT Dallas
• Best Practices
• Background

Module 25: Insert

• Picture
• ClipArt
• Shapes
• Smart Art
• Format

Module 26: Header Footer & View

• Slide number
• Normal Slide
• Slide Sort
• Notes
• Guidelines

Module 27: Print

• Handouts
• Slide Show
• Animation
• Animation

Module 28: Slide Master

• Create & Editing in Slide Master

Module 29: Action Button

• Presentation Presentation with Action buttons

ACCOUNTING

Module 30:Accounting concepts

Module 31:Basic Accounting Teams

Module 32:Practical Training in Manual Accounting ( Actual Voucher Book)

Module 33:Salary Payrolls, PF, ESI and Banking activities

Module 34:A complete GST enabled package with latest updates

Module 35:Tally Prime

Module 36:Introduction to computerized accounting

Module 37:Company Creation

Module 38:Learn to create Ledger and Understanding Group

Module 39:Learn to do Voucher Entry in Tally

Module 40:Accounting & Inventory Vouchers

Module 41:Stock & Inventory Management in Tally

Module 42:Godown creation and transfer (stock transfer)

Module 43:Purchase, sales & returns

Module 44:Voucher Class, Purchase/Sales Order Processing

Module 45:BOM, Manufacturing Voucher, Price List

Module 46:Bank Reconciliation

Module 47:GST Implement & Return Preparation Also Include TDS

Module 48:Complete Payroll (Salary) Processing, ESI, PF

Module 49:Advance Topics: Budget, Voucher Numbering, Cost centre

Module 50:Accounts Reports - Trading & Profit or Loss A/c, Balance Sheet, and other Financial Statements.

FINANCIAL ANALTICS

Module 51: Microsoft Excel - Quick Introduction

• MS Excel Useful Tools
• Best Practices That Will Make a Difference
• Beginner, Intermediate & Advanced Functions
• Financial Functions in Excel
• Practical Exercise "Build a P&L From Scratch"
• Building Professional Charts in Excel
• Creating Complete Professional Charts from Scratch
• Working with Pivot Tables in Excel
• Practical Exercise

Module 52: Financial Reporting

• a Complete 3-statement Model
• Practical Exercise- Build a Flexible Model with Multiple
• Understanding the Big Picture: Why, What, When
• Practical Exercise

Module 53: The Core Principles of Accounting

• Accounting - The Importance of Timing
• Accounting - Preparing a Cash Flow Statement: Understanding
• Cash Flow Analysis, Trade Receivables and Inventory
• Fixed Assets
• Trade Payables
• Leasing Liabilities and Using Leverage
• Raising Equity, Types of Equity, and Dividend Payments
• Practical Exercise - Accounting

Module 54: Financial Statement Analysis - An Introduction

• Understanding Subtleties
• Practical Exercise-1
• Practical Exercise -2

Module 55: Capital Budgeting

• Time value of money and interest rate
• Basic Notions
• Loan Calculations
• Value of Cash Flow
• Practical Exercise-1
• Practical Exercise-2

Module 56: Power BI

• Getting started
• Getting ready for P&L Preparation - Analyzing Sales
• Preparing and Analyzing P&L
• Introduction to DAX and P&L Analysis redo with DAX
• Preparing DAX for the Next Level
• Preparation of Balance Sheet
• More Financial Ratios
• Making Ledgers and Enabling Drill-through
• Trial Balance
• Cash flow Statement
• Statement of Changes in Equity
• Capstone Project

INVESTMENT BANKING

Module 57: Introduction to investment Banking

• Commercial Banking
• Investment Banking
• Activities of Investment Banking

Module 58: Capital Markets

• What is an Equity
• Equity Issue
• Debt Issue
• IPO pricing Mechanism
• Time horizon of IPO
• Identifying Valuation
• Share Allocation
• Seasoned Equity Offering
• Issuing a Bond
• Issuing Debentures

Module 59: Mergers and Acquisition

• Type of M&A
• Process of Acquisition
• Valuation
• Payment options in M & A
• Buyer types in M& A

Module 60: Restructuring

• Asset Restructuring
• Liability Restructuring

Module 61: Financial Modelling

• Valuation Methodologies
• P&L Forecasting Methodologies
• Balance Sheet Forecasting
• Capstone Project -Tesla Valuation

Module 61: Financial Modelling

• Valuation Methodologies
• P&L Forecasting Methodologies
• Balance Sheet Forecasting
• Capstone Project -Tesla Valuation

Module 61: Leverage Buyouts

• Capstone Project- Volkswagen

Module 62: Pre-Placement Training

• Business Communication
• Business Etiquettes
• Personality Development
• Communicative English
• Interview Preparation