{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["PFR Pg1","PFR Pg2"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"PFR Pg1","index":0,"n_rows":79,"n_cols":9,"rows_kept":79,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,8],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,8],[2,0,2,2],[2,4,2,5],[2,6,2,8],[3,2,3,4],[3,7,3,8],[4,1,4,3],[4,5,4,6],[4,7,4,8],[5,1,5,3],[6,1,6,3],[6,7,6,8],[7,4,7,6],[7,7,7,8],[8,6,8,8],[9,2,9,3],[9,6,9,8],[10,0,10,1],[10,2,10,3],[10,6,10,8],[11,1,11,3],[11,5,11,6],[11,7,11,8],[12,1,12,3],[12,6,12,8],[13,1,13,3],[13,4,13,5],[14,1,14,3],[15,0,15,1],[15,2,15,3],[15,4,15,5],[16,1,16,3],[16,4,16,5],[17,0,17,8],[18,0,18,8],[19,0,19,4],[19,5,19,8],[20,2,20,4],[20,7,20,8],[21,0,21,4],[21,5,21,8],[22,1,22,2],[22,3,22,4],[22,6,22,7],[24,0,24,8],[25,2,25,4],[25,7,25,8],[26,0,26,1],[26,2,26,3],[26,5,26,6],[26,7,26,8],[27,0,27,8],[28,0,28,8],[29,2,29,4],[29,7,29,8],[30,0,30,8],[31,0,31,8],[32,2,32,4],[32,7,32,8],[33,0,33,1],[33,2,33,3],[33,5,33,6],[33,7,33,8],[34,0,34,8],[35,0,35,8],[36,2,36,4],[36,7,36,8],[37,0,37,1],[37,2,37,3],[37,5,37,6],[37,7,37,8],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[59,2,59,3],[61,6,61,8],[62,2,62,3],[62,6,62,8],[65,1,65,3],[65,5,65,6],[66,1,66,3],[68,7,68,8],[70,0,70,2],[70,7,70,8],[71,1,71,2],[71,7,71,8],[74,0,74,2],[74,4,74,5],[74,7,74,8],[75,0,75,2],[75,4,75,5],[75,7,75,8],[76,1,76,2],[76,4,76,5],[76,7,76,8],[77,1,77,2],[77,4,77,5],[77,7,77,8],[78,1,78,2],[78,4,78,5],[78,7,78,8]]}
[null,null,"Financial Planner:"]
[null,null,"Provincial Licence:",null,"ON",null,"PERSONAL FINANCIAL REVIEW"]
["Date:",{"$nulls":5},"(New Client Application Form)"]
["Age:",{"$f":"IF(B9=0,\" \",DATEDIF(B9,TODAY(),\"y\"))","v":" "},{"$nulls":3},"Age:",{"$f":"IF(G6=0,\" \",DATEDIF(G6,TODAY(),\"y\"))","v":" "}]
["Name:",{"$nulls":4},"Spouse/Partner Name:"]
["Address:",{"$nulls":4},"Birthdate:",null,"SIN:"]
[{"$nulls":5},"Telephone:","Home:"]
["Postal Code:",null,"How Long:",null,"Work:"]
["Birthdate:",null,"SIN:",null,null,"Employer:"]
["Telephone:","Home:",{"$nulls":3},"Address:"]
["Work:",{"$nulls":4},"Occupation:"]
["E-mail:",{"$nulls":4},"Type of Business:"]
["Employer:",{"$nulls":4},"How Long:"]
["Address:",{"$nulls":5},"Name","Birthdate","Age"]
["Occupation:",{"$nulls":4},"Children:",null,null,{"$f":"IF(H15=0,\" \",IF(DATEDIF(H15,TODAY(),\"y\")<1,\"under 1\",(DATEDIF(H15,TODAY(),\"y\"))))","v":" "}]
["Type of Business:",{"$nulls":7},{"$f":"IF(H16=0,\" \",IF(DATEDIF(H16,TODAY(),\"y\")<1,\"under 1\",(DATEDIF(H16,TODAY(),\"y\"))))","v":" "}]
["How Long:",{"$nulls":7},{"$f":"IF(H17=0,\" \",IF(DATEDIF(H17,TODAY(),\"y\")<1,\"under 1\",(DATEDIF(H17,TODAY(),\"y\"))))","v":" "}]
[]
["Under Section 265(2) of the Income Tax Act (Canada), Moneystrat is required to collect information to determine whether individuals opening a non-registered account are U.S. tax residents or U.S. citizens."]
["Are you a U.S. resident for U.S. tax purposes or a U.S. citizen?"]
["      Yes ","      No ",{"$nulls":3},"      Yes ","      No "]
["If Yes, please provide your U.S. taxpayer identification number (TIN):"]
["U.S. TIN:",{"$nulls":4},"U.S. TIN:"]
[]
["Are you (i) an officer or director of a reporting issuer or any other issuer whose securities are publicly traded (e.g. an entity whose securities are traded on a stock exchange or an over-the-counter market) (an \"Issuer\"); or (ii) an officer or director of a company which is itself an insider or a subsidiary of such Issuer?"]
["      Yes ","      No ",{"$nulls":3},"      Yes ","      No "]
["If yes, please list the Issuer(s):",{"$nulls":4},"If yes, please list the Issuer(s):"]
[]
["Are you designated as a Pro (licensed to sell securities)?"]
["      Yes ","      No ",{"$nulls":3},"      Yes ","      No "]
[]
["Do you: (i) beneficially own; or (ii) have control or direction over; or (iii) have a combination of beneficial ownership of, and control or direction over, directly or indirectly, securities of an Issuer carrying more than 10% of the voting rights attached to all of the lssuer’s outstanding voting securities?"]
["      Yes ","      No ",{"$nulls":3},"      Yes ","      No "]
["If yes, please list the Issuer(s):",{"$nulls":4},"If yes, please list the Issuer(s):"]
[]
["Do you or as part of a group, hold or control an Issuer?"]
["      Yes ","      No ",{"$nulls":3},"      Yes ","      No "]
["If yes, please list the Issuer(s):",{"$nulls":4},"If yes, please list the Issuer(s):"]
["FINANCIAL GOALS (check all applicable):",{"$nulls":4},"INCOME:",null,"GROSS ANNUAL ","MONTHLY NET"]
["      Save income tax dollars",null,"      Current monthly income",null,null,"Self:","Work"]
["      Own your own home",null,"      Future monthly income",{"$nulls":3},"Interest"]
["      Pay off mortgage",null,"      Keep ahead of inflation",{"$nulls":3},"Rental"]
["      Increased savings",null,"      Have more insurance protection",{"$nulls":3},"Pension"]
["      Retire early",null,"      Send children to university",{"$nulls":3},"Other"]
["      Start own business",null,"      Other (please specify)",null,null,"Tax %:"]
["Other:",{"$nulls":4},"Spouse/Partner:","Work"]
["1 year goals:",{"$nulls":5},"Interest"]
["5 year goals:",{"$nulls":5},"Rental"]
["10 year goals:",{"$nulls":5},"Pension"]
["Comments:",{"$nulls":5},"Other"]
[{"$nulls":5},"Tax %:"]
["      Will","      Power of Attorney     Date:",{"$nulls":3},"Total Net Income:",null,{"$f":"+I52*12","v":{"v":0,"d":"$0"}},{"$f":"SUM(I40:I44)+SUM(I46:I50)-I45-I51","v":{"v":0,"d":"$0"}}]
["Lawyer:",{"$nulls":4},"Total Expenses:",null,{"$f":"+I53*12","v":{"v":0,"d":"$0"}},{"$f":"'PFR Pg2'!G58","v":{"v":0,"d":"$0"}}]
["Accountant:",{"$nulls":4},"Uncommitted Income:",null,{"$f":"+H52-H53","v":{"v":0,"d":"$0"}},{"$f":"+I52-I53","v":{"v":0,"d":"$0"}}]
["Tax:",{"$nulls":4},"NET WORTH:",null,{"$f":"'PFR Pg2'!B60","v":{"v":0,"d":"$0"}}]
[]
["WILL ANY OTHER PERSON OR PERSONS:",{"$nulls":4},"LEVERAGING:"]
["a) have trading authorization for this account?",{"$nulls":4},"The client has been provided with a leveraging disclosure"]
["      Yes ","      No ","(If Yes, provide particulars)",null,null,"document in compliance with MFDA rules.",null,null,"Yes"]
[]
["b) have financial interest in this account?",{"$nulls":4},"CLIENT IDENTIFICATION:"]
["      Yes ","      No ","(If Yes, provide particulars)",null,null,"Client 1:"]
[{"$nulls":5},"Client 2:"]
[]
["BANKING INFORMATION:"]
["Bank Name: ",{"$nulls":3},"Account #:"]
["Branch:",{"$nulls":3},"Transit #:"]
[]
["SOURCE OF INITIAL CONTACT: ",null,null,"      Referral ","      Seminar ","      Advertising ","           Other:"]
[]
["How long have you known the client?",{"$nulls":4},"Have you met the client?",null,"Yes         No"]
["Referred by:"]
[]
["INSURANCE COVERAGE:"]
["INSURANCE COMPANY",null,null,"Type","Coverage",null,"Premium","Cash Surrender Value"]
[{"$nulls":4},"$",null,"$","$"]
["GROUP"]
["DISABILITY"]
["MORTGAGE"]

{"sheet":"PFR Pg2","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"merged":[[58,7,58,8],[59,5,59,8],[60,5,60,8]]}
["ASSETS",{"$nulls":4},"EXPENSES","MONTHLY",null,"YEARLY"]
[null,"Amount","Rate","Due"]
["Chequing",{"$nulls":4},"Rent or Mortgage"]
["Savings",{"$nulls":4},"Taxes"]
["Trust Company",{"$nulls":4},"Insurance"]
["Credit Union",{"$nulls":4},"Hydro"]
["Other",{"$nulls":4},"Heat"]
["TOTAL CASH ASSETS",{"$f":"SUM(B3:B7)","v":{"v":0,"d":"$0"}},{"$nulls":3},"Water"]
[{"$nulls":5},"Telephone"]
["Canada Savings Bonds",{"$nulls":4},"Cable TV"]
["GICs",{"$nulls":4},"Maintenance"]
["Term Deposits",{"$nulls":4},"Other"]
["Other",{"$nulls":4},"TOTAL HOUSING",{"$f":"SUM(G3:G12)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(I3:I12)","v":{"v":0,"d":"$0"}}]
["Insurance Cash Value"]
["TOTAL LIQUID ASSETS",{"$f":"SUM(B10:B14)","v":{"v":0,"d":"$0"}},{"$nulls":3},"Car Payment"]
[{"$nulls":5},"Car Oil and Gas"]
["Notes Receivable",{"$nulls":4},"Car Maintenance"]
["Mortgage Receivable ",{"$nulls":4},"Car Insurance"]
["Stocks/Bonds",{"$nulls":4},"Car Club"]
["Real Estate",{"$nulls":4},"Car Licence"]
["Tax Shelters",{"$nulls":4},"Other"]
["RRSP/RRIF",{"$nulls":4},"TOTAL TRANSPORTATION",{"$f":"SUM(G15:G21)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(I15:I21)","v":{"v":0,"d":"$0"}}]
["Other"]
["TOTAL INVESTMENT ASSETS",{"$f":"SUM(B17:B23)","v":{"v":0,"d":"$0"}},{"$nulls":3},"Food"]
[{"$nulls":5},"Milk and Bread"]
["Home",{"$nulls":4},"Tobacco/Liquor"]
["Cottage",{"$nulls":4},"Other"]
["Furnishings",{"$nulls":4},"TOTAL FOOD",{"$f":"SUM(G24:G27)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(I24:I27)","v":{"v":0,"d":"$0"}}]
["Vehicles"]
["Boat/Motor/Trailer",{"$nulls":4},"Clothing"]
["Personal",{"$nulls":4},"Footwear"]
["Other",{"$nulls":4},"Laundry/Cleaners"]
["TOTAL PERSONAL ASSETS",{"$f":"SUM(B26:B32)","v":{"v":0,"d":"$0"}},{"$nulls":3},"Other"]
[{"$nulls":5},"TOTAL CLOTHING",{"$f":"SUM(G30:G33)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(I30:I33)","v":{"v":0,"d":"$0"}}]
["TOTAL ASSETS",{"$f":"B33+B24+B15+B8","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"Life/Disability Insurance"]
["LIABILITIES",{"$nulls":4},"Debt"]
[{"$nulls":5},"Investments"]
["Visa",{"$nulls":4},"Dental/Medical"]
["MasterCard",{"$nulls":4},"Child Care"]
["Bank",{"$nulls":4},"Charity/Church"]
["Other",{"$nulls":4},"Other"]
["TOTAL CONSUMER CREDIT",{"$f":"SUM(B39:B42)","v":{"v":0,"d":"$0"}},{"$nulls":3},"TOTAL OTHER",{"$f":"SUM(G36:G42)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(I36:I42)","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"BASIC EXPENSES"]
["Insurance Loans"]
["Instalment Loans",{"$nulls":4},"TOTAL BASIC",{"$f":"+G43+G34+G28+G22+G13","v":{"v":0,"d":"$0"}},null,{"$f":"+I43+I34+I28+I22+I13","v":{"v":0,"d":"$0"}}]
["Personal Loans",{"$nulls":4},"LIFESTYLE"]
["Accrued Income Tax"]
["Other",{"$nulls":4},"Entertainment"]
["TOTAL SHORT TERM",{"$f":"SUM(B45:B49)","v":{"v":0,"d":"$0"}},{"$nulls":3},"Vacations"]
[{"$nulls":5},"Clubs and Lodges"]
["Mortgage: Home",{"$nulls":4},"Gifts"]
["Mortgage: Other",{"$nulls":4},"Home"]
["Loan: Personal Assets",{"$nulls":4},"Other"]
["Loan: Investments",{"$nulls":4},"TOTAL DISCRETIONARY",{"$f":"SUM(G49:G54)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(I49:I54)","v":{"v":0,"d":"$0"}}]
["TOTAL LONG TERM",{"$f":"SUM(B52:B55)","v":{"v":0,"d":"$0"}},{"$nulls":3},"LIFESTYLE"]
[]
["TOTAL LIABILITIES",{"$f":"+B56+B50+B43","v":{"v":0,"d":"$0"}},{"$nulls":3},"TOTAL EXPENSES",{"$f":"+G55+G46","v":{"v":0,"d":"$0"}},null,{"$f":"+I55+I46","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"NOTES:"]
["NET WORTH: ",{"$f":"B35-B58","v":{"v":0,"d":"$0"}}]