This is going to change our way to Finance Anything tremendously and going to be immensely helpful to Capital Budgeting, Financial Planning & Analysis. Once again, CHAMP EXCEL is glad to organize a Master Class On Financial Functions & Capital Budgeting an Interactive Webinar by Eminent Excel Expert and CA Sh. Vijay Agarwal, awarded Microsoft Excel MVP for four consecutive years (2014-18) for his Excel Skills.
For all Excel enthusiasts who want to be an Excel Pro and want to automate their processes.
Who Wants to Learn How to Create Capital Budgeting.
You Can Use these Functions On Any Version Of Microsoft Excel
👉 How Do You Decide: whether you should invest in Project A or Project B
👉 NPV: calculates the net present value of an investment using a
discount rate and a series of future cash flows.
👉 XNPV: calculates the net present value of an investment using a discount rate
and a series of cash flows that occur at irregular intervals
👉 PMT: Calculates the payment for a Loan.
👉 PPMT: Calculates principal payment in given period.
👉 IPMT: Get interest amount of a loan payment in a given period
👉 RATE: Get interest rate per period of an annuity.
👉 NPER: Number of periods required to clear the loan amount
👉 DB: Calculates the depreciation of an asset.
👉 PV: Calculates the present value of a loan based on a constant interest rate
👉 FV: Calculates the future value of an investment based on a constant interest rate
👉 IRR: financial function that returns the internal rate of return for a series of
cash flows that occur at regular intervals.
👉 XIRR: financial function that returns the internal rate of return for a series of
cash flows that occur at irregular intervals.
👉 SLN: Returns the depreciation of an asset for one period,
calculated with a straight-line method
👉 SYD: Returns the "sum-of-years" depreciation for an asset in a given period.
Obtain a digital certificate for completing this course
Get access to the working and business solution files
90 DAYS ACCESS
Get access to the webinar recording for 3 months
Get answers to all your queries
Click on 'Enroll Now' button and do Signup first.