Take Excel Modeling for Finance Professionals and learn the most Trending Career Profile for the Professionals. Now, understand sturdy Money Models and Build Robust Financial Models. Perform Calculations that cover Revenues, Manage Operating and maintenance Cost and do Capital Budgeting.
Date
Duration
Price
Details
Opening Soon
N/A
$ 299
Opening Soon
N/A
$ 349
Take our expertise help to help yourself find a Batch. It will help you find a batch that meets your needs
✓ Discover and learn about the most productive finance teams and how they are driving greater efficiency using Practical scenarios and Case Studies
✓ Supercharge your skills which involve handling Finance. Designed to handle huge volumes of data, and the Models that will help you transform the way you work
✓ You’ll be able to get a 35 % hike in your Salary as you’ll have better problem solving and analytical skills
✓ You’ll be able to Impress your Boss and Colleagues at Work with the most sought-after skills in today’s Corporate
✓ Become a Predominant Talent Required for Career Advancements and Attract better Jobs with higher Chances of getting Promoted
✓ All you need to know is Basic Excel and Math. And Add Excel Modeling in your Career and your skillset. This will bring game-changing capabilities into your present as well as Future
Yoda Learning’s eBook comes with basic guidelines for People to get familiar with Excel Modeling
Essential Shortcuts:
Logic Building Formulas: IF, AND, OR, MAX and MIN
Scenario Building Formulas: INDEX, VLOOKUP, MATCH, CHOOSE, OFFSET
What if Analysis Switches: Spin Button, Drop Down list, Scroll Bar
Calculation Formulas: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, SUMPRODUCT, SMALL, LARGE, SUMIF, COUNTIF, MROUND
General Flow:
2. Building automated timeline (FY)
3. Timing and Event activation Flags (True/False)
4. Revenue Buildup (PPA / Merchant Sale) with YoY escalation in prices
5. Capex Schedule (The journey from Capex > CWIP > PPE or Gross Fixed Assets)
6. Use of BASE Analysis (Beginning, Addition, Subtraction, Ending)
7. Amortization/Depreciation schedule
8. Interest during Construction (IDC) – to be capitalized
9. Waterfall Structure of funding
10. Incorporating Revolver Balance & Minimum Cash Balances
11. Debt schedules & repayment
12. Working Capital schedule & Linkages
13. Building iterative calculation for Interest
Others: IRR, NPV, Ratios, What If Analysis, Relevant Shortcuts
Date
Duration
Price
Details
Opening Soon
N/A
$ 299
Opening Soon
N/A
$ 349
We build trusted relationships and work with Clients to create the value they’re looking for