home *** CD-ROM | disk | FTP | other *** search
-
- Problem Use to examine what-if scenarios for existing stock portfolio
- and prospective stock purchases.
-
-
-
- Block Diagram
- ______________ ______________ ______________ __________
- | | | | |
- | Stock 1 Data | Portfolio | | |
- | | Summary Area | | |
- |______________|______________| Macros | Instruct-|
- | | | | ions |
- | Stock 2 Data | | | |
- | | | | |
- |______________| |______________| |
- | | | |
- | Stock 3 Data | | |
- | | | |
- |______________| |__________|
- | |
- | Worksheet for|
- | Prospective |
- | Purchases |
- |______________|
-
- Tips
- What-if" portfolio summary table is well designed and useful.
- It begins at cell O1. Summaries are based on some sophisticated
- formulas.
-
- Macros begin at cell AO1.
-
-
-
-
-
-