INSTANT BALANCE SHEETS FOR EXCEL 2008

How to make balance sheets with 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.

bal1.jpg (316968 bytes)

System Requirements

Requires: Excel 97 or later. Web data requires Excel 2000 or later and Windows XP/2000/2003 or later.

Order

Excel Templates - Financial Excel All Programs Complete Edition contains all our Excel templates listed in the table above: financial analysis Excel templates, business valuation, financial accounting, business planning, cash flow, lease/purchase, real estate & loan management, budgeting, business financial plan workbooks, templates and guides, 30 separate add-ins and templates for Excel.

'Complete Excel Templates 2008 Edition' - our most powerful financial product. It contains also our additional products: Excel Add-ins Collection, Complete Excel Training Bible, and 12 months full membership of our Global Business Community Network. Save a total $2,400.

If you have Excel 2007 and want to promote your business, you can purchase the spreadsheets with over 10 million sales contacts and addresses sorted in to 51 States.

You will be able to download the product immediately after ordering! Additionally, you can receive the CD.

30-day money back guarantee!

Excel Templates - Complete Excel Templates 2008 Edition
Complete Excel Templates 2008 Collection Buy Online  $339.00
Excel Financial All Programs Complete Set Buy Online  $229.95
INSTANT BALANCE SHEETS FOR EXCEL Buy Online  $125.95

 

Excel templates, Spreadsheets