Purchase Solution

Evaluating Phone Plans Using the Time Value of Money

Not what you're looking for?

Ask Custom Question

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.