In the yellow boxes, enter in the purchase price, the value after repair you expect ARV calculation is typically based on comps and can be difficult, biggerpockets has a book word doc on it. The spreadsheet gives novice investors an easy and affordable way to know whether a real estate rental investment income property will be profitable before they put their money in. That is less than the cost of building the house. Being a software engineer, I decided to create my own and I am happy to share it with you here. For example, if you add more rows to the operating expenses, double check the formula used to total the expenses to make sure it is summing all of the expenses. If a multi-family has units with different numbers of beds, just average the rental amounts.