Bailment Dealer Details - Financial Data Tab

Purpose

Facilitates the input of Financial Details supplied by a Bailment Dealer.

Ratios are then calculated and evaluated to assist in determining the Credit Limits and Status that will be applied to the Bailment Dealer

Access

1. Bailment Dealer | Credit Management tab | Financial Data tab

Dialog Details

Details Specific Buttons

[Button]	Explanation
Main Tab	The following dialog will be displayed: Field Description Code A short unique alpha numeric quick key code for the financial data Description The name of the financial data item Period Ending Select from the date drop down the date up to which the financial data is valid Full Year Check this tick box if the financial data is for a full year, otherwise leave unchecked Notes Enter any notes that may useful for this set of financial data
Balance Sheet Tab	Enter Balance Sheet information from the set of financial accounts.  Care should be taken to enter financial data against the correct item to ensure ratios are calculated correctly. All values should be entered as positive unless there is an opposite sign from that expected.  For example, if profit and loss appropriation were a loss, that amount would be entered with a leading minus (-).  The Sign column will show the normal expected sign of the value. Values can be entered by clicking into the first value field, entering an amount and then down arrowing to the next field.  Continue until the Balance Sheet details have been completed.   A running total of assets and liabilities is maintained in the bottom section of the dialog.  To be correct the Total Assets must equal the Total Liabilities plus Total Equity.  If this is not correct the difference will be shown in the Checksum field in red as follows:
Profit and Loss Tab	Enter into this Tab Profit and Loss information from the set of financial accounts.  Care should be taken to enter financial data against the correct item to ensure ratios are calculated correctly. All values should be entered as positive unless there is an opposite sign from that expected.  For example, if taxation were a refund, that amount would be entered with a leading minus (-).  The Sign column will show the normal expected sign of the value. Values can be entered by clicking into the first value field, entering an amount and then down arrowing to the next field.  Continue until the Profit and Loss details have been completed.   The totals of Gross Profit < Net Profit Before Tax and Net Profit After Tax are displayed in the bottom section of the dialog.  These amounts should be compared to the set of financial statements being loaded from to ensure accuracy of input.
Ratios	This is a display only dialog It shows immediately after input of the Balance Sheet and Profit and Loss dialogs a number of calculated ratios.  These can be reviewed for reasonableness as a further test against the accuracy of data entry. Field Calculation Current Current Assets / Total Current Liabilities Quick (Cash at Bank / Total Current Liabilities) + ( Trade Debtors / Total Current Liabilities) Debt to Equity Total Liabilities / Total Assets Debt Coverage (Net Profit Before Tax – Interest Expense – Depreciation) / Non Current Liabilities COGS to Sales (Net Profit Before Tax – Interest Expense – Depreciation) / Total Non Current Liabilities Gross Profit Margin Cost of Goods Sold / Sales SG & A to Sales Operating Expenses / Sales  Net Profit Margin Net Profit before Tax / Sales Return on Equity Net Profit before Tax / Total Shareholder Funds Return on Assets Net Profit before Tax / Total Assets Days in Receivable Turnover (Trade Debtors / Sales) * 360 Sales to Total Assets Sales / Total Assets Inventory Cover (Net Profit before Tax – Interest Expense) / Interest Expense Sales Growth (Sales_n – Sales_n-1)/Sales_n-1 Accts Receivable Turnover Sales / ((Trade Debtors_n-1 + Trade Debtors_n) / 2) Days in Inventory (((Inventory_n-1 + Inventory_n) / 2) / Cost of Goods Sold) * 360 Inventory Turnover Cost of Goods Sold / ((Inventory_n-1 + Inventory_n) / 2 ) Days in Accts Payable (((Trade Creditors_n-1 + Trade Creditors_n) / 2) / Cost of Goods Sold ) * 360  Accts Payable Turnover Cost of Goods Sold / ((Trade Creditors_n-1 + Trade Creditors_n) / 2)
	Allows the editing of any of the Financial Data Details entered
	Allows the deleting of any of the Financial Data Details entered The following message will display:
	Prints the Balance, Profit and Loss and Ratios as a Preview Report

• Related Articles

• Bailment Dealer Details - Credit Management Tab

  Purpose Bailment Dealers are allocated credit limits that they are allowed to borrow up too. If assets are purchased that exceed the credit limit then those purchases will be rejected. Every Bailment Dealer will have a permanent limit. Some Bailment ...

• Bailment Dealer Details - Credit Review Tab

  Purpose The Credit Review process will be undertaken to determine what the Bailment Dealers’ Permanent and Temporary limits will be. Credit Reviews will normally be undertaken annually, but special reviews for a new dealer, or to set a temporary ...

• Bailment Dealer Details - Credit Status Tab

  Purpose To allow for the easy recognition of whether the Bailment Dealer is a potential Credit Risk. The latest Credit Status will be marked as Active. All earlier Credit Status will have a Record State of Archived. Access Bailment Dealer | Credit ...

• Bailment Dealer Details - Credit Facility Tab

  Purpose The Credit Facility tab presents a list of existing facilities and shows the Dealers’ Credit Limit, Utilised Credit, Releases and Available Credit for each Distributor. Access Bailment Dealer Details | Credit Management Tab | Credit Facility ...

• Bailment Dealer Details - Stock Audit Management Tab

  Purpose Allow the establishment of rules for the reporting of future Stock Audits due for Bailment Dealers Record the results of Stock Audits undertaken Access Bailment Dealer | Stock Audit Management Tab Dialog Details Audit Management Field ...