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.
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.
Instant Balance Sheets is designed for business managers developing financial forecasts, who require a quick and easy way to transform basic profit and loss spreadsheets into monthly balance sheets and cash flow schedules to present to their managers, bankers or investors.
With Instant Balance Sheets Total assets always balance Total liabilities.
The cash flow schedule is linked to the balance sheet template and it monitors changes within each month's balance sheet, adjusting the forecast cash position at the end of each month to compensate for changes in working capital, fixed asset purchases, loans and investments. Monthly closing cash balance is posted back into the respective balance sheet, balancing assets and liabilities automatically.
System Requirements:
Platform : Windows XP/Me/9x/NT/2000/2003 or Mac OS.
Web Data Requires: Excel 2000 or later and MS Windows XP/2000/2003 or later.
Check Discount]
Instant Balance Sheets Excel Templates