Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Quick Five Year Financial Plans Plus Ratios Screen Shots

Quick Five Year Financial Plans Plus Ratios: Business Financial Plans Start

Business Financial Plans Screen Shots

Start by creating your monthly budgets for years 13. 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:

Index of pages and spreadsheets 1

Index of pages and spreadsheets 2

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: (Click on each image to enlarge)

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 $169.95 $69.95 Secure Payment Options
Buy as part of All Excel Templates Gold Edition -
HUGE Value - 80% Discount!

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

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