Evaluating Phone Plans Using the Time Value of Money
Not what you're looking for?
A recent article at MSN was "Droid Versus Pre Versus iPhone: A Cost of Ownership Reality Check: Which of these three hot handsets will cost you the most over two years?" By Ian Paul, PC World. (It can be found at the following although it is not needed for this question as the data is listed below.)
http://tech.msn.com/products/articlepcw.aspx?cp-documentid=22645499>1=40000
Using the time value of money concept, compare these three phones using risk free interest rates of 3%, 10% and 25%. Explain the different results resulting from the three interest rates.
iPhone Droid Palm Pre
Cost of Phone with 2-year contract $199.00 $199.99 $146.99
Calling Plan (450 minutes per month) $39.99 $89.98 $69.99
Data Access Fee per month $30.00 $- $-
Unlimited SMS per month $20.00 $- $-
Total Monthly cost $89.99 $89.98 $69.99
Activation Fee--one time cost $36.00 $35.00 $36.00
Early Cancellation Fee $175.00 $175.00 $200.00
Total Two-year Cost $2,394.76 $2,394.51 $1,862.75
Purchase this Solution
Solution Summary
Using Excel 97-2003, this solution illustrates how to evaluate different cellular telephone plans using time value of money concepts.
Solution Preview
I have computed the net present value of the outlays for each phone at each annual interest rate in the attached Excel 97-2003 spreadsheet. As one would expect, because the initial outlay ...
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.