Description
- Find out how much you can afford to pay for a house using goal seek and financial functions,
- Consolidate the information from several sheets,
- Understanding the grouping of data,
- Use solver to explore possible outcomes depending on input variables.
- Understand how to forecast future income
- Internal rate of return
- Net present value and other financial functions
- Reasons to use macros
- Creating, editing a macro
- Creating a button for a macro
Case Studies included in this workbook:
The Granny Flat investment spreadsheet will take you through the various costs involved in developing a granny flat in your backyard. It will clearly demonstrate the costs and enable you to forecast your future earnings and return on investment. Read more about Investing in a granny flat
Based on purchasing an investment property in Newcastle NSW we’ve created a number of spreadsheets to help students discover how much they can borrow, how to compare property investment options and make decisions to help them prepare financially for their life.
Reviews
There are no reviews yet.