Amazing Features!
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.
Who Should Attend:
For all Excel enthusiasts who want to be an Excel Pro and want to automate their processes.
Important Note:
Who Wants to Learn How to Create Capital Budgeting.
You Can Use these Functions On Any Version Of Microsoft Excel
Salient features of the Webinar
👉 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.
👉 Q&A
More Perks
CERTIFICATION
Obtain a digital certificate for completing this course
WORKING FILES
Get access to the working and business solution files
90 DAYS ACCESS
Get access to the webinar recording for 3 months
INTERACTIVE Q/A
Get answers to all your queries
Step 1: Signup
Click on 'Enroll Now' button and do Signup first.
Step 1: Signup
Click on 'Enroll Now' button and do Signup first.
Step 2: Payment
After Signing up go for payment method.
Step 3:
Your Registration is successfully done.
Step 3:
