Financial Analyst Life Insurance

MATTHEW ANDERSON, CPA, MBA

Tampa Bay Area ************@*****.***

813-***-**** linkedin.com/in/mlanderson73/

FINANCIAL ANALYST – REAL ESTATE

Energetic, hungry finance and accounting professional with over 20 years combined finance and accounting experience. Experienced in deal underwriting/proforma analysis on projects in excess of $1,000,000,000. Experienced in financial statement variance analysis, projections, comparison with budgets, year over year, and against industry standard. History of significantly reducing modeling time and increasing modeling results through years of expertise with Excel.

Full cycle accounting

Financial modeling

Timberline, JD Edwards, SQL, Argus

Variance analysis

Cash flow forecasting

Three statement financials

Financial Modeling

Fully programmed model in Excel to have one page for input of independent variables and validity check. Reduced previous initial modeling time from 8 hours to 1 hour per acquisition review and subsequent variable modification and model validation from 1 hour to nearly instantaneous

Supported finance team in Ottawa with projections as privately held Canadian parent company decided to split Minto Communities Florida into two companies, a land company and a home building company

Maintained cash flow valuation models for developer clients for Developments of Regional impact helping client’s maximize investment return (largest project in excess of 20,000 dwelling units, 10,000,000 commercial square feet and $20 billon nominal value at projected completion).

Programmed multi-worksheet budget using macros and visual basic.

Real Estate

Negotiated revenue sharing of fiscal surplus anticipated by new development either via an interlocal agreement with the local government and the CDD or direct payment from the local government to share in the cost of public/private projects such as parking garages or municipal parks creating financial win-win situations for the client and local government.

Added modules to model to include community development district debt financing, proper calculation of real estate taxes, realistic budget for deficit funding of HOAs, and purchase money mortgage (seller-issued note)

Fair Market Value – Engaged with appraiser. Reviewed and compared fair market value of current land inventory to book value for impairment purposes. Submitted report for annual audit of financial statements.

Cash Flow

Modeled Excel HUD review workbook to automate residential closing statement review for accuracy and weekly cash flow projections in $5,000,000+, resulting in authorization to close home.

Used Lender Analysis Model (Excel) to supported company’s largest cash flow inflows (fleet equity) and largest cash outflows (vehicle down payments and monthly principal and interest payments).

Presented to leadership monthly cash flow needs to private equity ownership, based on the outputs of the model. Incorporated data points from fleet director fleet, accounting and business intelligence.

Budgeting and Analysis

Produced ad hoc reporting and analysis for CFO. Determined used vehicle financing capacity. Established special deal financing capacity; calculated incentive repayments based on time and quantity of vehicles purchased.

Post-Acquisition Audit – Compared current projected financial results of various projects against projected results at CAC presentation. Explained variances, incorporating various market, material cost and regulatory changes over several years. Cross-departmental effort with land, finance, sales and marketing, and purchasing. Obtained historical spend, projected future spends, current home prices, lot premiums, option revenues, direct home costs and various indirect spend allocations.

Maintained land development budgets for in-process projects, providing Minto with first real-time budget, and preventing large land development cost overruns.

MATTHEW ANDERSON, CPA, MBA 813-***-**** Page 2

Tax Compliance and Bankruptcy

Preparation of 2003 - 2009 amended federal and New York income tax returns for client reporting Passive Foreign Investment Company (PFIC) income, capital gains, allocation of prior years’ tax and related interest under §1291 rules.

Prepared US consolidated 1120 and consolidated or separate state corporate tax returns for multi-entity, multi-state waste disposal company using Thomson Reuters ONESOURCE software.

Prepared tax returns (1120, 1065, 1040, 709, 706) for corporations, partnerships, and gift/estate taxes.

Recruited for analyst expertise during leadership’s efforts to avoid bankruptcy.

Training

Assisted in development and training of Florida local governments on the Fiscal Impact Analysis Model (FIAM, developed under contract with the State of Florida to estimate fiscal impacts of new development) resulting in educated decisions about the best fiscal use of land.

Professional History

MASSMUTUAL Financial Services Representative Orlando, FL Nov 2019 – Jan 2021

Prospected new clients for life insurance, using warm and cold calls to reach 500 per day. 100% commission-based.

ENCORE FUNDS Maternity Leave Accounting Consultant Kissimmee, FL June 2019 – Sept 2019

Real estate investment vehicle in South Florida with numerous properties. Accounting consultant dedicated to Margaritaville Resort, a “multiple-use” community (housing/retail/hotel property).

AEZ RENT A CAR Senior Financial Analyst Orlando, FL Aug 2018 – Dec 2018

Fleet of 30,000 vehicles at airports nationwide. Advised CFO, VP Finance, Treasurer, and Fleet Director. Coordinated with purchases and sales of cars; managed 5 credit lines for most favorable terms and capacity.

MATTAMY HOMES Land Analyst Orlando, FL Jan 2016 – July 2018

Modeled land budget and proforma for presentation of multi-$1,000,000 land acquisitions to Capital Allocation Committee (CAC). Achieved sufficient pipeline of lot inventory in prime locations to meet division’s 5-year plan of more than 1,000 closings per year.

MINTO COMMUNITIES FLORIDA Senior Financial Analyst Tampa, FL Aug 2014 – Dec 2015

Modeled financial proformas for land under consideration for acquisition; presented results to senior management.

FLORIDA TAX AND VALUATION/ICX GROUP Consultant Orlando, FL. June 2010 – July 2014

Engaged under Kovel Letter by law firm to aid defense client in Southern District of New York/Department of Justice (DOJ) criminal investigation and subsequent plea deal. Charges of tax evasion and foreign bank account report (FBAR). Assignment included reviewing DOJ forensic evidence.

FISHKIND & ASSOCIATES Financial Analyst Orlando, FL Aug 2005 - June 2010

Engaged by various funds, consortiums and partnerships to evaluate investment decisions, analyze public policy decisions, value loan portfolios for FAS 157 (ASU 820) purposes and other special projects using SEC filings, other publicly available information, private surveys and interviews utilizing analytical ratios, financial modeling, cash flow modeling, valuation techniques and/or regression modeling techniques creating client investment and/or savings opportunities.

GRANT THORNTON, LLP Staff Accountant Tampa, FL 2000 – 2002

Education

MBA, Finance and Real Estate concentrations, University of Florida

Master’s of Taxation, University of Central Florida

Bachelor of Science, Accounting, Virginia Tech

Contact this candidate