|
INVOICE PROFITABILITY CALCULATOR PLATINUM EDITION
Platinum Edition Welcome Worksheet: This represents the first Worksheet of the IPC product. This Worksheet contains both General and Detailed Information for the entire IPC product. This particular Worksheet has a Getting Started Section, Customer and Invoice Buyer Input Section, a Profitability Analysis Reporting Section, an Internet Links Section which contains a form to Apply for Financing the Best Customer Invoices , a What to do Next Section, a Frequently Asked Questions Section, and a Help Section that includes a complete Help Manual on "How to use the IPC product." Customer Input Worksheet: This represents the second Worksheet of the IPC product. This Worksheet contains a form where the user is expected to Input the Company's Financial Information and Invoice Data pertaining to a single Customer. Initially, the Customer should be the Best Customer of the business. The required data fields include the Name of the Company, the Revenue of the entire Company, the Name of their Best Customer, the Sales Revenue of their Best Customer, the Variable Cost (Cost of Goods Sold) associated with their Best Customer, the Fixed Cost (Plant, Equipment, G&A) allocated to their Best Customer, Company Growth Rate Parameters (Sales Growth Rate and Overhead Growth Rate are separate parameters) for both what the Company's Best Customer expects to grow next year and how much could they grow if they had more Working Capital, the Average Invoice Size of their Best Customer, and the Working Capital Investment Period (this represents both Pre and Post Invoice Periods). Multi-Customer Input Worksheet: This represents the third Worksheet of the IPC product. This is where the Company can input the same information described in the Customer Input Worksheet for multiple Customers of the business. The user can Copy any if the Individual Customers to the Customer Input Worksheet for analysis, or the user can use the Composite Average of all of the Individual Customers to the Customer Input Worksheet for analysis. With this flexibility the user can quickly ascertain which customers provide the most profitability for the business. Additionally, if a business needs to the profitability to a desired amount, the user can add Individual Customers until the target profitability had been achieved. Invoice Buyer Input Worksheet: This represents the fourth Worksheet of the IPC product. This Worksheet contains a form where the user is expected to Input the Invoice Buyer's Discount Data associated with purchasing the Best Customer's Invoices. The required Invoice Buyer's data fields include a choice of a Fixed or a Variable (2 tier) Discount Percentage, Invoice Advance payment Percentage, and Delays in receiving the Advance and Rebate payments. Note: The initial Discount Percentage is usually set higher initially and modified later when the actual schedule is known. Profitability Analysis Worksheet: This represents the fifth Worksheet of the IPC product. The Profitability Analysis compares two different business Strategies. Strategy 1 represents the current Working Capital financial investment strategy, and Strategy 2 represents the Sell the Invoices at Discount to finance Working Capital strategy. The pro forma Financial Statements compares the two strategies. These financial statements include a Financial Summary, Income Statement (Working Capital Investment and Standard Accounting Practice Views), Balance Sheet, and a Cash Flow Analysis. Invoice Testing Worksheet: This represents the sixth Worksheet of the IPC product. This is where a a user can Back Test a single Customer Invoice stream over a period of time - typically a month, or an user can Track Invoice payments as they are received from the Invoice Buyer. Back Testing of a single Customer's past Invoices can quickly provide insight for the user to realize the real value of that "Sheet of Paper" called an Invoice. The Back Testing Profitability results are summarized at the top of the Worksheet. Likewise, the user can Track Invoices as they are received from the Invoice Buyer for a single Customer. This tracking of a single Customer Invoices is only done for no more than a 3 month period, or until the user is satisfied the pro forma Profitability Analysis has been confirmed. The running total Forward Testing Profitability results are summarized the at top of the Worksheet. |
P.O. Box 209, Morrisville, PA 19067-0209
Phone (215) 736-1107 Fax: (215) 736-0268