CPC Finance Analyst

CAHEC Properties Corporation CPC is responsible for (i) structuring, negotiating, and closing new and re-syndicated development projects, (ii) providing owner representation for properties owned by CPC and its affiliates, and (iii) acquiring affordable properties that are at risk of removal from the affordable housing stock. Through its affiliates, CPC is the Managing Member or General Partner for over two hundred multifamily affordable housing communities and, in this role, is responsible for the physical and economical oversight of each property. Specifically, CPC is responsible for ensuring all applicable compliance is maintained, the physical condition of each property is of a high quality, all local, state, and federal reporting requirements are met, and financial commitments to investors and other stakeholders are maintained. CPC is also responsible for overseeing all property and corporate accounting and finance functions of CPC and its affiliated entities. Hiring Full Time | CPC Finance Analyst Monday - Friday 8:00am-5:00pm | 7700 Trenholm Road Ext., Columbia

SC 29223

Position Summary The Finance Analyst will analyze, evaluate, structure, and assist in closing complex real estate transactions. Working with the Development Finance Manager (Supervisor) and each member of the Development Team, the Finance Analyst will develop and maintain financial models that measure development activities from property selection to construction completion and stabilization and ensure compliance with regulatory and financing requirements. Additionally, the position will assist in obtaining transaction financing and LIHTCs, review transaction documents to ensure consistency between financial modeling and closed transactions and work with Development Team on other assigned development activities. Position Duties and Responsibilities A. Essential Functions (60%) 1.0 Financial Modeling & Analysis Collect and interpret relevant data necessary for financial modeling and stress analysis for development transactions. Work with Development Team in preparing application packages required for each transaction and develop and maintain spreadsheets to automate and expedite the application process. Work with Supervisor and Project Manager to analyze transaction economics throughout the construction process to ensure development and financial goals are met. Work with Supervisor and other stakeholders (including CAHEC and CMI) to consider and price new acquisitions. Develop and maintain a current knowledge of industry trends and underwriting standards. Compare development data and analysis with established CAHEC affiliates and states' underwriting criteria for variances and suitability for development, document findings, and report accordingly. Review Qualified Allocation Plans and other financing application guidelines to ensure financial modeling is done in a manner consistent with said guidance. This review includes understanding and incorporating any and all underwriting guidelines applicable to the given transaction. This process will include internal memorialization of guidelines and requirements and providing comments to the agency/promulgator as requested from time to time. ( 15%) 2.0 Relationship Management Work with Lenders, Federal and State Agencies to obtain financing and approvals for development transactions. Prepare necessary reports for all financial partners and respond to stakeholders concerning potential and closed transactions Work with accounting and legal firms to ensure development transactions are memorialized / documented in manner that is consistent with current financial models and transaction's economic requirements of multiple financial partners are not conflicted. Work with third party report providers (Environmental, Appraisal, Market Study, Capital Needs Assessment…) to finalize reports and incorporate final findings in financial models. (25%) 3.0 Data Management & Coordination Maintain version control for financial models and other development spreadsheets. Upload spreadsheets and related development data into corporate database for report generation. Work with Supervisor to provide weekly updates on closed and potential transactions. Work with Supervisor and Development Team to maintain accurate and current development schedules and budgets for all closed and potential transactions that delineate critical path items and leveraged and opportunity costs. B. Additional Responsibilities Perform other related duties as requested or assigned. Knowledge, Skills, and Abilities Required A. Minimum Learned Skills and Abilities Proven ability to demonstrate advanced proficiency in Microsoft Word and Excel. Proven ability to analyze and develop complex financial models. Working experience and knowledge of real estate development pro formas. Proven ability to manage multiple, concurrent priorities and easily adapt to constantly changing priorities in order to meet established timetables. Proven ability to listen and understand issues being presented, and to think analytically to develop and recommend effective creative solutions. Proven ability to demonstrate intermediate proficiency in web browser-based cloud storage applications. Demonstrate excellent interpersonal and communication skills (verbal and written), particularly for obtaining, organizing, and accurately conveying information pertaining to portfolio performance, compliance, and other tax credit matters to internal and external stakeholders. Proven ability to establish and maintain productive working relationships and establish the highest level of integrity with others to coordinate work and share information in order to meet departmental goals, objectives, and timetables. Work with an overall methodology consistent with CPC's principles of integrity and social responsibility and values of quality, customer service, leadership, innovation, personal development, and fun. Work to exemplify the standards and values outlined by CPC's mission statement. B. Minimum Education Bachelor's degree in planning, math, finance, business, accounting, or economics or related field; or an equivalent combination of education and comparable work experience. C. Minimum Work Experience Minimum two (2) year progressively responsible work experience in finance, data analysis, or investment modeling; or relevant education and training. D. Significant Physical Position Requirements Physical effort is that which is normally associated with work in an office environment. This position requires the ability to travel to occasional meetings, seminars, and other work-related functions within both local and long distances from CPC's office in Columbia, SC. E. Work Environment This position performs work out of CPC's corporate office in Columbia, SC. Travel, typically by automobile, is required for at least 5% of this position. Certain objectives require working on-site at various locations, and some professional training opportunities may also require travel. The candidate would need access to a regular means of transportation. F. Telecommunications, Information Technology, and Office Equipment Used Typical office equipment includes, but not limited to, desktop workstations and laptops utilizing a Windows-based environment. Software consists of a variety offered in Microsoft Office, including Word, Excel, Outlook, Power Point as well as a customized database and a variety of web-based applications. Other equipment may include a variety of electronic devices such as tablets, printers, copiers, scanners, cellular phones, and digital cameras.

Benefits:

401(k) 401(k) matching Dental insurance Employee assistance program Flexible spending account Health insurance Life insurance Paid time off Vision insurance

Work Location:

In person