I purchase houses to rent, and probably look at 10-20 houses a day online. What I am looking for is away to come up with a formula in Mathmatica to determine if the house I want to purchase are profitable. I wrote the formula in Excel except it doesn't give me the whole picture.

What determines if a house is profitable to purchase is the Price per square foot, purchase price, retail value of other houses in the area, Renovation costs, Short term Renovation loan, and long term mortgage. If I can just glance at a graph that would make it so much easier to determine if I should purchase the house or not.