Investment Analysis -- introduction
GOOD LUCK WITH YOUR NEW REAL ESTATE INVESTMENT PROGRAM.
Certain financial mortgage calculations will need to be performed by your MS Excel software,
such as EFFECT (effective interest rate) and NOMINAL (nominal interest rate), plus normal
financial functions such as PV (present value), FV (future value) and PMT (payment).
Of course your Excel setup should also include normal mathematical functions,
such as for example ROUND (rounding) and ABS (absolute).
By simply running the real estate Investment Analysis program you will find out whether
your current setup of your Excel software includes the required financial functions.
SUGGESTED STEPS ( After saving investca.xls on your computer and starting up your Excel program )
- Open 'investca.xls' and click on the Investment Analysis tab along the bottom. Then, for example, edit the Purchase Price. As you make changes to your data input fields, you will see the Cash Flow chart change instantly. If you do not get any error messages then your Excel setup is good. Go ahead, run the software and enjoy!
- If your Excel setup is unable to perform the required calculations, then you have excluded certain Excel functions when you originally installed your MS Excel software on your computer. Review your manual on how to 'Add In' the above indicated functions now. For example if you are using Excel 97, click on 'Add-Ins' under 'Tools' and make sure that 'Analysis ToolPak' and 'Analysis ToolPak - VBA' are checked.
- Alternatively, go to Microsoft 'Help' and contact MS Excel for Technical Support.
Best regards,
Roloff Veld and Manya Milkovich
Sutton Group-1st West Realty