Search results for:
No result found! Try with different keywords!

Financial Analysis Using Excel


Financial Analysis Using Excel


Financial Analysis is crucial for taking investment decisions that can have a huge financial impact on companies. By attending this seminar, you will be able to effectively prepare and build financial models that cater to different types of investments alternatives, understand and analyze time value of money, present value, future value and weighted average cost of capital (WACC), in addition to conducting proper analysis of financial information.

You can perform financial analysis with Excel in an easy way. Excel provides you several financial functions such as PMT, PV, NPV, XNPV, IRR, MIRR, XIRR, and so on that enable you to quickly arrive at the financial analysis results.

Course Objectives
By the end of the course, participants will be able to:

Apply time value of money concepts
Perform and interpret financial analysis
Apply cost of capital calculation techniques
Construct forecasted financial statement models and perform sensitivity analysis
Use the free cash flow technique in determining the value of a project or a company

Course Outline:
Financial calculations: Applications

Time value of money:
Present value and net present value
Internal rate of return and Multiple IRR (MIRR)
Using XNPV and XIRR

Amortization of loan schedule
Effective yields and returns

Corporate financial analysis
Profit and loss versus balance sheet analysis
Comparable company analysis
Building block analysis
Vertical, trend, and horizontal analysis

Current, quick, and cash ratios
Asset management and activity
AR and AP Turnover
Cash conversion cycle
Asset turnover

Solvency, leverage and gearing
Debt, equity, and times interest earned ratios
Assessing profitability management
Profit margin, gross margin, return on assets, return on equity

Market and valuation
Price-earnings and earnings per share ratios
Modeling the DuPont identity
The three-step models
Calculating cost of capital and capital structure
Supernormal growth
Calculating cost of equity and cost of debt
Computing the expected return on the market
Computing weighted average cost of capital

Target Audience

Professionals in corporate finance, financial analysts, investment bankers, financial controllers, finance managers, professionals responsible for project valuation, project finance, portfolio managers, and professionals in the private investment industry.

Please write to register | princetonacademy ! co ! in / Call -022 67256200

You may also like the following events from Eventbrite:

Also check out other Workshops in Mumbai.

Liked this event? Spread the word :

Map JW Marriott Hotel, Juhu Tara Road Juhu, Mumbai, India
Loading venue map..
Questions or Comments? Post them here.
Event details from Report a problem

More Events in Mumbai

Explore More Events in Mumbai
Create an Event