Napkin math - house hacking investment

[Marco Werner]

Hi friends, 

was wondering if anybody here built a simple Excel to do back of the envelope on a house hacking investment? 

including all the basic elements that drive value, e.g., 

- reduction in tax liability on rental income (from depreciation, interest rate payments, other related expenses)

- reduction in personal income tax liability from interest rate payments (i.e., up to $750k mortgage)

- savings on paying rent (i.e., the rent you are currently paying)

If not, drop in your thoughts on which value drivers need to be included and I can pull a quick one together. 

Thank you!