•  Home
 •  About
 •  Business Books

 •  Business Planning
 •  Charts
 •  Contact Us
 •  Downloads

 •  Excel Toys
 •  Functions
 •  Glossary
 •  Links
 •  Library
Product Catalog

 •  Tools
 •  Training
 •  Worksheets

 



(There is No Support For Free Downloads)

Want to have some fun? Here is a new way to create an Excel business analysis system that is customized just for you. How? You build it to your specifications from preconfigured modules.

All you do is open and save "mastertoy.xls" plus your module selections then add the modules to the "mastertoy.xls"    workbook one at a time.
It's really cool because all of the modules (toys) are automatically linked to "mastertoy.xls" for broadcasting throughout all of the imported modules. This means that after you build your system you only have to update the Master Data Entry worksheet.

In addition to our Free Training Section, this is great way to get better acquainted with  the power and flexibility of Excel and our systems.
 


DISCLAIMER

This is a very basic analysis system. It should not be confused with our products which are more accurate, advanced, powerful, and comprehensive. Most of the business data is outdated (2002) and should not be used for comparative analysis.

We do not recommend the use of this system if you are an accountant, business owner, startup entrepreneur, CFO, consultant, or any financial professional.

Think of this system as a learning exercise in business analysis concepts and using Excel to do it.


INSTRUCTIONS: Please follow these steps exactly and in order.

You use only one Excel feature - "Move or Copy . . . ".  for importing into "mastertoy.xls".

1. Using Windows Explorer, create a folder and name it "toys" (without the parentheses).

2. On this page, open and save "mastertoy.xls" to the toys folder.

3. Open and save all of your module choices to the toys folder.

4. Start Excel.

5. Always open  "mastertoy.xls" first.

6. Open a module.

7. Right click on the tab and choose "Move or Copy . . . "

8. In the "To Book" box, scroll and select mastertoy.xls.

9. In the "Before sheet box", scroll and select any location you desire.

10. Click OK.

NOTE: If there are more than one worksheet showing in a module, right click on any tab and choose "Select All Sheets" and repeat steps 7, 8, 9, and 10.

The numbers in parentheses are worksheets per module.
 

Modules

mastertoy.xls (7) (open and save first)
Contains:
1. Master Data Entry
2. Forecast Analysis
3. Financial Summary
4. Executive Summary
5. Comparative Income Statement
6. Comparative Balance Sheet
7. Cash Flow 4 Periods

 

Description

Sheets

   

Description

Sheets

1. breakdownexpenses.xls (1)   10. expenseanalysis.xls (1)
2. breakeven4periods.xls (1)   11. expensebudget.xls (1)
3. breakevenadjusted.xls (1)   12. optimal.xls (1)
4. breakevenanalysis.xls (1)   13. payroll.xls (1)
5. breakevenanalysis2.xls (1)   14. productivity.xls (5)
6. breakevenanalysis3.xls (1)   15. proformabalance.xls (1)
7. breakevenanalysis4.xls (1)   16. proformaincome.xls (1)
8. cashflow8.xls (1)   17. ratios.xls (13)
9. charts.xls (9)   18. salesversusexpense.xls (1)

(There is No Support For Free Downloads)


 

 

© Copyright, 2007, The Vickers Company., All Rights Reserved.   |   Privacy Statement   |   Terms of Use