We are a small product business. We do our business forecasting in a software programme called Brixx which we find very intuitive. Brixx forecasts cashflow which also feeds into a P&L and Balance Sheet. It is possible to download into Excel but the download contains values only, no formulas. We have been asked to provide the same forecast in Excel in order to test the forecasts through various potential scenarios.
Anyone who takes on this job would need a reasonable knowledge of accountancy/business finance in order to understand how the cashflow feeds into the P&L and Balance Sheet.