In order to successfully create the R-Series Report, you will need to gather and/or create the following client financial information:
(i.e. A/R, Inventory, A/P, Accrued Pay, Debt Repayment)
(see R Series template for select ratios)
You can easily obtain historical and YTD financial statements if you use an accounting system such as PeachTree, QuickBooks or Great Plains. You will want to use averages for balance sheet accounts such as Accounts Receivable, Accounts Payable and Inventory when computing financial ratios. Use the average of the beginning and ending values for such accounts for a given period.
Someone in accounting, preferably a person who has access to the most current financial statements and who is well versed with creating/modifying graphs in Excel, such as the Controller or Accounting Manager.