Few options...

You could make it a table and enter in the formula there that way when you add more data and the table wraps around it, it will apply the previous formula...
You could also just double click the last formula on the Bottom right hand corner of the cell. it will auto drag it until it finds the end.
Or, once pasted, jump to the bottom of your data by hitting CTRL+Down, and then click in cell where the last formula will end, hit CTRL+Up then hit CTRL+D. This will duplicate previously applied information (Values,Formats,Formulas)