freepc - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 42 43 44 45 46 47 48 49 50 B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW BX BY BZ CA CB CC CD CE CF CG CH CI CJ CK CL CM CN CO CP CQ CR CS CT CU Time A nnual Internet p rice for 3 yrs $ 263.40 P C Cost $ 1,000.00 Retention Rate #ADDIN? discount rate 0.1 Price increase 0.03 Switch back 0.1 NPV #ADDIN? With us? Quit? Comeback? Revenue Price 0 Yes 0 0 $ 263.40 1 Yes 0 0 $ 263.40 2 Yes #ADDIN? 0 $ 263.40 $ 263.40 3 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 271.30 4 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 279.44 5 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 287.82 6 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 296.46 7 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 305.35 8 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 314.51 9 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 323.95 10 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 333.67 11 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 343.68 32 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 639.34 33 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 658.52 3 4 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 678.28 3 5 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 698.63 3 6 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 719.58 37 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 741.17 38 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 763.41 39 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 786.31 40 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $ 809.90 0 .5 0.6 0.7 0.8 0.9 Name NPV NPV NPV NPV NPV DescriptionOutput (Sim#1) (Sim#2) (Sim#3) Output Output Output (Sim#4) (Sim#5) Output Cell F8 F8 F8 F8 F8 Minimum = -312.99 -312.99 -312.99 -312.99 -312.99 Maximum = 1 371.32 1766.71 2061.12 2219.84 2489.99 Mean = 2 62.65 391.32 584.3 871.87 1375.44 S td Deviation =3 35.7 404.43 482.37 549.28 642.35 V ariance = 1 12692.7 163564.6 232677.1 301711.7 412612.4 S kewness = 0 .55 0.49 0.43 0.02 -0.21 K urtosis = 2 .9 2.79 2.71 2.35 2.27 9 5% Perc = 8 48.44 1132.05 1415.91 1758.87 2368 Filter Minimum = Filter Maximum = Type (1 or 2) = # V alues Filtered = 0 0 0 0 0 S cenario #1 75% >= >75% >75% >75% >75% S cenario #2 25% <= <25% <25% <25% <25% S cenario #3 90% >= >90% >90% >90% >90% 0 0 0 0 0 0 0 0 0 0 -400 -400 -400 -400 -400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 42 43 44 45 46 47 48 49 50 CW CX CY CZ DA DB DC DD DE DF DG DH DI DJ DK DL DM DN DO DP DQ DR DS DT DU DV DW DX DY DZ EA EB EC ED EE EF EG EH EI EJ EK EL EM EN EO EP EQ ER ES ET EU EV EW EX EY EZ FA FB FC FD FE FF FG FH FI FJ FK FL FM FN FO FP FQ FR FS FT FU FV FW FX FY FZ GA GB GC GD GE GF GG GH GI GJ GK GL GM GN GO GP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 GQ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 42 43 44 45 46 47 48 49 50 GR GS GT GU GV GW GX GY GZ HA HB HC HD HE HF HG HH HI HJ HK HL HM HN HO HP HQ HR HS HT HU HV HW HX HY HZ IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...
View Full Document

This note was uploaded on 03/17/2010 for the course ACCT acct 4360 taught by Professor Robert during the Spring '10 term at DeVry Colorado Springs.

Ask a homework question - tutors are online