Download - 1 - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Transcript
- 1 - 1 Certified General Accountants of British Columbia 2 FINANCIAL ACCOUNTING ASSETS - FA2 3 4 MODULE 5, INTEREST CONCEPTS OF FUTURE & PRESENT VALUES 5 MS. DALLAS: Welcome to the CGA Financial Accounting 6 Assets, module 5, Interest concepts of future & 7 present value, presented by Laura Dallas and 8 Erin Creagh. 9 10 11 12 FA2, MODULE 5, PART 1, INTRODUCTION You are now listening to Module 5, part 1, the introduction. There will be five parts to this lecture. 13 Part 2, is the Module Summary and Learning 14 Objective; Part 3, Past Exam Analysis; Part 4, 15 the Overview and Definitions Topics 5.1 – 5.2, 16 and Part 5, will be topic 5.3 to 5.5. 17 topic 5.6 is a computer illustration and you 18 will be doing that part on your own. 19 Note that So welcome to interest calculations. This 20 module will be one that either you love, because 21 you already know how to do it, or it can be your 22 worst nightmare if you haven’t worked with 23 interest and financial calculators before. 24 A quick overview of the module 5 topics 25 are: the time value of money; basic interest Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 2 - 1 concepts; computing present and future values; 2 periodic payments required for present value and 3 future value problems; topic 5, computing the 4 terms; and topic 6, the computer illustration. 5 There is not one specific calculator that 6 students can use. 7 calculator they want, so trying to teach each 8 student how to use their financial calculator 9 and automatically getting the correct answer, 10 can be a challenge in this format. 11 purchase a financial calculator that you feel 12 comfortable with, but make sure you know you 13 really need a financial calculator and not a 14 scientific calculator. 15 after you finish this module you will certainly 16 know why. 17 Students can use any You can Big differences and At the CGA website, you will find a heading 18 “Allowable Examination Room Materials and 19 Calculators”. 20 of print screen what the window looks like, what 21 you now want to go and find if you want to 22 double check what I am going to tell you here. 23 But basically students may use their own 24 calculator in examinations, provided they meet 25 the following guidelines: the calculator is I have cut and pasted here a sort Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 3 - 1 silent, battery operated and non-printing; the 2 calculator has only one line of display, and the 3 calculator does not have alpha keys. 4 keys allowing text entry. 5 important. That means That is very 6 Students are responsible for ensuring that 7 the calculator batteries are fully operational. 8 There will be no exchange or borrowing of 9 calculators or batteries during the exam. 10 no operating instructions allowed in the exam 11 room either. 12 other type of aid or material is permitted in 13 the exam room. 14 And No other mechanical, electronic or You can bring in spare batteries just as 15 you can bring in spare pencils and spare 16 erasers. 17 in spare batteries for you calculator. 18 have seen some students bring in two calculators 19 one that’s their financial calculator for doing 20 all financial information, and sometime students 21 will bring in a calculator that has big key pad 22 numbers so they can quickly add something up if 23 necessary. 24 calculators but they all must follow those rules 25 about being silent and non-printing et cetera, If you feel the need to you can bring And I So, yes, you can have two Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 4 - 1 2 et cetera. So hopefully you hear me quite clearly that 3 I do highly recommend that you have financial 4 calculator. 5 calculate the present value and the future value 6 and the amounts. 7 calculate it all if you know all the formulas 8 and things like that but an investment in a good 9 financial calculator will be an asset to you in 10 further CGA courses, including the finance 11 courses. 12 calculator can be an accountant’s best friend. 13 So get one that you like and that you can use 14 well and feel confident using it well. 15 You’ll be able to automatically Yes, you can manually But truthfully a good financial And of course remember that it is your 16 responsibility to know how to use your 17 calculator, and be prepared for the exam. 18 students that know how to use it and calculate 19 the present values and things like that quickly 20 just -- you don’t have to spend time double 21 guessing yourself, it’s something you just want 22 to know. 23 for future courses. The And like I say it is in preparation 24 In this module, the solutions to the 25 numerical calculations are demonstrated using Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 5 - 1 the most common format of data entry for 2 financial calculators. 3 could be slightly different across different 4 brands and models of calculators. 5 look at your owner’s manual for some specific 6 instructions. 7 are almost like car manuals they’re pretty 8 detailed and pretty long. 9 meaning to scare you about these financial 10 calculators, but if you know how to use it 11 definitely a great asset for this exam. 12 But the method of input So you can Although those owner’s manuals So I am certainly not Now some students who encounter little 13 difficulty with interest and present value 14 concepts, the reason they don’t encounter 15 difficulties, is most likely because they have 16 taken a business math course, usually at a 17 college level or they have taken a finance 18 course. 19 course at a college level and found that the 20 successful students are the ones that know how 21 to use their calculators. 22 just memorize all the formulas but you can’t 23 keep those with you forever. 24 students that get A’s are the ones that know how 25 to use their calculators. And I have taught the business math Some students like to Honestly the And some of you are Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 6 - 1 saying, “How difficult is it?” 2 saying for adding and subtracting I’m saying I 3 want you to know how to use it to calculate the 4 present value. 5 I am not just And also if you need a refresher, there are 6 many business math textbooks out there. 7 see them at your local college bookstore, or 8 even at your library. 9 same sort of website as the FA2 text. 10 in from McGraw Hill and college and you will 11 find a list of quite a few textbooks listed 12 there, and you will see certainly business math 13 textbooks there. You can Or you can just use the Just type 14 If you do end up at that McGraw Hill 15 website usually the first one you might see is 16 the one called Business Mathematics in Canada, 17 by Ernest Jerome. 18 I quite like it. 19 publisher McGraw Hill is that the text websites 20 are all set out in a similar fashion. 21 you use the text for the FA2 website, you will 22 certainly be able to use up these business math 23 tips from this website equally as well. 24 might quite enjoy that. 25 if you can find that. I have used that text before, And the nice thing about the So, if And you So have a look and see So you certainly don’t Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 7 - 1 have to, like I say, as my job as a lecturer 2 isn’t to give you more information but for some 3 students that need a brush up on their math 4 skills this might be a way to do it. 5 And another extra, and again this is just 6 an extra if you are struggling with your 7 calculator or these kind of skills, I’ve got a 8 website I will mention to you in a minute about 9 an interactive calculator demonstration 10 exercise. 11 your calculator, be sure to check it out. 12 am going to give you a specific one for the BAII 13 plus, but I’ll mention that one to you and you 14 can find it and if that’s not your calculator of 15 course you could just Google your calculator and 16 find it. So if you are having trouble with Or I 17 Now when I am teaching a business math 18 class we actually go through the simple interest 19 questions one step at a time looking at each 20 button that we are going to push on the 21 financial calculator until every student in the 22 class has it. 23 it’s a great exercise. 24 25 Sometimes it can take a while but Actually there is a link directly from the McGraw Hill site and the business math in Canada Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 8 - 1 website directly to the Texas Instrument BAII 2 plus calculator. 3 calculator, I do like it. 4 any one on the exam that you want. 5 strongly recommend not a particular brand, but I 6 am recommending you need a financial one. 7 kind of laugh every time I see it somewhere 8 saying, “Well, check your user’s manual on the 9 calculator,” because the one I got, honestly it 10 was about 40 pages long. 11 out your calculator’s website. And I have used that Remember you can use And I I So definitely check 12 I am just going to give you an example in 13 the next couple of pages of what it looks like 14 for the one that I found. 15 that have come to me in class, they have got 16 their financial calculator and they can’t even 17 change the decimal places. 18 to this interactive website about your 19 calculator you will actually know how to do it 20 and you don’t even stop to think, it is just as 21 quick. I have known students But once you’ve gone 22 And I know I am kind of going on about this 23 for a minute because many of you can just change 24 anything on your phones and electronic gadgets 25 in half a second so you shouldn’t have a problem Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 9 - 1 with it, but those of you that are having a 2 problem be sure to check out somewhere that you 3 know how to use it well. 4 subject. 5 Enough of that What else have I got for you here in this 6 module for module 5? 7 things. 8 practice, multiple-choice in the hand out 9 document, because one thing about present value, 10 how you calculate it has not changed over the 11 years. 12 can do it, whether we’ve been using formulas or 13 whether you’re using tables, but now the 14 definite way to do it is from your calculator. 15 So I have included lots of extra multiple-choice 16 with you but they are from really old exams and 17 they were calculated using tables, which means 18 they only go to about 5 decimal places so they 19 could be out just slightly. 20 that. 21 A few more introductory One thing is I’ve got lots of extra There has been a few different ways we So just watch for So again if you already know how to use 22 your calculator present values is nothing, you 23 won’t even need to worry about it. 24 those of you that this is something new or 25 you’re really rusty on, remember your best But for Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 10 - 1 friend is called practice, practice, practice. 2 Doing the extra questions will give you the 3 confidence so on exam day you’ll be just flying 4 through these questions. 5 ones you look forward to. 6 They will be the easy I want you to visualize the exam day, take 7 ten seconds out right now and visualize the exam 8 day. 9 a) you’re going to feel comfortable and 10 confident because you’ve practiced, or 11 b) you are going to be stressed and panicking 12 because you can’t remember how to make the 13 calculator work for you. 14 You kind of have two choices here: As I mentioned the best way to know for 15 sure you know how to make your calculator work, 16 practice, practice, practice. 17 Let’s look ahead. Guess what after module 18 5 you are over halfway through. 19 up in the balance of the course? 20 current financial assets & current financial 21 liabilities. 22 concepts that you are learning in module 5 23 there. 24 inventory valuation and cost of goods sold. 25 Module 8, again we’re going to be using this What’s coming Module 6 is You will have to use some of the Module 7 is on inventory measurement, Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 11 - 1 financial calculator, investments and financial 2 instruments. 3 and equipment and intangible capital assets, and 4 module 10, on property, plant and equipment and 5 intangibles focusing on depreciation, 6 amortization and impairment. 7 Module 9, is on property, plant You’ve got this little breather in module 8 5, and then just a few more concepts that 9 somewhat fit together. 10 Okay, we are almost finished here for the 11 introduction. 12 on those things since some of you will find it 13 helpful and off you go to check out your 14 calculator. 15 I hope I didn’t nag you too much Next. part 2 on the module summary and 16 learning objectives. 17 minutes almost, this is the end of FA2, Module 18 5, Part 1 the introduction. 19 FA2, MODULE 5, PART 2, MODULE SUMMARY & LEARNING 20 21 And at about 12, 13 OBJECTIVES MS. DALLAS: FA2, Module 5 Interest Concepts, Part 2 the 22 module summary and learning objective which will 23 take us from slide 27 to 38. 24 25 So the topics in module 5, an overview: the time value of money; basic interest concepts; Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 12 - 1 computing present and future values; the 2 periodic payments required; computing the term, 3 and then the computer illustration. 4 huge module and they have just broken it into a 5 lot of little pieces and grasping each one one 6 at a time. You’re going to find this one of the 7 shorter modules for you to work through. It’s not a 8 So the learning objectives, number 1, is to 9 describe the concept of the time value of money; 10 2, describe the concept of interest including 11 simple and compound interest, and effective and 12 nominal rates of interest; and 3, compute the 13 present and future value of a single payment, 14 and an annuity, both ordinary and annuity due; 15 and 4, compute the required periodic payments 16 for a given present value or future value; 17 5, compute the number of periodic payments and 18 the final payment required to eliminate a debt; 19 and 6, design a worksheet to perform time value 20 of money analysis. 21 So interest concepts. This module explains 22 the fundamental concepts of interest and present 23 value and future values. 24 annuities due are both explained. 25 techniques, including the use of a financial Ordinary annuities and Valuation Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 13 - 1 calculator and functions in Excel are 2 demonstrated. 3 So the concept of the time value of money, 4 a dollar today is worth more than a dollar 5 received tomorrow because today’s dollar can be 6 invested to earn interest. 7 Simple and compound interest. Interest can 8 be thought of as a rent charge for the use of 9 money. 10 the principal amount owing only and not accrued 11 interest. 12 used. 13 periodically and based on the principal amount 14 owing plus any unpaid interest. 15 compounds on itself. 16 Simple interest is calculated based on Simple interest is not very commonly Compound interest is calculated So the interest A nominal rate is the stated rate of 17 interest. 18 that you actually pay when the effects of 19 compounding are considered. 20 concepts are easy to get mixed up but when we 21 get to that section of the module notes I will 22 make sure I clarify a bit more. An effective rate is the annual rate And those two 23 So to determine the future and present 24 values of single payments and annuities, you can 25 use the calculator method or the spreadsheet Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 14 - 1 method. 2 they tell you to refer to the owner’s manual of 3 your financial calculator for specific 4 instructions. 5 calculator method for the exam. And of course in the module summary And really you need to know the 6 To calculate the regular payment required. 7 Determining the regular payment to extinguish a 8 debt by equal payments due at the end of each 9 interest period and determine the regular 10 payment required to accumulate a required future 11 amount. 12 want to retire with a million dollars how much 13 do I have to save every month for the next so 14 many years to do that? Great question. 15 A good example here is to say, if I And determine the regular payment required 16 payable in advance, for an acquisition made on 17 credit. 18 regular payment meaning we want the same payment 19 amounts. 20 will be different. 21 All of these items have, they say, a It’s just the last payment amount that And compute the number of periodic 22 payments. 23 payments plus a smaller last payment that is 24 required to extinguish a debt. 25 how many payments are you going to have to make Determining the number of full In other words Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 15 - 1 at a certain amount before you pay off the debt? 2 Well, as you can see module 5 is much 3 shorter and quite a welcome relief for many of 4 you. 5 on for this module I believe, so you’re going to 6 be busy with that. 7 this as a slightly lighter module for many of 8 you. 9 10 You do have that assignment to be working It’s kind of nice to have At about 5 minutes slide number 38, this is the end of FA2, module 5, part 2. 11 FA2, MODULE 5, PART 3, PAST EXAM ANALYSIS 12 MS. DALLAS: FA2, module 5, interest concepts of future 13 and present value, part 3, the past exam 14 analysis. 15 The exam blueprint indicates that 5 to 7 16 percent of the exam will be from module 5. 17 Usually module 5 is covered in the format of a 18 few multiple-choice questions, but occasionally 19 a question with journal entries has shown up on 20 the exam, as you need to know the debit and 21 credit portion and then from module 5 you are 22 going to need to know the calculations. 23 prepared for those multiple-choice questions or 24 even a small question on interest and present 25 values. Be Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 16 - 1 When I say a small question, one of the 2 really old questions I saw on it was way back in 3 December 2004, and I really haven’t seen one 4 since then, and you won’t have access to that 5 old exam so I will let you know what I mean when 6 I say they’ve got a small question on it, I 7 think it is worth only 7 marks. 8 put it in a multiple-choice question, they laid 9 it out for you. 10 On January 1, a company obtained a loan of 11 $250,000. 12 installments including principal and compound 13 interest at 8 percent. 14 due at the end of the year. 15 prepare an amortization schedule for the loan 16 and round it to the nearest dollars, and then 17 part (b) record the journal entry related to the 18 But rather than The question is pretty clear: The loan is to be paid in three equal And the first payment is The required is to st payment made on December 31 . 19 Now we haven’t seen this type of question 20 for a while but it doesn’t mean something like 21 that won’t come back up. 22 multiple choice well I don’t think you will have 23 a problem with this. 24 25 But if you know the The examiner felt that the overall performance on the question was satisfactory; Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 17 - 1 although the individual results varied 2 significantly. 3 that many students did well, but many students 4 had no idea how to tackle the question. 5 Now this leads me to believe I have included the solution for part A, 6 the little schedule for you, and there are not 7 exact columns you have to do, but normally if 8 you are making an amortization schedule you’d 9 have the date, the amount of the payment, what’s 10 the amount of the interest, so what’s the total 11 payments and what’s the ending balance of the 12 loan. 13 that, they wouldn’t care if you had the order 14 slightly out. 15 it is not something that’s actually a published 16 document with your financial statements that has 17 to be exact. 18 doing little schedules. 19 And it’s not like you have to memorize When something is just a schedule So there is some flexibility when And the journal entry would be a debit to 20 the interest expense, a debit to the loan 21 payable and a credit to the cash. 22 about 4 maybe 5 marks for the schedule and 2 or 23 3 marks just for the journal entry. 24 25 So that was Now sometimes, as I have shown from the June 2010 question (g), sometimes the question Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 18 - 1 will not be all just number calculating 2 regarding module 5, it could be a bit theory 3 based. Such as: 4 “If payments are changed from being made 5 at the end of the month to the beginning 6 of the month, which of the following 7 would be true? 8 1) The future value of a series of 9 payments would decrease. 10 2) The future value of a single payment 11 would not change. 12 3) The present value would increase; or 13 4) The present value of a single payment 14 would decrease.” 15 Now, if I was doing this kind of question I 16 would give myself a small little example. 17 again if we’re making payments at the end of the 18 month and we’re changing it from the end to the 19 beginning, which would be true? 20 answer is, three, the present value of a series 21 of payments would increase. 22 But The correct And I look at the June 2010 question (h): 23 “Roman does not have any money saved for 24 his retirement. 25 years and he wants to have $100,000 saved He wants to retire in 10 Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 19 - 1 by that time. 2 earn about 6 percent per year on his 3 investments. 4 at the end of each year to achieve this 5 goal?” 6 He thinks he is going to How much must he contribute So that’s a standard calculate the answer 7 question. 8 answer is 1) $7,587 and I will show you the 9 calculation for that in just a second. 10 What is the amount? The correct So in this module what we are trying to do 11 is either calculate the present value, calculate 12 the future value, calculate the amounts of the 13 payments. 14 15 So here’s another example from June 2010 question (i). 16 “LIM is selling some drilling equipment 17 and finally it received an offer. 18 purchaser would provide a down payment of 19 $50,000 and make annual payments of 20 $10,000 for six years, and the first 21 payment is due in one year. 22 cash equivalent price of this offer, 23 assuming the effective interest rate is 8 24 percent?” 25 The What is the In other words what are they really offering in Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 20 - 1 2 today’s dollars? And of course we would want that so we 3 could compare it against somebody else that’s 4 got a pure cash offer for us. 5 and let me show you how in just a second. 6 The answer is 2, I have got those answers laid out for you 7 and basically when I say payment equals $10,000, 8 “N equals 6,” “I equals 8,” “present value 9 equals,” you have to plug that in and calculate. 10 You need to calculate the present value of all 11 the amortization amount and add the $50,000 that 12 they are going to pay you cash right now. 13 are finding out what the stream of money that 14 $10,000’s worth plus add the $50,000 they just 15 gave us, that’s why the answer is $96,229 and 16 not $46,229. 17 So we Notice these answers have all been rounded 18 to whole dollars, if you did get some cents it 19 probably means you did it correctly. 20 your calculators would be preset for 6 or 9 21 decimal places, which makes you have more 22 accurate numbers, so good for you for that. 23 Most of So if those questions slightly challenged 24 you, good. 25 module and you’re going to spend some time You’re going to go through the whole Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 21 - 1 learning the material first and then you will 2 spend some time practicing. 3 feel comfortable with it and you will be ready 4 for the exam. 5 And then you will So this was just a quick little review of 6 what kind of questions have been on the past 7 exams, what can you expect and what you have to 8 look for as you are going through the module. 9 So at about 7 minutes, this is the end of part 3 10 on the past exam analysis. 11 FA2, MODULE 5, PART 4, OVERVIEW AND DEFINITIONS, AND 12 TOPICS 5.1 AND 5.2 13 BASIC INTEREST CONCEPTS 14 MS. DALLAS: TIME VALUE OF MONEY and FA2, Module 5, Interest concepts, Part 4. 15 This section will take us from slide 50 to 74 16 and covers a lot of interesting information on 17 an overview of interest concepts, definitions, 18 information about the calculator and then on to 19 topic 5.1, the time value of money and 5.2 on 20 basic interest concepts. 21 First thing I want you to make sure you 22 note is about the required reading. 23 actually not physically in the textbook and you 24 need to get to that required reading. 25 to click on the link and it is only available It’s You have Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 22 - 1 online, and that link is at the beginning of 2 topic number 1, 2 or 3. 3 chapter 8 from the textbook, but it is only 4 online. 5 It is an appendix for And it’s actually not that long so if you 6 really wanted to print it out, you can even save 7 it to your hard drive or you can print it out or 8 whatever suits you. 9 Now on slide 52 I have the abbreviations 10 for most of the calculator terminology. 11 stands for present value; “FV" for future value; 12 “PMT” is the amount of the annuity payment; “I” 13 is the interest rate per period; “N” is the 14 number of periods. 15 of years it is the number of periods. 16 the present value, the future value, the 17 payment, the interest or N, or a “?” you should 18 be able to solve for any one of the desired 19 values. 20 “PV” Notice it is not the number So for Also be aware that there is the BGN key, 21 the begin key, and you need to set your 22 calculator on that if you’re using annuity due. 23 But only if you are using an annuity due, and if 24 you are trying to use -- do a regular annuity 25 and your begin key is on, you’re in begin mode Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 23 - 1 2 and you’re going to get the wrong answers. And a note of caution is you cannot just 3 clear the calculator by pressing the calculator 4 clear, you have to completely reset all of the 5 entries for the values of N, I, PV, PMT and the 6 future value. 7 clear your calculator of that and you are going 8 to have to look in the instruction manual if 9 you’re not aware of how to do it. 10 And there are certain ways to And the good thing is that it holds 11 everything the same. 12 something, you know, with $50,000 over 5 years 13 at, let’s say the interest rate is 8 percent or 14 10 percent or 12 percent. 15 in and change “I” and press the calculate button 16 and it will do it. 17 do it. 18 So that is why the calculator doesn’t clear the 19 memory for each one of them, unless there is a 20 specific key -- I think you have press the 21 function 2 key or something like that. 22 sure you look at your calculator and know how to 23 clear all those keys. 24 25 Say we are trying to do We can just go back Then we change “I” again and So it does the what if situation great. So make Another really important thing is called the cash flow. You have to enter the values Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 24 - 1 into the calculator correctly. 2 as plus, and cash outflow is a minus. 3 you deposit $5,000 into the bank that’s a 4 negative, and you are thinking “What?” 5 is, it’s out of your pocket. 6 get the money back in the future it’s going to 7 be a positive. 8 the plus/minus key for this. But basically the 9 concept always is if the present value is minus 10 then the future value is positive or visa versa. 11 Because either we give the bank money and then 12 later we get the money back from the bank or the 13 bank gives us money and then we make payments 14 back to the bank. 15 always a plus and a minus. 16 Cash inflow is So when Well it And then when you So you are going to have to use But with the cash flow it is So again the underlying logic is that a 17 present value represents what you would pay 18 today, a cash outflow, to obtain a sum or sums 19 of money in the future, the inflows. 20 value is positive as the bank will give the 21 money back to you, so then it’s an inflow to 22 you. 23 for the bank, we’re looking at it for you. 24 outflows are negative; inflows are positive. 25 The future We are not looking at outflows or inflows So So money has a different value over time Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 25 - 1 because money can be put to work, and therefore 2 it earns interest. 3 Let’s look at a couple of definitions. For 4 simple interest, it’s calculated based on the 5 original principal amount and not on any accrued 6 interest. 7 on the original amount. 8 is calculated periodically and based on the 9 original principal amount plus any unpaid 10 interest that’s been accrued since the beginning 11 of the period. 12 It just calculates the interest based And compound interest So it compounds. The future value is the value that a stream 13 of money will accumulate to in the future at a 14 given compounded interest rate. 15 value is the value today of that stream of money 16 to be received sometime in the future. 17 single payment, the present value factor is 18 always less than the future value factor, 19 assuming positive interest growth rate. 20 that number there is sort of more important when 21 you are using tables and stuff, and what we’re 22 trying to say, if we’ve got a certain amount of 23 money ten years from now or five years from now, 24 any point in the future it will be worth less 25 than that now because the money is worth less And the present For a And Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 26 - 1 now, more in the future. 2 in the future might be $970 today, so you can 3 see that factor is less than one. 4 percent so that’s less than one. 5 to totally know that but you have to remember 6 that when you are going directions with the 7 money. 8 So a thousand dollars It’s like 97 You don’t have And importantly the definition of an 9 annuity. 10 of equal amounts. 11 payment is made at the beginning of the period. 12 And we will go through those details in a little 13 bit. 14 15 Annuity is a number of single payments And annuity due is when the FA2, MODULE 5, PART 4, TOPIC 5.1 TIME VALUE OF MONEY So some hints I have about the time value 16 of money. 17 you’re converting everything to the present 18 value or to the future value. 19 directed, you should pretty much always be 20 calculating to the present value. 21 whether you are given the future amounts or the 22 present amount. 23 carefully in those problem style formats. 24 what they are telling you for the future or is 25 it what’s happening now? You always have to determine whether Unless otherwise And determine So you have read the question Is Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 27 - 1 2 And also determine are you given just a single amount or an annuity? 3 And then you have to perform the 4 calculations to make the decision about the 5 problem or the case. 6 I have a few other sort of little kind of 7 rules. 8 greater the value. 9 conversely, the lesser the value of the present 10 value for a given future value. 11 longer it takes to maturity the more it is going 12 to be worth at the end. 13 The longer the time to maturity, the And also the opposite or Okay. So the And the higher the rate of interest, the 14 greater the future value will be as well. 15 the more frequent the compounding the greater 16 the future value will be as well. 17 the longer the time, the higher the rate, the 18 more frequent. 19 will be more. And So that means Always the amount in the future 20 So there is sort of a relationship between 21 the present value and the future value; that is 22 the future value equals the present value times 23 one plus “I” to the “N” factor. 24 restated showing the present value. 25 It can also be So these formulas are the basis for the Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 28 - 1 above statements about the time value of money. 2 I’m really not going to go over more of the 3 formulas as I encourage you to use the 4 calculator for everything, the financial 5 calculator that is going to automatically 6 calculate everything. 7 always just use the formulas to go through it. 8 It is not recommended, and also some students 9 love to double-check their work by memorizing 10 the formulas. 11 ahead, but if not focus on your financial 12 calculator. 13 FA2, MODULE 5, PART 4, TOPIC 5.2 14 But you definitely can If you’ve got extra time go SIMPLE INTEREST So topic 5.2, simple interest is rarely 15 used in business, so unless stated otherwise, 16 all interest computations are to be calculated 17 on a compound basis. 18 the compounding period is annual, unless there 19 is a specific comment to tell you otherwise. 20 And that’s general. 21 law, in Canada, we always are stating interest 22 in values that are compounded annually unless 23 they tell you otherwise that it is not annual. 24 So the method of calculating interest 25 refers to how often the interest is compounded. And you would assume that We almost have that rule, Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 29 - 1 So it’s quite often to see lenders compounding 2 interest on a basis or daily, weekly, month, 3 semi-annually, or annually. 4 always assume it’s annual unless you are told 5 otherwise. 6 But, like I said, And accountants are interested in the 7 number of periods, not years, that the 8 investment or loan is to be held for, and the 9 interest rate per period. 10 requires converting the nominal rate per year to 11 a more appropriate measure. 12 purposes, when we are trying to compare things, 13 it is necessary to ensure that all nominal, the 14 quoted rates of interest, are converted to the 15 effective rate, what you actually pay or receive 16 rates. 17 And this frequently So for comparative So be patient with yourself and almost 18 write this down, and on slide 69 it’s printed 19 out there for you. 20 quoted in the annual terms with the number of 21 compounding periods. 22 compounded quarterly. 23 as the nominal rate. 24 pay when the effects of compounding are taken 25 into rate is called the effective rate. That the interest rates are, For instance 10 percent The quoted rate is known The rate that you actually Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 30 - 1 So for example, 10 percent compounded 2 quarterly is really the effective rate of 10.38 3 percent. 4 effective rate. 5 refers to the annual stated rate with 6 compounding. 7 that you actually end up receiving or paying. 8 So effectively how much? 9 important is say you have a credit card or 10 something and they tell you it’s only 2 percent 11 per month. 12 it’s really 28.8 percent per year I believe that 13 one is. 14 they are talking about on an annual basis. 15 So the nominal rate versus the The nominal rate of interest The effective rate is the rate Where this is really Well when you compound that out, So it’s really important to know what And if you’re trying to figure out some of 16 these things on the calculator or your 17 spreadsheet, the easier way to calculate rather 18 than using the formula every time to switch 19 between nominal to effective rates, is there are 20 some built-in functions on your calculator or 21 your spreadsheet to do it for you. 22 want to try and find those and make sure you 23 know how to use that function on your 24 calculator. 25 So you might Like I said I almost feel kind of remiss Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 31 - 1 not showing you on your calculator, but if there 2 is 10 of you out there I believe there’s at 3 least five different financial calculators. 4 we can’t really do that, but we are telling you 5 these are the important things you need to know, 6 now figure out your calculator to do that. 7 So So on slide 73 I have kind of made a little 8 table for you. 9 $1,000 at 10 percent interest today, for 3 10 years. 11 $100 interest, so your total investment will be 12 $1,100. 13 to have a $110 interest, so you will have 14 $1,210. 15 $121 interest, so you will now have $1,331. 16 the future value of $1,000 in three years at 10 17 percent is $1,331. 18 value, the PV of $1,331 three years from now at 19 10 percent is $1,000. 20 able to go back and forth with these numbers. 21 Supposing you want to invest So at the end of year 1, you will have a So at the end of year 2, you’re going So at the end of year 3, you will earn So Or you can say the present So see you have to be And we will go into a little more detail of 22 even going back and forth with the numbers, but 23 even in -- if I told you we have $1,000 today 24 and we want to have so much in the future how 25 much do we have to put in per year, or how many Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 32 - 1 years are we going to have to put in for? 2 That’s what we will look at in the next part of 3 the lecture. 4 So actually at 13 minutes, this is the end 5 of FA2, Module5, Part 4, which was just the 6 overview of the definitions for topic 5.1 and 7 5.2, and quite a bit of the real details are 8 going to be in the next section coming up in 9 topics 5.3 to 5.5. 10 So again at about 13 and a half minutes 11 slide 74, this is the end of FA2, Module 5, Part 12 4. 13 FA2, MODULE 5, PART 5, TOPICS 5.3 TO 5.5, COMPUTING THE 14 PRESENT AND FUTURE VALUES, THE PERIODIC PAYMENTS 15 and CALCULATING THE TERM 16 MS. DALLAS: FA2, Module 5, Interest Concepts, Part 5. 17 This section will take us from slide 75 to 102, 18 and Topics 5.3 to 5.5 on computing the present 19 and future values, the periodic payments, and 20 calculating the term. 21 potatoes of this module. 22 23 24 25 This is the real meat and FA2, MODULE 5, PART 5, TOPIC 5.3 COMPUTING PRESENT AND FUTURE VALUES Topic 5.3. In Topic 5.3 please note, I have copied this directly from the module notes Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 33 - 1 because I want to make sure you hear it and see 2 it, and are aware of it. It says: 3 “While the required reading does 4 illustrate the calculation of both 5 present and future values, this topic 6 limits the balance of the discussion to 7 the calculation of present values, 8 because these are what you are most 9 likely to encounter. 10 future values also are examinable.” 11 However, note that So you have to be able to go from present 12 values to future values or future values to 13 present, and they usually are giving you the 14 examples only calculating the present value. 15 So basically there’s like three, maybe even 16 more methods, for calculating the present value 17 and future value. 18 is the spreadsheet method; and three, is the 19 calculator method. 20 need to use the calculator method. 21 the tables were given, I am not sure for how 22 long or if they are going to be given this year, 23 actually I didn’t read up on it. 24 want to be using tables make sure you follow up 25 and call the CGA office and ask them, but I have One is the table method; two, And you will most likely In the past If you really Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 34 - 1 a feeling they are not supplied anymore because 2 they are actually not part of the course 3 content. 4 administrative so I am not going to really go 5 there. 6 anymore, however it is briefly found in the 7 required reading, sort of in the other sections 8 that aren’t referred to. 9 those. 10 And like I said I am not The module notes don’t discuss tables So let’s not count on The spreadsheet method, well you’re not 11 going to be taking your computer into the exam 12 so from the spreadsheet you can come up with 13 formulas and if you want to memorize those you 14 could, although I think it’s silly. 15 really want to be using your calculator. So you 16 And as I have said, most accountants 17 nowadays rely heavily on the use of their 18 financial calculator, notice not the scientific 19 calculator, and you will be much more efficient 20 and successful in your career if you become 21 proficient with your calculator. 22 So annuity versus annuity due. It’s from 23 the required reading on page 397 where I picked 24 up these definitions for you. 25 is where the payment or receipt occurs at the Ordinary annuity Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 35 - 1 end of each interest compounding period. 2 annuity due, the payment or the receipt occurs 3 at the beginning of each compounding period. 4 call it an ordinary annuity. 5 mortgage, all of those kinds of things, loans, 6 they are all ordinary. 7 they give you the money at the beginning of the 8 month, your first payment is at the end of the 9 month. 10 And an We For instance a That means your payment, So there is a few underlying assumptions 11 that you need to be aware of for annuities. 12 amount of each payment is the same throughout 13 the entire stream of the annuity payments. 14 the payments are equally spaced. 15 monthly, quarterly or even annually. 16 interest rate is stable, that means it always 17 the same. 18 interest coincide with the payment period. 19 other words, it’s annual payment, annual 20 compounding. 21 not exist, then you have to have a more -- it’s 22 more intense, the calculation, and it all has to 23 be done manually. 24 25 The And It can be The The periods used for compounding In If any of these conditions does Exhibit 5.3-1, shows the difference between an ordinary annuity and an annuity due. Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 36 - 1 Basically what the difference is is the timing 2 of the payment. 3 is at the end of the interest period, whereas 4 the annuity due, the payment is at the 5 beginning. 6 comparing the timeline with the ordinary annuity 7 and the three payments with the annuity due and 8 the three payments. 9 For the ordinary, the payment And you can see this difference by For some students it is a whole lot easier 10 once you visualize that picture of the time 11 chart of it. 12 there. It makes sense of what is going on 13 And example 5.3-2 and -3 – I have reproduced 14 it on slide 82 and 83 here – but what’s basically 15 happening is for an ordinary annuity you would 16 enter in the data. 17 2500, “I” is 4, and the present value would work 18 out to be negative $23,462.68, when you’ve got 19 your calculator in your financial mode and 20 everything else has been cleared. 21 For “N” is 12, the payment is Now if you just changed one thing, and that 22 one thing was you set your present value for an 23 annuity due, you have to set it to the BGN mode. 24 You really wouldn’t even have to change any of 25 the other numbers because they would all stay in Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 37 - 1 there and then you press compute for present 2 value and you’d get $24,401. 3 the beginning of the period it’s more than the 4 payments at the end of the period. 5 So if you pay at And the reason that would make sense is if 6 you get the money at the beginning of the period 7 you’re earning interest during that period. 8 Where as if you got the money at the end of the 9 period you wouldn’t have earned interest during 10 that period. 11 So practice on your calculator. Make sure 12 you can stick these two exact things in and come 13 up with the exact amount of monies. 14 your calculator. 15 have done the business math I literally walk 16 around and make the students all punch it in and 17 I should be able to see the exact numbers, and 18 it usually has more decimal places in it. 19 want to have it exact and make sure we walk 20 through it one step at a time, that we really do 21 get these numbers. 22 ready to move on if you can’t get these numbers. 23 Practice on If I have a classroom, when I And I And honestly you are not And quite often I find what the problem is 24 with some of the errors that are made is if 25 they, the student, does not enter the plus or Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 38 - 1 the minus key correctly, or if you haven’t 2 cleared all the items to start. 3 there is this little key called the compounding 4 frequency that gets all messed up and that could 5 be a bit of the problem. 6 in the other parts, is learn your calculator. 7 Find a website for your specific calculator, try 8 and find a tutorial for it and make sure you 9 understand how your calculator works. 10 make life so much easier for you. 11 And sometimes So as I’ve said before It will And for those of you who need it, I have 12 put extra practice questions with examples, how 13 to enter it in your calculator, into the 14 handouts. 15 And on slide 57 I’ve actually got it that 16 it sort of, if you look at any of these 17 textbooks that I picked up from the library on 18 business math, they show you how to exactly put 19 it in and then you use your calculator and you 20 make sure you can get the exact right answer. 21 So you might want to pause me for a second or 22 have a look at slide 57 and print those out. 23 And make sure you can get your calculator to get 24 the exact numbers. 25 So for many of you this is completely just Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 39 - 1 a review. 2 skimmed through the required reading, you know 3 how to use your calculators, especially those 4 people that work in banks or have taken business 5 math courses before. 6 you. So for you folks you are lucky on this 7 one. For other students you may have to read it 8 through two or three times. 9 words, practice. 10 11 You are going through it, you’ve It’s just a refresher for And as my usual FA2, MODULE 5, PART 5, TOPIC 5.4, PERIODIC PAYMENTS REQUIRED So topic 5.4, is for the periodic payments 12 required. 13 backwards and forth and calculate any of the 14 unknowns with the calculator. 15 Truthfully, you should be able to go I went through the definitions earlier but 16 I’ve got it here on slide 90 again. 17 calculators come with the numbers or all of 18 these little keys all on one line, present 19 value, future value, payment, “I” or “N”. 20 I am saying to you is that it doesn’t matter 21 which of the information you’re given in the 22 problem, you should be able to calculate any of 23 the other ones. 24 should be able to calculate. 25 Now most What Any of those unknowns you And truthfully, once you get a handle on it Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 40 - 1 you can go back and forth and change one thing 2 and do what ifs and once you really understand 3 it and understand how it works and when you’ve 4 got to press the “enter” key and when you’ve got 5 to press the “function 2” key or the “shift 6 function key” or whatever it is on your 7 calculator, once you know the rules you will be 8 able to play the game and do a great job. 9 FA2, MODULE 5, PART 5, TOPIC 5.5, COMPUTING THE TERM 10 And again topic 5.5 is to calculate the 11 term, but once you know how to do them either 12 way you should be able to get your calculator to 13 do the exact amount and calculate the terms for 14 how long are you going to have to make these 15 payments. 16 And the tricky part is figuring out what 17 the last payment is, because the last payment is 18 very unlikely to be the same as all the other 19 payments. 20 way. 21 could find a multiple-choice question that says, 22 “How do you calculate that last payment?” 23 prepared. 24 25 It really just doesn’t work out that So it is very likely that on the exam you Be Oh, I know, I remember from when I taught, like I said business math classes, many students Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 41 - 1 get really frustrated, ready to throw their 2 calculator out the window, when they get 3 “error,” “error,” “error” flashing across the 4 screen, or sometimes they get little error 5 numbers. 6 and it is usually the student, it’s not the 7 calculator – is that what they do is enter the 8 present and the future values both as positive 9 numbers. 10 out now, means a bigger cash flow in later. 11 that means one of the numbers has to be negative 12 and one positive. 13 The most common error that we found – Remember the logic again, cash flow So And if you are adding a payment into it 14 you’ve got to make sure the payment number 15 coincides with both of it as well otherwise you 16 get wrong numbers. 17 reason you will have an error, if you haven’t 18 got your plus/minus keys correct. 19 Okay, so the most common And so I also want to say good luck to you, 20 for those of you who are using financial 21 calculators for the first time. 22 don’t give up, and practice until you are 23 efficient with your calculator. 24 25 Be patient, And also I want to tell you this is value added. The value you are adding to yourself by Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 42 - 1 knowing efficiently and correctly how to use 2 your financial calculator is huge. 3 personal life, for mortgages, for loans, in your 4 business life, knowing your financial calculator 5 is a must to be successful. 6 just seem like a minor issue, but really, the 7 confidence others will have in you because you 8 know the calculator and you understand the value 9 of money is very important. 10 In your And it really might One other thing I wanted to mention is the 11 past exam solutions for the multiple choice 12 answers, some of the older exams showed the 13 factors from the tables, whereas the more recent 14 exam show the calculator information. 15 answers should be the same, except if you are 16 doing an old, old exam again the factors were 17 usually only six decimal places and our 18 calculators are nine. 19 slight variation there. 20 So the So there could be just a And like I always say, important, don’t 21 forget to do the self-test for module 5. 22 Question 1, of course is a computer 23 question that will really help you learn some of 24 these skills that you will use in the future, I 25 am sure. Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 43 - 1 FA2, MODULE 5, PART 5, TOPIC 5.6, COMPUTER ILLUSTRATION 2 Again topic 5.6 is the computer 3 illustration that will help you with that. 4 you’re not going to get a question on the exam 5 with a computer question, but you will have 6 questions like this in your life and in your 7 career, so you do want to use the computer and 8 Excel for the interest calculations. 9 And And also, very valuable in this self-test, 10 there are about 25 multiple-choice questions. 11 And then questions 3 to 7 are also excellent 12 practice for your financial calculator, although 13 they are given to you more as little problems, 14 so you have to read and understand which is 15 which. And where the problem comes is figuring 16 out what’s the present value, which one is the 17 future value. 18 Also, I just remembered that, from the 19 textbook website, I believe, there is also some 20 multiple-choice questions there that you can use 21 to do more practice. 22 And for some of you, it is only going to 23 take you a few minutes to do each question, like 24 you should be able to do the multiple-choice 25 questions within three minutes. So you can Copyright © The Certified General Accountants Association of British Columbia. All rights reserved. - 44 - 1 2 practice lots of them within an hour. I like my quote that I have for you, and if 3 you guys are seeing the quote flashing on your 4 screen you know that that means I am almost 5 finished talking and you get to start doing your 6 practice. 7 “What we hope to do with ease, we must 8 learn first to do with diligence.” 9 Meaning that you have to very carefully do it 10 the first few times and then eventually it will 11 become easy. 12 13 And the next one I’ve got for you is Albert Einstein: 14 “Don’t worry about your problems with 15 mathematics; I assure you mine are 16 greater.” 17 As I said, Module 5 is definitely one of the 18 shorter modules, you just have to practice doing 19 the information. 20 concepts that you have to learn, and learn your 21 calculator and then it is just up to you to do 22 some practicing. 23 There are a few shorter key So at slide 102 and about 14 minutes, this 24 is the end of FA2, Module 5, Part 5. 25 (END OF FA2, MODULE 5, PART 5) Copyright © The Certified General Accountants Association of British Columbia. All rights reserved.