There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Instructor: The WallStreet School
Language: English
Validity Period: 180 days
Max Viewing Hours: 210 Hours
Basic Microsoft Excel | |||
Introduction to Excel | |||
Basic Shortcuts in Excel 1 | |||
Basic Excel Shortcuts_TWSS_File to be downloaded | |||
Basic Shortcuts in Excel 2 | |||
Basic Excel 2 Shortcuts File | |||
Sum, Count, Average, Median, filter, Max, Min, Sort, Advance filters, Transpose, Arrays | |||
Text functions, concatenate, cell freezing, sensitivity analysis, Data Table | |||
EMI Calculation, introduction to developer tab, goal seek, Use of scroller | |||
If condition, Multiple Ifs, If or, If and or, Conditional formatting, date and time formulas | |||
If condition examples, Sumif(s), Countif(s), Averageif(s), rank of numeric and alphanumerics, CAGR - Annual, Monthly & Daily data | |||
Basic Charting Rules of Bar Chart, Making chart with secondary axis + Cheat sheet for revision | |||
Basic Excel Working File | |||
Basic Excel Test | |||
Basic Excel Test | |||
Advance Microsoft Excel | |||
Introduction to Vlookup + Example of Vlookup + CAGR, Usage of exact range, approximate range | |||
Advance Usage of Vlookup, introduction match formula, limitation of Vlookup, using a combination of Vlookup +Match, Introduction to Hlookup, combination of Hlookup and Match | |||
Complex Usage of Vlookup + Match, Hlookup + Match | |||
Introduction to Index, Offset with granular understanding , combination of Index and Offset, Index and Offet superceding Vlookup | |||
Advance complexity of Index and Offset in mathematical functions | |||
Using Formulas learnt to make dynamic charts, highlighting months with highest and lowest sales, making dynamic doughnut chart using scroller showing product wise sales for multiple years | |||
Advance Level Dynamic Charting though the use of formulas, how to compare industry with company products through dynamic charting, use of scroller to control what financial data should be seen and not seen | |||
Usage of Choose Formula and making Basic Dashboards for showing financial data dynamically through charting , rebasing of stock price data for parity and comparison | |||
Use of formulas learnt above for creation of advance Dashboards and how to use conditional formatting to get the desired results for a blunt data pull | |||
Advance Excel Working File | |||
Advanced Excel Test File | |||
Advanced Excel Test | |||
Excel for Finance | |||
How to Rebase Stock Price | |||
Rebasing the Stock Price | |||
How to use Indirect Function for Extracting Data from Multiple Sheets | |||
TWSS File_Raw Data_How to Extract Data from Multiple Sheets | |||
Basic Financial Statements | |||
Case Study | |||
Assumptions | |||
Profit & Loss | |||
Balance Sheet, Cashflow & Output | |||
Basic Financial Model Case Study Worksheet | |||
Case Study Basics Financial model | |||
Real Estate Case Study- 1 | |||
Discussing Question and assignment | |||
Understanding IRR_NPV_MIRR | |||
Getting started with Model and Population of Numbers | |||
Projecting Sales | |||
Projecting Cash Inflows | |||
Projecting Cash Outflows | |||
Working on Debt and Final Conclusion | |||
Management Decision Making | |||
Case Study_TWSS_Real Estate Model | |||
Assumption Sheet_Practice Raw File_Real Estate Case Study | |||
Real Estate Case Study- 2 | |||
Part I_Step by Step approach to prepare Financial Feasibility Model | |||
Part II_Calculation of Net Cash Inflows and outflows | |||
Part III_Debt Schedule, Net Cash flows to Equity and Equity IRR | |||
Part IV_Money Multiple and Senstivity Analysis | |||
Part V_Goal seek function to calculate desired return for Developer | |||
Hotel Case Study | |||
Understanding the Case Study and assignment | |||
Understanding IRR_NPV_MIRR | |||
Populating Numbers | |||
Projecting Revenues | |||
Projecting Income statement | |||
Projecting Fixed Assets Schedule | |||
Projecting Capex and Debt Schedule | |||
Projecting Cash flows and Balance Sheet | |||
Output Sheet and calculation of IRR | |||
Decision Making | |||
Case Study_Hotel TWSS | |||
Case Study_TWSS Fast Food | |||
Practice Sheets | |||
Projections of a Company | |||
Browsing Latest Annual Report | |||
How to Start Projections | |||
Projecting Opex and Starting Fixed Assets Schedule | |||
Projecting Fixed Asset Schedule and Capex | |||
Projecting Fixed Asset Schedule and Capex (Cont.) | |||
Projection Income Statement | |||
Projecting Cash Flows | |||
Balance Sheet (Asset Side) Part A | |||
Balance Sheet (Asset Side) Part B | |||
Balance Sheet (Liabilities Side) | |||
Balance Sheet (Debt) | |||
Working Files | |||
PepsiCo DCF Valuation | |||
Overview of Valuation Methods | |||
Overview of DCF | |||
How to do Projections | |||
Revenue Projection of PepsiCo | |||
Revenue Projection Files | |||
Source files & Data | |||
Projection of Income Statement of PepsiCo | |||
Projection of Cash Flow Statement of PepsiCo | |||
Debt Schedule of PepsiCo | |||
Projection of Balance sheet of PepsiCo | |||
Calculation of Free Cash Flows of PepsiCo | |||
Cost of Capital | |||
Calculation of Cost of Capital for PepsiCo | |||
DCF Output of PepsiCo | |||
Pepsico DCF Valuation - Solution | |||
Comparable Company Analysis | |||
Overview of Comparable Company Analysis | |||
Step by Step Process of Performing Comparable Company Analysis | |||
Connecting Process of CCA based valuation with a real M&A deal | |||
Deal Related Info | |||
Selection of Comparable Companies to Perform CCA | |||
Calculation of Market Capitalisation | |||
Understanding Concept of Dilution | |||
Calculation of Dilution by applying Treasury Stock Method | |||
Exercise on Dilution | |||
Exercise on Dilution - Solution | |||
Calculation of Enterprise Value | |||
Recap | |||
Downloading of Companies’ filings to perform CCA | |||
Understanding Flow of Trading Comps Template | |||
Trading Comps Template and Filings | |||
Trading Comps Updated XYZ Ltd EV Cal-Excel File | |||
Calculation of EV of Coca Cola | |||
Trading Comps Updated-Coca Cola EV Cal- Excel File | |||
Calculation of EV of PepsiCo | |||
Trading Comps Updated-PepsiCo EV Cal- Excel File | |||
Calculation of EV of Campbell | |||
Trading Comps Updated-Campbell Cal- Excel File | |||
Calculation of EV of Conagra | |||
Step 4-Performance Indicators of Comparable Companies | |||
Trading Comps Updated-Conagra EV Cal- Excel File | |||
Calculation of LTM Numbers of Coca Cola | |||
Trading Comps Updated-LTM Numbers Calculation-Coca Cola- Excel File | |||
Calculation of Adjusted LTM Numbers of Coca Cola | |||
Trading Comps Updated-Adjusted LTM Numbers-Coca Cola- Excel File | |||
Calculation of Adjusted LTM Numbers of PepsiCo | |||
Trading Comps Updated-Adjusted LTM Numbers-PepsiCo- Excel File | |||
Calculation of Adjusted LTM Numbers of Campbell | |||
Trading Comps Updated-Adjusted LTM Numbers-Campbell- Excel File | |||
Proforma Adjustments for M&A and Spinoff | |||
Proforma Adjustments-Campbell Acquisition of Snyder | |||
Trading Comps Updated-Proforma Adjustments_Campbell Acq. of Snyder- Excel File | |||
Calculation of Output of Trading Comps | |||
Trading Comps Updated-Calculation of Output with All 12 Comparables- Excel File | |||
Analysis of Output and Valuation of Dr Pepper | |||
Trading Comps Updated Final Output Excel File | |||
Comparable Transaction Analysis | |||
Transaction Comps: Part I | |||
Data Files and Template | |||
Transaction Comps: Part II | |||
Transaction Comps : Campbell and Snyder Deal | |||
Transaction Comps: Part III | |||
Transaction Comps : RB Foods Deal | |||
Transaction Comps : With Input and Output of all 14 Transactions | |||
Transaction Comps : Final Solution | |||
Dr. Pepper DCF Valuation | |||
Dr. Pepper DCF Valuation | |||
Additional Files | |||
Football Field Analysis | |||
Football Field Analysis | |||
Dr Pepper Valuation Models | |||
Dr Pepper Historical Quotes | |||
Football Field Template | |||
Football Field Solution | |||
Leveraged Buyout | |||
LBO - Case Study | |||
LBO - Basic Terms Explained | |||
LBO - Assumption Sheet | |||
LBO - Debt Assumptions | |||
LBO - Goodwill | |||
LBO - Closing balance sheet | |||
LBO - P&L and tax schudule | |||
LBO - Balance sheet and CFS part 1 | |||
LBO - Balance sheet and CFS part 2 | |||
LBO_Output | |||
LBO - case study | |||
LBO - Notes | |||
LBO Working File | |||
Merger Model | |||
M & A Process | |||
Why we need to learn PowerPoint | |||
Basics of PowerPoint (Part 1) | |||
Basic of PowerPoint (Part 2) | |||
Setting up PowerPoint | |||
Letter of interest | |||
Letter of Intent full | |||
Merger Model Basics | |||
Merger Model Files | |||
M & A Notes | |||
M&A and LBO notes | |||
Rules on How to Conduct yourself in an Interview | |||
Golden Rules while Appearing for an Interview | |||
Interview Questions_With Answers | |||
Assessment Test | |||
Valuations MCQs | |||
Assessment Test for the Certificate | |||
Valuation Notes | |||
Valuation Notes | |||
Upgrade you Linkedin Profile | |||
Attract Potential Recruiters |
After successful purchase, this item would be added to your courses.
You can access your courses after successfully logging in through any Web browser.
WARNING : The Student will be liable for any -
The student will have to indemnify The Wallstreet School for the loss sustained.
To Safeguard, we have watermarked each and every video with OTP verified phone number to verify the Student's identity.
NOTE : Following access restrictions are applicable due to security reasons -
- You can login to the portal through 1 web browser and 1 Mobile Application (Android or IOS)
- You'll have to contact our support to change the devices once you have logged in. So make sure to purchase the course when you're on an appropriate device