Spreadsheet: 161810d1339629463-linking-cells-in-two-worksheets-in-the-same-workbook-figure-15-sales-forecast-and-market-share
Sheet: Sales Forecast 2011-2012

SALES FORECAST ON CURRENT TREND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR ENDING FEBRUARY 2012
AGENT [NAME] CODE SGAL • BRANCH CN • AREA HERITAGE HILL ESTATES • SUBURB LOUWLARDIA EXTENSION 48 • LOCAL MUNICIPALITY PRETORIA
AGENT SALES / COMMISSION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REFERRAL COMMISSION
 | PURCHASER |  |  |  |  |  | HOUSE | TOWNHOUSE | CLUSTER | STAND - RES. 1 | STAND - RES. 2 | PROPERTY ADDRESS |  |  |  |  |  |  |  |  |  |  |  | SALES DATE |  |  |  | LIST PRICE |  |  |  | SALES PRICE |  |  |  | REGISTRATION DATE |  |  |  | % COMMISSION | GROSS COMMISSION |  |  |  | (A) AGENT COMMISSION |  |  |  | OUTSTANDING COMMISSION |  |  |  | REFERRAL AGENT |  |  |  |  | REFERRAL AGENT BRANCH/FRANCHISE |  |  |  |  |  |  |  |  |  |  |  | % COMMISSION | (B) REFERRAL COMMISSION PAID OUT |  |  |  | (C) REFERRAL COMMISSION PAID IN
1 | Wehan Pullman |  |  |  |  |  |  | X |  |  |  | Unit 14/1082, Rasmus Erasmus Boulevard |  |  |  |  |  |  |  |  |  |  |  | 2011-08-03 00:00:00 |  |  |  | 1250000 |  |  |  | 1250000 |  |  |  | 15/09/2011 |  |  |  | 5 |  |  |  |  |  |  |  |  | 0 |  |  |  | [NAME] |  |  |  |  | Pam Golding Properties, Centurion |  |  |  |  |  |  |  |  |  |  |  | 10 | 0 |  |  |  | 7369.64
2 | [NAME] |  |  |  |  |  |  |  |  |  | X | 1085 Rasmus Erasmus Boulevard |  |  |  |  |  |  |  |  |  |  |  | 2011-07-07 00:00:00 |  |  |  | 1680000 |  |  |  | 1680000 |  |  |  | 15/01/2012 |  |  |  | 5 |  |  |  |  |  |  |  |  | 0 |  |  |  | [NAME] |  |  |  |  | Pam Golding Properties, Centurion |  |  |  |  |  |  |  |  |  |  |  | 10 | 0 |  |  |  | 2089
3 | [NAME] |  |  |  |  |  |  |  |  | X |  | 1147 Lemondale Drive |  |  |  |  |  |  |  |  |  |  |  | 2011-08-08 00:00:00 |  |  |  | 450000 |  |  |  | 0 |  |  |  | - |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
4 | D'Shorne Human |  |  |  |  |  |  |  |  | X |  | 1060 Peacan Avenue |  |  |  |  |  |  |  |  |  |  |  | 17/9/2011 |  |  |  | 486500 |  |  |  | 450000 |  |  |  | 2012-05-06 00:00:00 |  |  |  | 8 |  |  |  |  |  |  |  |  | 19460
5 | [NAME] |  |  |  |  |  |  | X |  |  |  | Unit 9/1082, Rasie Erasmus Boulevard |  |  |  |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00 |  |  |  | 1250000 |  |  |  | 1250000 |  |  |  | 30/11/2011 |  |  |  | 5 |  |  |  |  |  |  |  |  | 0 |  |  |  | SALES FORCAST ON CURRENT TREND
6 | Amit Ramsumair |  |  |  |  |  |  |  |  | X |  | 1052 Katbos Avenue |  |  |  |  |  |  |  |  |  |  |  | 2011-07-09 00:00:00 |  |  |  | 486500 |  |  |  | 420000 |  |  |  | 15/12/2011 |  |  |  | 8 |  |  |  |  |  |  |  |  | 16800
7 | [NAME] |  |  |  |  |  |  |  |  | X |  | 1147 Lemondale Drive |  |  |  |  |  |  |  |  |  |  |  | 21/11/2011 |  |  |  | 485500 |  |  |  | 450000 |  |  |  | 2012-01-06 00:00:00 |  |  |  | 8 |  |  |  |  |  |  |  |  | 18000 |  |  |  | COMMISSION TARGET : |  |  |  |  |  |  |  |  | 250000 |  |  |  | VALUE OF OTP'S TAKEN :
8 | [NAME] |  |  |  |  |  |  |  |  | X |  | 1043 Katbos Avenue |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 |  |  |  | 483000 |  |  |  | 483000 |  |  |  | 2012-03-02 00:00:00 |  |  |  | 5 |  |  |  |  |  |  |  |  | 0 |  |  |  | (1) COMMISSION TO DATE : |  |  |  |  |  |  |  |  |  |  |  |  | VALUE OF SUCCESSFUL OTP'S :
9 | [NAME] |  |  |  |  |  |  |  |  | X |  | 1149 Lemondale Drive |  |  |  |  |  |  |  |  |  |  |  | 30/11/2011 |  |  |  | 485500 |  |  |  | 450000 |  |  |  | 2012-06-06 00:00:00 |  |  |  | 8 |  |  |  |  |  |  |  |  | 18000 |  |  |  | TO GO ON TARGET : |  |  |  |  |  |  |  |  |  |  |  |  | (3) STRIKE RATE : |  |  |  |  |  |  |  |  |  |  |  | %
10 | [NAME] |  |  |  |  |  |  | X |  |  |  | No. 12 Village View, Lucia Lilean Avenue |  |  |  |  |  |  |  |  |  |  |  | 16/12/2011 |  |  |  | 2280000 |  |  |  | 0 |  |  |  | - |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  | NUMBER OF MONTHS : |  |  |  |  |  |  |  |  | 12 |  |  |  | NUMBER OF MONTHS LAPSED : |  |  |  |  |  |  |  |  | 12
11 | [NAME] |  |  |  |  |  |  |  | X |  |  | No. 7 Nederzetting, lucia Lilean Avenue |  |  |  |  |  |  |  |  |  |  |  | 19/2/2012 |  |  |  | 2150000 |  |  |  | 0 |  |  |  | - |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  | NUMBER OF MONTHS LEFT : |  |  |  |  |  |  |  |  | 0 |  |  |  | (2) RYTHYM :
12 | [NAME] |  |  |  |  |  |  |  |  | X |  | 930 Northview Lane |  |  |  |  |  |  |  |  |  |  |  | 2012-06-02 00:00:00 |  |  |  | 385000 |  |  |  | 0 |  |  |  | - |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  | POTENTIAL MONTHLY EARNINGS : |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY INCOME :
13 | [NAME] |  |  |  |  |  |  |  |  | X |  | 1041 Katbos Avenue |  |  |  |  |  |  |  |  |  |  |  | 16/2/2012 |  |  |  | 450000 |  |  |  | 425000 |  |  |  | 2012-12-05 00:00:00 |  |  |  | 5 |  |  |  |  |  |  |  |  | 10625 |  |  |  | (1) COMMISSION TO DATE = AGENT COMMISSION (COLUMN A) – (MINUS) REFERRAL COMMISSION PAID OUT (COLUMN B) + (PLUS) REFERRAL COMMISSION RECEIVED (COLUMN C) .                                                                                        (2) RYTHYM = COMMISSION TO DATE ÷ NUMBER OF MONTHS LAPSED × NUMBER OF MONTHS IN THE YEAR.                                                                                    (3) STRICK RATE = ACTUAL SALES VS. POTENTIAL SALES %.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFFER DECLINED BY SELLER |  |  |  |  |  |  |  |  |  | LOAN APPLICATION DECLINED BY FSP