Business Financial Plans Screen Shots

Start by creating your monthly budgets for years 1–3. We explain how you can apply Excel tools to hide unwanted rows containing blank (zero) values to create a neat spreadsheet presentation using your Landscape Print setting control.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. Index of pages and spreadsheets:

The 10 year plan templates provide an ultra quick way to generate a ten year forecasts. Combining with three Loan Note repayment tables, year end declining loan balances and annual interest payable for loan financings are transferred directly into your ten year summary presentation.

Start with Assumptions, which you can vary and optimize:

Easy directions – no accounting knowledge is required

Prepare yearly sales and expenses forecasts: (Expense rows are lower down on this page)

You can use open up to fully extended spreadsheets or Hide all unwanted rows

Generate the 10 Year Summary – it all takes less than 30minutes

Hiding unwanted rows gives neater presentations

You can achieve the following: With a few simple entries into the 5 years monthly budget planner spreadsheets, generate monthly five year balance sheets, profit & loss schedules and cash flow tables. Vary any unit volume monthly forecast, price and cost of sales and instantly recalculate the monthly and profit & loss forecasts, balance sheets, month end closing cash balances. Instantly calculate all key operating ratios.Instantly calculate times covered quick working capital and inventory levels above or below credit facility covenants or agreed credit limits.Review the five year plan in one easy report that contains the income forecast, balance sheets and cash flows (source and application of finance).No accounting knowledge is required. Back To: Business Financial Plans Start

Quick Five Year Financial Plans Plus Ratios $139.95 Payment Problems/Options OR, Buy as Part of All Excel Templates Gold Edition. 80% Discount!

Special ! Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Templates

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