when choosing the highest present value contract, how large an annuity can billy pay himself for the next 40 years at 10% interest?   Contract 1 $900,000 signing bonus  $850,000 at the end of each year for the next  5 years   Contract 2 $200,000 immediate signing bonus $100,000 at the end of each year for the next five years $150,000 a year at the end of years 5 through 10 $1,000,000 a year at the end of years 11 through 40   Contract 3 $1,000,000 immediate signing bonus $500,000 at the end of year 1 $1,000,000 at the end of year 2 $1,500,000 at the end of year 3 $2,500,000 at the end of year 4   As part of the third offer he was also promised a $200,000 bonus for any year in which he was selected to play in the Pro Bowl All Star game. his agent figured there was a 25% probability of that occuring in each of the next 4 years.

What effective interest rate will Frankie have to earn if his investments of $2,000 at the end of every three months for 20 years are to have a maturity value in 20 years of $1,000,000?

Excel Online Structured Activity: Required annuity payments Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $45,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 3%. He currently has $220,000 saved, and he expects to earn 7% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.     Open spreadsheet, here is the spreadsheet.   How much must he save during each of the next 10 years (end-of-year deposits) to meet his retirement goal? Do not round your intermediate calculations.…

(Future value of an ordinary annuity) You are graduating from college at the end of this semester and after reading the The Business of Life box in thischapter, you have decided to invest $4,700 at the end of each year into a Roth IRA for the next 40 years. If you earn 8 percent compounded annually on your investment, how much will you have when you retire in 40 years? How much will you have if you wait 10 years before beginning to save and only make 30 payments into your retirement account?

Moon purchases a lot for $300,000. Moon agrees to pay $25,000 dollars at the end of each year. If the interest rate is 4% compounded annually, how many full payments must be made, and what will be the size of the concluding payment one year after the last full payment? How to enter into TVM Solver??

Bob purchases an annuity that will pay him $10,000 a year for the next 15 years starting a year from now.  Assuming a 5% annual interest rate, what is the value of this annuity?  Choose the closes. a) $150,000 b) $103,797 c) $124,622 d) $77,217

Maria Addai has been offered a future payment of $750 two years from now. If she can earn an annual rate of 6.5 percent, compounded daily, on her investment, what should she pay for this investment today?

10 years from now Mr. X will start receiving a pension of $ 3000 a year for 16 years. How much the pension worth now if interest rate is 10%. Please mention the reasoning for number of terms chosen in every step.