| Compare mortgages/screen 4/rate of investment return and cash flows |
SUMMARY: Provides a year by year summary of changes in property values (row 2), declining loan balances (row 3), equity balances (row 4), total cumulative mortgage interest paid so far (row 5), cumulative cash flow so far (row 6) derived from budgeted annual maintenance costs, insurance's, taxes, rental income inputs user entered in screen 1. The net balance values row by row (row 7) calculate the annual difference between Equity and cumulative interest and cumulative cash flow. Net gain (row 8) is the difference between the deposit value in row 1. Column 4 and net balance this year. Row 9 is the annualized rate of investment return. Provides great assistance towards working out by trial and error the rate of price change that is required to achieve positive annual net gains after costs and interest charges and the desired rate of return on the original deposit investment.
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Contact Management Document Management Sales Management
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment Management Marketing Planners Project Management Quality Control Schedulers )
MS Excel Add-ins, Spreadsheets, Templates
Copyright © Millennium Software All Rights Reserved