We require someone to create an excel function, that will run as read only (user cannot change code etc), but the results can be saved to an excel file or printed. Here is what we want it to do:
The function will need to be designed to look professional (color and logo's would be provided to you). The functions purpose is to allow a user to enter details about a potential property purchase/sale. The details entered would be as follows:
Is The Property For Sale Yours? [Yes/No]
Are You The Only Owner, Or Do You Have A Partner? [Only Owner/Partner]
What Is Your Main Reason For Selling? [Repayment Stress/Relocating/Divorce/No Equity/Bank Foreclosure/REA Cant Sell/Other]
(if Other, allow a field to enter the Other reason)
Do You Need To Move Out Of This Property Right Away? [Yes/No]
How Much Money Do You Need For This Sale? $[Enter Data Here...]
What Is The Current Mortgage Loan Balance? $[Enter Data Here...]
What Is The Interest Rate On Your Mortgage Loan? [Enter Data Here...]
Is Your Interest Rate Fixed Or Variable? [Fixed/Variable]
(if Fixed, another question needs to be asked - How Many Years Is The Interest Rate Fixed? [1/2/3/4/5/5+]
What Is The Approximate Land Size? [Enter Data Here...]
How Many Bedrooms Does The Property Have? [Enter Data Here...]
How Many Bathrooms Does The Property Have? [Enter Data Here...]
How Much Car Accomodation Does The Property Have? [1 Garage/2 Garage/3+ Garage/1 Carport/2 Carport/3+ Carport]
*** The could be a couple more questions, but this will just be for saving or printing purposes.
The purpose of this function is once the user presses the: Process Details button, it will tell the user what they could do for the seller based on what they have been told. Eg. If they want $300,000 and the seller only has a debt for $70,000, the function would suggest that the user can tell the seller that they can purchase based on the seller offering flexible terms of sale, meaning the seller accepts between. For this deal to display, the function would need to determine that there was at least 25% equity owned by the seller. This example above would show the seller owning nearly 77% equity, so the ratio displayed would be 23% in GREEN, showing the user that they could provide the seller between 23% of the asking price and 75%.
If the debt and the sale price were greater then 75%, then the terms suggested by this function would be that the user could offer a small down payment, and simply take over the outgoing mortgage loan payments and other outgoing costs.
We have tried to be as detailed as possible, but this excel function should be really simple for someone who is already good at excel.
An example of the presentation quality can be found at [url removed, login to view] (this has nothing to do with this project, but we want the quality to be as good or better then this example)...
The ownership of this function would be 100% owned by the us as the buyer, and could not resold to others wanting a similar function.
Look forward to your bids.