{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":119,"n_cols":52,"rows_kept":119,"cut":false,"hidden":false,"merged":[[15,5,15,7],[9,4,10,9],[11,5,11,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[32,5,34,15],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[24,5,24,15],[25,5,25,15],[26,5,28,15],[29,5,30,15],[31,5,31,15],[61,5,61,7],[61,11,61,15],[35,5,37,15],[40,5,40,21],[41,5,41,21],[42,5,42,21],[44,5,44,21],[56,5,56,15],[57,5,57,15],[59,5,59,7],[59,11,59,15],[60,5,60,7],[60,11,60,15],[62,5,62,7],[62,11,62,15],[63,5,63,7],[63,11,63,15],[64,5,64,7],[64,11,64,15],[65,5,65,7],[65,11,65,15],[66,5,66,7],[66,11,66,15],[67,5,67,7],[67,11,67,15],[86,5,86,15],[68,5,68,7],[68,11,68,15],[69,5,69,7],[69,11,69,15],[70,5,70,7],[70,11,70,15],[71,5,71,7],[71,11,71,15],[72,11,72,15],[73,5,73,10],[74,5,83,10],[104,4,104,5],[87,5,90,15],[92,5,92,15],[94,5,94,7],[94,11,94,15],[95,11,100,15],[96,7,96,9],[99,7,99,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Based on the review of the engagement, we have indentied the following threats to independence:"]
[]
[null,null,null,null,null,"Indicate the threats identified",null,null,null,"Signifcant?"]
[null,null,null,null,"Threat 1",{"$f":"AX35","v":""},null,null,null,"--Select from Dropdown--"]
[null,null,null,null,"Threat 2",{"$f":"AX36","v":""},null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 3","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 4","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 5","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 6","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 7","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 8","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 9","",null,null,null,"--Select from dropdown--"]
[null,null,null,null,"Threat 10",null,null,null,null,"--Select from dropdown--"]
[]
[]
[null,null,null,null,null,"Quality Control Plan "]
[null,null,null,null,null,"The following is a summary of our quality control plan:"]
[null,null,null,null,null,"On all new (initial) Yellow Book engagements, partner performs the majority of the work and the engagement is sent to an outside firm for EQCR. This removes the self-review threat for preparation of financial statements."]
[]
[]
[null,null,null,null,null,"For the repeat Yellow Book engagements, manager and staff performs the majority of the work and partner reviews their work. We intentionally remove partner from being materially involved and thus keeps their objectivity when reviewing the file. Due to the size of the firm, we believe this step lowers the self-review threat."]
[]
[null,null,null,null,null,"Background on Client (include as required in your situation.  The following are examples)"]
[null,null,null,null,null,"Person Name– runs the management company and responsible for operations on a daily basis. He has been in this position of owning and managing HUD properties for over 30 years. He/she has applicable knowledge to understand and identify financial and regulatory issues in the financial statements. is heavily involved with the HUD compliance regarding tenant issues"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F46","v":"Self-Interest"},1,{"$f":"IF(G$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU35=\"Include Me\",MAX(AV34:AV$34)+1,\"\")","v":""},{"$f":"IF(AU35=\"Include Me\",AS35,\" \")","v":" "},{"$f":"IFERROR(INDEX($AW$35:$AW$43,MATCH(ROW()-ROW($AX$34),$AV$35:$AV$43,0)),\"\")","v":""},null,"--Select from Dropdown--"]
[null,null,null,null,null,"Person Name – is CPA and the Board of Directors Treasurer. He reviews the financial statements for appropriate financial reporting within professional standards. He is heavily involved with the overall internal controls and financial reporting with GAAP.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H46","v":"Self Review"},2,{"$f":"IF(I$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU36=\"Include Me\",MAX(AV$34:AV35)+1,\"\")","v":""},{"$f":"IF(AU36=\"Include Me\",AS36,\" \")","v":" "},{"$f":"IFERROR(INDEX($AW$35:$AW$43,MATCH(ROW()-ROW($AX$34),$AV$35:$AV$43,0)),\"\")","v":""},null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J46","v":"Bias"},3,{"$f":"IF(K$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU37=\"Include Me\",MAX(AV$34:AV36)+1,\"\")","v":""}," ","",null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L46","v":"Familiarity"},4,{"$f":"IF(M$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU38=\"Include Me\",MAX(AV$34:AV37)+1,\"\")","v":""}," ","",null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N46","v":"Undue Influence "},5,{"$f":"IF(O$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU39=\"Include Me\",MAX(AV$34:AV38)+1,\"\")","v":""}," ",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P46","v":"Management Participation"},6,{"$f":"IF(Q$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU40=\"Include Me\",MAX(AV$34:AV39)+1,\"\")","v":""}," ",""]
[null,null,null,null,null,"Independence Evaluation Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R46","v":"Advocacy "},7,{"$f":"IF(S$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU41=\"Include Me\",MAX(AV$34:AV40)+1,\"\")","v":""}," ",""]
[null,null,null,null,null,"Part I—General Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T46","v":"Adverse Interest"},8,{"$f":"IF(U$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU42=\"Include Me\",MAX(AV$34:AV41)+1,\"\")","v":""}," ",""]
[null,null,null,null,null,"Are there threats to independence?  Consider the following. Highlight areas that are considered threats with any color.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V46","v":"Structural"},9,{"$f":"IF(W$46>0,\"Include Me\",\"\")","v":""},{"$f":"IF(AU43=\"Include Me\",MAX(AV$34:AV42)+1,\"\")","v":""}," ",""]
[]
[null,null,null,null,null,"Threats"]
[null,null,null,null,null,"Self-Interest",{"$f":"SUMIF(G48:G55, \"<>16777215\")","v":0},"Self Review",{"$f":"SUMIF(I48:I55, \"<>16777215\")","v":0},"Bias",{"$f":"SUMIF(K48:K55, \"<>16777215\")","v":0},"Familiarity",{"$f":"SUMIF(M48:M55, \"<>16777215\")","v":0},"Undue Influence ",{"$f":"SUMIF(O48:O55, \"<>16777215\")","v":0},"Management Participation",{"$f":"SUMIF(Q48:Q55, \"<>16777215\")","v":0},"Advocacy ",{"$f":"SUMIF(S48:S55, \"<>16777215\")","v":0},"Adverse Interest",{"$f":"SUMIF(U48:U55, \"<>16777215\")","v":0},"Structural",{"$f":"SUMIF(W48:W55, \"<>16777215\")","v":0}]
[]
[null,null,null,null,null,"Audit organization having undue dependence on income from a particular audited entity.",16777215,"Audit organization issuing a report on the effectiveness of the operation of the systems after design or implement.",16777215,"Member of the engagement team having preconceptions about the objectives of a program under audit that are strong enough to affect the auditor’s objectivity.",16777215,"Member of engagement team having a close/immediate family member who is a principal or senior manager of the audited entity.",16777215,"External interference or influence that could improperly limit or modify the scope of an engagement or threaten to do so, including exerting pressure to inappropriately reduce the extent of work performed in order to reduce costs or fees. ",16777215,"A member of the engagement team being, or having recently been, a principal or senior manager of the audited entity. ",16777215,"A member promotes the attest client's securities as part of an IPO.",16777215,"The attest client or the CPA initiates litigation against or expresses an intent  to commence litigation.",16777215,null,16777215]
[null,null,null,null,null,"Member of audit team entering employing negotiations with audited entity.",16777215,"Audit organization having prepared data used to generate records that are the subject of the engagement.",16777215,"Member of the engagement team having biases associated with political, ideological, or social convictions that result from membership or employment in, or loyalty to, a particular type of policy, group, entity, or level of government that could affect the auditor’s objectivity.",16777215,"Member of engagement team having a close/immediate family member who is a principal or senior manager of the audited entity.",16777215,"External interference with the selection or application of audit procedures or in the selection of transactions to be examined. ",16777215,"An audit organization principal or employee serving as a voting member of an entity’s management committee or board of directors, making policy decisions that affect future direction and operation of an entity’s programs, supervising entity employees, developing or approving programmatic policy, authorizing an entity’s transactions, or maintaining custody of an entity’s assets. ",16777215,"A member provides expert witness services to an attest client.",16777215,null,16777215,null,16777215]
[null,null,null,null,null,"Significant error found when evaluating results of previous service provided by auditor’s audit organization.",16777215,"Audit organization providing service or audited entity directly affecting the subject matter of the engagement.",16777215,null,16777215,"Principal/employee of audited entity recently served on the engagement team.",16777215,"Unreasonable restrictions on the time allowed to complete an engagement or issue the report. ",16777215,"An audit organization principal or employee recommending a single individual for a specific position that is key to the entity or program under audit, or otherwise ranking or influencing management’s selection of the candidate. ",16777215,"A member represents and attest client in U.S. tax court orother public forum.",16777215,null,16777215,null,16777215]
[null,null,null,null,null,"Member of the audit team has direct financial interest in the audited entity.",16777215,"A member of the engagement team being/recently been, employed by audited entity in a position to significantly influence the subject matter of the engagement.",16777215,null,16777215,"Auditor accepting gifts or preferential treatment from an audited entity.",16777215,"\nExternal interference over the assignment, appointment, compensation, and promotion of audit personnel.\n",16777215,"An auditor preparing management’s corrective action plan to deal with deficiencies detected in the engagement.",16777215,"Advocating for the client to HUD on compliance issues.",16777215,null,16777215,null,16777215]
[null,null,null,null,null,null,16777215,null,16777215,null,16777215,"Senior audit personnel having a long association with the entity. There is no specific time limit listed. CPAs make this choice after 4-6 years, in general",16777215,"Restrictions on funds or other resources provided to the audit organization that adversely affect the audit organization’s ability to carry out its responsibilities. ",16777215,null,16777215,null,16777215,null,16777215,null,16777215]
[null,null,null,null,null,null,16777215,null,16777215,null,16777215,null,16777215,"Authority to overrule or to inappropriately influence the auditors’ judgment as to the appropriate content of the report. ",16777215,null,16777215,null,16777215,null,16777215,null,16777215]
[null,null,null,null,null,null,16777215,null,16777215,null,16777215,null,16777215,"Threat of replacing the auditors over a disagreement with the contents of an audit report, the auditors’ conclusions, or the application of an accounting principle or other criteria. ",16777215,null,16777215,null,16777215,null,16777215,null,16777215]
[null,null,null,null,null,null,16777215,null,16777215,null,16777215,null,16777215,"Influences that jeopardize the auditors’ continued employment for reasons other than incompetence, misconduct, or the audited entity’s need for GAGAS engagements. ",16777215,null,16777215,null,16777215,null,16777215,null,16777215]
[]
[null,null,null,null,null,"Part II - Safeguards"]
[null,null,null,null,null," Select from the safeguards below that will be applied to eliminate or reduce the threat."]
[]
[null,null,null,null,null,"Safeguards",null,null,null,"Applied (Yes or No)",null,"Comments"]
[null,null,null,null,null,"Consulting a professional organization or regulatory authority.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Consulting another auditor.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Discussing independence issues with those charged with governance of the entity.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Disclosing to those charged with governance the nature of the audit and the nonaudit services provided. The 2011 Yellow Book requires that this be done for all nonaudit services as part of establishing and documenting the understanding of the nonaudit services to be performed prior to the performance of those services (paragraph 3.39 of the 2011 Yellow Book).",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Assigning separate engagement personnel for the audit and nonaudit service.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Obtaining secondary reviews of the nonaudit services by professional personnel who were not involved in planning or supervising the audit engagement.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Obtaining secondary reviews of audit areas affected by the nonaudit services by professional personnel who were not members of the audit engagement team.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Discussing the significance of the threats to management participation or self-review with the engagement team and emphasizing the risks associated with such threats.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Educating management on the nonaudit services performed by reviewing and explaining the reason and basis for all significant transactions, as well as authoritative standards, so that management is in a position to determine or approve all assumptions and judgments and take responsibility for the nonaudit services.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"When financial statement preparation is the nonaudit service being performed, determining that there has been review of the financial statements and successful completion of a disclosure checklist by the audited entity.",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"For recurring audits, having another independent audit organization perform an audit of the areas affected by the nonaudit service (a “cleansing” audit; see paragraph 3.43 of the 2011 Yellow Book).",null,null,null,"--Select from dropdown--"]
[null,null,null,null,null,"Including the audit engagement as a required engagement quality control review (EQCR) under the audit firm’s system of quality control.",null,null,null,"--Select from dropdown--"]
[]
[null,null,null,null,null,"Conclusion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Client SKE"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Documentation of Decision"]
[]
[null,null,null,null,null,"Do the safeguards described above, combined with the client SKE, documented eliminate or reduce to an acceptable level the indicated threats to independence?\n\n",null,null,null,"--Select from dropdown--",null,"Additional Comments "]
[]
[null,null,null,null,null,"Prepared by"]
[null,null,null,null,null,"Dated"]
[]
[null,null,null,null,null,"Reviewed by"]
[null,null,null,null,null,"Dated"]
[]
[]
[null,null,null,null,1,"1(a)",null,2,null,3,null,4,null,5,null,6]
[null,null,null,null,"Detailed description of nonaudit services",null,null,"Is the nonaudit service specifically prohibited?",null,"Will the nonaudit service involve assuming management responsibilities?",null,"Threats significant, If \"Yes,\" identify significant threats below. If \"No,\" indicate N/A.",null,"Are safeguards beyond client SKE required?  If yes, document safeguards. REMEMBER, CLIENT SKE ALONE IS AN INSUFFICIENT SAFEGUARD.",null,"Identify the individual(s) BY NAME designated by the audited entity to oversee nonaudit services."]
[null,null,null,null,"Prepare FS","We will prepare the financial statements, including note disclosure.  The client will provide a trial balance to be used in the preparation of the financial statements",null,"No",null,"No",null,"Yes, management participation and self-review threats are significant",null,"See independence tab",null,"Name of Person"]
[null,null,null,null,"Preparing journal entries other than proposed audit entries","We will propose and prepare year-end adjusting entries for client.  Client management will review and approve all journal entries",null,"No",null,"No",null,"Yes, management participation and self-review threats are significant",null,"See independence tab",null,"Name of Person"]
[null,null,null,null,"Preparing Tax Returns","We will prepare and submit a draft copy of the returns and related returns for management review and approval",null,"No",null,"No",null,"No",null,"No",null,"Name of Person"]
[null,null,null,null,"Complete REAC Submission","We will complete and submit the Electronic submission to management for review and approval",null,"No",null,"No",null,"Yes, management participation and self-review threats are significant",null,"No",null,"Name of Person"]
[null,null,null,null,"Prepare Corrective Action Plan","We provided a draft of the CAP for the client"]
[null,null,null,null,"Other:"]
[null,null,null,null,"Other:"]
[]
[null,null,null,null,null,7,null,8,null,9,null,10,null,11]
[null,null,null,null,null,"Document SKE of the designated individual(s), or provide a working paper reference to separate documentation. (no SKE - No Independence)",null,"Document that the audited entity agrees to each of the following: a. Agrees to assume all management responsibilities. b. Will evaluate the adequacy and results of the nonaudit services performed.  c. Will accept responsibility for the results of the nonaudit services.  Provide a working paper reference to document. ",null,"List documention showing that the understanding with the audited entity regarding the objectives of the nonaudit services is accepted.",null,"List documentation of the understanding established with the audited entity regarding the auditor's responsibilities.",null,"Documentation of the understanding established with the audited entity regarding the limitation, if any, on the nonaudit services to be provided."]
[null,null,null,null,null,"Toby has exstensive experience in financial reporting, including 5 years with the entity. ",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter"]
[null,null,null,null,null,"See above.  Additionally, we observed here abilities to review  and approve JE in prior years.",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter"]
[null,null,null,null,null,"Toby has significant real estate and tax experience and is designated to review and approve all tax returns and related schedules. Toby has the necessary SKE's to oversee these services.",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter"]
[null,null,null,null,null,"Toby s familiar with the REAC submitions and has the necessary SKE's to oversee these services.",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter",null,"Engagement Letter / Rep Letter"]