CPD training for Professional

SAICA/ IRBA CPD Training available on our new site http://www.AuditExcel.com or go directly to the SAICA CPD training page .

These pages are designed to allow people to learn about using Microsoft Excel in a structured way. We have also built in the functionality to allow you to test yourself and at the same time verify that you have completed the training. This will be especially useful for professionals who need to earn points or hours that can be verified as training for the year e.g. (CA) SA (Chartered Accountants), CIMA, Doctors etc. It can also be used by people who want to improve their excel skills and include proof of this training on their CV's.

If you are struggling to watch the video clips due to your connection speed or network, see the bottom of the page to find out how to get a CD's with all the video clips included.

NOTE:

Due to the limited participants, the SMS line has been discontinued by the network provider. While we search for an alternate solution you can mail us the answers and we will verify them from our side. Send you mail to info@AuditExcel.co.za

Section 16: Finance Functions 1 (PMT, CUMIPMT, CUMPRINC) (CPD= 45 min)

PMT function (2 min)

The PMT function calculates the required payments to amortise a loan based on the original capital amount, interest rate and term of loan.
Switching on your add ins (2 min)

In order to get the best out of Excel, you should load the tools that come standard with the product. In this clip we load the Analysis tool pack to give us additional functions.

CUMIPMT/ CUMPRINC (4 minutes)

The CUMIPMT and CUMPRINC functions allow you to calculate the total interest or principal paid between two periods without having to develop a amortisation schedule.
Finance Exercise 1 (28 minutes)

Follow the instructions in the file.
Finance Exercise 1 Solution (9 minutes)
Question 16:
CUMPRINC will tell you the interest amount due between any periods of an amortization table?

Answers:
A- TRUE

B- FALSE

SMS the letters CPD, the section number and answer to See Note Above (South Africa ONLY)
e.g. CPD 1F

Secion 17: Finance Function 2- RATE, NPV, IRR (CPD= 45 min)

RATE (2 min)

Calculate the interest RATE charged on a constant annuity cash flow.

Compound Annual Growth Rate using the RATE function (2 min)

Use the RATE function to calculate the CAGR for numbers

NPV (3 min)

Calculate the Net Present Value of a series of cash flows.

IRR (2 min)

Calculate the Internal Rate of Return of a series of cash flows

Finance Exercise 2
Follow the instructions in the file.
Finance Exercise Solution [VIDEO CLIPS???]
What the end file should look like after the 2 exercises
Question 17:
Which of the following statements about Excel's NPV function is FALSE

Answers:
A- It does not allow for beginning of period calculation

B- You can only use annual cash flows

C- The first number it sees it considers to be one period out instead of the initial cash outflow

SMS the letters CPD, the section number and answer to See Note Above (South Africa ONLY)
e.g. CPD 1F

To understand the terms and conditions of receiving the certificate of completed modules please visit this page- CPD Terms and Conditions

To find out more about getting all this training material on a convenient CD visit this page - All video clips on a convenient CD.

Don't like what you see. Tell us at training@AuditExcel.co.za .

Do you have suggestions of what you would like to see. Tell us at training@AuditExcel.co.za .