Find the present value of each payment

Assignment Help Finance Basics

Reference no: EM131797775

Question: You win a lottery ticket with a prize of $1.5 million. The prize is paid in ten equal annual installments. The first payment is one year from today. Your bank offers you an interest rate of 1% per month (effective).

What is the present value of these payments? Work out the answer in two ways. First use the annuity formula. Be careful about which interest rate you plug into the formula. Second use Excel. Do not use the PV or NPV formulas in Excel. Instead, find the present value of each payment using our present value formula PV = FV/(1+r)^T, using the monthly effective rate as r. Then add the ten present values to get the PV of the stream.

Reference no: EM131797775

Questions Cloud

Compute a mean and standard deviation : Compute a mean and standard deviation for each year and then describe the differences in expenditures for the five-year period.

What is irvings recognized gain or loss on the sale : Irving paid a realtor commission of $2,000 on the sale. What is Irvings recognized gain or loss on the sale if Blackacre has an adjusted basis of $63,000

Explain why we study ethics and morality : Submit a 2 page assignment explaining why we study ethics and morality. Also, research, explain and providing an example of each ethical term.

Various divisions of the agency : One of your goals as the new chief administrator of a large social service bureau is to equalize workloads within the various divisions of the agency.

Find the present value of each payment : What is the present value of these payments? Work out the answer in two ways. First use the annuity formula. Be careful about which interest rate you plug.

Determine the december inventory : Campbell Corporation uses the retail method to value its inventory. Determine the December 31, 2011, inventory

What happened to the shapes of the underlying : Does this change relate at all to what happened to the mean over the four-year period? How? What happened to the shapes of the underlying distributions?

What type of compound interest table is appropriate : The contract required 8 equal annual payments with the first payment due on June 1, 2012. What type of compound interest table is appropriate for this situation

Discuss the nature and type of information required : Discuss the nature and type of information required at each level of decision making within a typical organization hierarchy.

User Account

All Pages