Suppose You Have $1100 and Decided to Purchase a New

question 6

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.

---

Definitions:

Bilingualism

The ability to fluently speak and understand two languages.

Terror Management Theory

A psychological perspective asserting that the fear of death influences human behavior and cultural attitudes.

Aggression

A range of behaviors that can result in both physical and psychological harm to oneself, others, or objects in the environment.

Phobias

Persistent, irrational fears of specific objects, activities, or situations that lead to a compelling desire to avoid the dreaded subject or situation.