Suppose You Have $1100 and Decided to Purchase a New

Essay

Suppose you have $1100 and decided to purchase a new model of television that costs you $1100. You find an electronics store where a gift voucher, worth $50, is offered with this TV model if payment is made in full during the time of purchase, or it can be financed at 0 percent interest for 5 months with a monthly payment of $220. You now have two options: either invest your amount for an annual interest rate of 10% and opt for 0 percent financing option for the TV purchase; or choose full payment option. Develop a spreadsheet model to find the better option that results in a good saving? Also, find the discount rate for 0 percent financing option.
Hint: Use Goal Seek to find the discount rate that makes the net present value of the payments = $1050.