Microsoft Office Tutorials and References
In Depth Information
Important Tools for Any Business
Accounts Payable to Net Sales
(Accounts Payable*Days in Period)/(Net Sales*Days in Year )
Accounts Payable to Net Sales indicates the size of a company’s accounts payable relative to
its sales revenue for the period on an annualized basis.
Total Liabilities to Net Worth
Total Liabilities to Net Worth indicates the size of a company’s total liabilities relative to its
net worth as of the report date.
Net Worth to Total Liabilities
Net Worth to Total Liabilities indicates the size of a company’s total net worth relative to its
total liabilities as of the report date.
At times you’ll have to schedule and manage resource pools. There are several ways to do
this. This resource pool takes into account international employee rates converted to US
dollar rates and applies the rates to a schedule that forecasts resource allocation over time,
per employee. By using VLOOKUP to lookup the rate of the employee, the IF and AND functions
as well as the SUBTOTAL function, you can create effective time-management tools for
scheduling out people. First, establish a rate sheet. The example in Figure 2.25 shows the Canadian
rates of the employees converted to US currency.
Establish the employee
table from which to
reference the dollar