Spreadhseet for Buy & Hold Proforma The only tab with fields that need to be populated is the 'Assumptions' tab. In fields under the section called 'ACQUISITION', you'll see that some fields have 2 or more inputs that allow you to input amounts as either a straight dollar amount or as a % of either rent or purchase price. For these rows, you only populate 1 of these fields and keep all others blank. For example, row 40 Property tax can be input as either a % of property value, $ (monthly), or $ amt (annually). You only fill in one cell (either B40, C40 or D40) and the spreadsheet will normalize everything for you. You can tell whether or not you did it right because there will be a green checkmark in column G. The proforma is ready to read when every field has a green checkmark next to it.