Home > Software engineering >  Repayment date amount automatically filter out
Repayment date amount automatically filter out

Time:10-08


Name borrowing amount payment type % period (month) interest rate monthly reimbursement date
Zhang SAN's 900 A 1 3 January 11, 2000 15
Li si 2000 B 1.1 6 March 21, 2000, 25
Fifty and 1000 C 12 April 21, 2000, 1.2/

Based on EXCEL form a many people borrowing list ()
1. If the payment type for A is "monthly principal and interest" of A month=equal also borrowing amount (amount/month) + remaining repayment amount * of interest, the first month, zhang SAN (February 15, 2000) is the amount of 900/3 + 900 * 1%=390, 2 months (March 15, 2000) also 900/3 + (900-900/3) * 1%=360, 3 months (April 15, 2000) also 900/3 + (900-900/3-900/3) * 1%=330,
2. If the payment type for B is also "month interest due debt" for the monthly amount=amount * of interest, in the period of one-time also borrowing amount, bill every month since (April 25, 2000) attached to each month 25 the amount of interest has a total of 5 months=2000 * 1.1%=220, the 6th month of September 25, 2000, reimbursement amount=interest (2000 * 1.1%) + (2000), the loan amount
3. If the payment type for C is "maturing debt" fifty and borrowing date (April 21, 2000) first one-time return interest=1000 * * 12=144, 1.2% in the period (April 20, 2001) also borrowing amount 1000,


Requirements: according to the date of payment, such as today is April 15, 2000, statistical filter need payment today, then automatically amount,
Name reimbursement amount repayment date
Zhang SAN on April 15, 2000, 330
Old six * * on April 15, 2000,
Panax notoginseng on April 15, 2000,

By April 21, 2000 shows the
Name reimbursement amount repayment date
Fifty and 144 2 April 21, 000,
Potatoes on April 21, 2000, * *

By April 25, 2000 shows the
Name reimbursement amount repayment date
Li si 220 on April 25, 2000,
Cabbage * * on April 25, 2000,
,
,
,


  •  Tags:  
  • VBA
  • Related