Part 1 For Questions #1 through #10 (see below):

In a MS-Word document (Document 1), identify what type of TVM problem(s) are being used from the following list:

Present value Future value Present value of an annuity Future value of an annuity Annuity of a present value Interest rate Using your financial calculator, answer Questions #1 through #10 and list the keystrokes used to solve the problem.

Questions to be answered related to Homework Assignment #1:

Lauren is offered a delayed payment of $20,000 to be paid in seven years. Assuming Laurens opportunity cost of funds is 9.25%, what is the value of that lump sum today?

You've just won the lottery! The prize is $20,000,000, payable in twenty equal, annual installments. If you require 6.5% from your investments, how much money in PV dollars have you actually won?

Bob deposits his recently received work bonus of $4,500 into an investment account. Assuming Bob makes no additional deposits of funds and the account earns an 11% annual return, what will the value of the account be in twelve years?

Assume that $4,000 I deposited into an investment account doubled in value over a six year period. What annual interest rate must I have earned over this period? Is the initial amount of the deposit relevant to the calculation of the annual interest rate? Why or why not?

John recently purchased a condo for $310,000. If Johns bank offers him thirty year fixed rate mortgage at 5.25% on a 80% Loan to Value, how much will his monthly mortgage payment be?

Joe wants to propose marriage to Beth. He wants to buy a $4,000 ring in 11 months. How much must he save monthly in order to be able to buy the ring if he can earn 7.0% on his money?

I am 25 years old and plan on retiring at age 65. I spend $2.50 each-and-every day on my favorite coffee beverage at McDonalds. If I forego my daily coffee and can instead invest this money at a return rate of 8.0%, how much extra money will I have at the time of my retirement?

I am currently 28 years old and have $25,000 in savings. I plan on saving $1,000 per month until I retire at age 67. I believe that I can earn 10% on my investments. If the actuaries estimate that I will live to be 93,and I shift my post-retirement savings to a safer portfolio that delivers a 5% return, how much can I take each month in retirement from my portfolio and end up with exactly no money when my time is up (i.e., I go to that big stock market in the sky)?

You reach a settlement in your lawsuit against Wii, Cheet, Them, LLC which requires the company to pay you $1,000 per month for the next 5 years. You hear a commercial with a catchy jingle (its my money and I want it now.) and plan to sell your annuity for a single lump sum. Assume you are willing to accept a discount rate of 7.60% on these funds. How much would you expect to receive today in exchange for your rights to continue receiving payments under the settlement?

Greshak Corp. reports the following revenues:

2015 $10,000,000 2016 $11,250,000 2017 $12,500,000 2018 $13,500,000 2019 $12,750,000 2020 $12,900,000

What was Greshaks compound annual growth rate (CAGR) in revenues over the 6-year period 2015 through 2020?

Note - the following questions use data presented in the MS-Excel file entitled "Worksheet1" posted as part of the homework assignment.

11. Calculate the mean, median and mode for Worksheet 1 for each of the following data series for home runs, strikeouts and batting average:

2008 AL 2008 NL 2009 AL 2009 NL 2018 AL 2018 NL 2019 AL 2019 NL

12. Calculate the standard deviation for Worksheet 1 for each of the following data series for home runs, strikeouts and batting average:

2008 AL 2008 NL 2009 AL 2009 NL 2018 AL 2018 NL 2019 AL 2019 NL

13. Calculate the correlation coefficient for Worksheet 1 between home runs and strikeouts for each of the following data series

2008 AL 2008 NL 2009 AL 2009 NL 2018 AL 2018 NL 2019 AL 2019 NL

14. Calculate the correlation coefficient for Worksheet 1 between home runs and batting average for each of the following data series

2008 AL 2008 NL 2009 AL 2009 NL 2018 AL 2018 NL 2019 AL 2019 NL

15. Create a graph that shows average home runs in linear sequence by league. There should be two lines. The vertical axis should show average home runs and the horizontal axis should show year.

16. Create a graph that shows the standard deviation of home runs in linear sequence by league. There should be two lines. The vertical axis should show average standard deviation and the horizontal axis should show year.

17. Create a graph that shows the correlation coefficient between home runs and strikeouts in linear sequence by league. There should be two lines. The vertical axis should show correlation coefficient and the horizontal axis should show year.

18. In a brief paragraph or two, discuss your observations above in answering the question of whether there has been an increase in home runs as well as potential explanations as to why.

19. In a brief paragraph or two, explain how can data and data analytics help in answering questions?

20. Can the same concepts be applied in a business setting? Can you provide a potential business question within your own work sphere where TVM principles and/or data analytics can be helpful?