FINANCIAL ANALYSIS

Success Stories

NEW MARKETING INITIATIVE 

Cost Benefit Analysis tool 

Insurance Agency 

Summary

The local insurance agency was considering a new complex marketing initiative and needed leadership buy-in to the project.  A customizable Cost Benefit Analysis (CBA) tool was created with built-in scenario testing for flexibility and a definitive answer.

 

Work Highlights

  • The Excel-based CBA created was made so that all steps along the way were included, had logical assumptions, and transparency

  • Scenarios were made to assess the range of possible outcomes

  • Each scenario could be adjusted to test "what if" situations that leadership wanted to see

  • Created a basic, easy to grasp metric of expense vs benefit at the item level to understand the profitability at the most granular level needed

  • The expected outcome was highlighted and transparently calculated

FINANCIAL PROJECTIONS 

Revenue Forecasting 

Financial Services Company  

Summary

The company was developing its financial outlook that required input from multiple teams and dozens of people.  By following a logical, event based process with easy tools, the teams were able to agree upon a good forecast for the following years.

 

Work Highlights

  • Projections made with logical, incremental style additions to the existing baseline

  • Tools created for "what if" scenarios based off of prior year results and new initiatives being implemented

  • Forecasts were made where individuals could input their estimates and have it automatically roll up to a total amount

  • Individual and total projections were automatically pulled and updated in a report for leadership

HIRING A NEW EMPLOYEE 

Decision Tool 

Insurance Agency 

Summary

Given a desire to expand, the insurance agency was considering hiring a new employee to help grow the business.  A customizable, automatically updating tool was created to help determine how beneficial hiring a new employee would be to the company based on scenarios of the potential employee's performance.

 

Work Highlights

  • Significantly improved the online template that was found by the agency from Facebook

  • Created an Excel-based grid-style scenario tool that gave outcomes based on the potential employee's performance

  • All inputs and display metrics were adjustable and changes automatically updated the scenario grid

  • No coding or Excel knowledge was needed for the end user

FINANCIAL PLANNING TOOL 

Client facing investment summary 

Financial Advisor 

Summary

Wanting to broaden out from standard investment projection tools, we were able to help the financial advisor by creating a tool that had customizability in all key metrics and inputs while adding a clear, easy to understand summary that was presented to their clients.

 

Work Highlights

  • Offered a unique and customizable Excel-based solution to present a new investment strategy to their clients with a simple summary

  • Built a tool that was in the advisor's mind, but didn't have the time to functionally piece together in Excel

  • Fully changeable set of inputs adjustable for each individual client

  • Transparently displayed the "behind the scenes" work in case they wanted to dive deeper into the math

Every big decision could use a Cost Benefit Analysis to make sure it's the right move.

Think you could be the next success story? 

We hope so too.

 

The first meeting is always free!

Book an appointment with Jack or

reach out to us and we'll get back to you asap!

 
Subscribe to Our Newsletter
  • LinkedIn
  • Facebook
  • YouTube

Based in Charlotte, NC

© 2020 Pineapple Consulting Firm