Create a spreadsheet for real estate investment
$250-750 USD
Pagado a la entrega
I request an excel spreadsheet template for real estate investment scenarios.
I want the spreadsheet to work the following for me PER PROPERTY PURCHASED:
Amortization of loans up to 80 years length, with monthly breakdown of principal and interest components (user will set purchase price and interest rate on borrowed finance)
LVR - This is the Loan to Value Ration. For example, if a property is purchased for $100,000 and the loan is $70,000 then the LVR is 70%.
I would like the spreadsheet to identify principal and interest repayments on the loan amount only, not the full purchase price of the property
Payback period for capital improvements (spreadsheet user will provide amounts paid for capital improvements at any given time during the 50 year investment period)
Outgoings and multiple cost fluctuations and Rental income fluctuations ie allowance for increase or decrease in (set by user)
Land tax rates (usually set for the life of the investment - set by user)
Calculation of purchase costs (user will provide percentage, please make allowance for up to 10 different purchase costs which user will enter)
Comparison of investment against market yield. Example: typically residential real estate returns 4% per annum, but one investment scenario set by the user only returns 3.8%. (user sets market yield. Market yield should be set to change on a yearly basis set by the user throughout the 80 year period)
A final net figure per annum and also at the end of the 80 years (or earlier as set by the user), be it a loss or income. This final figure should end at 80 years or prior to that as set by the user and should calculate NPV should the user choose to run a scenario where the investment is sold in any given month in any year prior or up until the 80th year.
THE SPREADSHEET MUST THEN REPLICATE THIS FOR UP TO 100 PURCHASED PROPERTIES. The purpose is to identify how well scenario would run with the user inputting a scenario where an investor buys more investments at any month in any year up until the 80th year.
Additionally, the spreadsheet should take into account the development of each of the 100 properties, individually. For example, property number 27 is developed in year 18 and 6 months to now have 20 units built on the land instead of 3 houses. Development costs set by the user can be input as well as additional funding expenses such as interest. This should take into account capital income, ie sale of each newly built unit, or rental income, and how it performs against the development's ongoing costs and pre existing funding as well as typical market yield. (user sets upfront costs and expected interest rate over the life of the development project for that property. FOR THIS PARTICULAR ISSUE TO BE RESOLVED I CAN PROVIDE YOU WITH A SPREADSHEET OF AN INDIVIDUAL SCENARIO AND HOW IT WORKS. REMEMBER, THIS PARTICULAR FEATURE OF THE SPREADSHEET MUST RUN IN ACCORDANCE WITH MY REQUIREMENTS AS LISTED.
Finally, I would like the spreadsheet to provide a summary in easy to understand figures as well as via graphs. All the information that the scenario produces should be provided graphically as well.
The spreadsheet must do this per property, as well as a summary for all properties purchased.
THE SUCCESSFUL CANDIDATE FOR THIS JOB
You should have excellent English skills and a thorough understanding of finance and real estate investment and development. I will provide you with further details on how I expect the end result, but for the most part, you will need to complete this project with little input from me.
THE DESIRED OUTCOME OF THIS PROJECT
A complete tool which provides me with a way to develop analysis on scenarios for real estate investment opportunities. I should be able to determine, when, and how much to invest at any time and when to sell and in the case of developed properties, how much to sell before the break even point is reached.
Nº del proyecto: #6181522
Sobre el proyecto
23 freelancers están ofertando un promedio de $437 por este trabajo
Hello; my name is Sevinc Aydin. I am one of the top freelancer here with my great experience especially with excel and vba coding. I also have a finance and accounting background. When I read your project, I was very e Más
Hello, I highly recommend my team for your work. My team has vast experience in data entry projects like data mining, data research, typing work, magneto data entry, product add. I have a team of 40 employers which Más
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases Más
Greetings! I am a fine accountant and have good hand with excel based financial models. Consider the job done with perfection. Thank you
Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft Excel database and VBA o Más
Hello, I am civil engineer working as project manager, and I have been educated as real estate consultant. My skills as Excel programmer are excellent. If you are interested in awarding me your project please contact m Más
Hi I would like to do this for you . i have done alot of similar tasks before this . Please review my profile here at freelancer.com and lets get started asap after little bit of cross questioning and discussion. Look Más
Hello, I am very interested in doing this project for you. I not in in the real estate industry, but I work in construction projects and I have done this type of math before. About me: I am an Engineer from N Más
Hi there! My name is Conrad Gillard and I would like to help you with your real estate investment project. I have extensive experience with VBA programming to automate calculations, and I am confident that I can dev Más
Dear Employer I am new to the website and currently have bid the lowest as I need to get few projects to make some reviews. I have been part of strategic planning for 5 years and am very well verse with preparing fin Más