|
INVOICE PROFITABILITY CALCULATOR SILVER EDITION
Silver 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). Invoice Buyer Input Worksheet: This represents the third 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 fourth 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 |
P.O. Box 209, Morrisville, PA 19067-0209
Phone (215) 736-1107 Fax: (215) 736-0268