...Financial Functions Using Microsoft Excel FV | PV | RATE | NPV | IRR | PMT | Printing Formulas | FV FV(rate,nper,pmt,pv,type) Rate is the interest rate per period. Nper is the total number of payment periods in an annuity. Pmt is the payment made each period; it cannot change over the life of the annuity. Pmt must be entered as a negative number. Pv is the present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero). PV must be entered as a negative number. Type is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0 which represents at the end of the period. If payments are due at the beginning of the period, type should be 1. PV PV(rate,nper,pmt,fv,type) Rate is the interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments, your interest rate per month is 10%/12, or 0.83%. You would enter 10%/12, or 0.83%, or 0.0083, into the formula as the rate. Nper is the total number of payment periods in an annuity. For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 (or 48) periods. You would enter 48 into the formula for nper. Pmt is the payment made each period and cannot change over the life of the annuity. Pmt must be entered as a negative amount. Fv is the future value, or a cash balance you want to attain after the...
Words: 2368 - Pages: 10
...all the cells between and including the reference. A range reference consists of two cell addresses separated by a colon. The reference A1:A3 includes cells A1, A2, and A3. The reference A1:C3 includes A1, A2, A3, B1, B2, B3, C1, C2, and C3. A union reference includes two or more references. A union reference consists of two or more cell addresses separated by a comma. The reference A7,B8,C9 refers to cells A7, B8, and C9. Functions Microsoft Excel has a set of prewritten formulas called functions. Functions differ from regular formulas in that you supply the value but not the operators, such as +, -, *, or /. For example, you can use the SUM function to add. When using a function, remember the following: o Use an equal sign to begin a formula. o Specify the function name. o Enclose arguments within parentheses. o Use a comma to separate arguments. Here is an example of a function: =SUM(2,13,A1,B27) In this function: o The equal sign begins the function. o SUM is the name of the function. o 2, 13, A1, and B27 are the arguments. o Parentheses enclose the arguments. o A comma separates the arguments. The SUM function adds the arguments together. In the exercises that follow, we will look at various functions. Typing a Function 1. Open Microsoft Excel. 2. Type 12 in cell B1. 3. Press Enter. 4. Type 27 in cell B2....
Words: 1942 - Pages: 8
...Life Insurance and Superannuation Models Week 1: Life Insurances (Single Life) 1 / 27 Week 1: Life Insurances (Single Life) Summary Life insurance. Benefits payable contingent upon death; payment made to a designated beneficiary. Actuarial present values (APV ) Actuarial symbols and notation Insurance payable at the moment of death Continuous Level benefits, varying benefits (e.g. increasing, decreasing) Insurances payable at the end of year of death Discrete Level benefits, varying benefits (e.g. increasing, decreasing) References Chapter 4 (Bowers, et al.) or Chapter 3 (Gerber) ACTL3002: Week 1 2 Life Insurance Contracts Made between a life insurance company and one or more persons called the policyholders Policyholders agree to pay an amount or series of amounts to the life insurance company called premiums. In return the life insurance company agrees to pay an amount or amounts called benefit(s), to the policyholder on the occurrence of a specific event. Benefits payable under two main types: On or following the death of the policyholder, Payable provided the life survives for a given term e.g. annuity. ACTL3002: Week 1 3 Types of Life Insurance Contracts Whole life insurance contract Benefits are paid on the policyholder’s death Term assurance contract A contract to pay a sum assured on or after death provided death occurs during a specified period, called the term of the contract. Pure endowment contract Provides...
Words: 1997 - Pages: 8
...Chong KW Q007 " 5-6 6-7 7-8 8-9 11 - 12 12 - 1 1-2 Lim LC Q006 " 2-3 3-4 Selvi Q301B AACB1243 (L) AAMS1433 (L) AACB1223 (L) AACB1243 (T) AACB1123 (L) Q006 " DCB1 A2 " AACB1223 (T) A3 " " " Lim LC Q301D " TUESDAY Prog. Gp. A1 8-9 Chong KW Q007 9 - 10 Selvi Q007 " 10 - 11 Selvi D204(2) AAMS1433 (T) A2 " Henry Hwang K303 A3 " " " " 11 - 12 12 - 1 1-2 2-3 AACB1143 (L) 3-4 4-5 AHEL2043 (L) 5-6 6-7 7-8 8-9 AACB1123 (L) AACB1243 (L) AACB1243 (P) Chen SH DK 5 AACB1223 (T) Hor SF / Lim SA K304 / K303 AHEL2043 (L) Hor SF / Lim SA K304 / K303 AHEL2043 (L) Hor SF / Lim SA K304 / K303 Lim LC K203 AACB1243 (T) DCB1 Selvi K103 WEDNESDAY Prog. Gp. A1 8-9 9 - 10 10 - 11 11 - 12 12 - 1 1-2 2-3 3-4 AACB1223 (T) 4-5 AHEL2043 (L) 5-6 6-7 7-8 8-9 AAMS1433 (T) Henry Hwang K303 AACB1243 (P) A2 Selvi D204(2) AACB1243 (P) A3 Selvi D204(2) Prog. Gp. A1 8-9 9 - 10 Henry Hwang Lim LC K105 AACB1243 (T) Hor SF / Lim SA K302 / K301 AHEL2043 (L) Hor SF / Lim SA K302 / K301 AHEL2043 (L) Hor SF / Lim SA K302 / K301 DCB1 Selvi K106 THURSDAY 10 - 11 Chen SH DK 5 " 11 - 12 12 - 1 1-2 AACB1143 (T) 2-3 3-4 4-5 5-6 6-7 7-8 8-9 AAMS1433 (L) AACB1143 (L) AACB1123 (P) Wong AK C106 - even week AACB1143 (T) Chen SH Q301D AACB1223 (P) Lim LC D204(2) AACB1123 (P) - even week Chen SH Q301D Q006 DCB1 A2 " AACB1143 (T) AAMS1433 (T) Henry Hwang...
Words: 468 - Pages: 2
...Team Leadership Appendix 1 MANAGING MEETINGS: A TOOLKIT lecture outline managing meetings 1 Senior managers spend 23 hours a week in meetings, middle managers spend 35 percent of their time in meetings a week, and top managers spend 50 to 80 percent of their time in meetings a week 2 However, 28 percent of professionals believe meetings are unproductive 3 Forty-five percent of professionals believe that they would be more productive if meetings were banned one day a week 4 Managers resort to using various tactics (Exhibit A1-1) 4p meeting management model (Exhibit a1-2) 1 Key steps 1 Specify purpose of meeting 2 Invite the right people 3 Carefully plan the meeting content and format 4 Effectively manage the meeting’s process 2 Skilled meeting managers organize the meeting not by who is there, but what is to be done 3 Organize discussions around five key planning questions 1 Why meet? 2 Who to include? 3 What to discuss? 4 How to record ideas? 5 Where to meet? [pic] [pic] dealing with problem people in meetings 1 List of typical meeting member roles to distribute before meeting (Exhibit A1-3) advice for meeting attendees A. Determine if you need to attend the meeting B. Prepare C. Be on time D. Ask for clarification on points that are unclear or ambiguous E. When giving information, be precise and to the point ...
Words: 546 - Pages: 3
...with community managers in mind, and we broke each function down in a way that’s easy to understand. Our Analysts’ guide to Excel functions So what exactly are Excel functions? Functions show a relation between a set of inputs and a set of outputs, where each input has exactly one output. In Excel, functions take the data from your workbook (the input) and turn them into information (the output) through a specific syntax. For example, you may be familiar with something like SUM. 1 The syntax of the function SUM is: Syntax refers to the way the function is ordered, so that it returns a result. Each function starts with an equal sign (=) and are followed by the name of the function itself. =SUM(this, plus this) Example: =SUM(A1, A2) This means that the cell you...
Words: 4145 - Pages: 17
...QNT/561: Week One Assignment Exercises 80, 82, and 87 (Ch. 3) Exercise 80* a. The times are a population because we are considering the wait times for all of the customers seated on Saturday night. b. To find the mean: µ = ∑ X N µ = 1021 25 µ = 40.84 To find the median: The midpoint value of the population is 39. c. To find the range: Range = Largest Value – Smallest Value Range = 67 – 23 Range = 44 To find the standard deviation: σ = √∑ (X - µ)2 N σ = √∑(X – 40.84) 2 = √5291.36 = √211.65 = 14.55 25 25 Exercise 82* a. To find the mean cost: X = ∑fM = 7,060 = $141.20 N 50 b. To find the standard deviation: s = √∑f (M - X)2 = √33,728 = √688.33 = 26.24 n – 1 50 - 1 c. To find the proportion of costs within two standard deviations of the mean: X ± 2s 141.2 + 2(26.24) = 193.68 141.2 - 2(26.24) = 88.72 The electricity costs are all almost all within $89 to $194. Exercise 87* a. Select the variable selling price. 1. Mean = 221.1029 Median = 213.6 Standard Deviation = 47.1054 2. The mean selling price for a home in the Denver, CO area is about $221,103 while the median price is a bit lower at $213,600. With the standard deviation being high at $47,105, the range of home prices is quite big. b. Select the variable referring to the area of the home in square feet. 1. Mean = 2223.81 Median = 2200 Standard Deviation = 248.6594 2...
Words: 975 - Pages: 4
...MKT 500 Company Introduction, Market Segmentation, and Product Positioning Student Dr. Kelly Bruning Marketing 500026VA016-1126-001 July 22, 2012 Company Introduction, Market Segmentation, and Product Positioning Dating is something that most people have done or will do at any given point in their life. For some people, meeting and asking someone out for coffee, dinner, drink, or even a movie is as easy as breathing. On the other hand, for others it is just not that simple. Then to add to that scenario, you have people that have been with their mates for years, then suddenly find themselves single as a result of divorce, or because the spouse died unexpectedly. Now, just imagine someone in this situation who frankly hasn’t had a date in years, except with their significant other. They may not be prepared for the challenges of dating, or able to get out and meet people in the traditional manner in which most people are accustomed to dating. In addition, times have changed, and now with advance technology, a person can meet potential suitors online without ever having to leave the house. It is for this reason that online dating has become very popular. People can now search out the type of person who attributes fits more closely with their own ("What causes popularity of online dating?"). With the trend of online dating, there are a number of dating sites where there are millions of people who are utilizing the sites. To subscribe to these various sites, a person will...
Words: 4042 - Pages: 17
... | |Week | | | |Weeks 1-2 |Introduction to Statistics|Business Statistics (BS) (Selvanathan |Module lecture recordings & lecture |Learning Statistics and Excel in |Introduce yourself to | | | |and Data Collection |et al): Chapter 1, Chapter 2 |workbook (A1, A2, A3, A4) |Tandem (LSET), Chapter 1: |the class | | |2 Mar – 15 Mar | | | |Introduction to Microsoft EXCEL & | | | | | |Video recordings: |Set up your account to the APLIA site|Chapter 1 (BS): Appendix 1.A | | | | | |A1 |so you can access the...
Words: 729 - Pages: 3
...A 37 year old woman was visiting her OB/gynecologist for her 8 weeks prenatal care and during this visit physician ordered prenatal tests that included CBC with differential, Hepatitis B surface antigen, RPR, HIV screening, Rubella titers, ABO Rh type and antibody screening. The CBC and rest of the immunology test were normal. The antibody screening performed on Echo (solid phase) was negative. Immucor Echo (blood bank automated instrument) was not able to determine the ABO type. The following results were obtained from Echo. |Mono control |Anti-A |Anti-B |Anti-D |Anti-D |A1 cell |B cell | | | | |Series 4 |Series 5 | | | |0 |4+ |4+ |3+ |2+ |2+ |2+ | After looking at initial results from the instrument, technologist repeats the ABO/Rh typing using the tube method. The following results were obtained at immediate spin. |Anti-A |Anti-B |Anti-D |Mono Control |A1 Cell |B Cell | | | |Series 4 |(D control) | | | |4+ |4+ |4+ ...
Words: 374 - Pages: 2
...Accounting & Finance: Weeks 1-3 Class | Tutor | Classroom | Campus Map | AF A1 | Iwona Winiarska-Pringle | Adam Smith 1101 | D8 | AF A2 | Aneta Keska | Adam Smith 1102 | D8 | AF A3 | Keith Delves | Adam Smith 717 | D8 | AF A4 | Damien Kerr | 25 Bute Gardens, room 130 | D17 | AF A5 | Joyce Laird | Sir Alexander Stone 206 | D5 | AF A6 | Duncan Minett Westwood | Sir Alexander Stone 403 | D5 | AF A7 | James McCallum | Sir Alexander Stone 404 | D5 | AF A8 | Rachel Elmslie | 11 University Gardens, room 201 | D15 | AF A9 | Vasiliki Papaionnou | 2 University Gardens, room 208 | D15 | AF A10 | Iain Gallacher | 3 University Gardens, room 202 | D15 | AF A11 | Gerry McLellan | 4 University Gardens, room 101 | D15 | AF A12 | Carol Irvine | 7 University Gardens, room 101 | D15 | AF B1 | Iwona Winiarska-Pringle | Adam Smith 1101 | D8 | AF B2 | Aneta Keska | Adam Smith 1102 | D8 | AF B3 | Keith Delves | Adam Smith 717 | D8 | AF B4 | Damien Kerr | 25 Bute Gardens, room 130 | D17 | AF B5 | Joyce Laird | Sir Alexander Stone 206 | D5 | AF B6 | Duncan Minett Westwood | Sir Alexander Stone 403 | D5 | AF B7 | James McCallum | Sir Alexander Stone 404 | D5 | AF B8 | Rachel Elmslie | 11 University Gardens, room 201 | D15 | AF B9 | Vasiliki Papaionnou | 2 University Gardens, room 208 | D15 | AF B10 | Iain Gallacher | 3 University Gardens, room 202 | D15 | AF B11 | Gerry McLellan | 4 University Gardens, room 101 | D15 | AF B12 | Justin O’Hagan...
Words: 494 - Pages: 2
...Nom : Prénom : Code candidat : . — DIPLÔME D’ÉTUDES EN LANGUE FRANÇAISE DELF A1 Niveau A1 du Cadre européen commun de référence pour les langues Nature des épreuves Durée Note sur 20 min environ /25 Compréhension des écrits Réponse à des questionnaires de compréhension portant sur quatre ou cinq documents écrits ayant trait à des situations de la vie quotidienne. 30 min /25 Production écrite Épreuve en deux parties : - Compléter une fiche, un formulaire - Rédiger des phrases simples (cartes postales, messages, légendes, etc.) sur des sujets de la vie quotidienne 30 min /25 Compréhension de l’oral Réponse à des questionnaires de compréhension portant sur trois ou quatre très courts documents enregistrés ayant trait à des situations de la vie quotidienne. (2 écoutes) Durée maximale des documents : 3 minutes Production orale Épreuve en trois parties : - entretien dirigé - échange d’informations - dialogue simulé Seuil de réussite pour obtenir le diplôme : 50/100 Note minimale requise par épreuve : 5/25 Durée totale des épreuves collectives : 1 heure 20 minutes DELF A1 5 à 7 min Préparation : 10 min Note totale : /25 /100 Page 1 sur 9 DOCUMENT DU CANDIDAT ÉPREUVES COLLECTIVES Partie 1 COMPRÉHENSION DE L’ORAL 25 points Répondez aux questions en cochant ( ) la bonne réponse, ou en écrivant l’information demandée. Exercice 1 4 points Vous allez entendre 2 fois un document...
Words: 3579 - Pages: 15
...Please review the rubric posted in week 1 for math problems. Submit to your assignment tab. Submit a certificate of originality for this assignment. Exercise 7.1 – Problem 10a If A = {w, x, y, z}, determine the number of relations on A that are (a) reflexive; Total reflexive pairs is 2n^2-2 N2-2 = 12. Therefore, 212 Relations Exercise 7.1 – Problem 10b If A = {w, x, y, z}, determine the number of relations on A that are (b) symmetric; Total reflexive pairs is 2(n^2+n)/2 (n2+n)/2 = 10. Therefore, 210 Relations Exercise 7.2 – Problem 15a Draw the digraph G1 = (V1, E1) where V1 = {a, b, c, d, e, f } and E1 = {(a, b), (a, d), (b, c), (b, e), (d, b), (d, e), (e, c), (e, f ), (f, d)}. Hand drawn diagraph submitted with assignment. Exercise 7.3 – Problem 1 Draw the Hasse diagram for the poset (P(U), ⊆), where U ={1, 2, 3, 4}. Hand drawn diagram submitted with assignment. Exercise 7.3 – Problem 6a For A = {a, b, c, d, e}, the Hasse diagram for the poset (A, R) is shown in Fig. 7.23. (a) Determine the relation matrix for R. The matrix is as follows: 11111 01011 00111 00011 00001 Exercise 7.4 – Problem 1a Determine whether each of the following collections of sets is a partition for the given set A. If the collection is not a partition, explain why it fails to be. a) A = {1, 2, 3, 4, 5, 6, 7, 8}; A1 = {4, 5, 6}, A2 = {1, 8}, A3 ={2, 3, 7} The collection IS a partition as it meets all 3 rules for partitions. Exercise...
Words: 629 - Pages: 3
...the board of directors says, "There is a 50% chance this company will earn a profit, a 30% chance it will break even, and a 20% chance it will lose money next quarter." a. Use an addition rule to find the probability the company will not lose money next quarter. (Round your answer to 2 decimal places.) b. Use the complement rule to find the probability it will not lose money next quarter. (Round your answer to 2 decimal places.) Find the Weekly Learning Assessment answers here QNT 561 Week 2 Weekly Learning Assessments Chapter 5 Exercise 22 A National Park Service survey of visitors to the Rocky Mountain region revealed that 50% visit Yellowstone Park, 40% visit the Tetons, and 35% visit both. a. What is the probability a vacationer will visit at least one of these attractions? (Round your answer to 2 decimal places.) b. What is the probability .35 called? c. Are the events mutually exclusive? Chapter 5 Exercise 34 P(A1) = .20, P(A2) = .40, and P(A3) = .40. P(B1|A1) = .25. P(B1|A2) = .05, and P(B1|A3) = .10. Use Bayes' theorem to determine P(A3|B1). (Round your answer to 4 decimal places.) Want to download the Complete Weekly Assignment of QNT/561 Class..?? Click QNT 561 Weekly Learning Assessments Chapter 5 Exercise 40 Solve the following: a. 20! 17! b. 9P3 c. 7C2 Chapter 6 Exercise 4 Which of...
Words: 1187 - Pages: 5
...units of nutrient C. Learning Objective 1: Recognize problems that linear programming can handle. Linear programming lets you optimize an objective function subject to some constraints. The objective function and constraints are all linear. Two feed grains are available, X and Y. A bag of X has 2 units of A, 1 unit of B, and 1 unit of C. A bag of Y has 1 unit of A, 1 unit of B, and 3 units of C. A bag of X costs $2. A bag of Y costs $4. Minimize the cost of meeting the nutrient requirements. To solve, express the problem in equation form: Cost = 2X + 4Y objective function to be minimized Constraints: 2X + 1Y $ 14 nutrient A requirement 1X + 1Y $ 12 nutrient B requirement 1X + 3Y $ 18 nutrient C requirement 8 8 Read vertically to see how much of each nutrient is in each grain. X $ 0, Y $ 0 non-negativity Learning objective 2: Know the elements of a linear programming problem -- what you need to calculate a solution. The elements are (1) an objective function that shows the cost or profit depending on what choices you make, (2) constraint inequalities that show the limits of what you can do, and (3) non-negativity restrictions, because you cannot turn outputs back into inputs. LINEAR PROGRAMMING II Graph method of solution Graph the constraints as equalities, like before. The constraints are now $ rather than #, so the feasible area is everything to the right and above all of the constraint lines. You want to find the lowest...
Words: 4295 - Pages: 18
