cleaned up example attached
I have been moving rows 22-34 left and right by inserting/deleting cells, but you'll see that throws errors in rows 48 and 55. I can solve that by redrawing rows 36-57 after I move the rows dealing with the apartment purchase. Cells B16-B20 are hard input numbers. The rest of rows 18-20 are just references for me to show what the value and expenses will be as the years pass for the target apartment. Those numbers are not involved in the calculations. As you will see, rows 26, 30 refer to the amortization schedule on a different worksheet. I can't calculate these numbers easily. The mortgage reduction is not linear as one pays less interest as the years go by. As a side note, the equity number in line 27 is not a true sum. I included the possibility that I would relocate to an area where housing costs are cheaper. The adjustment is in the equity number even though the FMV and mortgage would be lower in that scenario. Have fun.
|