Suppose You Have $1100 and Decide to Purchase a New

question 60

Essay

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

---

Definitions:

Anxiety

A feeling of worry, nervousness, or unease about something with an uncertain outcome, often reflecting a reaction to stress.

Distress

Extreme anxiety, sorrow, or pain, which can be a response to an immediate threat or long-term stressor, affecting one's mental and emotional well-being.

Judgments Of Abnormality

Assessments or evaluations made regarding whether certain behaviors or conditions deviate significantly from what is considered normal or acceptable in a society.

Cultural Norms

Common norms and guidelines that direct the actions of individuals in societal groups.