TXHousingConsultants
New Member
- Joined
- Aug 15, 2013
- Messages
- 2
[links to view the spreadsheet are at the bottom] I'm using excel 2007, windows 7 Ultimate (64-bit)
I have a spreadsheet that calculates the accrued daily interest each day. The columns are: day#, month#, starting balance, deposits, withdrawals, ending balance, daily interest, and month's accrued interest.
On every 31st day (row) it automatically takes the month's accrued interest's Value and adds it into the ending balance (of the 30th day). I found this online, and I'm not sure how to change the formulas. The issue is that instead of the accrued interest to be compounded on the 31st day, I would like to compound it on specific dates (due dates from the mortgage Line of Credit). On top of that, the spreadsheet rows (under the day# column) show: 1,2,3,etc. ; I would like to make it dates from 01/01/13 - 12/31/13. But it appears that other formulas are dependant on those cells.
Bottom line: I manage a line of credit, which has several deposits & withdrawals throughout the billing cycle, and I need to know the total $$ amount of interest paid/owed at the end of my project (which is about 3-7 billing cycles). The billing cycles are not on a set date of each month.
You can see on the 31st that the accrued interest has compounded.
Click here to download from SkyDrive: http://sdrv.ms/14EmNjP
Click here to download from Google Drive: https://docs.google.com/file/d/0B62tNlIfVtGVdjBOUTNSRzltQ28/edit?usp=sharing
I have a spreadsheet that calculates the accrued daily interest each day. The columns are: day#, month#, starting balance, deposits, withdrawals, ending balance, daily interest, and month's accrued interest.
On every 31st day (row) it automatically takes the month's accrued interest's Value and adds it into the ending balance (of the 30th day). I found this online, and I'm not sure how to change the formulas. The issue is that instead of the accrued interest to be compounded on the 31st day, I would like to compound it on specific dates (due dates from the mortgage Line of Credit). On top of that, the spreadsheet rows (under the day# column) show: 1,2,3,etc. ; I would like to make it dates from 01/01/13 - 12/31/13. But it appears that other formulas are dependant on those cells.
Bottom line: I manage a line of credit, which has several deposits & withdrawals throughout the billing cycle, and I need to know the total $$ amount of interest paid/owed at the end of my project (which is about 3-7 billing cycles). The billing cycles are not on a set date of each month.
Code:
[RANGE=cls:xl2bb-100][XR][XH=cs:9]Excel 2007[/XH][/XR][XR][XH][/XH][XH]B[/XH][XH]C[/XH][XH]D[/XH][XH]E[/XH][XH]F[/XH][XH]G[/XH][XH]H[/XH][XH]I[/XH][/XR][XR][XH]7[/XH][XD=h:r|fw:b]interest rate[/XD][XD=h:r|bc:ffff00]4.740000%[/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r|fw:b][/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r][/XD][/XR][XR][XH]8[/XH][XD=h:r|fw:b]daily interest rate[/XD][XD=h:r|cls:fx][FORMULA==C7/365]0.012986%[/FORMULA][/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r|fs:i][/XD][XD=h:r|fs:i][/XD][XD=h:r][/XD][XD=h:r][/XD][/XR][XR][XH]9[/XH][XD=h:r|fw:b]initial balance[/XD][XD=h:r|bc:ffff00]$ 35,000.00[/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r|fs:i][/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r][/XD][/XR][XR][XH]10[/XH][XD=h:r][/XD][XD=h:r][/XD][XD=h:r|fw:b][/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r][/XD][XD=h:r][/XD][/XR][XR][XH]11[/XH][XD=h:r|fw:b]day#[/XD][XD=h:r|fw:b]month#[/XD][XD=h:r|fw:b]starting balance[/XD][XD=h:r|fw:b]deposits[/XD][XD=h:r|fw:b]withdrawals[/XD][XD=h:r|fw:b]ending balance[/XD][XD=h:r|fw:b]daily interest[/XD][XD=h:r|fw:b]month's accrued interest[/XD][/XR][XR][XH]12[/XH][XD=h:r]1[/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B12-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$9]$ 35,000.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D12+E12-F12]$ 35,000.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G12]$ 4.5452[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==H12]$ 4.5452[/FORMULA][/XD][/XR][XR][XH]13[/XH][XD=h:r|cls:fx][FORMULA==B12+1]2[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B13-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G12+IF(MOD(B12,30)=0,ROUND(I12,2),0)]$ 35,000.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D13+E13-F13]$ 35,000.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G13]$ 4.5452[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B12,30)<>0,I12,0)+H13]$ 9.0904[/FORMULA][/XD][/XR][XR][XH]14[/XH][XD=h:r|cls:fx][FORMULA==B13+1]3[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B14-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G13+IF(MOD(B13,30)=0,ROUND(I13,2),0)]$ 35,000.00[/FORMULA][/XD][XD=h:r]$ 1,500.00[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D14+E14-F14]$ 36,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G14]$ 4.7400[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B13,30)<>0,I13,0)+H14]$ 13.8304[/FORMULA][/XD][/XR][XR][XH]15[/XH][XD=h:r|cls:fx][FORMULA==B14+1]4[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B15-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G14+IF(MOD(B14,30)=0,ROUND(I14,2),0)]$ 36,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D15+E15-F15]$ 36,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G15]$ 4.7400[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B14,30)<>0,I14,0)+H15]$ 18.5704[/FORMULA][/XD][/XR][XR][XH]16[/XH][XD=h:r|cls:fx][FORMULA==B15+1]5[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B16-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G15+IF(MOD(B15,30)=0,ROUND(I15,2),0)]$ 36,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ 16,000.00[/XD][XD=h:r|cls:fx][FORMULA==D16+E16-F16]$ 20,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G16]$ 2.6622[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B15,30)<>0,I15,0)+H16]$ 21.2326[/FORMULA][/XD][/XR][XR][XH]17[/XH][XD=h:r|cls:fx][FORMULA==B16+1]6[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B17-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G16+IF(MOD(B16,30)=0,ROUND(I16,2),0)]$ 20,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D17+E17-F17]$ 20,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G17]$ 2.6622[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B16,30)<>0,I16,0)+H17]$ 23.8948[/FORMULA][/XD][/XR][XR][XH]18[/XH][XD=h:r|cls:fx][FORMULA==B17+1]7[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B18-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G17+IF(MOD(B17,30)=0,ROUND(I17,2),0)]$ 20,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D18+E18-F18]$ 20,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G18]$ 2.6622[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B17,30)<>0,I17,0)+H18]$ 26.5570[/FORMULA][/XD][/XR][XR][XH]19[/XH][XD=h:r|cls:fx][FORMULA==B18+1]8[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B19-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G18+IF(MOD(B18,30)=0,ROUND(I18,2),0)]$ 20,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D19+E19-F19]$ 20,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G19]$ 2.6622[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B18,30)<>0,I18,0)+H19]$ 29.2192[/FORMULA][/XD][/XR][XR][XH]20[/XH][XD=h:r|cls:fx][FORMULA==B19+1]9[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B20-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G19+IF(MOD(B19,30)=0,ROUND(I19,2),0)]$ 20,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D20+E20-F20]$ 20,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G20]$ 2.6622[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B19,30)<>0,I19,0)+H20]$ 31.8814[/FORMULA][/XD][/XR][XR][XH]21[/XH][XD=h:r|cls:fx][FORMULA==B20+1]10[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B21-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G20+IF(MOD(B20,30)=0,ROUND(I20,2),0)]$ 20,500.00[/FORMULA][/XD][XD=h:r]$ 28,000.00[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D21+E21-F21]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G21]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B20,30)<>0,I20,0)+H21]$ 38.1797[/FORMULA][/XD][/XR][XR][XH]22[/XH][XD=h:r|cls:fx][FORMULA==B21+1]11[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B22-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G21+IF(MOD(B21,30)=0,ROUND(I21,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D22+E22-F22]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G22]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B21,30)<>0,I21,0)+H22]$ 44.4781[/FORMULA][/XD][/XR][XR][XH]23[/XH][XD=h:r|cls:fx][FORMULA==B22+1]12[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B23-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G22+IF(MOD(B22,30)=0,ROUND(I22,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D23+E23-F23]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G23]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B22,30)<>0,I22,0)+H23]$ 50.7764[/FORMULA][/XD][/XR][XR][XH]24[/XH][XD=h:r|cls:fx][FORMULA==B23+1]13[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B24-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G23+IF(MOD(B23,30)=0,ROUND(I23,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D24+E24-F24]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G24]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B23,30)<>0,I23,0)+H24]$ 57.0748[/FORMULA][/XD][/XR][XR][XH]25[/XH][XD=h:r|cls:fx][FORMULA==B24+1]14[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B25-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G24+IF(MOD(B24,30)=0,ROUND(I24,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D25+E25-F25]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G25]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B24,30)<>0,I24,0)+H25]$ 63.3732[/FORMULA][/XD][/XR][XR][XH]26[/XH][XD=h:r|cls:fx][FORMULA==B25+1]15[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B26-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G25+IF(MOD(B25,30)=0,ROUND(I25,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D26+E26-F26]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G26]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B25,30)<>0,I25,0)+H26]$ 69.6715[/FORMULA][/XD][/XR][XR][XH]27[/XH][XD=h:r|cls:fx][FORMULA==B26+1]16[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B27-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G26+IF(MOD(B26,30)=0,ROUND(I26,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D27+E27-F27]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G27]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B26,30)<>0,I26,0)+H27]$ 75.9699[/FORMULA][/XD][/XR][XR][XH]28[/XH][XD=h:r|cls:fx][FORMULA==B27+1]17[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B28-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G27+IF(MOD(B27,30)=0,ROUND(I27,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D28+E28-F28]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G28]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B27,30)<>0,I27,0)+H28]$ 82.2682[/FORMULA][/XD][/XR][XR][XH]29[/XH][XD=h:r|cls:fx][FORMULA==B28+1]18[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B29-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G28+IF(MOD(B28,30)=0,ROUND(I28,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D29+E29-F29]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G29]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B28,30)<>0,I28,0)+H29]$ 88.5666[/FORMULA][/XD][/XR][XR][XH]30[/XH][XD=h:r|cls:fx][FORMULA==B29+1]19[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B30-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G29+IF(MOD(B29,30)=0,ROUND(I29,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D30+E30-F30]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G30]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B29,30)<>0,I29,0)+H30]$ 94.8649[/FORMULA][/XD][/XR][XR][XH]31[/XH][XD=h:r|cls:fx][FORMULA==B30+1]20[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B31-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G30+IF(MOD(B30,30)=0,ROUND(I30,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D31+E31-F31]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G31]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B30,30)<>0,I30,0)+H31]$ 101.1633[/FORMULA][/XD][/XR][XR][XH]32[/XH][XD=h:r|cls:fx][FORMULA==B31+1]21[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B32-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G31+IF(MOD(B31,30)=0,ROUND(I31,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D32+E32-F32]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G32]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B31,30)<>0,I31,0)+H32]$ 107.4616[/FORMULA][/XD][/XR][XR][XH]33[/XH][XD=h:r|cls:fx][FORMULA==B32+1]22[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B33-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G32+IF(MOD(B32,30)=0,ROUND(I32,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D33+E33-F33]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G33]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B32,30)<>0,I32,0)+H33]$ 113.7600[/FORMULA][/XD][/XR][XR][XH]34[/XH][XD=h:r|cls:fx][FORMULA==B33+1]23[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B34-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G33+IF(MOD(B33,30)=0,ROUND(I33,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D34+E34-F34]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G34]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B33,30)<>0,I33,0)+H34]$ 120.0584[/FORMULA][/XD][/XR][XR][XH]35[/XH][XD=h:r|cls:fx][FORMULA==B34+1]24[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B35-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G34+IF(MOD(B34,30)=0,ROUND(I34,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D35+E35-F35]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G35]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B34,30)<>0,I34,0)+H35]$ 126.3567[/FORMULA][/XD][/XR][XR][XH]36[/XH][XD=h:r|cls:fx][FORMULA==B35+1]25[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B36-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G35+IF(MOD(B35,30)=0,ROUND(I35,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D36+E36-F36]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G36]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B35,30)<>0,I35,0)+H36]$ 132.6551[/FORMULA][/XD][/XR][XR][XH]37[/XH][XD=h:r|cls:fx][FORMULA==B36+1]26[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B37-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G36+IF(MOD(B36,30)=0,ROUND(I36,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D37+E37-F37]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G37]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B36,30)<>0,I36,0)+H37]$ 138.9534[/FORMULA][/XD][/XR][XR][XH]38[/XH][XD=h:r|cls:fx][FORMULA==B37+1]27[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B38-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G37+IF(MOD(B37,30)=0,ROUND(I37,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D38+E38-F38]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G38]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B37,30)<>0,I37,0)+H38]$ 145.2518[/FORMULA][/XD][/XR][XR][XH]39[/XH][XD=h:r|cls:fx][FORMULA==B38+1]28[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B39-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G38+IF(MOD(B38,30)=0,ROUND(I38,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D39+E39-F39]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G39]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B38,30)<>0,I38,0)+H39]$ 151.5501[/FORMULA][/XD][/XR][XR][XH]40[/XH][XD=h:r|cls:fx][FORMULA==B39+1]29[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B40-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G39+IF(MOD(B39,30)=0,ROUND(I39,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D40+E40-F40]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G40]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B39,30)<>0,I39,0)+H40]$ 157.8485[/FORMULA][/XD][/XR][XR][XH]41[/XH][XD=h:r|cls:fx][FORMULA==B40+1]30[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B41-1)/30, 0)+1]1[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G40+IF(MOD(B40,30)=0,ROUND(I40,2),0)]$ 48,500.00[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D41+E41-F41]$ 48,500.00[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G41]$ 6.2984[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B40,30)<>0,I40,0)+H41]$ 164.1468[/FORMULA][/XD][/XR][XR][XH]42[/XH][XD=h:r|cls:fx][FORMULA==B41+1]31[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B42-1)/30, 0)+1]2[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G41+IF(MOD(B41,30)=0,ROUND(I41,2),0)]$ 48,664.15[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D42+E42-F42]$ 48,664.15[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G42]$ 6.3197[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B41,30)<>0,I41,0)+H42]$ 6.3197[/FORMULA][/XD][/XR][XR][XH]43[/XH][XD=h:r|cls:fx][FORMULA==B42+1]32[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B43-1)/30, 0)+1]2[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G42+IF(MOD(B42,30)=0,ROUND(I42,2),0)]$ 48,664.15[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D43+E43-F43]$ 48,664.15[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G43]$ 6.3197[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B42,30)<>0,I42,0)+H43]$ 12.6393[/FORMULA][/XD][/XR][XR][XH]44[/XH][XD=h:r|cls:fx][FORMULA==B43+1]33[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==ROUNDDOWN((B44-1)/30, 0)+1]2[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==G43+IF(MOD(B43,30)=0,ROUND(I43,2),0)]$ 48,664.15[/FORMULA][/XD][XD=h:r]$ -[/XD][XD=h:r]$ -[/XD][XD=h:r|cls:fx][FORMULA==D44+E44-F44]$ 48,664.15[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==$C$8*G44]$ 6.3197[/FORMULA][/XD][XD=h:r|cls:fx][FORMULA==IF(MOD(B43,30)<>0,I43,0)+H44]$ 18.9590[/FORMULA][/XD][/XR][XR][XH=cs:9][RANGE][XR][XD]Sheet1[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE][RANGE=cls:xl2bb-extra-100][XR][XH=cs:2|h:l|fw:b]Cell Formulas[/XH][/XR][XR][XH]Cell[/XH][XH]Formula[/XH][/XR][XR][XD]C8[/XD][XD]=C7/365[/XD][/XR][XR][XD]C12[/XD][XD]=ROUNDDOWN((B12-1)/30, 0)+1[/XD][/XR][XR][XD]C13[/XD][XD]=ROUNDDOWN((B13-1)/30, 0)+1[/XD][/XR][XR][XD]C14[/XD][XD]=ROUNDDOWN((B14-1)/30, 0)+1[/XD][/XR][XR][XD]C15[/XD][XD]=ROUNDDOWN((B15-1)/30, 0)+1[/XD][/XR][XR][XD]C16[/XD][XD]=ROUNDDOWN((B16-1)/30, 0)+1[/XD][/XR][XR][XD]C17[/XD][XD]=ROUNDDOWN((B17-1)/30, 0)+1[/XD][/XR][XR][XD]C18[/XD][XD]=ROUNDDOWN((B18-1)/30, 0)+1[/XD][/XR][XR][XD]C19[/XD][XD]=ROUNDDOWN((B19-1)/30, 0)+1[/XD][/XR][XR][XD]C20[/XD][XD]=ROUNDDOWN((B20-1)/30, 0)+1[/XD][/XR][XR][XD]C21[/XD][XD]=ROUNDDOWN((B21-1)/30, 0)+1[/XD][/XR][XR][XD]C22[/XD][XD]=ROUNDDOWN((B22-1)/30, 0)+1[/XD][/XR][XR][XD]C23[/XD][XD]=ROUNDDOWN((B23-1)/30, 0)+1[/XD][/XR][XR][XD]C24[/XD][XD]=ROUNDDOWN((B24-1)/30, 0)+1[/XD][/XR][XR][XD]C25[/XD][XD]=ROUNDDOWN((B25-1)/30, 0)+1[/XD][/XR][XR][XD]C26[/XD][XD]=ROUNDDOWN((B26-1)/30, 0)+1[/XD][/XR][XR][XD]C27[/XD][XD]=ROUNDDOWN((B27-1)/30, 0)+1[/XD][/XR][XR][XD]C28[/XD][XD]=ROUNDDOWN((B28-1)/30, 0)+1[/XD][/XR][XR][XD]C29[/XD][XD]=ROUNDDOWN((B29-1)/30, 0)+1[/XD][/XR][XR][XD]C30[/XD][XD]=ROUNDDOWN((B30-1)/30, 0)+1[/XD][/XR][XR][XD]C31[/XD][XD]=ROUNDDOWN((B31-1)/30, 0)+1[/XD][/XR][XR][XD]C32[/XD][XD]=ROUNDDOWN((B32-1)/30, 0)+1[/XD][/XR][XR][XD]C33[/XD][XD]=ROUNDDOWN((B33-1)/30, 0)+1[/XD][/XR][XR][XD]C34[/XD][XD]=ROUNDDOWN((B34-1)/30, 0)+1[/XD][/XR][XR][XD]C35[/XD][XD]=ROUNDDOWN((B35-1)/30, 0)+1[/XD][/XR][XR][XD]C36[/XD][XD]=ROUNDDOWN((B36-1)/30, 0)+1[/XD][/XR][XR][XD]C37[/XD][XD]=ROUNDDOWN((B37-1)/30, 0)+1[/XD][/XR][XR][XD]C38[/XD][XD]=ROUNDDOWN((B38-1)/30, 0)+1[/XD][/XR][XR][XD]C39[/XD][XD]=ROUNDDOWN((B39-1)/30, 0)+1[/XD][/XR][XR][XD]C40[/XD][XD]=ROUNDDOWN((B40-1)/30, 0)+1[/XD][/XR][XR][XD]C41[/XD][XD]=ROUNDDOWN((B41-1)/30, 0)+1[/XD][/XR][XR][XD]C42[/XD][XD]=ROUNDDOWN((B42-1)/30, 0)+1[/XD][/XR][XR][XD]C43[/XD][XD]=ROUNDDOWN((B43-1)/30, 0)+1[/XD][/XR][XR][XD]C44[/XD][XD]=ROUNDDOWN((B44-1)/30, 0)+1[/XD][/XR][XR][XD]D12[/XD][XD]=$C$9[/XD][/XR][XR][XD]D13[/XD][XD]=G12+IF(MOD(B12,30)=0,ROUND(I12,2),0)[/XD][/XR][XR][XD]D14[/XD][XD]=G13+IF(MOD(B13,30)=0,ROUND(I13,2),0)[/XD][/XR][XR][XD]D15[/XD][XD]=G14+IF(MOD(B14,30)=0,ROUND(I14,2),0)[/XD][/XR][XR][XD]D16[/XD][XD]=G15+IF(MOD(B15,30)=0,ROUND(I15,2),0)[/XD][/XR][XR][XD]D17[/XD][XD]=G16+IF(MOD(B16,30)=0,ROUND(I16,2),0)[/XD][/XR][XR][XD]D18[/XD][XD]=G17+IF(MOD(B17,30)=0,ROUND(I17,2),0)[/XD][/XR][XR][XD]D19[/XD][XD]=G18+IF(MOD(B18,30)=0,ROUND(I18,2),0)[/XD][/XR][XR][XD]D20[/XD][XD]=G19+IF(MOD(B19,30)=0,ROUND(I19,2),0)[/XD][/XR][XR][XD]D21[/XD][XD]=G20+IF(MOD(B20,30)=0,ROUND(I20,2),0)[/XD][/XR][XR][XD]D22[/XD][XD]=G21+IF(MOD(B21,30)=0,ROUND(I21,2),0)[/XD][/XR][XR][XD]D23[/XD][XD]=G22+IF(MOD(B22,30)=0,ROUND(I22,2),0)[/XD][/XR][XR][XD]D24[/XD][XD]=G23+IF(MOD(B23,30)=0,ROUND(I23,2),0)[/XD][/XR][XR][XD]D25[/XD][XD]=G24+IF(MOD(B24,30)=0,ROUND(I24,2),0)[/XD][/XR][XR][XD]D26[/XD][XD]=G25+IF(MOD(B25,30)=0,ROUND(I25,2),0)[/XD][/XR][XR][XD]D27[/XD][XD]=G26+IF(MOD(B26,30)=0,ROUND(I26,2),0)[/XD][/XR][XR][XD]D28[/XD][XD]=G27+IF(MOD(B27,30)=0,ROUND(I27,2),0)[/XD][/XR][XR][XD]D29[/XD][XD]=G28+IF(MOD(B28,30)=0,ROUND(I28,2),0)[/XD][/XR][XR][XD]D30[/XD][XD]=G29+IF(MOD(B29,30)=0,ROUND(I29,2),0)[/XD][/XR][XR][XD]D31[/XD][XD]=G30+IF(MOD(B30,30)=0,ROUND(I30,2),0)[/XD][/XR][XR][XD]D32[/XD][XD]=G31+IF(MOD(B31,30)=0,ROUND(I31,2),0)[/XD][/XR][XR][XD]D33[/XD][XD]=G32+IF(MOD(B32,30)=0,ROUND(I32,2),0)[/XD][/XR][XR][XD]D34[/XD][XD]=G33+IF(MOD(B33,30)=0,ROUND(I33,2),0)[/XD][/XR][XR][XD]D35[/XD][XD]=G34+IF(MOD(B34,30)=0,ROUND(I34,2),0)[/XD][/XR][XR][XD]D36[/XD][XD]=G35+IF(MOD(B35,30)=0,ROUND(I35,2),0)[/XD][/XR][XR][XD]D37[/XD][XD]=G36+IF(MOD(B36,30)=0,ROUND(I36,2),0)[/XD][/XR][XR][XD]D38[/XD][XD]=G37+IF(MOD(B37,30)=0,ROUND(I37,2),0)[/XD][/XR][XR][XD]D39[/XD][XD]=G38+IF(MOD(B38,30)=0,ROUND(I38,2),0)[/XD][/XR][XR][XD]D40[/XD][XD]=G39+IF(MOD(B39,30)=0,ROUND(I39,2),0)[/XD][/XR][XR][XD]D41[/XD][XD]=G40+IF(MOD(B40,30)=0,ROUND(I40,2),0)[/XD][/XR][XR][XD]D42[/XD][XD]=G41+IF(MOD(B41,30)=0,ROUND(I41,2),0)[/XD][/XR][XR][XD]D43[/XD][XD]=G42+IF(MOD(B42,30)=0,ROUND(I42,2),0)[/XD][/XR][XR][XD]D44[/XD][XD]=G43+IF(MOD(B43,30)=0,ROUND(I43,2),0)[/XD][/XR][XR][XD]G12[/XD][XD]=D12+E12-F12[/XD][/XR][XR][XD]G13[/XD][XD]=D13+E13-F13[/XD][/XR][XR][XD]G14[/XD][XD]=D14+E14-F14[/XD][/XR][XR][XD]G15[/XD][XD]=D15+E15-F15[/XD][/XR][XR][XD]G16[/XD][XD]=D16+E16-F16[/XD][/XR][XR][XD]G17[/XD][XD]=D17+E17-F17[/XD][/XR][XR][XD]G18[/XD][XD]=D18+E18-F18[/XD][/XR][XR][XD]G19[/XD][XD]=D19+E19-F19[/XD][/XR][XR][XD]G20[/XD][XD]=D20+E20-F20[/XD][/XR][XR][XD]G21[/XD][XD]=D21+E21-F21[/XD][/XR][XR][XD]G22[/XD][XD]=D22+E22-F22[/XD][/XR][XR][XD]G23[/XD][XD]=D23+E23-F23[/XD][/XR][XR][XD]G24[/XD][XD]=D24+E24-F24[/XD][/XR][XR][XD]G25[/XD][XD]=D25+E25-F25[/XD][/XR][XR][XD]G26[/XD][XD]=D26+E26-F26[/XD][/XR][XR][XD]G27[/XD][XD]=D27+E27-F27[/XD][/XR][XR][XD]G28[/XD][XD]=D28+E28-F28[/XD][/XR][XR][XD]G29[/XD][XD]=D29+E29-F29[/XD][/XR][XR][XD]G30[/XD][XD]=D30+E30-F30[/XD][/XR][XR][XD]G31[/XD][XD]=D31+E31-F31[/XD][/XR][XR][XD]G32[/XD][XD]=D32+E32-F32[/XD][/XR][XR][XD]G33[/XD][XD]=D33+E33-F33[/XD][/XR][XR][XD]G34[/XD][XD]=D34+E34-F34[/XD][/XR][XR][XD]G35[/XD][XD]=D35+E35-F35[/XD][/XR][XR][XD]G36[/XD][XD]=D36+E36-F36[/XD][/XR][XR][XD]G37[/XD][XD]=D37+E37-F37[/XD][/XR][XR][XD]G38[/XD][XD]=D38+E38-F38[/XD][/XR][XR][XD]G39[/XD][XD]=D39+E39-F39[/XD][/XR][XR][XD]G40[/XD][XD]=D40+E40-F40[/XD][/XR][XR][XD]G41[/XD][XD]=D41+E41-F41[/XD][/XR][XR][XD]G42[/XD][XD]=D42+E42-F42[/XD][/XR][XR][XD]G43[/XD][XD]=D43+E43-F43[/XD][/XR][XR][XD]G44[/XD][XD]=D44+E44-F44[/XD][/XR][XR][XD]H12[/XD][XD]=$C$8*G12[/XD][/XR][XR][XD]H13[/XD][XD]=$C$8*G13[/XD][/XR][XR][XD]H14[/XD][XD]=$C$8*G14[/XD][/XR][XR][XD]H15[/XD][XD]=$C$8*G15[/XD][/XR][XR][XD]H16[/XD][XD]=$C$8*G16[/XD][/XR][XR][XD]H17[/XD][XD]=$C$8*G17[/XD][/XR][XR][XD]H18[/XD][XD]=$C$8*G18[/XD][/XR][XR][XD]H19[/XD][XD]=$C$8*G19[/XD][/XR][XR][XD]H20[/XD][XD]=$C$8*G20[/XD][/XR][XR][XD]H21[/XD][XD]=$C$8*G21[/XD][/XR][XR][XD]H22[/XD][XD]=$C$8*G22[/XD][/XR][XR][XD]H23[/XD][XD]=$C$8*G23[/XD][/XR][XR][XD]H24[/XD][XD]=$C$8*G24[/XD][/XR][XR][XD]H25[/XD][XD]=$C$8*G25[/XD][/XR][XR][XD]H26[/XD][XD]=$C$8*G26[/XD][/XR][XR][XD]H27[/XD][XD]=$C$8*G27[/XD][/XR][XR][XD]H28[/XD][XD]=$C$8*G28[/XD][/XR][XR][XD]H29[/XD][XD]=$C$8*G29[/XD][/XR][XR][XD]H30[/XD][XD]=$C$8*G30[/XD][/XR][XR][XD]H31[/XD][XD]=$C$8*G31[/XD][/XR][XR][XD]H32[/XD][XD]=$C$8*G32[/XD][/XR][XR][XD]H33[/XD][XD]=$C$8*G33[/XD][/XR][XR][XD]H34[/XD][XD]=$C$8*G34[/XD][/XR][XR][XD]H35[/XD][XD]=$C$8*G35[/XD][/XR][XR][XD]H36[/XD][XD]=$C$8*G36[/XD][/XR][XR][XD]H37[/XD][XD]=$C$8*G37[/XD][/XR][XR][XD]H38[/XD][XD]=$C$8*G38[/XD][/XR][XR][XD]H39[/XD][XD]=$C$8*G39[/XD][/XR][XR][XD]H40[/XD][XD]=$C$8*G40[/XD][/XR][XR][XD]H41[/XD][XD]=$C$8*G41[/XD][/XR][XR][XD]H42[/XD][XD]=$C$8*G42[/XD][/XR][XR][XD]H43[/XD][XD]=$C$8*G43[/XD][/XR][XR][XD]H44[/XD][XD]=$C$8*G44[/XD][/XR][XR][XD]I12[/XD][XD]=H12[/XD][/XR][XR][XD]I13[/XD][XD]=IF(MOD(B12,30)<>0,I12,0)+H13[/XD][/XR][XR][XD]I14[/XD][XD]=IF(MOD(B13,30)<>0,I13,0)+H14[/XD][/XR][XR][XD]I15[/XD][XD]=IF(MOD(B14,30)<>0,I14,0)+H15[/XD][/XR][XR][XD]I16[/XD][XD]=IF(MOD(B15,30)<>0,I15,0)+H16[/XD][/XR][XR][XD]I17[/XD][XD]=IF(MOD(B16,30)<>0,I16,0)+H17[/XD][/XR][XR][XD]I18[/XD][XD]=IF(MOD(B17,30)<>0,I17,0)+H18[/XD][/XR][XR][XD]I19[/XD][XD]=IF(MOD(B18,30)<>0,I18,0)+H19[/XD][/XR][XR][XD]I20[/XD][XD]=IF(MOD(B19,30)<>0,I19,0)+H20[/XD][/XR][XR][XD]I21[/XD][XD]=IF(MOD(B20,30)<>0,I20,0)+H21[/XD][/XR][XR][XD]I22[/XD][XD]=IF(MOD(B21,30)<>0,I21,0)+H22[/XD][/XR][XR][XD]I23[/XD][XD]=IF(MOD(B22,30)<>0,I22,0)+H23[/XD][/XR][XR][XD]I24[/XD][XD]=IF(MOD(B23,30)<>0,I23,0)+H24[/XD][/XR][XR][XD]I25[/XD][XD]=IF(MOD(B24,30)<>0,I24,0)+H25[/XD][/XR][XR][XD]I26[/XD][XD]=IF(MOD(B25,30)<>0,I25,0)+H26[/XD][/XR][XR][XD]I27[/XD][XD]=IF(MOD(B26,30)<>0,I26,0)+H27[/XD][/XR][XR][XD]I28[/XD][XD]=IF(MOD(B27,30)<>0,I27,0)+H28[/XD][/XR][XR][XD]I29[/XD][XD]=IF(MOD(B28,30)<>0,I28,0)+H29[/XD][/XR][XR][XD]I30[/XD][XD]=IF(MOD(B29,30)<>0,I29,0)+H30[/XD][/XR][XR][XD]I31[/XD][XD]=IF(MOD(B30,30)<>0,I30,0)+H31[/XD][/XR][XR][XD]I32[/XD][XD]=IF(MOD(B31,30)<>0,I31,0)+H32[/XD][/XR][XR][XD]I33[/XD][XD]=IF(MOD(B32,30)<>0,I32,0)+H33[/XD][/XR][XR][XD]I34[/XD][XD]=IF(MOD(B33,30)<>0,I33,0)+H34[/XD][/XR][XR][XD]I35[/XD][XD]=IF(MOD(B34,30)<>0,I34,0)+H35[/XD][/XR][XR][XD]I36[/XD][XD]=IF(MOD(B35,30)<>0,I35,0)+H36[/XD][/XR][XR][XD]I37[/XD][XD]=IF(MOD(B36,30)<>0,I36,0)+H37[/XD][/XR][XR][XD]I38[/XD][XD]=IF(MOD(B37,30)<>0,I37,0)+H38[/XD][/XR][XR][XD]I39[/XD][XD]=IF(MOD(B38,30)<>0,I38,0)+H39[/XD][/XR][XR][XD]I40[/XD][XD]=IF(MOD(B39,30)<>0,I39,0)+H40[/XD][/XR][XR][XD]I41[/XD][XD]=IF(MOD(B40,30)<>0,I40,0)+H41[/XD][/XR][XR][XD]I42[/XD][XD]=IF(MOD(B41,30)<>0,I41,0)+H42[/XD][/XR][XR][XD]I43[/XD][XD]=IF(MOD(B42,30)<>0,I42,0)+H43[/XD][/XR][XR][XD]I44[/XD][XD]=IF(MOD(B43,30)<>0,I43,0)+H44[/XD][/XR][XR][XD]B13[/XD][XD]=B12+1[/XD][/XR][XR][XD]B14[/XD][XD]=B13+1[/XD][/XR][XR][XD]B15[/XD][XD]=B14+1[/XD][/XR][XR][XD]B16[/XD][XD]=B15+1[/XD][/XR][XR][XD]B17[/XD][XD]=B16+1[/XD][/XR][XR][XD]B18[/XD][XD]=B17+1[/XD][/XR][XR][XD]B19[/XD][XD]=B18+1[/XD][/XR][XR][XD]B20[/XD][XD]=B19+1[/XD][/XR][XR][XD]B21[/XD][XD]=B20+1[/XD][/XR][XR][XD]B22[/XD][XD]=B21+1[/XD][/XR][XR][XD]B23[/XD][XD]=B22+1[/XD][/XR][XR][XD]B24[/XD][XD]=B23+1[/XD][/XR][XR][XD]B25[/XD][XD]=B24+1[/XD][/XR][XR][XD]B26[/XD][XD]=B25+1[/XD][/XR][XR][XD]B27[/XD][XD]=B26+1[/XD][/XR][XR][XD]B28[/XD][XD]=B27+1[/XD][/XR][XR][XD]B29[/XD][XD]=B28+1[/XD][/XR][XR][XD]B30[/XD][XD]=B29+1[/XD][/XR][XR][XD]B31[/XD][XD]=B30+1[/XD][/XR][XR][XD]B32[/XD][XD]=B31+1[/XD][/XR][XR][XD]B33[/XD][XD]=B32+1[/XD][/XR][XR][XD]B34[/XD][XD]=B33+1[/XD][/XR][XR][XD]B35[/XD][XD]=B34+1[/XD][/XR][XR][XD]B36[/XD][XD]=B35+1[/XD][/XR][XR][XD]B37[/XD][XD]=B36+1[/XD][/XR][XR][XD]B38[/XD][XD]=B37+1[/XD][/XR][XR][XD]B39[/XD][XD]=B38+1[/XD][/XR][XR][XD]B40[/XD][XD]=B39+1[/XD][/XR][XR][XD]B41[/XD][XD]=B40+1[/XD][/XR][XR][XD]B42[/XD][XD]=B41+1[/XD][/XR][XR][XD]B43[/XD][XD]=B42+1[/XD][/XR][XR][XD]B44[/XD][XD]=B43+1[/XD][/XR][/RANGE]You can see on the 31st that the accrued interest has compounded.
Click here to download from SkyDrive: http://sdrv.ms/14EmNjP
Click here to download from Google Drive: https://docs.google.com/file/d/0B62tNlIfVtGVdjBOUTNSRzltQ28/edit?usp=sharing
Last edited:
