Small Business Cash Flow Model
Originally published: 11/04/2020 08:59
Publication number: ELQ-95515-1
View all versions & Certificate
certified

Small Business Cash Flow Model

A daily cash flow model for small businesses, in Microsoft Excel.

Description
This is a highly tunable, daily cash flow model for the post Covid-19 era. The model is designed to be highly intuitive to use with navigation buttons and the ability to jump ahead and back several screens in a manner similar to what you would find in a web-based application. The model can be sensitized for adjustments or deferrals in payroll expense, payroll-related taxes, rent expense and many additional expenses, including both recurring and one-time expenses. The model is designed to auto-accrue any deferrals and therefore doesn't require any manual 'true-ups' to present the real-world scenarios.

The model also auto-estimates the paycheck protection program (ppp) loan for a small business and allows small business owners and advisors to small businesses to efficiently model existing and new debt agreements as well as equity issuances in the future.

Lastly, the model allows small business owners and advisors to small businesses to see daily cash flows until the end of August. By simply adjusting the month, the model auto-updates not only the dates and days (so you can see exactly what the expected cash balance is on a specific day) but also brings back the expected ending cash balance for each day.

This Best Practice includes
1 excel model

Acquire business license for $19.00

Add to cart

Add to bookmarks

Discuss

Further information

To allow small businesses and advisors to small businesses to effectively forecast daily cash flows.

Most suitable for those with moderate proficiency in excel.

Not suitable for valuing small businesses


0.0 / 5 (0 votes)

please wait...