Financials - Other Excel Sheets
The following are some of the other types of help provided to its clients by BBA.
These include the use of Excel to create a range of different types of templates and other types of projections.
Problem: for a proposed minigolf, create simple Cash Flow, Breakeven and Startup Budget templates.
Solution: produce a simple template for identified costs. Work with the client to identify and group costs.
Problem: a joint US / Israeli energy biotech company, EB Clean Energy, wanted to set up a European entity including a joint Israeli / US / European energy research center with a University in the Czech Republic. The university had major undergraduate and graduate programs in the related fields and in particular for municipal solid waste (MSW) conversion technologies and fossil coal power plants where the new MSW fuel would be a non-coal replacement option. To meet with an interested investor for the construction of a pilot plant ($12-15 million), the client wanted to create a simple template for sources and uses of funds for two periods (years 1-2 (total), years 3-5 (annual)) and look at a high, low and average set of projection numbers.
Solution: produce a simple template.
Problem: as discussed above and in working with an investor, EB Clean Energy wanted to look at the costs for a new company, EB Clean Energy Europe (EBC-E) wanted to have an idea of the total recurring and non-recurring costs involved in setting up a new office and research facility.
Solution: produce a simple budget with the ability to identify monthly cost modules for each category of expenses and then have the ability to increase and decrease the number of cost modules for the given time periods - for year 1, these were the first 6 months and the next 6 months.
The result was almost $ 1 million in non-recurring costs for year 1, which would not exist in following years. There was just under $ 700 thousand or recurring costs in year 1. Thus, the initial capital raise was just under $ 1.7 million for this part of the project. The investment in a pilot plant were separate.
Problem: in relation to the above work for EBC, the client, in setting up a new company, EBC-E, was going to be bringing in an investor(s) for both pilot plants (to test each particular municipal solid waste (MSW) stream to be used as fuel) and production plants. Each type of plant generated a different income streams for the client, the seller of the technology. Also, the client wanted to be able to vary the mix, volume and timing of sales of each type of plant and the fees and charges.
Solution: The model shown is in two parts.
Part 1, projects the income to be generated by each type of plant sale and by income timeframe.
-
For pilot plants, EBC-E would receive an allocation for overhead and a fee for supervision and coordination of construction and plant startup.
-
For combines production plants, which would torrefy MSW and sell the power produced, EBC-E would receive a project fee, construction supervision fee, service fee and production royalty fee.
Part 2, uses the numbers from Part 1 to make projections of total income based on plant sales inputs.
Problem: EB5 is a special US immigration program granting green cards to investors. The basic program requires between $500,000 and $1 million invested along with the creation of at least 10 jobs. A real estate developer was looking for investors into a 5-year Working Capital Fund.
Solution: We took a current development project and extrapolated out the job creation data for an EB5 presentation.
Problem: The client had proposed the sale of a used mini-golf, with all payments upfront; thus a capital budget item for a buyer. We suggested they try selling the mini-golf as an operating expense item through a lease-to-own.
Solution: The model include options to offer a discount factor; 3-6 year leases with an increase in total cost for 4-6 year leases as another variable input.
Problem: As part of a pre-seed funding round, the client had already seen very strong investor interest; and, the company was already profitable. It was a $600,000 round.
Solution: BBA created an approach and model to provide an equity kicker without giving up any equity.
I'm a paragraph. Click here to add your own text and edit me. It's easy.