INSTANT BALANCE SHEETS FOR EXCEL
Instant Balance Sheets provides 12 monthly linked balance sheet templates which always balance. You can quickly and easily create 12 month profit & loss schedules and cash flows (source and application of funds) which automates all the figures in your 12 monthly balance sheets.
Ideal for when you want to turn your monthly profit and loss forecasts or last 12 months data into monthly and year end balance sheets and cash flows.
Start by entering monthly inputs of Unit Volumes/Prices/Cost of Sales and Company Expenses (100 rows). There are quick and easy working capital and fixed capital templates provided.
The balance sheet templates balance by transferring changes that occur between successive monthly periods into the monthly cash flow schedule. The cash flow schedule tracks changes that take place within all twelve balance sheets and this calculates the balancing cash position at the end of each month. .
If you want to transform 12 month financials (historical or forecast) into neat income schedules and balance sheets to display to management, investors, lenders, banks, use Instant Balance Sheets for really quick results.
Instant Balance Sheets are delivered with separate Excel files A & B, plus a tutorial version. You can choose which application best suites your purposes (or both).
Version A provides a forward looking planning suite which accepts monthly unit volume forecasts, different product prices and cost of sales for the 12 month period and a monthly company expenses forecast. You can predict sales days outstanding, inventory levels and percentage of sales supporting receivables.
Version B provides an historical suite that converts unit sales, revenues and company expense data into monthly balance sheets and income schedules. The program calculates average price yield per product, average cost of sale, and monthly break even volumes. You can enter actual sales days outstanding, inventory levels and percentage of sales supporting receivables.
CURRENCY > You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel.
The delivered file is zipped. There are three separate excel files enclosed.
