Tag: Accounting

Financial accounting forms the basis for any financial model or business valuation

Key logic designed to forecast cash flow up to 10 years for a fitness center that has recurring monthly fees.

The purpose of this model is to provide a simple way to show the below summary by month for many companies in one file -Income statement -Balance sheet -Cash flow statement -Financial ratio -Charts and…

Compare fixed and variable legs of an interest rate swap.

Straight forward way for a manufacturing business to see cost per unit and define margins in order to see suggesting selling prices per unit.

This monthly budget-to-actual dashboard allows for at-a-glance performance analysis. In addition to analyzing YTD performance, it also provides a revised forecast for the year based on actual performance to date and budgeted performance for the…

Ever wondered how much you need to charge in order to offer insurance on a given product or service? You will know how much after using this tool.

The user has the ability to enter inventory movements, track it in a clean database based on macro input, and then query this to see average cost, net count, net value on date ranges as…

A simple way to measure your projections by month against what you actually did. Includes visual variance analysis. Goes out 3 years.

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.