Financial Consultant Job Opportunities In Los Angeles. Project Clients Past Employers. Toyota Financial Services 1. B division of Toyota Motor Corporation, largest US captive auto finance company offering financing and insurance products to dealers and their customersHD Supply White Cap 7. This topic describes features that have been removed, or that are planned for removal from Microsoft Dynamics 365 for Finance and Operations, Enterprise edition. B division of HD Supply Holdings Inc., a supplier of construction and industrial equipmentOn Assignment, Inc. B staffing company in the technology, life sciences, and creative sectorsRobertson Properties Group 4. M division of Decurion Corporation, a diversified entertainment company with assets in the commercial real estate and movie theater industriesCIM Group, Inc. Private Funds real estate and infrastructure fund management companyMemorial Hospital of Gardena segment of Avanti Hospitals, a privately held hospital acquisition and management companyOptimus Properties LLC private equity owned real estate investment and development companyProperty Management Associates LLC privately held real estate management companyUnited States Census Bureau federal government agency producing statistical population dataFunctional Finance Accounting Experience. Financial Reporting General Accounting. Hands on and supervisory divisional management experience over numerous senior accountants and accounting clerks AR, AP, Payroll. Supervisory experience included all aspects of staff development in a decentralized environment of rapid acquisition integration and staffing changes. Directed and participated in monthly, quarterly, and year end closing process within multiple companies, assuring the accuracy of data and integrity of reporting in accordance with Generally Accepted Accounting Principles GAAP or Other Comprehensive Basis of Accounting OCBOA. Prepared monthly and annual financial statements, including income statement, balance sheet, cash flow statement, statement of equity, and footnote disclosures at corporate and fund levels. Developed internal monthly reporting packages capturing a wide variety of financial performance metrics, ratios, and presentation styles adapted to the issues, people, and businesses involved. Prepared and reviewed quarterly management presentations on behalf of the CFO and the Board of Directors. Reviewed results, analyzed and explained major variances to budget and year over year actuals, and made recommendations for corrective actions in various companies. Developed standardized audit ready balance sheet sub ledgers and supporting schedules including fixed asset rollforwards, floor plan reconciliations, deferred rent schedules, AR, prepaid assets, investments and swaps, current and long term debt, and other accrued expenses. Verified these supporting schedules tied to the GL and were consistent with GAAP. Functioned as the principal liaison with external and internal auditors in various companies. Coordinated and supervised preparation and completion of year end financial audit schedules and quarterly loan covenant compliance reporting for a variety of organizations and entities. Improved month end close procedures to reduce closing time from seven days to five days in a mature accounting environment. Reviewed, corrected and improved upon dozens of balance sheet accounts in preparation for year end, using GL account reconciliations software. Performed hundreds of journal entry corrections to ensure financial statements were GAAP compliant as of year end. Reconciled 2. 8 out of balance cash accounts for a private, for profit hospital from disorganized files of invoices, bank statements, credit card statements, contracts, checks, and receipts, including a multi million dollar payroll account corrected by a lt 1,0. Technical Accounting External Reporting. Responsible for ensuring GAAPFASB compliance, including application andor research of several technical areas, including operating vs. ASC 8. 40 Leases, consolidations ASC 8. Consolidations and revenue recognition ASC 6. Revenue Recognition. Prepared reporting of straight line rent adjustments in accordance with FAS 1. Calculated SFAS 1. Analyzed and journalized complex real estate transactions, including acquisitions, dispositions, partnership dissolutions, 1. FAS 1. 41. R. Experience researching financial accounting topics and making recommendations on GAAP compliance, including position papers. Achieved cost savings of over 1. K in reduced Delaware franchise tax liability for a publicly traded 2. B staffing company over a two year period upon discovering an alternative equity reporting method resulting in more favorable tax treatment. Financial Audit, Internal Controls Sarbanes Oxley Compliance. Participated actively in SOX 4. Collaborated with department managers to develop and maintain control matrices and process narratives, identifying significant control deficiencies and material weaknesses for resolution. Documented accounting processes and procedures in the form of manuals, policies, desk procedures, and standard forms in three different pre SOX control environments. Created process flowcharts for wholesale lending business, visually depicting transaction flow between the point of sale systems, the general ledger ERP system, and the reporting platform. Provided detailed description of inputs, outputs, and system logic at each decision point. Developed month end and year end close checklists to ensure that the balance sheet accounts were consistently and systematically updated according to company policy and GAAP, and that stringent timelines were met. Excel Dashboard Templates KPIs Reports Software. Mr Dashboard is the largest network of business managers and professionals focused on business improvement. Implemented improvements to the AR, AP, treasury, and capital expenditure approval processes, which included more frequent sub ledger monitoring and reconciliation, development of communication protocols for capital investments and unusual transactions, and enhanced documentation of signoffs. Financial Planning Analysis. Hands on and supervisory experience preparing annual operating plans, annual budgets, and quarterly forecasts in collaborative settings for multiple companies. Presented financial measurements in formal settings in dozens of different situations. Rewrote budget policies and procedures as part of the annual budgeting cycle to accommodate significant organizational changes in the finance department. Developed budgeting and reporting templates for privately held hospital as part of RFP package and ongoing compliance to qualify for and maintain grant funding from First 5 LA program. Prepared long and short term capital expenditure plans up to 2. M annual spend for multiple real estate companies, tracked construction spending and progress, and capitalized project costs. Assets purchasedconstructed included land, buildings, leasehold improvements, machinery and equipment, furniture and fixtures, trademarks, and other intangibles such as goodwill. Financial Modeling. Extensive experience building, improving and refining budget, planning, analytical, valuation, personnel, and other types of financial models in various companies. Weve compiled 22 free, downloadable dashboard templates including marketing, executive, and financial dashboard examples. Human Resources KPI Scorecard how to create a HR KPI dashboard using typical hr performance metrics and custom Excel gauges Systems Expertise Selected Detail. Microsoft Excel. Proficient Excel User including formula building, macro creationmodification, graphing presentations charts. Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. Developed models for calculating annual common area maintenance CAM, property tax, and insurance reconciliations used for tenant billing and revenue forecasts under NNN retail leases. Torrent Download Aerosmith Songs. Completed a variety of financial models for a privately held real estate investment fund manager, including a purchase analysis model forecasting discounted future cash flows, capitalization rate, gross rent multiplier, cash on cash return, debt coverage ratio, ROI, ROC, and other key metrics based on market rents, holding period, and debt assumptions, and a sales analysis model forecasting deal profitability, management fees, and corresponding investor net profit and loss allocations based on current financial performance and future assumptions. HR software should be an allinone solution, or nearly that, for a small business owners HR needs. Here we look at 3 top choices for small businesses.