Loren Mckim Email & Phone Number

Using Excel, built dynamic financial model for the CFO that included pivot tables and vlookups for forecasting six phase-in periods, allowing variables for start dates, phase length, and manpower. Using Excel and Cognos, provided quarterly and annual analysis of P&L and Balance Sheet, calculated Forex positions, built financial models to include pivot tables and macros, and provided recommendations to manufacturing company; provided research and recommendations to management through PowerPoint; provided mortgage loan analysis to large regional bank using proprietary software and Excel. Created web site for non-profit organization.Using Excel, built dynamic financial models for home builders of current inventory by age, cost, and location. Provide analysis of Operations and Sales, resulting in increased sales by more than 25%, and inventory reduction by more than 50% within one month.Key Achievements:• Assisted company with its IPO resulting in the company going public 6 months earlier than planned.• Assisted company with its Sales Plan resulting in increasing revenue in the first month by $3 million.

Delivered to C-level executives and other senior manager the daily, monthly and quarterly financial analysis and variance reports of operations on more than six million accounts worth over $1 billion. Created various intricate financial models in Excel to analyze and forecast cash flow, ROI, and manpower planning. Created scorecards to track monthly production. Created and maintained Budget and Cost Data. Analyzed and calculated commissions of sales teams. Led effort to create complex, extensive models for strategic planning of staff.Key Achievements:• Increased revenue more than $250K by creating a staffing plan to smooth workflow which removed bottlenecks and increased efficiency within a department.• Created savings of $150K by reducing manpower with a new method to track portfolio performance.

Marlton, Nj, Us

Provided contractor onsite support and guidance to US Air Force. Managed $500 million in 1,000 grants. Identified monthly financial variances to Secretary of Defense using both Excel and Oracle’s Discoverer databases. Provided monthly budget analyses to senior management and to Congress.

Master Of Business Administration (M.B.A.), Business Management

Bachelor Of Arts, Finance And Business Management