This has been answered by someone already but it's missing a piece of information. The link to the answer is here: https://www.coursehero.com/tutors-problems/Statistics-and-Probability/25945888-An-advertisement-in-the-newspaper-offers-a-new-car-for-sale-or-lease/

Below is the original question and the answer given. I cannot see the formula in G27. Also, I wasn't sure if this was correct because I don't feel like they removed the $550 security deposit. I'd love to have someone review for accuracy.

\fB C D E F G H K L M IN P 1 Results of Monte Carlo Simulation Sample 2 Number SHS18 Simulation Stats -18574 870 1000 repetitions .19385 933 S|seconds Summary Statistics Notes -18314 760 Average -18299 005 -17823.803 SD 635.7330 -17506 903 Max -16126 007 -17719 921 -21309 469 -18701 296 10 -18479 250 Histogram of $H$28 -18970 637 10 -18936 447 11 -18395.900 12 -18533 685 15 13 -18174.934 16 14 -18236 589 17 15 -18063 082 18 16 -17179 023 19 17 -17970.001 20 15 -19753 951 21 19 -18016 249 -21400 -19430 -18400 17410 -15450 22 20 -18310 843 23 21 -17796 992 12 -17917 420H C D F F G H Purchase Cumulative Purchain Purchase price of car 43240 Month Mileage Mileage Cashlow DCF Cashflow W N -58513 LN RANDI]] CE] :G3/(1+$8514/12)*503 :-[85-38) LaDie -50$12"LN RANDI]] -[4:] -C4/1 40514/17)*504 -5045-IN( 4-40516,54-MAN(F].$0516).0) "$050 Down payment 7500 --50$13"AN RANDI]] -15+F4 -05/(1-$0514/12)*505 W N H 6 Monthly payment 158 #-$8$13"LN RANDI]] CEO+FS G6/(1+$3514/12)^506 =-58$5-IF(FG>.$8516,FG-MAN(F5,$8516).0)"$859 7 Payment term (months) 24 - $8512"IN(RANDI]] -1746 -67/(1+58514/12)*507 H Security deposit 950 -GH/(1.$8514/12)*508 9 Charge per mile 0.71 6 "-56$13"LMIRANDI]] F9+FS -69/(1+$8514/17)*509 --5856-IFF9> $8516,F9-MAX(FR, $8516).0;"5859 10 purchase price at end of lease 29732 7 =$8512 LN|RANDI]] -E10419 =610/(1-$ 514/12)-5010 11 Average Mileage driven 25000 - $8517"IN|RANDI]] EITHFIO -611/1-$0514/12)*5011 13 Average mileage / mih -811/34 =-58513"LN(RANDI]] -F13+F11 =612/(1+$9514/12)*5012 =-5856-IF(F123-$8516.F12-MAX(F11,$8516)_0)"SAS 13 Mileare 10 = $8$12"LN|RAND/]] =E13+F12 =G13/(1+$3514/12)~$013 = $8$5 IF(#13>=$3516,F13 MAX(F12,98$10).0)*Su; 14 interest rate -NORMINV[ RAND().8-5%%.1%) 11 -58512"IN RANDI]] -[14:F13 -G14/(1-$8514/12)*5014 -5056 IF(F14)-58516,F14 MAX(F13.50516).0)*509 15 Realizable value =010-MAX[O,ED-30000)"89 12 =-$8513 LN(RANDI]] =E15 .F14 =015/(1*$0514/12)*5015 =-5056-17(715>=$8516.F15-MAX(F14.$6516).0)"$04 16 Threshold Mileage 30000 13 = $8$12"LNRANDINI SEIS+FIS =GIC/11+$8514/12)*$016 17 14 -58SIZ"IN RANDI]] -EIT PLE -617/(1-$9514/12)*5017 --5856-15(617>-50516.F17-MAX(FIG.50516).0)*209 14 15 =-$0$12"IN RANDI]] -CIS FIT =618/11-50514/12)*5018 =-5036-IF(518-$0516,F18-MAX(F17,50516)_0)"Sng 19 16 --$6$13"LN RANDI]] ME19-FIE #G15/(1+$8514/12)*$019 =-$8$6-IF(F19>:$3516,F19-MAX(F18, S8516),0)" SR 20 17 --$8512"LN|RANDIII -EXO415 -620/1 1-58514/12)*5020 --5856-IF(207-58516.F20-MAX(F19.50516).0)*$09 21 18 -G21/1 1+$8514/12)*5021 19 --58513 LM|RANDI]] -EX -FX --5856-1FF325-$8516.F23-MAX(F21,$8516)_01"SA 23 20 = $8$13"LN|BAND/]] =EX3+F12 =G23/(1+$3514/12)*$023 =-58$5-IF(F23)=$3516,F23-MAX(F22,$8$10].0)*$8: 31 -$8$12"IN| RAND(]] -(24:F2] -624/(1.$8514/12)*5024 -5035-IF(5245-50516,F24-MAX(F23.50516).0)*509G H 1 Results of Monte Carlo Simulation Sample 2 Number SK528 Simulation Stats -18097.076 1000 repetitions -18074.074 7 seconds Summary Statistics Notes AWNI -18164.035 Average -18273.093 -18267.836 SD 395.4021 -18146.436 Max -17825.585 -17919.622 -21949.809 -16270.916 E -19454.259 Histogram of $K$28 10 11 9 -17976.283 12 10 -18287.870 13 11 -18229.493 14 12 -18053.780 15 13 -18284.855 16 14 -18067.705 17 15 -18110.372 18 16 -18192.005 19 17 -17966.616 20 18 -18261.984 -12000 -31000 -20000 -19000 -18000 21 19 -18129.281 22 20 -18169.362 23 21 -18947.639 24 11 -18438.251 10700 Ken