{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Template - USE","Example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":false,"merged":[[55,2,56,14],[18,3,19,14],[33,3,34,14],[36,3,36,14],[38,3,39,14],[41,3,42,14],[24,3,25,14],[4,2,10,14],[13,2,14,14],[21,3,22,14],[29,3,31,14],[44,3,46,14]]}
[null,"My Mortgage Auction Corp., in Bankruptcy"]
[null,"Investor Account Reconciliation - Instructions"]
[]
[]
[null,"Purpose:","This template was developed to assist Investors in preparing a standardized accounting of their contracts and transactions with My Mortgage Auction Corp (MMAC). By accurately filling out this spreadsheet, Investors can calculate their Net Gain or Net Loss, compare this with the amount previously reported by the Trustee, and identify any missing transactions or discrepenancies that the Trustee is not aware of.\n\nAdditionally, investors can use this template to attribute bank account transactions from multiple bank accounts to an individual investment contracts (\"Deals\"). An Investor Account Reconciliation (\"AIR\") should be completed for each named individual in an investment contract.\n\nThis statement can then be provided to the Trustee, with all supporting documents as part of your Notice of Dispute."]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:","Personal Information"]
[null,null,"Please enter your personal information (investor name and email), so that the Trustee can easily compare your Investor Schedule to the Trustee's version, and reach out to you at the most appropriate address. This should match the name on your investor contract."]
[]
[]
[null,null,"Enter Transaction Data"]
[]
[null,null,"Amount Reported Per the Trustee:","Please include the amount of Net Gain that was included in the Investor Schedule that you received from the Trustee. This will be compared to the calculated Net Gain (Net Loss) to determine the variance to be reviewed by the Trustee."]
[]
[]
[null,null,"Contract Deal #:","For each transaction, list the deal number associated with the Investment Contract you originally entered into with MMAC. This usually follows the format YYYY-## (ex. 2024-04)."]
[]
[]
[null,null,"Name per Contract","Please include the name that is shown on the investment contract associated with the Contract Deal #. The template should use the same investor contract name."]
[]
[]
[null,null,"Name per Bank Statement","Please include the name that is shown on the bank statement associated with the amount of Cash Deposited or Cash Withdrawn."]
[]
[null,null,"Date per Bank Statement","List the date on which you either sent cash to MMAC (Cash Deposited) or withdrew cash from MMAC (Cash Withdrawn). The Trustee can use this date to look for the transaction in the Funds Flow Analysis. Provide the date in format Day-Month-Year (DD-MMM-YY)."]
[]
[]
[]
[null,null,"Cash Deposited:","The actual amount of cash that you provided to MMAC, whether via cheque, wire, bank transfer or other payment means. This is essentially the principal you invested into MMAC. Please enter all values as a positive figure (i.e. 10,000.00)."]
[]
[]
[null,null,"Cash Withdrawn:","The actual amount of cash that you received from MMAC. Please enter all values as a positive figure (i.e. 10,000.00)."]
[]
[null,null,"Interest Earned:","The amount of interest that should have been earned, as stated on the investment contract, for this specific transaction or deal #. Please enter all values as a positive figure (i.e. 10,000.00)."]
[]
[]
[null,null,"Deal # Reinvested from:","If you rolled or transferred your investment into another investment contract or deal number, please provide the reference as to which deal this came from."]
[]
[]
[null,null,"Supporting Document(s):","List any documents that support your Cash Deposit and Cash Withdrawal, such as bank statements, cheques, branch to branch transfers, wire transfer details, etc. Please ensure that the information provided includes information that allows the Trustee to verify that the deposit or withdrawal matches your name."]
[]
[]
[]
[null,null,"Automated Calculations"]
[null,null,"The Opening Balance, Net Gain (Net Loss) and Closing Balance will be automatically calculated, based on the transaction data you enter into the template."]
[null,null,"At the bottom of the table, the total will be calculated, including the Net Gain (Net Loss)."]
[]
[null,null,"If the automatic calculations do not match your manual calculations, please flag this when sending your template to the Trustee."]
[]
[null,null,"Review and Verify"]
[null,null,"Before submitting the template to the Trustee, please review all entries and ensure they are correct and supported by documentation. Verify that all calculations are correct and in-line with your records."]
[]
[]
[null,null,"Save and Submit"]
[null,null,"Once completed, save the spreadsheet with your name in the file name for easy identification."]
[]
[null,null,"Submit the file to the Trustee at the below email address:"]
[null,null,"ca_syomortgage@pwc.com"]

{"sheet":"Template - USE","index":1,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,3,4,5],[5,3,5,5],[4,1,4,2],[9,8,9,10]]}
[null,"My Mortgage Auction Corp, in bankruptcy"]
[null,"Investor Account Reconciliation - Template"]
[]
[]
[null,"Investor Name"]
[null,"E-mail"]
[]
[]
[null,"Total Net Winnings (Net Loss), as calculated below",null,null,null,null,{"$f":"H34","v":0}]
[null,"Amount reported per the Trustee (Investor Statement)",null,null,null,null,null,null,"<- Ensure \"Enable Content\" is clicked"]
[null,"Variance",null,null,null,null,{"$f":"G9-G10","v":0}]
[]
[]
[null,"[year-##]",null,null,"[D-MMM-YY]",null,"Positive values only","Positive values only","Positive values only",null,"[year-##]","[Bank statement; cheques; deposit slips; etc.]"]
[null,"Contract Deal #","Investor Name per Contract","Name(s) per Bank Statement","Date per Bank Statement","Opening Balance","Cash Deposited","Cash Withdrawn","Interest Earned","Closing Balance","Deal # reinvested from","Supporting Document(s)"]
[null,null,null,null,null,0,null,null,null,{"$f":"SUM(F16:G16,-H16,I16)","v":0}]
[null,null,null,null,null,{"$f":"J16","v":0},null,null,null,{"$f":"SUM(F17:G17,-H17,I17)","v":0}]
[null,null,null,null,null,{"$f":"J17","v":0},null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"J26","v":0},null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"J30","v":0},null,null,null,0]
[]
[null,"Total",null,null,null,{"$f":"F16","v":0},{"$f":"SUM(G16:G32)","v":0},{"$f":"SUM(H16:H32)","v":0},{"$f":"SUM(I16:I32)","v":0},{"$f":"SUM(F33:G33,I33)-H33","v":0}]
[null,null,null,null,null,null,"Net Gain (Net Loss)",{"$f":"H33-G33","v":0}]

{"sheet":"Example","index":2,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"My Mortgage Auction Corp, in bankruptcy"]
[null,"Investor Account Reconciliation - Example"]
[]
[]
[null,"Investor Name","John Doe"]
[null,"E-mail","[Email@address.com]"]
[]
[]
[null,"Total Net Winnings (Net Loss), as calculated below",null,null,null,null,{"$f":"H35","v":5000}]
[null,"Amount reported per the Trustee (Investor Statement)",null,null,null,null,5000]
[null,"Variance",null,null,null,null,{"$f":"G9-G10","v":0}]
[]
[]
[null,"[year-##]",null,null,"[D-MMM-YY]",null,"Positive values only","Positive values only","Positive values only",null,"[year-##]","[Bank statement; cheques; deposit slips; etc.]"]
[null,"Contract Deal #","Investor Name per Contract","Name(s) per Bank Statement","Date per Bank Statement","Opening Balance","Cash Deposited","Cash Withdrawn","Interest Earned","Closing Balance","Deal # reinvested from","Supporting Document(s)"]
[null,"2020-01","John Doe","John Doe","2020-01-01",0,100000,0,15000,{"$f":"SUM(F16:G16,-H16,I16)","v":115000}]
[null,"2020-02","John Doe","John Doe","2020-02-01",{"$f":"J16","v":115000},0,0,17250,132250,"2020-01"]
[null,"2020-03","John Doe","Jane & John Doe","2020-03-01",{"$f":"J17","v":132250},0,30000,{"$f":"F18*20%","v":26450},128700,"2020-02"]
[null,"2021-01","John Doe","John Doe","2021-01-01",128700,50000,20000,{"$f":"G19*30%","v":15000},173700]
[null,"2021-02","John Doe","Jane Doe","2021-02-01",173700,0,20000,20000,173700,"2020-03"]
[null,"2021-03","John Doe","John Doe","2021-03-01",173700,0,20000,30000,183700,"2021-02"]
[null,"2022-01","John Doe","Jane Doe","2022-01-01",183700,0,25000,30000,188700,"2021-03"]
[null,"2023-04","John Doe","John Doe","2023-04-01",188700,0,40000,40000,188700,"2022-01"]
[null,null,null,null,null,188700,null,null,null,188700]
[null,null,null,null,null,188700,null,null,null,188700]
[null,null,null,null,null,188700,null,null,null,188700]
[null,null,null,null,null,{"$f":"J26","v":188700},null,null,null,188700]
[null,null,null,null,null,188700,null,null,null,188700]
[null,null,null,null,null,188700,null,null,null,188700]
[null,null,null,null,null,188700,null,null,null,188700]
[null,null,null,null,null,{"$f":"J30","v":188700},null,null,null,188700]
[null,null,null,null,null,{"$f":"J31","v":188700},null,null,null,188700]
[]
[null,"Total",null,null,null,{"$f":"F16","v":0},{"$f":"SUM(G16:G32)","v":150000},{"$f":"SUM(H16:H32)","v":155000},{"$f":"SUM(I16:I32)","v":193700},{"$f":"J32","v":188700}]
[null,null,null,null,null,null,"Net Gain (Net Loss)",{"$f":"H34-G34","v":5000}]