BARATELLIOne firm. One platform. Every market.
BARATELLIOne firm. One platform. Every market.
The working Excel models behind the exhibits in the three volumes. Each one carries the Northgate numbers from the book, so you can trace every figure, then overwrite the blue inputs with your own company’s. Free to download, no sign-up.
The model behind Exhibits 30.6 and 30.7: receipts and disbursements by line, net cash flow, the weekly revolver sweep, the borrowing base roll, availability and liquidity against the floor. It also carries the Week 1 variance report (Exhibit 30.8), the collection curve (Exhibit 30.4) and a change log.
Tabs: Read Me · Assumptions · 13-Week Summary · Borrowing Base · Variance Week 1 · Collection Curve · Change Log
Yellow cells hold opening balances and policy settings. Blue numbers are inputs: your aging, pay calendar and AP schedule. Black numbers are formulas and green numbers link from another tab, so the model recalculates the moment an input changes. Northgate is the fictional sample company that runs through all three volumes.
Baratelli CPA & Accounting builds and maintains the monthly package, the 13-week forecast and the lender reporting in Baratelli Bankable, reviewed by a US CPA.
Work with the firm →Educational reference. Not legal, tax or investment advice. Northgate and its figures are illustrative. © 2026 The Baratelli Institute.