Home › Forums › Other › Equity equation in excel › Cell A3 : 1/1/2012 Cell A4:
Cell A3 : 1/1/2012 Cell A4: 2/1/2012 Select these two cells and copy waaaaay down
Cell B3 352000 Cell B4 B3-F3 Copy from Cell B4 all the way down
Cell C2 =+.03875/12
Cell D3 1655.23 copy cell D3 waaaaaay down
Cell E3 =+$C$2*B3 Copy waaaaaaadown
Cell F3 =+D3-E3 Copy waaaaay down
Cell G3 =440000-B3 Copy waaaaay down
Labels B2 Remaining loan d2 Payment E2 Interest F2 Principal G2 Equity
