Assignment

profileKing Wave
mgt_240_Time_Value_of_Money_Spreadsheet_Calculations-Lecture.xls

Sheet1

FINANCIAL MANAGEMENT
CHAPTER 4
TIME VALUE OF MONEY CALCULATIONS - LECTURE
FUTURE VALUE OF A SINGLE AMOUNT
Present Value 10000
Interest rate per year 5%
Number of years 10
Future Value $16,288.95
PRESENT VALUE OF A SINGLE AMOUNT
Future value 40000
Interest rate per year 8%
Number of years 18
Present Value $10,009.96
FUTURE VALUE OF AN ANNUITY FUTURE VALUE OF AN ANNUITY DUE
Annual payment 555 Annual payment 555
Interest rate 8% Interest rate 8%
Number of years 18 Number of years 18
Future Value $20,780.89 Future Value $22,447.68
PRESENT VALUE OF AN ANNUITY PRESENT VALUE OF AN ANNUITY DUE
Annual payment 1000 Annual payment 1000
Interest Rate 5% Interest Rate 5%
Number of years 20 Number of years 20
Present Value $12,462.21 Present Value $13,085.32

Sheet2

Sheet3