Spreadsheet: 120752d1315497918-multiple-results-sample
Sheet: Debt Analysis

 |  |  | DEBT ANALYSIS - at various cost of funds
 |  |  | Cost of Funds:
 |  |  |  |  | YEAR 1 |  | YEAR 2 |  | YEAR 3 |  | YEAR 4 |  | YEAR 5 |  | YEAR 6 |  | YEAR 7
 |  |  | Initial Equity |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | Vehicles Purchased
 |  |  | Previous Year's Debt |  | 0
 |  |  | Principal Reduction:
 |  |  | Net income:
 |  |  | End of Year Debt:
 |  |  | Total Equity:
 |  |  | Debt to Equity
 |  |  | Cost of Funds: |  | 0.16
 |  |  |  |  | YEAR 1 |  | YEAR 2 |  | YEAR 3 |  | YEAR 4 |  | YEAR 5 |  | YEAR 6 |  | YEAR 7
 |  |  | Initial Equity |  | 17000000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | Vehicles Purchased |  | -165000000 | 7500 | -105600000 | 4800 | -105600000 | 4800 | -105600000 | 4800 | -105600000 | 4800 | 0 |  | 0
 |  |  | Previous Year's Debt |  | 0 |  | -129914999.7106916 |  | -196784987.7891148 |  | -139895284.7433419 |  | -127040883.6182696 |  | -112849624.7761897 |  | -483264.5453858078
 |  |  | Principal Reduction: |  | 12379839.2413967 |  | 28023053.6400759 |  | 150528762.6133521 |  | 105600000 |  | 105600000 |  | 99390138.64645816 |  | 85878205.85871734
 |  |  | Net income: |  | 5705161.047911676 |  | 10706958.28150096 |  | 11960940.43242079 |  | 12854401.12507229 |  | 14191258.8420798 |  | 12976221.58434574 |  | 9781871.927774234
 |  |  | End of Year Debt: |  | -129914999.7106916 |  | -196784987.7891148 |  | -139895284.7433419 |  | -127040883.6182696 |  | -112849624.7761897 |  | -483264.5453858078
 |  |  | Total Equity: |  | 22705161.04791167 |  | 33412119.32941263 |  | 45373059.76183342 |  | 58227460.88690571 |  | 72418719.72898552 |  | 85394941.31333126 |  | 95176813.2411055
 |  |  | Debt to Equity |  | 5.721826832082333 |  | 5.88962902499529 |  | 3.083223513637006 |  | 2.181803597189634 |  | 1.558293562748828 |  | 0.005659170648207517
 |  |  | Cost of Funds: |  | 0.14
 |  |  |  |  | YEAR 1 |  | YEAR 2 |  | YEAR 3 |  | YEAR 4 |  | YEAR 5 |  | YEAR 6 |  | YEAR 7
 |  |  | Initial Equity |  | 17000000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | Vehicles Purchased |  | -165000000 | 7500 | -105600000 | 4800 | -105600000 | 4800 | -105600000 | 4800 | -105600000 | 4800 | 0 |  | 0
 |  |  | Previous Year's Debt |  | 0 |  | -128735689.2700735 |  | -193214484.0015104 |  | -133817623.7259409 |  | -118477116.7466217 |  | -101740623.6321844 |  | 12498601.31216467
 |  |  | Principal Reduction: |  | 12379839.2413967 |  | 28023053.6400759 |  | 150528762.6133521 |  | 105600000 |  | 105600000 |  | 99390138.64645816 |  | 85878205.85871734
 |  |  | Net income: |  | 6884471.488529772 |  | 13098151.62848723 |  | 14468097.66221735 |  | 15340506.97931921 |  | 16736493.11443726 |  | 14849086.29789087 |  | 10441536.1551786
 |  |  | End of Year Debt: |  | -128735689.2700735 |  | -193214484.0015104 |  | -133817623.7259409 |  | -118477116.7466217 |  | -101740623.6321844
 |  |  | Total Equity: |  | 23884471.48852977 |  | 36982623.117017 |  | 51450720.77923435 |  | 66791227.75855356 |  | 83527720.87299083 |  | 98376807.1708817 |  | 108818343.3260603
 |  |  | Debt to Equity |  | 5.389932506226788 |  | 5.224466728337765 |  | 2.60088919453875 |  | 1.773842474866754 |  | 1.218046207520583
 |  |  | Cost of Funds: |  | 0.12
 |  |  |  |  | YEAR 1 |  | YEAR 2 |  | YEAR 3 |  | YEAR 4 |  | YEAR 5 |  | YEAR 6 |  | YEAR 7
 |  |  | Initial Equity |  | 17000000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | Vehicles Purchased |  | -165000000 | 7500 | -105600000 | 4800 | -105600000 | 4800 | -105600000 | 4800 | -105600000 | 4800 | 0 |  | 0
 |  |  | Previous Year's Debt |  | 0 |  | -127556378.8294554 |  | -189674642.2853621 |  | -127865849.5200474 |  | -110207075.0442312 |  | -91170916.15930139 |  | 24610274.56250109
 |  |  | Principal Reduction: |  | 12379839.2413967 |  | 28023053.6400759 |  | 150528762.6133521 |  | 105600000 |  | 105600000 |  | 99390138.64645816 |  | 85878205.85871734
 |  |  | Net income: |  | 8063781.92914787 |  | 15458682.90401743 |  | 16880030.15196262 |  | 17658774.47581615 |  | 19036158.88492981 |  | 16391052.07534431 |  | 10695796.84692397
 |  |  | End of Year Debt: |  | -127556378.8294554 |  | -189674642.2853621 |  | -127865849.5200474 |  | -110207075.0442312 |  | -91170916.15930139
 |  |  | Total Equity: |  | 25063781.92914787 |  | 40522464.8331653 |  | 57402494.98512792 |  | 75061269.46094406 |  | 94097428.34587386 |  | 110488480.4212182 |  | 121184277.2681421
 |  |  | Debt to Equity |  | 5.089271012253503 |  | 4.680728160694814 |  | 2.227531217121755 |  | 1.468228233224516 |  | 0.9688991268091249