﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<?application progid="SMath Solver" version="1.3.0.9126"?>
<worksheet xmlns="http://smath.info/schemas/worksheet/1.0">
  <settings ppi="96">
    <identity>
      <id>a599b7a0-e981-4d0c-abf4-d9b96b885822</id>
      <revision>20</revision>
    </identity>
    <calculation>
      <precision>5</precision>
      <exponentialThreshold>5</exponentialThreshold>
      <trailingZeros>false</trailingZeros>
      <significantDigitsMode>false</significantDigitsMode>
      <mixedNumbers>false</mixedNumbers>
      <roundingMode>0</roundingMode>
      <approximateEqualAccuracy>0</approximateEqualAccuracy>
      <fractions>decimal</fractions>
    </calculation>
    <pageModel active="false" viewMode="2" printGrid="false" printAreas="true" simpleEqualsOnly="false" printBackgroundImages="true" hideElementsHighlightings="true">
      <paper id="1" orientation="Portrait" width="850" height="1100" />
      <margins left="39" right="39" top="49" bottom="49" />
      <header alignment="Center" color="#a9a9a9">&amp;[DATE] &amp;[TIME] - &amp;[FILENAME]</header>
      <footer alignment="Center" color="#a9a9a9">&amp;[PAGENUM] / &amp;[COUNT]</footer>
      <backgrounds />
    </pageModel>
    <dependencies>
      <assembly name="SMath Core" version="1.73.9126.0" guid="a37cba83-b69c-4c71-9992-55ff666763bd" />
      <assembly name="MathRegion" version="1.73.9126.0" guid="02f1ab51-215b-466e-a74d-5d8b1cf85e8d" />
      <assembly name="SpecialFunctions" version="1.73.9126.0" guid="2814e667-4e12-48b1-8d51-194e480eabc5" />
      <assembly name="TextRegion" version="1.73.9126.0" guid="485d28c5-349a-48b6-93be-12a35a1c1e39" />
      <assembly name="AreaRegion" version="1.73.9126.0" guid="4974b228-4974-44cf-8274-bf2936b4a766" />
      <assembly name="Statistical Tools" version="1.0.6824.32561" guid="76f6e9f5-ac86-4ffb-9e4d-284c8daecaf9" />
      <assembly name="X-Y Plot Region (JXCharts)" version="0.3.9106.25707" guid="c12231ec-4873-43c1-a7d0-a167ebd17066" />
      <assembly name="PlotRegion" version="1.73.9126.0" guid="c451c2b5-798b-4f08-b9ec-b90963d1ddaa" />
    </dependencies>
  </settings>
  <regions type="content">
    <region left="9" top="0" width="178" height="29" color="#000000" fontSize="14">
      <text lang="eng" fontFamily="Times New Roman" fontSize="10">
        <content>
          <p style="font-size: 14px; text-decoration: underline;">Investment Prediction</p>
        </content>
      </text>
    </region>
    <region left="504" top="0" width="101" height="371" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">MRD</e>
          <e type="operand">21.1</e>
          <e type="operand">20.2</e>
          <e type="operand">19.4</e>
          <e type="operand">18.5</e>
          <e type="operand">17.7</e>
          <e type="operand">16.8</e>
          <e type="operand">16.0</e>
          <e type="operand">15.2</e>
          <e type="operand">14.4</e>
          <e type="operand">13.7</e>
          <e type="operand">12.9</e>
          <e type="operand">12.2</e>
          <e type="operand">11.5</e>
          <e type="operand">10.8</e>
          <e type="operand">10.1</e>
          <e type="operand">9.5</e>
          <e type="operand">8.9</e>
          <e type="operand">8.4</e>
          <e type="operand">7.8</e>
          <e type="operand">7.3</e>
          <e type="operand">20</e>
          <e type="operand">1</e>
          <e type="function" args="22">mat</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="603" top="0" width="101" height="100" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">MRD2</e>
          <e type="operand">6.8</e>
          <e type="operand">6.3</e>
          <e type="operand">5.8</e>
          <e type="operand">5.3</e>
          <e type="operand">4.8</e>
          <e type="operand">5</e>
          <e type="operand">1</e>
          <e type="function" args="7">mat</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="18" top="36" width="46" height="24" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">m</e>
          <e type="operand">1</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="117" top="36" width="54" height="24" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">n</e>
          <e type="operand">20</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="198" top="36" width="94" height="26" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">yr</e>
          <e type="operand">1</e>
          <e type="operand">n</e>
          <e type="function" args="2">range</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="324" top="36" width="119" height="26" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Val</e>
          <e type="function" args="1">Clear</e>
          <e type="operand">1</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="18" top="72" width="74" height="24" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">μ</e>
          <e type="operand">2.5</e>
          <e type="operand" style="unit">%</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="126" top="72" width="74" height="24" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">σ</e>
          <e type="operand">7.5</e>
          <e type="operand" style="unit">%</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="261" top="72" width="123" height="23" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Times New Roman" fontSize="10">
        <content>
          <p>Fraction in Equities:</p>
        </content>
      </text>
    </region>
    <region left="396" top="72" width="73" height="30" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">F.e</e>
          <e type="operand">60</e>
          <e type="operand" style="unit">%</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="18" top="99" width="147" height="26" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Val</e>
          <e type="operand">n</e>
          <e type="operand">1</e>
          <e type="function" args="2">matrix</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="261" top="99" width="110" height="23" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Times New Roman" fontSize="10">
        <content>
          <p>Fraction in Fixed:</p>
        </content>
      </text>
    </region>
    <region left="387" top="99" width="128" height="30" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">F.f</e>
          <e type="operand">1</e>
          <e type="operand">F.e</e>
          <e type="operator" args="2">-</e>
          <e type="operator" args="2">:</e>
        </input>
        <contract>
          <e type="operand" style="unit">%</e>
        </contract>
        <result action="numeric">
          <e type="operand">40</e>
        </result>
      </math>
    </region>
    <region left="612" top="108" width="181" height="26" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">MRD</e>
          <e type="operand">MRD</e>
          <e type="operand">MRD2</e>
          <e type="function" args="2">stack</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="261" top="126" width="172" height="23" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Times New Roman" fontSize="10">
        <content>
          <p>Return on Fixed Investments:</p>
        </content>
      </text>
    </region>
    <region left="432" top="126" width="81" height="30" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">r.f</e>
          <e type="operand">3.5</e>
          <e type="operand" style="unit">%</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="18" top="135" width="268" height="294" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">j</e>
          <e type="operand">1</e>
          <e type="operand">m</e>
          <e type="function" args="2">range</e>
          <e type="operand">r.u</e>
          <e type="operand">n</e>
          <e type="function" args="1">Random</e>
          <e type="operator" args="2">:</e>
          <e type="operand">i</e>
          <e type="operand">1</e>
          <e type="operand">n</e>
          <e type="function" args="2">range</e>
          <e type="operand">r.n</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operand">r.u</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operand">μ</e>
          <e type="operand">σ</e>
          <e type="function" args="3">ICDF.Normal</e>
          <e type="operator" args="2">:</e>
          <e type="operand">1</e>
          <e type="operand">1</e>
          <e type="function" args="3">line</e>
          <e type="function" args="3">for</e>
          <e type="operand">Val</e>
          <e type="operand">1</e>
          <e type="function" args="2">el</e>
          <e type="operand">800</e>
          <e type="operator" args="2">:</e>
          <e type="operand">i</e>
          <e type="operand">2</e>
          <e type="operand">n</e>
          <e type="function" args="2">range</e>
          <e type="operand">f.m</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operand">1</e>
          <e type="operand">MRD</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">/</e>
          <e type="operator" args="2">:</e>
          <e type="operand">Inc</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operand">Val</e>
          <e type="operand">i</e>
          <e type="operand">1</e>
          <e type="operator" args="2">-</e>
          <e type="function" args="2">el</e>
          <e type="operand">f.m</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
          <e type="operand">Rate</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operand">1</e>
          <e type="operand">F.e</e>
          <e type="operand">r.n</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">+</e>
          <e type="operand">F.f</e>
          <e type="operand">r.f</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">+</e>
          <e type="operator" args="2">:</e>
          <e type="operand">Val</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operand">Val</e>
          <e type="operand">i</e>
          <e type="operand">1</e>
          <e type="operator" args="2">-</e>
          <e type="function" args="2">el</e>
          <e type="operand">Rate</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">*</e>
          <e type="operand">Inc</e>
          <e type="operand">i</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">-</e>
          <e type="operator" args="2">:</e>
          <e type="operand">4</e>
          <e type="operand">1</e>
          <e type="function" args="6">line</e>
          <e type="function" args="3">for</e>
          <e type="operand">4</e>
          <e type="operand">1</e>
          <e type="function" args="6">line</e>
          <e type="function" args="3">for</e>
        </input>
      </math>
    </region>
    <region left="288" top="171" width="207" height="38" color="#000000" fontSize="10">
      <text lang="eng" width="201" fontFamily="Times New Roman" fontSize="10">
        <content>
          <p>The Income that is withdrawn <span style="font-style: italic;">(Inc)</span> is dependent on this MRD Factor:</p>
        </content>
      </text>
    </region>
    <region left="54" top="441" width="127" height="33" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Val</e>
          <e type="operand">4</e>
          <e type="function" args="2">el</e>
        </input>
        <result action="numeric">
          <e type="operand">706.0888</e>
        </result>
      </math>
    </region>
    <region left="225" top="441" width="127" height="33" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Rate</e>
          <e type="operand">5</e>
          <e type="function" args="2">el</e>
        </input>
        <result action="numeric">
          <e type="operand">1.07678</e>
        </result>
      </math>
    </region>
    <region left="432" top="441" width="127" height="33" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Inc</e>
          <e type="operand">5</e>
          <e type="function" args="2">el</e>
        </input>
        <result action="numeric">
          <e type="operand">39.89202</e>
        </result>
      </math>
    </region>
    <region left="54" top="486" width="71" height="33" color="#000000" fontSize="10">
      <math error="43">
        <input>
          <e type="operand">Val</e>
          <e type="operand">5</e>
          <e type="function" args="2">el</e>
        </input>
        <result action="numeric">
          <e type="operand">#</e>
        </result>
      </math>
    </region>
    <region left="225" top="486" width="240" height="33" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Val</e>
          <e type="operand">4</e>
          <e type="function" args="2">el</e>
          <e type="operand">Rate</e>
          <e type="operand">5</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">*</e>
          <e type="operand">Inc</e>
          <e type="operand">5</e>
          <e type="function" args="2">el</e>
          <e type="operator" args="2">-</e>
        </input>
        <result action="numeric">
          <e type="operand">720.40894</e>
        </result>
      </math>
    </region>
    <region left="54" top="540" width="79" height="33" color="#000000" fontSize="10">
      <math error="43">
        <input>
          <e type="operand">Val</e>
          <e type="operand">10</e>
          <e type="function" args="2">el</e>
        </input>
        <result action="numeric">
          <e type="operand">#</e>
        </result>
      </math>
    </region>
    <region left="180" top="693" width="245" height="23" color="#000000" fontSize="10" isBreakable="false">
      <text lang="eng" width="245" fontFamily="Times New Roman" fontSize="10">
        <content>
          <p>Predicted Value ($k) over Life Span (20yr)</p>
        </content>
      </text>
    </region>
    <region left="0" top="711" width="710" height="457" color="#000000" fontSize="10">
      <plot type="2d" render="lines" scale_x="0.0443449266958134" scale_y="3.68470883775986" scale_z="0.148543766641706" rotate_x="0" rotate_y="0" rotate_z="0" transpose_x="-353" transpose_y="-202" transpose_z="0">
        <input>
          <e type="operand">yr</e>
          <e type="operand">Val</e>
          <e type="function" args="2">augment</e>
          <e type="operand">800</e>
          <e type="operand">2</e>
          <e type="operand">1</e>
          <e type="function" args="4">sys</e>
        </input>
      </plot>
    </region>
    <region top="1323" color="#000000">
      <area collapsed="true">
        <title lang="eng">
          <content>
            <p>Histogram Snippet</p>
          </content>
        </title>
      </area>
      <region left="18" top="1332" width="547" height="721" color="#000000" fontSize="10">
        <math decimalPlaces="4">
          <input>
            <e type="operand">intervals</e>
            <e type="operand">values</e>
            <e type="function" args="2">hist</e>
            <e type="operand">binBounds</e>
            <e type="operand">intervals</e>
            <e type="function" args="1">sort</e>
            <e type="operator" args="2">:</e>
            <e type="operand">binMin</e>
            <e type="operand">binBounds</e>
            <e type="operand">1</e>
            <e type="function" args="2">el</e>
            <e type="operator" args="2">:</e>
            <e type="operand">binCount</e>
            <e type="operand">intervals</e>
            <e type="function" args="1">length</e>
            <e type="operand">1</e>
            <e type="operator" args="2">-</e>
            <e type="operand">1</e>
            <e type="function" args="2">matrix</e>
            <e type="operator" args="2">:</e>
            <e type="operand">sortedValues</e>
            <e type="operand">values</e>
            <e type="function" args="1">sort</e>
            <e type="operator" args="2">:</e>
            <e type="operand">lastIndex</e>
            <e type="operand">1</e>
            <e type="operator" args="2">:</e>
            <e type="operand">j</e>
            <e type="operand">2</e>
            <e type="operand">intervals</e>
            <e type="function" args="1">length</e>
            <e type="function" args="2">range</e>
            <e type="operand">binMax</e>
            <e type="operand">binBounds</e>
            <e type="operand">j</e>
            <e type="function" args="2">el</e>
            <e type="operator" args="2">:</e>
            <e type="operand">k</e>
            <e type="operand">lastIndex</e>
            <e type="operand">values</e>
            <e type="function" args="1">length</e>
            <e type="function" args="2">range</e>
            <e type="operand">v</e>
            <e type="operand">sortedValues</e>
            <e type="operand">k</e>
            <e type="function" args="2">el</e>
            <e type="operator" args="2">:</e>
            <e type="operand">lastIndex</e>
            <e type="operand">k</e>
            <e type="operator" args="2">:</e>
            <e type="operand">v</e>
            <e type="operand">binMin</e>
            <e type="operator" args="2">&lt;</e>
            <e type="operand" style="string">value below the range</e>
            <e type="operand">continue</e>
            <e type="operand">2</e>
            <e type="operand">1</e>
            <e type="function" args="4">line</e>
            <e type="operand">v</e>
            <e type="operand">binMax</e>
            <e type="operator" args="2">≥</e>
            <e type="operand" style="string">value belong to next bins</e>
            <e type="operand">break</e>
            <e type="operand">2</e>
            <e type="operand">1</e>
            <e type="function" args="4">line</e>
            <e type="operand" style="string">found a value for this bin</e>
            <e type="operand">binCount</e>
            <e type="operand">j</e>
            <e type="operand">1</e>
            <e type="operator" args="2">-</e>
            <e type="function" args="2">el</e>
            <e type="operand">binCount</e>
            <e type="operand">j</e>
            <e type="operand">1</e>
            <e type="operator" args="2">-</e>
            <e type="function" args="2">el</e>
            <e type="operand">1</e>
            <e type="operator" args="2">+</e>
            <e type="operator" args="2">:</e>
            <e type="operand">continue</e>
            <e type="operand">3</e>
            <e type="operand">1</e>
            <e type="function" args="5">line</e>
            <e type="function" args="3">if</e>
            <e type="function" args="3">if</e>
            <e type="operand">3</e>
            <e type="operand">1</e>
            <e type="function" args="5">line</e>
            <e type="function" args="3">for</e>
            <e type="operand">binMin</e>
            <e type="operand">binMax</e>
            <e type="operator" args="2">:</e>
            <e type="operand">3</e>
            <e type="operand">1</e>
            <e type="function" args="5">line</e>
            <e type="function" args="3">for</e>
            <e type="operand">hist</e>
            <e type="operand">binCount</e>
            <e type="function" args="1">length</e>
            <e type="operand">1</e>
            <e type="function" args="2">matrix</e>
            <e type="operator" args="2">:</e>
            <e type="operand">j</e>
            <e type="operand">1</e>
            <e type="operand">binCount</e>
            <e type="function" args="1">length</e>
            <e type="function" args="2">range</e>
            <e type="operand">hist</e>
            <e type="operand">j</e>
            <e type="function" args="2">el</e>
            <e type="operand" style="string">rect</e>
            <e type="operand">binBounds</e>
            <e type="operand">j</e>
            <e type="function" args="2">el</e>
            <e type="operand">0</e>
            <e type="operand">binBounds</e>
            <e type="operand">j</e>
            <e type="operand">1</e>
            <e type="operator" args="2">+</e>
            <e type="function" args="2">el</e>
            <e type="operand">binBounds</e>
            <e type="operand">j</e>
            <e type="function" args="2">el</e>
            <e type="operator" args="2">-</e>
            <e type="operand">binCount</e>
            <e type="operand">j</e>
            <e type="function" args="2">el</e>
            <e type="operand">4</e>
            <e type="operand">1</e>
            <e type="function" args="6">mat</e>
            <e type="operand" style="string">#ff009900</e>
            <e type="operand" style="string">solid</e>
            <e type="operand">1</e>
            <e type="operand" style="string">#6600ff00</e>
            <e type="operand">6</e>
            <e type="operand">1</e>
            <e type="function" args="8">mat</e>
            <e type="operator" args="2">:</e>
            <e type="operand">1</e>
            <e type="operand">1</e>
            <e type="function" args="3">line</e>
            <e type="function" args="3">for</e>
            <e type="operand">hist</e>
            <e type="operand">9</e>
            <e type="operand">1</e>
            <e type="function" args="11">line</e>
            <e type="operator" args="2">:</e>
          </input>
        </math>
      </region>
      <region top="2043" color="#000000">
        <area terminator="true" />
      </region>
    </region>
    <region left="45" top="2070" width="555" height="244" color="#000000" fontSize="10">
      <xyplot width="545" height="236" points="100" name="XYPlot">
        <chartstyle usedefault="false" backcolor="White" bordercolor="Black" />
        <grid gridcolor="LightGray" gridpattern="Dash" gridthickness="1" isxgrid="true" isygrid="true" isy2grid="false" />
        <xaxes xmin="-0.2226212" xmax="0.3255751" xtick="0.1" visible="True" decimalplaces="3" numberformat="General" />
        <yaxes ymin="-0.2816107" ymax="6.055577" ytick="2" visible="True" decimalplaces="3" numberformat="General" />
        <y2axes isy2axis="false" y2min="-1" y2max="1" y2tick="0.5" visible="True" decimalplaces="3" numberformat="General" />
        <title2d title="" titlefont="Arial, 10pt" titlefontcolor="Black" />
        <xylabel labelfont="Arial, 10pt" labelfontcolor="Black" tickfont="Arial, 8pt" tickfontcolor="Black" xlabel="x" ylabel="y" y2label="y2" />
        <legend isbordervisible="false" islegendvisible="false" legendbackcolor="White" legendbordercolor="Black" legendfont="Arial, 8pt" legendposition="North" textcolor="Black" />
        <traces>
          <trace seriesname="" isy2data="false" isvisible="true" plotmethod="Shapes" lineantialias="false" linecolor="Blue" linethickness="1" linepattern="Solid" filled="false" hatched="false" fillcolor="64, 0, 0, 255" hatchstyle="Percent20" symbolantialias="false" symbolsize="8" symboltype="None" symbolborderthickness="1" symbolbordercolor="Black" symbolfillcolor="White" />
        </traces>
        <description active="true" position="Right" lang="eng">
          <content></content>
        </description>
        <input>
          <e type="operand">0.2</e>
          <e type="operator" args="1">-</e>
          <e type="operand">0.3</e>
          <e type="operand">0.175</e>
          <e type="operator" args="1">-</e>
          <e type="function" args="3">range</e>
          <e type="operand">r.n</e>
          <e type="function" args="2">hist</e>
          <e type="operand">1</e>
          <e type="operand">1</e>
          <e type="function" args="3">mat</e>
        </input>
      </xyplot>
    </region>
  </regions>
</worksheet>