Portfolio Analyst

The Portfolio Analyst plays an integral role on the Finance team by closely monitoring and analyzing various borrower and guarantor financial reports. This person works closely with Asset Manager and Vice President of Finance to ensure loan compliance across all loans. Essential Job Functions Tracks and monitors various borrower-submitted financial reports such as financial statements of borrower / project entity, guarantor certificates and financial statements to ensure that the borrowers are in compliance with the reporting covenants under the loan agreement. Assists Asset Manager in calculating and tracking various loan metrics such as loan-to-value ratios, debt service coverage ratios, debt-yield tests, collateral basket tests, internal rate of return, and other requirements as applicable to examine and verify projects’ financial health and ensure that the collateral value meets required thresholds as to comply with covenants under loan agreement. Assists the Asset Manager to update project database with such information to ensure portfolio and information are up-to-date. Develops compliance checklists and documentation to ensure financial records are maintained in compliance with the requirements under the loan agreements. Communicates regularly with the borrowers and guarantors regarding any past-due and/or upcoming reports; sends out reminders and follow-up inquiries as needed to ensure that the borrowers meet the loan compliance requirements as per reporting covenants under loan agreement. Reports status of submitted, upcoming, and delinquent reports to Asset Manager and Vice President of Finance. Constantly maintains and updates the tracker system based on the project status (under construction, operation, restructuring), adds and removes the project and report list to keep the system up-to-date. Assists Asset Manager in updating the internal database system, including project database which is used to store project information and be able to generate summary reports from the database for review by the Asset Manager and management. Assists Asset Manager to conduct various analyses of a loan, including financial modeling requirements as necessary. Other duties as assigned. Knowledge, Skills and Abilities Excellent work ethics Strong communication skills Strong attention to detail Ability to work cross-functionally across multiple teams Strong analytical abilities and aptitude in complex problem-solving Strong quantitative background with experience in loan compliance Positive attitude Highly organized and motivated Education and Experience Bachelor’s degree in Real Estate, Finance, Accounting, or related field preferred Proficiency in Microsoft Excel, Office, and PowerPoint Ability to handle and prioritize multiple tasks simultaneously Understanding of commercial real estate industry is a plus Physical Requirements Regularly required to sit for extended periods of time. Regular use of hands and fingers and repetition of the same movements. Reads and writes, speaks and hears. #J-18808-Ljbffr