By Pooja Borkar
By Pooja Borkar
By Pooja Borkar
Financial Modeling Tutorials
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 -
Here is the list of Top 15 financial functions in excel that are most frequently used in practical situations
Sensitivity analysis in excel modeling helps us study the uncertainty in the output of the model with the changes in the input variables.
Time Value of Money is due to the potential earning capacity of the given amount of money.
FV Formula is a financial terminology is used to find out the value of cash flow at a futuristic date as compared to original receipt.
PV factor deals with the idea of time value for money by trying to estimate the current value per dollar to be received at a future date.
Perpetuity means the business or the individual would receive a constant flow of equal amount of cash with no end.
Annuity vs Perpetuity are very significant parts of Time Value of Money calculation.
IRR is a metric employed in capital budgeting which is used to measure the extent of profitability of potential investments.
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.
NPV is calculated as PV of cash inflow less PV of cash outflow, Whereas IRR is Known as discount rate that make NPV of all cash inflows of a project equal to zero.
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.
Break Even Point is analysis to reduce the complexities and to understand the profit making point of your product or job through these simple methods.
Payback period of an investment is the length of the time period required for cumulative total net cash flows to total initial cash outlays.
Payback period formula is used by the investors, generally how long it would take to recoup their initial investments.
Discounted payback period Formula is used to calculate how much time a project would get back its initial investment.
Profitability Index is the ratio of the present value of future cash flows of the project to the initial investments in the project.
The rate at which the cash is being burnt by a company is called the cash burn rate.
Simple interest is the interest amount computed as a fixed percentage of the Principal amount.
Effective interest rate is a true rate of interest earned. It is also called as market interest rate.
Loan amortization schedule is referred to the paying back off a loan or debt amount in terms of installments spread over a particular period of time.
Rule of 72 is a formula that helps us to understand when we can double our investment.
Geometric mean return formula is used for computation of Average rate per period on an investment compounded over multiple time periods.
Real rate of return formula helps an investor is to find out what actually he gets in return for investing a specific sum of money in an investment.
The continuous compounding formula is to determine the interest earned which is repeatedly compounded for an infinite time period.
In the weighted average formula, the value is being multiplied by the right amount of weight and that is the beauty of wt average.
Holding period return is widely used for comparing returns from various investments held for different periods of time.
Cost-Benefit analysis models are to ascertain the accuracy of any investment decision and provide a foundation for comparing it with similar proposals.