9-59 a-s 4 Search FMGT 2299 MA 2 TVOM i... v Done for 8 points. Using a numeric table might be good here.) 4) Looking at 1416. a,Why did I make the goal of only 75,000 in number 14? (2 points) b. For 15 and 16, explain how these numbers impact a person's retirement scenario. (6 points. 1/2 page minimum.) 5) Looking at 17-20. (2 points each) a.Why is 17 the longest time frame? b.Why don't the answers for 18-20 reduce by half if we are doubling the annual amounts? OWhat are the monthly amounts in 1820? If we calculated monthly, would our answers change much? u. Calculate 18-20 monthly. Using for instance 4800/12 or 400 a month. 6) Looking at 21-26. People want to have 1,000,000 at retirement; at least people in my generation. a. Is 6 percent for 51 years a plausible scenario? Why or why not? (This answer should be 1/2 of a page at least for 5 points.) i, What are historical returns over the last 80 years on the stock market? ii. Will many people who are 25 today work until 75? Assume yes, but look for documentation of some kind on long term aging, the social security system, etc) b_What if inflation will require today's 25 year- olds to have 3,000,000? Calculate numbers 24-26 for that goal. (3 points) 9-58 as 4 Search - FMGT 2299 MA 2 TVOM i... v Done FMGT 2299 Major Assignment 2 Time Value of Money 100 Points People in this class should have already seen the topic of Time Value of Money in previous finance classes. This is one of the key concepts in finance and business, and it is critical that you have a firm grip on the concept. PART 1: You need to be able to calculate time value of money problems. Answer on the attached spreadsheet for 2 points each. (Total of 52). Usage of the functions of the spreadsheet is preferable and easier for you, but optional. PART 2: Six questions for 8 points each. Each of these questions require an answer of about one page. \"Looking at questions 1-5 (2 points each. Answer each one with several sentences): a.What makes the difference in amounts 1 and 3? Why do you think I added question 1? b. Explain the difference in the answers in 3 and 5. Why is one of them above 60,000 and the other below 60,000? c. For question 2 and 4, why is one above 4000 and the other below? d.Which two answers are the most different and why? 2) Looking at questions 611. Explain the importance of interest rates and time on a retirement accounts. Use the answers from these questions. (Minimum one half page for 8 points) 3) Looking at questions 12 and '13. Why are these answers close together? At 8,000 per year and the difference in time of 5 years, shouldn't the answers be at least 50,000 different? Explain with yearly amounts. (Minimum one half page for 8 points. Using a numeric table might be good here.) Finance Capstone MA2 TVOM - AU22 1 What Is the Future Value of a series of payments 4000 per year for 15 years at interest of 0 percent 2 What Is the Future Value of one payment 4000 for 15 years at interest of 4 percent What Is the Future Value of a series of payments 4000 per year for 15 years at interest of 4 percent 4 What Is the Present Value of one payment 4000 for 15 years at interest of 4 percent 5 What Is the Present Value a series of payments 4000 per year for 15 years at interest of 4 percent 6 What Is the Future Value of a series of payments 3700 per year for 18 years at interest of 3 percent 7 What Is the Future Value of a series of payments 3700 per year for 18 years at interest of 5 percent 8 What Is the Future Value of a series of payments 3700 per year for 18 years at interest of percent 9 What Is the Future Value of a series of payments 3700 per year for 25 years it interest of 7 percent 10 What Is the Future Value of a series of payments 3700 per year for 38 years it interest of 7 percent 11 What Is the Future Value of a series of payments 3700 per year for $5 years at interest of percent 12 What Is the Present Value of a series of payments of 8000 per year for 13 years at interest of 5 percent 13 What Is the Present Value of a series of payments of 8000 per year for 18 years at interest of 5 percent 14 What interest rate would you have to earn if you started with 4400 and wanted 75,000 in 27 years 15 What interest rate would you have to earn if you deposited 4400 per year and wanted ,200,000 in 27 years 16 What interest rate would you have to earn if you deposited 1400 per year and wanted 1,200,000 in $1 years 17 How many years to get to 2,000,000 if you started with 48000 and earned percent 18 How many years to get to 2,000,000 if you deposited 4800 per year and earned percent 19 How many years to get to 2,000,000 if you deposited 600 per year and earned percent 20 How many years to get to 2,000,000 if you deposited 15000 per year and earned percent 21 How much per year to get to 2,000,000 if you earned percent for 31 years 22 How much per year to get to 2,000,000 if you earned percent for 41 years 23 How much per year to get to 2,000,000 if you earned 3 percent for 50 years 24 How much per year to get to 2,000,000 if you earned 6 percent for 31 years 25 How much per year to get to 2,000,000 if you earned percent for 41 years 26 How much per year to get to 2,000,000 if you earned 6 percent for 51 yearsACROBAT tome Insert Page Layout Formulas Data Review View Help Out Calibri ~ 11 ~ A A ab Wrap Text General Normal Bad Good Copy BIU- - A HE Merge & Center $ - % 9 508 408 Conditional Format as Neutral Calculation Check Ce Format Painter Formatting ~ Table board Font Alignment Number Styles X V fx D E F G H M N ce Capstone MA2 TVOM - AU22 Answer: 1 What Is the Future Value of a series of payments of 4000 per year for 15 years at interest of 0 percent $64,000 2 What Is the Future Value of one payment of 4000 for 15 years at interest of 4 percent $7,203.77 3 What Is the Future Value of a series of payments of 4000 per year for 15 years at interest of 4 percent $87,298.12 4 What Is the Present Value of one payment of 4000 for 15 years at interest of 4 percent $ 2,221.06 5 What Is the Present Value of a series of payments of 4000 per year for 15 years at interest of 4 percent $ 46,252.49 6 What Is the Future Value of a series of payments of 3700 per year for 18 years at interest of 3 percent $ 92,932.41 7 What Is the Future Value of a series of payments of 3700 per year for 18 years at interest of 5 percent $ 112,994.31 8 What Is the Future Value of a series of payments of 3700 per year for 18 years at interest of 7 percent 138,302.17 9 What Is the Future Value of a series of payments of 3700 per year for 25 years It interest of 7 percent 254,102.94 10 What Is the Future Value of a series of payments of 3700 per year for 8 years at interest of 7 percent S 686 , 869.08 11 What Is the Future Value of a series of payments of 3700 per year for 5 years at interest of 7 percent $ 2,283,801.30 12 What Is the Present Value of a series of payments of 8000 per year for 13 years at interest of 5 percent $ 4,242.57 13 What Is the Present Value of a series of payments of 8000 per year for 18 years at interest of 5 percent $ 3,324.17 14 What interest rate would you have to earn if you started with 4400 and wanted 75,000 in 27 years 11% 15 What interest rate would you have to earn if you deposited 4400 per year and wanted 1,200,000 in 27 years 40% 16 What interest rate would you have to earn if you deposited 4400 per year | and wanted 1,200,000 in 51 years 12% 17 How many years to get to 2,000,000 if you started with 48000 and earned 5 percent 77 Years 18 How many years to get to 2,000,000 if you deposited 4800 per year and earned 5 percent 64 Years 19 How many years to get to 2,000,000 if you deposited 9600 per year and earned 5 percent 50 Years 20 How many years to get to 2,000,000 if you deposited 15000 per year and earned 5 percent 42 Years 21 How much per year to get to 2,000,000 if you earned 3 percent for 31 years 22 How much per year to get to 2,000,000 if you earned 3 percent for 41 years 32 23 How much per year to get to 2,000,000 if you earned 3 percent for 50 years 33 24 How much per year to get to 2,000,000 if you earned 6 percent for 31 years 34 25 How much per year to get to 2,000,000 if you earned 6 percent for 41 years 35 26 How much per year to get to 2,000,000 if you earned 6 percent for 51 years 36 37 38 Numbers + Enter Accessibility: Good to go mex w T X F1 Ox ESC ED F4 F5 F8 prt sc F9 F10 @ old 2 tab Q W F R U ock A S D F G H X C V B N