Need a lookup function for multiple tables

M

mhubert9028

New Member
Joined
Jan 27, 2017
Messages
1
Hi all,

I've been working to create an amortization schedule calculator. Basically there is a total of 31 tables (from Year 1 to Year 31). I have only shown 2 of the 31 below. I'm creating a loan results dashboard and one of the items I would like to see is a date that a certain amount of equity is acquired. (i.e. by inspection I can see that I have acquired 20% equity in Feb 2027, which would be payment number 121).

I would like my dashboard to show:
Number of payments to acquire 20% equity
Date that 20% equity is acquired

I have tried pivot tables, but run into issues due to the layout of my tables. I believe I need a lookup function which will account for my table layout. I am not interested in changing the table layout unless it is last resort or if I can use a pivot table. I am familiar with index match if there is a way to tailor it to my needs.

I hope the following table helps. This is my first post. Let me know if I can provide any more info. Thanks in advance!

[TABLE="width: 286"]
<tbody>[TR]
[TD="width: 380, bgcolor: #E7EBD4, colspan: 4, align: center"]LOAN RESULTS
[/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Loan Details
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Total Loan Cost
[/TD]
[TD="bgcolor: #E7EBD4"]$220,422.64
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Total Interest Paid
[/TD]
[TD="bgcolor: #E7EBD4"]$92,172.64
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Timeline
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Number of Payments
[/TD]
[TD="bgcolor: #E7EBD4"]360
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Date Loan is Paid
[/TD]
[TD="bgcolor: #E7EBD4"]2/4/2047
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]20% Equity Aquired
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype>

<tbody>
</tbody>
[/TD]
[TD="bgcolor: #E7EBD4"]Percent Equity
[/TD]
[TD="bgcolor: #FFCC99"]20%
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Equity Value
[/TD]
[TD="bgcolor: #E7EBD4"]$27,000
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Number of Payments
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"]Date Acquired
[/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
[TR]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[TD="bgcolor: #E7EBD4"][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 1028"]
<tbody>[TR]
[TD="class: xl71, width: 192, bgcolor: #158A0C"]Date
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Jan-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Feb-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Mar-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Apr-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]May-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Jun-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Jul-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Aug-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Sep-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Oct-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Nov-17
[/TD]
[TD="class: xl72, width: 90, bgcolor: #158A0C"]Dec-17
[/TD]
[TD="class: xl73, width: 90, bgcolor: #158A0C"]TOTAL
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Payment Number
[/TD]
[TD="class: xl70, bgcolor: #E7EBD4"]-
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]1
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]2
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]3
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]4
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]5
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]6
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]7
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]8
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]9
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]10
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]11
[/TD]
[TD="class: xl67, bgcolor: #E7EBD4"]-
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Amount Due - ESCROW
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$-
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$8,628.97
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #E7EBD4"]Amount Due - Mortgage
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$-
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$6,735.14
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Principal
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$-
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$184.79
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$185.40
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$186.02
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$186.64
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$187.26
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$187.89
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$188.51
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$189.14
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$189.77
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$190.40
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$191.04
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$2,066.85
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Interest
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$-
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$427.50
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$426.88
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$426.27
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$425.65
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$425.02
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$424.40
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$423.77
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$423.14
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$422.51
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$421.88
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$421.25
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$4,668.28
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Beginning Principal Balance
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$-
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$128,250.00
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$128,065.21
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,879.81
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,693.79
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,507.16
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,319.89
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,132.01
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,943.50
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,754.36
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,564.59
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,374.18
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$128,250.00
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Ending Principal Balance
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$-
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$128,065.21
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,879.81
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,693.79
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,507.16
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,319.89
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$127,132.01
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,943.50
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,754.36
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,564.59
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,374.18
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,183.15
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,183.15
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #158A0C"]Date
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Jan-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Feb-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Mar-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Apr-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]May-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Jun-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Jul-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Aug-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Sep-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Oct-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Nov-18
[/TD]
[TD="class: xl72, bgcolor: #158A0C"]Dec-18
[/TD]
[TD="class: xl73, bgcolor: #158A0C"]TOTAL
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Payment Number
[/TD]
[TD="class: xl70, bgcolor: #E7EBD4"]12
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]13
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]14
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]15
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]16
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]17
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]18
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]19
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]20
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]21
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]22
[/TD]
[TD="class: xl74, bgcolor: #E7EBD4"]23
[/TD]
[TD="class: xl67, bgcolor: #E7EBD4"]-
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Amount Due - ESCROW
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$784.45
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$9,413.42
[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #E7EBD4"]Amount Due - Mortgage
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$612.29
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$7,347.42
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Principal
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$191.67
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$192.31
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$192.95
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$193.60
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$194.24
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$194.89
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$195.54
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$196.19
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$196.85
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$197.50
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$198.16
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$198.82
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$2,342.74
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Interest
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$420.61
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$419.97
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$419.33
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$418.69
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$418.04
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$417.39
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$416.74
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$416.09
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$415.44
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$414.78
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$414.12
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$413.46
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$5,004.69
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Beginning Principal Balance
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,183.15
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,991.47
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,799.16
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,606.20
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,412.60
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,218.36
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,023.47
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,827.93
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,631.74
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,434.89
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,237.39
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,039.23
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$126,183.15
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #E7EBD4"]Ending Principal Balance
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,991.47
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,799.16
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,606.20
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,412.60
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,218.36
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$125,023.47
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,827.93
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,631.74
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,434.89
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,237.39
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$124,039.23
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$123,840.41
[/TD]
[TD="class: xl68, bgcolor: #E7EBD4"]$123,840.41
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
You must log in or register to reply here.

Similar threads

A
  • Question Question
Loan Tracker with prior/missed payments
Replies
0
Views
99
aurelius33
A
N
  • Solved
Formula For Entering Loan Repayment On The Same Day For Each Month
Replies
4
Views
488
Dave Patton
D
M
  • Question Question
suggest excel formula to calculate cumulative interest on no of days etc ......
Replies
1
Views
662
Peter_SSs
Peter_SSs
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
612
Peter_SSs
Peter_SSs
A
  • Question Question
Daily Interest Loan Scheduler | Missed Payments
Replies
0
Views
241
aurelius33
A

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top