Home Â» Financial Modeling Â» Excel Modeling

Financial Modeling Tutorials

- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

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

Here is the list of Top 15 financial functions in excel that are most frequently used in practical situations

Explore this ResourceSensitivity analysis in excel modeling helps us study the uncertainty in the output of the model with the changes in the input variables.

Explore this ResourceTime Value of Money is due to the potential earning capacity of the given amount of money.

Explore this ResourceFV Formula is a financial terminology is used to find out the value of cash flow at a futuristic date as compared to original receipt.

Explore this ResourcePV 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.

Explore this ResourcePerpetuity means the business or the individual would receive a constant flow of equal amount of cash with no end.

Explore this ResourceAnnuity vs Perpetuity are very significant parts of Time Value of Money calculation.

Explore this ResourceIRR is a metric employed in capital budgeting which is used to measure the extent of profitability of potential investments.

Explore this ResourceNPV 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.

Explore this ResourceNPV 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.

Explore this ResourceNPV formula is used mainly for making investment decisions.

Explore this ResourceIRR 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.

Explore this ResourceBreak Even Point is analysis to reduce the complexities and to understand the profit making point of your product or job through these simple methods.

Explore this ResourcePayback period of an investment is the length of the time period required for cumulative total net cash flows to total initial cash outlays.

Explore this ResourcePayback period formula is used by the investors, generally how long it would take to recoup their initial investments.

Explore this ResourceDiscounted payback period Formula is used to calculate how much time a project would get back its initial investment.

Explore this ResourceProfitability Index is the ratio of the present value of future cash flows of the project to the initial investments in the project.

Explore this ResourceThe rate at which the cash is being burnt by a company is called the cash burn rate.

Explore this ResourceSimple interest is the interest amount computed as a fixed percentage of the Principal amount.

Explore this ResourceEffective interest rate is a true rate of interest earned. It is also called as market interest rate.

Explore this ResourceLoan 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.

Explore this ResourceRule of 72 is a formula that helps us to understand when we can double our investment.

Explore this ResourceGeometric mean return formula is used for computation of Average rate per period on an investment compounded over multiple time periods.

Explore this ResourceReal 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.

Explore this ResourceThe continuous compounding formula is to determine the interest earned which is repeatedly compounded for an infinite time period.

Explore this ResourceIn the weighted average formula, the value is being multiplied by the right amount of weight and that is the beauty of wt average.

Explore this ResourceHolding period return is widely used for comparing returns from various investments held for different periods of time.

Explore this ResourceCost-Benefit analysis models are to ascertain the accuracy of any investment decision and provide a foundation for comparing it with similar proposals.

Explore this ResourceMortgage APR is the overall cost of the loan. whereas it is the applied interest rate on the loan.

Explore this ResourceFree Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

** Please provide your correct email id. Login details for this Free course will be emailed to you*

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

** Please provide your correct email id. Login details for this Free course will be emailed to you*

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

** Please provide your correct email id. Login details for this Free course will be emailed to you*

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

Free Valuation Course

Learn Discounted Cash Flow Valuation, Comparable Comps, Download Valuation Templates

Free Valuation Course

Learn Discounted Cash Flow Valuation, Comparable Comps, Download Valuation Templates

Download Colgate's Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Download Colgate Ratio Analysis Template

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

** Please provide your correct email id. Login details for this Free course will be emailed to you*