Xinyi Gao Email and Phone Number

• Prepare month-end, quarter-end, and year-end financial statements and conducts comprehensive business-focused variance analysis • Create and maintain fund level financial modelling by Excel for monthly recovery analysis, quarterly reforecast, yearly budgeting and cash flow analysis • Maintain and update fund ledger account reconciliation and prepare the adjustment entries to ensure items are cleared according to guidelines, procedures, policies, and deadlines.• Review consolidated… Show more • Prepare month-end, quarter-end, and year-end financial statements and conducts comprehensive business-focused variance analysis • Create and maintain fund level financial modelling by Excel for monthly recovery analysis, quarterly reforecast, yearly budgeting and cash flow analysis • Maintain and update fund ledger account reconciliation and prepare the adjustment entries to ensure items are cleared according to guidelines, procedures, policies, and deadlines.• Review consolidated financial statement for audit accounts, tax account, fixed asset, leasing expense, corporate funding and reporting to management • Corporate with front office to monitor the CAPEX project progress under/over budget and the completion status for amortization and recovery purpose • Monitor cash flow projections, prepare cash call and distribution • Conduct complex bank reconciliation as per auditing requirement • Assist in acquisitions, dispositions and participate in due diligence and statement of adjustment Show less

• Issue bi-weekly rental outstanding statements via Excel advanced formulas to ensure rental income are collected in time, achieving total efficiency results of 150% against quota• Analyze monthly utility statements through monitoring seasonal consumption and investigating unexpected cases, in order to assist commercial tenants to reduce further loss • Analyze past due accounts using Excel Visualization tools (Pivot Charts & PivotTables) and report to Property Manager, recovering loss… Show more • Issue bi-weekly rental outstanding statements via Excel advanced formulas to ensure rental income are collected in time, achieving total efficiency results of 150% against quota• Analyze monthly utility statements through monitoring seasonal consumption and investigating unexpected cases, in order to assist commercial tenants to reduce further loss • Analyze past due accounts using Excel Visualization tools (Pivot Charts & PivotTables) and report to Property Manager, recovering loss more than $300,000.00 per year and mitigating risk of delayed payment or bad debt expense• Update rent-roll of over 180 commercial units and determine the specific lease condition of each unit to utilize a 20% rental revenue growth from the prior year • Precisely forecast the construction budget of the Birchmount Project and ensure the error range within 15%, evaluating and tracking the risk of periodically completion Show less