This is a modified version of J Scott's SFH analysis sheet. I updated the formulas to work with an all cash offer or a 15 year mortgage and I added a separate calculation of property taxes based on assessed value that may be different from the purchase price. I also have separate rows for repairs vs capital reserves to plan for longer-term improvements such as a new roof, new HVAC, etc.