You fill only the yellow cells for each property. The workbook computes effective rent after vacancy, annual operating costs, net operating income, and a real monthly mortgage with a PMT formula — then the yields, the annual cash flow and the cash-on-cash return on the actual cash you put in (deposit plus buying costs).
A negative annual cash flow turns red, so a property that eats money every month can't hide behind a headline yield. It's the sanity-check a remote or first-time landlord needs before wiring a deposit.