ARTICLE

The ideas behind the reports, worked through

Latest

Management reporting and FP&A

How to lay out a monthly report, budget variances, year to date against the full-year forecast, the cash conversion cycle and rolling forecasts, each worked through with figures from the same sample workbooks as the report guides.

Where the article figures come from

Every figure is computed when the site is built, from the same synthetic dataset as reports 01–07; none is typed in. The one exception is the working capital simulator example in the cash cycle article, which uses the report 09 model and says so where it appears.

Excel, Power Query and Power BI for reporting

Excel updates for finance work

Excel for investors

Using Excel to screen stocks with tests you can check. The worked examples are fictional companies from the stock-screener template and do not come from the report guides' workbooks.

Dividend stocks

Every report's Excel workbook is free to download, in Thai and English.