25 Wrap Text General Paste B JU Merge & Center v $ v % 9 .00 Conditional Format Cell Formatting as Table Styles fx B D E F G H K M O What Type of TVM Problem To submit your answers: click on the title of the homework "What Type of Problem" . Once you do that, a page will open with various opticUnder #2, you will see TEXT SUBMISSION. To the right you will see "WRITE SUBMISSION" in a opaque box Click on that box (NOT #3 Add Comment) and a space will open where you can a space will open where you can type your answers. Homework Instructions: Write the TVM identifier for each of the timelines below. Your possible answers are PVLS, PVA, PVA Payment, FVLS, FVA, FVA Payment (you must include the work PMT if it applies). Please number each of your answers. Below each of your timeline identifications write a one sentence problem that fits that timeline. An example is given for #1. 16 0 3,000 20 21 Problem Type: FVLS (I want an answer in the future and the data given in the problem is a lump sum ). 22 The problem would be: if I deposit 3,000 today and it grows for 6 years, how much will there be in the account? 23 24 25 2. Sheet1 MacBook AirInsert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 A A ab, Wrap Text BIUV = Merge & Cer V fx B C D F F G H 0 1 2 3 4 5 8,000 3. 0 1 2 3 4 50 50 50 50 0 2 3 5 10 200 200 200 200 200 200 ??7 0 2 5 6 ...........25 5,000 6. 0 1 2 3 5 6 1,000 4,000 2,000 1 2 3 4000 6 7 8 5 50 50 ... 20 50 50 50 50 50 2,000 Sheet1 MacBoD G How to determine which type of TVM problem ow these steps exactly as they are written below: 1. DRAW A TIME LINE: include ALL DATA given in problem and question mark( s) to indicate where answer would be located (THIS IS key! !) 2. LOOK at timeline and determine if you want an answer that is shown by ONE question mark or MANY question marks (annuity payments). One Question Mark Many Question Marks $100 $100 $100 $100 $3,000 ? a. do you want an answer in the present (PV) or future (FV)? a. many question marks means you want to if question mark is BEFORE data - present value determine the annuity pmts (PMT) from a given amount if question mark is AFTER data - future value b. what is the type of data: lump sum(LS) or annuity pits (A)? b. look at location on timeline of single amount given in problem c. combine to find type of problem: c. if that amount is BEFORE the question marks: PVA PMT problem PVA FVA d. if that amount is AFTER the question marks: FVA PMT problem PVLS FVLS e. set up problem, find factor on table d. set problem up, find factor on table f. solve e. solve What type of problem is illustrated above? What type of problem is illustrated above? Sheet1 Sheet2 Sheet3 + MacBook AirD G How to determine which type of TVM problem ow these steps exactly as they are written below: 1. DRAW A TIME LINE: include ALL DATA given in problem and question mark( s) to indicate where answer would be located (THIS IS key! !) 2. LOOK at timeline and determine if you want an answer that is shown by ONE question mark or MANY question marks (annuity payments). One Question Mark Many Question Marks $100 $100 $100 $100 $3,000 ? a. do you want an answer in the present (PV) or future (FV)? a. many question marks means you want to if question mark is BEFORE data - present value determine the annuity pmts (PMT) from a given amount if question mark is AFTER data - future value b. what is the type of data: lump sum(LS) or annuity pits (A)? b. look at location on timeline of single amount given in problem c. combine to find type of problem: c. if that amount is BEFORE the question marks: PVA PMT problem PVA FVA d. if that amount is AFTER the question marks: FVA PMT problem PVLS FVLS e. set up problem, find factor on table d. set problem up, find factor on table f. solve e. solve What type of problem is illustrated above? What type of problem is illustrated above? Sheet1 Sheet2 Sheet3 + MacBook Air