Financial Modeling – Wal-Mart Stores Inc.

Learning how to create a financial model and perform valuation analysis on Retail sector giant- Wal-Mart Stores.

10

 1h 57m | 14 Videos | 59374 Views |   Intermediate| English[Auto-generated]

Financial Modeling of Wal-Mart Stores Inc.:

This course is very useful for the people who are into equity research and financial modeling domain – including students and professionals. This course gives a brief idea about valuing the companies in retail Sector, the revenue and cost drivers, forecasting the future financials and the stock price recommendation. Furthermore, it gives an idea how to prepare a report on the sector and companies.

This course gives a career prospect to the students who are planning to get a financial analyst job in any brokerage and KPOs. Knowledge about valuation of a petrochemical company and report writing would give the student an edge over the competitors. Also it boosts sector expertise of the seasoned professionals who are already working in the financial service domain.

First we go step by step about how to prepare a financial model, starting from data punching to forecasting the future numbers, valuation of the stock and arriving at a target price.

Materials included in the course are company financials, which are taken from the company websites. Apart from that, we have explained the steps in Microsoft power point and used Microsoft excel for building the financial model.

The training will include the following;
1. Introduction
2. Modelling historical data
3. Identifying Business Drivers
4. Forecasting Income Statement
5. Building Schedules
6. Forecasting balance sheet
7. Forecasting cashflow statement
8. Valuation
9. Ratio analysis
10. Sensitivity and scenario analysis

Course Objective:

• To study a promising sector like retail Sector and valuation
• To study steps of building financial model
• To enhance the sector expertise

Target Customers:

• Finance Students
• Investment banking Professionals
• Anyone who wants to learn financial modeling

Pre-Requisites:

• Basic knowledge of financial accounting, ratios
• Concepts of financial management, valuation methodologies
• Basic knowledge on Microsoft excel and word

Back to top ▴