calculating COC with renovations in year 2

[Jordan Krasner]

hey guys, im working on a COC analysis for some rental properties i am looking to purchase.

im just wondering one thing, 

let's say its a 3plex and 1 of the units needs work that you can only do at the end of year 1 because its currently occupied.

do you account for that renovation $ amount in your inital spend, or do you calculate it in year 2? do you calculate it in your total cash invested in every year?

here is a screenshot of my calculator i built:

notice 50k of reno's done in year 2... not sure how to go about that

thanks!