property analysis spreadsheet
Budget $250-750 USD
Design an interactice spredsheet with good facade which will:
1) predict how a single or portfolio of multiple properties will grow in value
2) examines an investors serviceability and predicts when they can afford the next property
3) works out their expected income tax liability from year to year
3) P&I loans and I/O loans and switching between them, fixed interest loans, variable interest loans
4) adjusting loan interest rates from year to year
5) adjusting rent percentage increases from year to year
6) adjusting cost increases from year to year
7) works out purchase costs (both property and stamp duty depending on the state of australia)
8) allows for initial deposits on properties
9) allows for entry of real information (eg from depreciation schedules, tax returns etc which overrides derived or predicted data
10) income from different sources (wages, rents, shares etc)
11) variable capital growth rates for different properties and the ability to vary the capital growth rate from year to year to allow for cycles
12) shows net asset position each year
5 freelance font une offre moyenne de $270 pour ce travail
Its my pleasure to bid over here. Looking forward for your positive response. Kindly refer to pm please for details.