Tag: Accounts Receivable
Financial models which focus on the analysis of accounts receivable
Payable and Receivable Tracking (Google Sheets)
This is a Google Sheets version of the financial model template for tracking accounts payable and accounts receivable
Cash Flow Projection Model
To analyse where the cash is coming from and going out, cash flow statements are prepared. It has three main categories – operating cash flow which includes day-to-day transactions, investing cash flow which includes transactions…
Annual Sales Planning – Actual Vs. Goal
Track the annual value of your contracts based on YTD billings and current year remaining billings.
Business Plan and Valuation of Retail Store
The purpose is to calculate, compare, and apply different theories of corporate valuation in order to assess their equivalence by using as a platform the retail store company Jumbo S.A. (a retail company in the…
3 Statement Modeling + Valuation
This detailed, yet easy to use three statement financial model will allow you to calculate your business' profit and loss, build a balance sheet and calculate cash flow. Additionally it will calculate the valuation of…
Sales Pipeline Planning for Enterprise Client Base
Build a cohort of enterprise clients with varying probabilities of renewal and see what the revenue looks like over multiple scenarios.
Accounts Payable Template | Receivable | Tracking
A simple template to keep track of the amount of money you owe other companies and how much other companies owe you.
Bad Debt Reserve Calculator
Spreadsheet to calculate general accounts receivable reserve based on a percentage as well as adding in specific reserves for clients. Should be updated monthly to determine if you have enough AR reserve on the books.