Advanced Property Investment Analysis Spreadsheet
Budget: £250 – £750 GBP
I am in urgent need of a dynamic and comprehensive spreadsheet for managing property purchase financials. This tool will provide how many properties can be purchased when an amount of capital is entered. The property price will be entered and assumed for every purchase for the first phase,
I would like the option to have either cash buys or mortgage buys.
an annual growth of the property value will be included for phase 2 and the sheet will then determine how many properties can be bought in phase 2.
Key Features:
Phase 1 / year 1
a spreadsheet that dertermines how many properties can be purchased with the starting capital
Phase 2 / remortgage of the bought properties release the capital uplift
then more properties can be bought
Phase 3 - same as above.
More importantly, the spreadsheet should allow me to run simulations to understand how many properties can be bought with given capital, assuming the same property prices, either with cash or mortgage purchases including other buying costs such as legal and tax, also refurbishment
Ideal architect of this spreadsheet will be versed in Visual Basics/ Excel and possess understanding of property investment Analytics. Your expertise in financial modeling and simulations will give you an edge.
Please note, there isn't a specific number of properties to manage in-place; rather, the output of the simulation will determine that. I need this done ASAP; your prompt response will be highly appreciated.
The attached file is severely limited to 500k starting capital and fixed mortgage or cash buys. I would like a spreadsheet where I can adjust the starting capital, and the number of properties (columns is adjusted/populated)
Also I would like to be able to run different scenarios, where the properties could be cash bought rather than mortgage bought. This could be a different sheet if thats too difficult to do.
I would like the option to have either cash buys or mortgage buys.
an annual growth of the property value will be included for phase 2 and the sheet will then determine how many properties can be bought in phase 2.
Key Features:
Phase 1 / year 1
a spreadsheet that dertermines how many properties can be purchased with the starting capital
Phase 2 / remortgage of the bought properties release the capital uplift
then more properties can be bought
Phase 3 - same as above.
More importantly, the spreadsheet should allow me to run simulations to understand how many properties can be bought with given capital, assuming the same property prices, either with cash or mortgage purchases including other buying costs such as legal and tax, also refurbishment
Ideal architect of this spreadsheet will be versed in Visual Basics/ Excel and possess understanding of property investment Analytics. Your expertise in financial modeling and simulations will give you an edge.
Please note, there isn't a specific number of properties to manage in-place; rather, the output of the simulation will determine that. I need this done ASAP; your prompt response will be highly appreciated.
The attached file is severely limited to 500k starting capital and fixed mortgage or cash buys. I would like a spreadsheet where I can adjust the starting capital, and the number of properties (columns is adjusted/populated)
Also I would like to be able to run different scenarios, where the properties could be cash bought rather than mortgage bought. This could be a different sheet if thats too difficult to do.