Spreadsheet: 132592d1323842138-if-then-statement-help-sample-excel
Sheet: Revenue - Loan Products (2)

 | Primary | Product |  |  | Deal | Contract | Contract | 2011 | Renewal | One |  | 2011-01-30 00:00:00 | 2011-02-28 00:00:00 | 2011-03-30 00:00:00 | 2011-04-30 00:00:00 | 2011-05-30 00:00:00 | 2011-06-30 00:00:00 | 2011-07-30 00:00:00 | 2011-08-30 00:00:00 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 | 2011-11-30 00:00:00 | 2011-12-30 00:00:00 | 2011 |  | 2012-01-30 00:00:00 | 2012-02-28 00:00:00 | 2012-03-30 00:00:00 | 2012-04-30 00:00:00 | 2012-05-30 00:00:00 | 2012-06-30 00:00:00 | 2012-07-30 00:00:00 | 2012-08-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-30 00:00:00 | 2012-11-30 00:00:00 | 2012-12-30 00:00:00 | 2012 |  | 2011-08-30 00:00:00 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 | 2011-11-30 00:00:00 | 2011-12-30 00:00:00 | 2011 |  | 2012-01-30 00:00:00 | 2012-02-28 00:00:00 | 2012-03-30 00:00:00 | 2012-04-30 00:00:00 | 2012-05-30 00:00:00 | 2012-06-30 00:00:00 | 2012-07-30 00:00:00 | 2012-08-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-30 00:00:00 | 2012-11-30 00:00:00 | 2012-12-30 00:00:00 | 2012
Client Name | Product | Profitablity | Industry | Type | Value | Start Date | End Date | New Deal | Probability | Time |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Current | Current | Current | Current |  | Current | Current | Current | Current | Current | Current | Current | Current | Current | Current | Current | Current | Current |  | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast |  | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget |  | 2012-01-30 00:00:00 | 2012-02-28 00:00:00 | 2012-03-30 00:00:00 | 2012-04-30 00:00:00 | 2012-05-30 00:00:00 | 2012-06-30 00:00:00 | 2012-07-30 00:00:00 | 2012-08-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-30 00:00:00 | 2012-11-30 00:00:00 | 2012-12-30 00:00:00
Existing Deals
Department of Treasury (Office of Domestic Finance) | Loan Level Data | Loan Data | Government | MCD | 251250 | 2011-06-30 00:00:00 | 2012-09-29 00:00:00 | Yes | 0.8296855848817969 |  |  |  |  |  |  |  | 209375 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 335000 |  | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 |  |  |  |  | 167500 |  | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 335000 |  | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 20937.5 | 17371.54193346262 | 17371.54193346262 | 17371.54193346262 | 17371.54193346262 | 236986.1677338505 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
KGS Alpha Capital Management | Prepayment/Credit | Behavioral Models | Investor | AFT | 200000 | 2011-06-23 00:00:00 | 2012-06-22 00:00:00 | Yes | 0.87934435867388 |  |  |  |  |  |  |  | 16666.67 | 16666.67 | 16666.67 | 16666.66 | 16666.67 | 16666.67 | 16666.67 | 116666.68 |  | 16666.67 | 16666.67 | 16666.67 | 16666.67 | 16666.67 |  |  |  |  |  |  |  | 83333.34999999999 |  | 16666.67 | 16666.66 | 16666.67 | 16666.67 | 16666.67 | 116666.68 |  | 16666.67 | 16666.67 | 16666.67 | 16666.67 | 16666.67 | 14655.73931123133 | 14655.73931123133 | 14655.73931123133 | 14655.73931123133 | 14655.73931123133 | 14655.73931123133 | 14655.73931123133 | 185923.5251786193 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0