Home / Questions / Time Value of Money Problems Directions Please complete the following problems
Time Value of Money Problems
Directions: Please complete the following problems. You can use the formula approach or Microsoft
Excel. However, make sure to show all of your work. For instance, if you choose to write down your
answers on paper, write down the formula and the inputs you used. If you use Excel, make sure to write
down your inputs (PV= x FV = x PMT= x Rate= x, Nper =x). As an alternative, if you do the work in Excel,
you can just electronically submit the file/spreadsheet.
1) Martha currently has $60,000 to invest. She will invest this money in an account that pays 4% interest
compounded annually for 8 years. How much money will Martha have at the end of 8 years?
2) Tim currently has $60,000 to invest. He will invest this money in an account that pays 4% interest
compounded semiannually for 8 years. How much money will Tim have at the end of 8 years?
3) John wants to have $700,000 in 15 years. He opens an account today and will earn 6% interest,
compounded semi-annually. How much money must John invest today to reach his goal?
4) Julie is opening up a retirement account today. The account will pay 6 % interest compounded
annually. She plans to invest $6,000 per year for 25 years at the beginning of the year. How much will
she accumulate at the end of 25 years?
5) Michael has just won the lottery! He has an option of taking a lump sum of $17 million or can be paid
$900,000 per year for 30 years at the end of the year. The discount rate is 3%. Which option is better?
6) Marie invested $35,000 today in an account that pays 4% annual compound interest. She wants to
know how long it will take for her investment to grow to $70,000. She will not be depositing or
withdrawing any money over the investment time horizon. Find time period (nper).
7) Suzanne invests $20,000 in an account that pays 7% annual compound interest for 3 years. She wants
to know how much money she will have at the end of each year. Please draw a timeline and show how
much money Suzanne will have accumulated at the end of each calendar year (Years 1-3)
Jan 31 2020 View more View Less
Review Sections 2.16-2.19 in the Grammar/Mechanics Handbook. Then select the correctly punctuated sentence and record its letter in the space provided. Also record the ap...
Aug 22 2021A flat square sheet of thin aluminum foil, 40 cmcm on a side, carries a uniformly distributed 400 nCnC charge.A)What, approximately, is the electric field 2.0 cmcm above ...
May 31 2021Which of the following is true of the Treaty of Lisbon that was signed in 2007? A.It defined the European Commission’s role in competition policy.B.It brought the commis...
Jan 11 2020Critically evaluate whether the introduction of the Consumer Rights Act 2015 has provided much needed clarity in respect of the parties obligation and liabilities in a sa...
Feb 04 2020Find the volume of the solid obtained by rotating about the line the region under the curve
Jun 14 2021You are given the following situations: 1. Thomas Petry owes a debt of $7,000 from the purchase of a boat. The debt bears interest of 12% payable annually. Petry will pa...
Jun 16 2020Use the unit output method to find K and vO in Figure P3−38.
Jun 15 2020Given a four bar slider-crank linkage with the link 40mm, L3 = b = 40°, w2 = 25 rad/Sec, 15 rad/Sec?. Find the values of az and a4, A lengths L1= d 120mm, L4- c =80mm .Fo...
Aug 20 2020All the activities involved in selling goods or services directly to final consumers for personal non-business uses are done by _________.wholesalersretailersmediatorscom...
Jul 01 2021In 2004, Link Realty Company purchased a tract of land for $9,000,000. Link developed the land into an industrial park at an additional cost of $750,000. the park was sub...
May 17 2018