*SHOW ALL WORK USING AN EXCEL SPREADSHEET*

1. Answer the following questions assuming the interest rate is 8 percent. Time Value of Money Problems a. What is the present value of $1,000 to be received in four years? b. What is the present value of $1,000 to be received in eight years? Why does the present value fall as the number of years increases c. What will be the value in seven years of $12,000 invested today? d. How much would you pay for the right to receive $5,000 at the end of year 1, $4,000 at the end of year 2, and $8,000 at the end of year 5? e. How long will it take for a $2,000 investment to double in value? f. What will be the value in 20 years of $1,000 invested at the end of each year for the next 20 years? g. A couple wishes to save $250,000 over the next 18 years for their child's college education. What uniform annual amount must they deposit at the end of each year to accomplish their objective? h. How long must a stream of $600 payments last to justify a purchase price of $7,500.00P Suppose the stream lasted only five years. How large would the salvage value (liquidating payment) need to be to justify the investment of $7,500.00