These are the expected results: First 4 months 2,403,350.00 Next 6 months 2,093,524.74 Next 6 months 1,773,148.94 Next 6 months 1,568,200.18 Next 6 months 1,229,935.40 Next 6 months 880,151.63 Next 6 months 518,456.60 This is the algorithm that I wanted to write: Principal=2,350,000 i=0 -> 2,403,350.00 =((FirstPeriodInterestReceived+1) * 2,350,000) - ((FirstPeriodInterestPaid) * 2,350,000) i=1 -> 2,093,524.74 =((OtherPeriodInterestReceived+1) * 2,403,350.00) - ((OtherPeriodInterestPaid) * 2,403,350.00) i=2 -> 1,773,148.94 =((OtherPeriodInterestReceived+1) * 2,093,524.74) - ((OtherPeriodInterestPaid) * 2,093,524.74) . . . i=6 -> 518,456.60 =((OtherPeriodInterestReceived+1) * 880,151.63) - ((OtherPeriodInterestPaid) * 880,151.63) Thanks, Job
... View more