home *** CD-ROM | disk | FTP | other *** search
-
- Problem Designed to analyze a real estate purchase over a 10 year time
- horizon. Can also be used for Rent/Buy decision analysis.
-
- Block Diagram
- ________________
- | |
- | Input Screen |
- | |
- |----------------|
- | Cash Flow |
- | Analysis |
- |----------------|
- | Net Proceeds |
- | From Sale |
- |----------------|
- | IRR Analysis |
- | |
- |----------------|
- | IRR Sensitivity|
- | Analysis |
- |----------------|
- | Instructions |
- | |
- |----------------|
-
-
- Tips
- @IRR calculations (A53)
- @PMT Calculations (H7, H12, H17)
- Depreciation calculations (D37)
- Data Table 1 Sensitivity analysis on property's annual
- appreciation using several @IRR formulas. Result graphed. (B78)
-
-
-
-
-