Instant Balance Sheets creates 12 monthly balance sheets which always balance, as well as automating production of 12 month profit & loss schedules and cash flows (source and application of funds) Starting with a simple revenue and expense template. Ideal for transforming monthly profit and loss forecasts into monthly and year end balance sheets and cash flows.
INSTANT BALANCE SHEETS FOR EXCEL
Balance sheets and cash flow schedules are created using Excel 3-D
links. 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 to drive the monthly balance sheets and cash flow calculations.
The balance sheet templates always balance Total Assets with Total Liabilities plus Shareholder Equity by transferring all balance sheet changes that occur between successive monthly periods into a cash flow schedule. The cash flow schedule calculates the total value of changes that take place within any month's balance sheet and this produces a balancing cash position at the end of each month. The monthly closing cash position is posted back into the monthly balance sheet, balancing assets and liabilities. The balancing is done for you, and you have no need for any accounting knowledge to take advantage of the automatic self balancing schedules.
If you want to transform 12 month financials (historical or forecast) into neat income schedules and balance sheets to show 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
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Try out; Invoice Template | Investment and Business Valuation Templates | Multiple Regression Analysis & Forecasting Template | Portfolio Optimization Template | Portfolio Tracking & Monitoring Templates | Project Planning & Management Template | Real Option Valuation Template | XLS Converter | AnalyzerXL | DownloaderXL | SmartVBA | TraderXL Pro (best Value)| Excel PivotTable Gear | Pivot4U | Workbook Splitter | Merge Excel Files | XL Fusion | Find Replace Excel | ConsolidateXL | MORE>>
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft