How do calculate column C ; without knowing column e ?

MPT with prepayment with no Servicing Fees Calculations

MPT with prepayment with no Servicing Fees Calculations (a) Pool (b) Principal due to (c) Scheduled (d) Principal Principal and Interest paid Paid Interest Pmts (O Total Principal and Interest Pmts to Issuer (g) Guarantee and Service Fees (h) Total Payments (i) 5% claim to Investors to cash flow ear 2 3 4 5 6 7 8 9 10 Balance repayment to Issuer (b)+(c) (f)-(g) 6,322,619 5,262,449 4,308,352 3,450,483 2,680,246 1,374,848 829,928 355,460 $750,000.00 $632,261.88 $526,244.91 $430,835.21 $345,048.28 $268,024.63 $199,032.48 $137,484.78 $82,992.83 $0.00 $1 ,327 ,381.23 $1,186,622.06 $944,036.36 $839,246.16 $743,526.41 $655,283.47 $572,416.50 $491 ,067.01 $398,115.04 $900,000.00 $758,714.25 $631,493.89 $517,002.25 $414,057.93 $321,629.55 $238,838.98 $164,981.74 $99,591.40 $42,655.18 $427,381.23 $427,907.81 $427,852.06 $427,034.11 $425,188.22 $421 ,896.85 $391 ,475.61 $355,459.86 $2,077,381.23 $1,818,883.94 $1,585,590.86 $1 , 184,294.44 $1 ,011 ,551.03 $854,315.95 $709,901.28 $574,059.84 $398,115.04 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $2,077,381.23 $1,818,883.94 $1,184,294.44 $1,011 ,551.03 $854,315.95 $709,901.28 $574,059.84 $398,115.04 $103,869 $79,280 $68,744 $59,215 $50,578 $42,716 $35,495 $28,703 $19,906 In this scenario, it assumes that the pool pays down 10% in unscheduled prepayment. Investors get net cash flow after fees. This investor gets 5% of total paid to investors.