Excel Modeling is a spreadsheet analysis that allows you to do analysis and projections using various inputs and assumption. Here we use excel modeling to find a solution to real-life problems of Corporate Finance.
In Excel Modeling, we cover the following -
Understanding Time Value of Money Concept
What is Net Present Value
What is the Internal Rate of Return
What is the difference between NPV and IRR
How to find the present value and future value in excel
Finding Annuity and Perpetuity in Excel
Finding the Breakeven Point in Excel
Calculating Profitability Index in Excel
Calculating Cash Burn Rate
Performing Cost Benefit Analysis
Top 15 Financial Functions in Excel
Here is the list of Top 15 financial functions in excel that are most frequently used in practical situations
NPV is defined as the difference between the existing value of net cash arrivals and the existing value of total cash expenditures, whereas XNPV is primarily determines the NPV for a range of cash payments which are not essentially periodic.
IRR is used to calculate the rate of return on an investment especially for the shorter duration of time, whereas ROI is used to calculate the performance of the investment over a certain period of time.