Can you explain how from the above data we obtain the following? (step by step)

Mortgage Pass Through Security Data Input Box: Number of mortgages in initial pool Average mortgage balance Initial mortgage pool balance Prepayment rate Mortgage rate Mortgage Amortization Years Servicing and Guarantee Fee Coupon rate PAR Market interest rate Pieces of MPT Securities 10 $100,000 $1,000,000 0.00% 8.00% 0.5% 7.50% 0.00 7.50% 1000 PSA (a) () 100 (b) 100% PSA Principal due to Prepayment (d) Total Principal and Interest Pmts to Issuer b)+(c) Principal and Interest Pmts to Issuer Average PSA Speed 100 Percent PSA (C) (1) (3) Guarantee Total Pmt to and Payments Individual Service Fees to Investors Investor (a lx(0.5%) (d)-e) (f)# End of Year Pool Pool Factor Year Balance 1.0000 0 $1,000,000 0.6790 1 678,966 0.3274 2 327,419 0.0000 300 396 13,000 25,122 388,034 380,744 353,612 401,034 405,865 353,612 5,000 3,395 1,637 396,034 402,470 351,975 402 1.30 3.70 5.75 352 Discount rate Agg Value of MPT 6.50% $1,018,086 7.50% $1,000,000 8.50% $982,453 Value of MPT $1,018 $1,000 $982 Mortgage Pass Through Security Data Input Box: Number of mortgages in initial pool Average mortgage balance Initial mortgage pool balance Prepayment rate Mortgage rate Mortgage Amortization Years Servicing and Guarantee Fee Coupon rate PAR Market interest rate Pieces of MPT Securities 10 $100,000 $1,000,000 0.00% 8.00% 0.5% 7.50% 0.00 7.50% 1000 PSA (a) () 100 (b) 100% PSA Principal due to Prepayment (d) Total Principal and Interest Pmts to Issuer b)+(c) Principal and Interest Pmts to Issuer Average PSA Speed 100 Percent PSA (C) (1) (3) Guarantee Total Pmt to and Payments Individual Service Fees to Investors Investor (a lx(0.5%) (d)-e) (f)# End of Year Pool Pool Factor Year Balance 1.0000 0 $1,000,000 0.6790 1 678,966 0.3274 2 327,419 0.0000 300 396 13,000 25,122 388,034 380,744 353,612 401,034 405,865 353,612 5,000 3,395 1,637 396,034 402,470 351,975 402 1.30 3.70 5.75 352 Discount rate Agg Value of MPT 6.50% $1,018,086 7.50% $1,000,000 8.50% $982,453 Value of MPT $1,018 $1,000 $982