To try and break it down into manageble chunks


I have highlighted what i think are the varibles that you would type in, in blue.


and pretty much everything else will calculate from that? for example i would think that b1 should always be the current year or maybe it should equal the move out date?




Ideally if we can get the years to be dynamic the calculation will work from them and we can hide what we dont want.


In my mind nothing should move as each calc can look for the correct detail


It might be a slow approch but we can get a decent spready at the end of this

Attached Files

calculator_1.xlsx (117.0 KB, 10 views)

Thanks for the effort. My thoughts:

1. rows 1-6 are irrelevant to the calculations. No need to move them into the blue section like you did.
2. You have shifted rows 24-27 to the right. Those cells need to align with rows 22, 30-34.
3. I didn't see any changes to the formulas in rows 26, 30 which are my problems. I can't calculate the values in those rows. I need to refer to the other worksheet.
4. You think this was a lot of numbers? I deleted 3/4 of the worksheet before I sent it to you. Look at rows 36-48. All those go into the year's income/expenses. Look at rows 52-55. those are the components of net worth. Calculating the mortgage is just one expense. apartment equity is one component of net worth.