Solutions worksheet for Time Value of Money questions in Chapter PPT

xlsx

School

York University *

*We aren’t endorsed by this school

Course

2320

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

6

Uploaded by CaptainMaskFerret26

Report
Chapter 4 - Time Value of Money slide 9: You invest $100 in an account paying compound interest at the rate of 10% per year. Ho $259.37 -> FV Function slide 13: How much do you need to invest today into an account paying compound interest at the -$6,768.39 -> PV Function slide 17: You have been offered $1 million five years from now. If the interest rates is expected to Years PVF @10% per year 1 0.90909090909 PV = 620,921.32 2 0.82644628099 3 0.7513148009 PV = $620,921.32 -> PV Func 4 0.68301345537 5 0.62092132306 slide 19: PV = 712.99; t = 5 year period; FV=1000 What is the discount rate? 7.00% -> RATE Function slide 20: PV = 1,890 ; t = ? ; FV = 3,000 ; r = 8% 6.003498 years -> NPER Function slide 23: You deposit $1,200 in your bank account today and $1,400 one year later. If your bank o Year Years invested Amount FV @8% FV 0 2 1,200 1.1664 1,400 1 1 1,400 1.08 1,512 2,912 slide 25: Years Years invested Amount FV @8% FV 0 3 1,200 1.259712 1,512 1 2 1,400 1.1664 1,633 2 1 1,000 1.08 1,080 You deposit $1,200 in your bank account today; $1,400 one year later; and $1,000 two ye how much money will you have in the account three years from today?
4,225 slide 27: Option 1: 15,500 cash now -> better choice for dealer Option 2: Years Payments PVF @8% PV 0 8,000 1 8,000 1 4,000 0.9259259 3,704 2 4,000 0.8573388 3,429 15,133 -> better choice for buyer since PV i slide 33: Delayed Perpetuity If the first perpetuity payment will not be received until four years from today, how much PV of perpetuity = C / r = $100,000 / 0.1 1,000,000 PV today = $1,000,000 / (1.10)^3 751,314.80 Your auto dealer gives you the choice to pay $15,500 cash now or make three payments: cost of money is 8%, Which is the better deal?
ow much will the account be worth in 10 years? rate of 5% per year, in order to receive $10,000 at the end of eight years? be 10% per year, how much is this prize worth to you in today’s dollars? ction offers you an 8% interest rate on your account, how much money will you have in the account ears from today. If your bank offers you an 8% interest rate on your account,
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
is less h money needs to be set aside today? : $8,000 now and $4,000 at the end of the following two years. If your
t two years from today?
Years 0 1 1 1 0.909091 1.1 2 0.826446 1.21 3 0.751315 1.331 4 0.683013 1.4641 5 0.620921 1.61051 6 0.564474 1.771561 7 0.513158 1.948717 8 0.466507 2.143589 9 0.424098 2.357948 10 0.385543 2.593742 11 0.350494 2.853117 PVF@10% FVF@10%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help