Financial Modeling Tutorials
Related Courses
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
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