MAO & BRRR & Circular References

[Gerald Renoe]

Hello BP!! I am starting out my BRRR efforts and as I calculate my MAO I also want to account for the ReFi loan costs (using 4.5%).

So, with Excel trying to give me "circular reference" warnings I have needed to do two separate calculations:

1) MAO - into which I manually insert my ATV: (ATV*.70)-Rehab

2) I then take the my total investment + the ReFi costs to arrive at an actual ATV needed to cover it all since I want to come out break even or as close as possible.

Is this solid math or am I off? 

I know there are online calculators but I want to and believe I need to work through the numbers on my own to build confidence and accuracy for my individual goals and deals. 

Thanks for input!! I have only ever done traditional buy and holds so BRRR is new to me.

--Jerry