Biotech financial and life cycle modelling with Excel

We have recently done a number of biotech financial and life cycle modelling with Excel. Initially the models were simple financial models with the biological factors only included in the working capital. The only difference between other businesses and, for example, an agricultural business, was how long your money sat in ‘inventory’ and the risks of all or nothing losses.

However, recently the model requests have become more sophisticated and included modelling the life cycle development of particular biological products, and the financing impact with long lead times.

Fish Farm Financial Modelling

Biotech financial and life cycle modelling with Excel

Detailed life cycle model assessing the biology of fish growth from fingerlings to grow out, optimising batches and producing detailed forecasts of the financials.

All aspects needed to be included i.e.

  • growth rates at various stages,
  • feed requirements,
  • mortality, and
  • tank movements.
Fish Farm Financial Modelling

Included was a requirement on the capex (read tanks) required to achieve stated goals within the known biological constraints with regards densities.

Also included was modelling the optimal batching of production given capex constraints to maximise production.

Biotech financial and life cycle modelling with Excel

All this needed to be included in a monthly financial model to assess viability of the project including key risks and sensitivities. The fish farm model is able to forecast the annual harvest which drives the financial statements and results in a (hopefully) favorable NPV and IRR based on the investment required.

If you need any biotech financial and life cycle modelling with Excel contact us at info@AuditExcel.co.za .

Yield evaluation Excel models on specific crops

Modelling various crop yields over time taking in initial growth stage, most productive periods and gradual declines to plan planting forecasts and impact on financials. Depending on the crop, the maximised yield periods differed.

Crop Yield Financial Model

If you need any biotech financial and life cycle modelling with Excel contact us at info@AuditExcel.co.za .

Financial evaluation of mixed dryland, irrigated and grazing

Model reviews of templates built to assess a mix of biological products and the likely return for financing requests.

Packaging requirements on seasonal crops

Assisting with the planning of the packaging requirements given various international orders for different packing sizes and grades. Included assessing likely yields based on the most recent information, forecasting packaging requirements and placing orders given lead times and percentage likelihood.

If you need any biotech financial and life cycle modelling with Excel contact us at info@AuditExcel.co.za .