Spreadsheet: 31788d1227730776-transferring-data-from-one-column-to-another-based-upon-a-variable-contract-example
Sheet: Sheet3

 | Selling Price |  |  |  |  |  |  |  |  |  | 3350 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 153 |  |  |  |  |  |  | Selling Price |  |  |  |  |  |  |  |  | 3350
 | Down Payment |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  | Life Premium |  |  |  |  |  |  |  |  | 42 |  |  |  |  |  |  | - Down Payment |  |  |  |  |  |  |  |  | 800
 | Trade Allowance |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | A&H Premium |  |  |  |  |  |  |  |  | 115 |  |  |  |  |  |  | - Trade Allowance |  |  |  |  |  |  |  |  | 0
 | Unit ACV |  |  |  |  |  |  |  |  |  | 1200 |  |  |  |  |  |  | Oth Premiums/Charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + Sales Tax |  |  |  |  |  |  |  |  | 0
 | Trade ACV |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | Tax Trade |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  | + Insurance Premiums |  |  |  |  |  |  |  |  | 157
 | Overhead per Unit |  |  |  |  |  |  |  |  |  | 700 |  |  |  |  |  |  | Insurance Profit |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  | + Misc Charges |  |  |  |  |  |  |  |  | 153
 | ACV of Repossession |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  | Other Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2860
 | Term in Months |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  | Growth in Overhead (%)
 | Units Sold per Month |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  | Marginal Tax Rate |  |  |  |  |  |  |  |  | 0.28 |  |  |  |  |  |  | Cash in Deal |  |  |  |  |  |  |  |  | 647.2
 | APR |  |  |  |  |  |  |  |  |  | 0.29 |  |  |  |  |  |  | Legal Collection Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross |  |  |  |  |  |  |  |  | 2212.8
 | Repossession Rate |  |  |  |  |  |  |  |  |  | 0.15 |  |  |  |  |  |  | Sales Tax Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Interest |  |  |  |  |  |  |  |  | 583.7023124398102
 | Growth Units/Year (%) |  |  |  |  |  |  |  |  |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Gross |  |  |  |  |  |  |  |  | 2796.50231243981
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Payment |  |  |  |  |  |  |  |  | 229.580154162654
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Payment |  |  |  |  |  |  |  |  | 52.98003557599707
MO | CC |  | New |  | [NAME] |  | CO |  | PO |  | Balance |  |  |  | Principle |  |  |  | Interest |  |  |  | Legal |  |  | Income |  |  |  | Expenses |  |  |  | Net Cash |  |  |  | Net CO |  |  |  | Gross |  |  |  | Net Prft |  |  |  | NP After Tax
1 | 10 |  | 10 |  | 9 |  | 1 |  | 0 |  | 24295.82861253612 |  |  |  | 1444.171387463886 |  |  |  | 622.05 |  |  |  | 0 |  |  | 2066.221387463886 |  |  |  | 13472 |  |  |  | -11405.77861253611 |  |  |  | 2760 |  |  |  | 22128 |  |  |  | 12990.05 |  |  |  | 9352.836
2 | 19 |  | 10 |  | 9 |  | 1 |  | 0
3 | 28 |  | 10 |  | 9 |  | 1 |  | 0
4 | 37 |  | 10 |  | 9 |  | 1 |  | 0
5 | 46 |  | 10 |  | 9 |  | 1 |  | 0
6 | 55 |  | 10 |  | 9 |  | 1 |  | 0
7 | 64 |  | 10 |  | 9 |  | 1 |  | 0
8 | 73 |  | 10 |  | 9 |  | 1 |  | 0
9 | 82 |  | 10 |  | 9 |  | 1 |  | 0
10 | 91 |  | 10 |  | 9 |  | 1 |  | 0
11 | 100 |  | 10 |  | 9 |  | 1 |  | 0
12 | 109 |  | 10 |  | 9 |  | 1 |  | 0
13 | 118 |  | 11 |  | 10 |  | 1 |  | 0
14 | 128 |  | 11 |  | 10 |  | 1 |  | 0
15 | 138 |  | 11 |  | 10 |  | 1 |  | 0
16 | 148 |  | 11 |  | 10 |  | 1 |  | 10
17 | 148 |  | 11 |  | 10 |  | 1 |  | 10
18 | 148 |  | 11 |  | 10 |  | 1 |  | 10
19 | 148 |  | 11 |  | 10 |  | 1 |  | 10
20 | 148 |  | 11 |  | 10 |  | 1 |  | 10
21 | 148 |  | 11 |  | 10 |  | 1 |  | 10
22 | 148 |  | 11 |  | 10 |  | 1 |  | 10
23 | 148 |  | 11 |  | 10 |  | 1 |  | 10
24 | 148 |  | 11 |  | 10 |  | 1 |  | 10
25 | 148 |  | 12 |  | 11 |  | 1 |  | 9
26 | 150 |  | 12 |  | 11 |  | 1 |  | 9
27 | 152 |  | 12 |  | 11 |  | 1 |  | 9
28 | 154 |  | 12 |  | 11 |  | 1 |  | 9
29 | 156 |  | 12 |  | 11 |  | 1 |  | 9
30 | 158 |  | 12 |  | 11 |  | 1 |  | 9
31 | 160 |  | 12 |  | 11 |  | 1 |  | 10
32 | 161 |  | 12 |  | 11 |  | 1 |  | 10
33 | 162 |  | 12 |  | 11 |  | 1 |  | 10
34 | 163 |  | 12 |  | 11 |  | 1 |  | 10
35 | 164 |  | 12 |  | 11 |  | 1 |  | 10
36 | 165 |  | 12 |  | 11 |  | 1 |  | 10
37 | 166 |  | 13 |  | 12 |  | 1 |  | 10
38 | 168 |  | 13 |  | 12 |  | 1 |  | 10
39 | 170 |  | 13 |  | 12 |  | 1 |  | 10
40 | 172 |  | 13 |  | 12 |  | 1 |  | 10
41 | 174 |  | 13 |  | 12 |  | 1 |  | 10
42 | 176 |  | 13 |  | 12 |  | 1 |  | 10
43 | 178 |  | 13 |  | 12 |  | 1 |  | 10
44 | 180 |  | 13 |  | 12 |  | 1 |  | 10
45 | 182 |  | 13 |  | 12 |  | 1 |  | 10
46 | 184 |  | 13 |  | 12 |  | 1 |  | 11
47 | 185 |  | 13 |  | 12 |  | 1 |  | 11
48 | 186 |  | 13 |  | 12 |  | 1 |  | 11
49 | 187 |  | 14 |  | 12 |  | 2 |  | 11
50 | 188 |  | 14 |  | 12 |  | 2 |  | 11
51 | 189 |  | 14 |  | 12 |  | 2 |  | 11
52 | 190 |  | 14 |  | 12 |  | 2 |  | 11
53 | 191 |  | 14 |  | 12 |  | 2 |  | 11
54 | 192 |  | 14 |  | 12 |  | 2 |  | 11
55 | 193 |  | 14 |  | 12 |  | 2 |  | 11
56 | 194 |  | 14 |  | 12 |  | 2 |  | 11
57 | 195 |  | 14 |  | 12 |  | 2 |  | 11
58 | 196 |  | 14 |  | 12 |  | 2 |  | 11
59 | 197 |  | 14 |  | 12 |  | 2 |  | 11
60 | 198 |  | 14 |  | 12 |  | 2 |  | 11