From the monthly archives: September 2013

Financial Forecasting Tool for a Silicon Valley Startup

Financial Forecasting Tool for a Silicon Valley Startup

GreatSoft, Inc. is a hi-tech company based in Silicon Valley. The company’s operations were growing and wanted to track the cash flows. The CFO of the company wanted to project future cash requirements to de-risk the company and forecast funding needs.

A comprehensive financial model with revenue model, hiring, and various cost assumptions was built. The model performed scenario analysis at various levels of sales and inventories to estimate liquidity position.

The tool enabled the client to deliver insights to the management helping it to make strategic decisions faster and with greater reliability. Management was able to perform what-if analysis and analyze a number of scenarios. This saved precious management time.

Check out the compact form of case study!

Perceptive Analytics download case study

one login 640

Financial Modeling to Raise Capital

Insta Variety is in the business of providing cloud based identity and access management solutions. They needed a financial model to present to investors in order to raise capital.

We built a financial model that seamlessly integrated the historical figures and the forecast. Cash flows under various alternatives were projected to effectively demonstrate the prospects of the business to the investors.

With the help of the model the client was able to effectively demonstrate strength of the business to investors. The client could negotiate to give away just as much equity as necessary. Investors used the model and conducted a what-if analysis to view the various business scenarios and were convinced of the strength of the business. A deal was made and foundations for a healthy partnership were laid.

Check out the compact form of case study!

Perceptive Analytics download case study

Tagged with:
 

lights 640

Excel Application for Street Lighting Design

CLASP is an international non-profit organization striving to improve environmental and energy performance of appliances and related systems. It provides an online tool to calculate street light design parameters. The client wanted to update this tool to add more flexibility in terms of an additional method of calculation, VBA implementation of the formulas and greater choice of selection parameters.

We revamped the tool with VBA macros and implemented an additional method of calculating design parameters. The updated tool involves complex scientific calculations to obtain the results and provides more criteria to facilitate analysis. We have also improved the design of the tool for better user experience.

The upgraded tool equips the users with more options for designing the street lighting. The additional method of calculation provides greater insight into the design choice. It also provides better visual experience in terms of illustration as the users choose various configurations.

Check out the solution we provided!

Perceptive Analytics download case study

Tagged with:
 

pilot 640

Employee Training Dashboard

Heli, Inc. is a helicopter services provider based in Canada. The company’s pilots undergo a number of trainings at regular intervals. The Operations Manager of the company wanted an automated way to monitor and track the training activity of the pilots.

A comprehensive application with built-in automation for streamlining the pilot training process was built. It includes an intuitive dashboard, which offers a one-glance depiction of current training status for each of the pilots. An easy-to-use interface facilitates updation of training activity details, and pilot information. The application also sends email notifications automatically to the pilots as and when trainings are due.

The tool provided the client an easy way to monitor and track the training activity of the pilots so that trainings are scheduled and conducted on time. This greatly increased operational efficiency of the client apart from the timely compliance with the safety standards and regulations.

Check out the solution we provided!

Perceptive Analytics download case study

Tagged with: