Loan Reconciliation

reconcile.awk

# Total Loan Amount		1500.00
# 
# Monthly Payment			20.78
# 
# Initial Rounding Adjustment	0.005000000
# 
# 	Loan			Raw		Rounding	Adjusted		Truncated
# Lender	Amounts	Percentages	Amount		Adjustment	Amount		Amount	Remainder
# 
# A1	50.00	0.033333.. 	0.69265974	[0.00500000]	0.69765974	0.69	0.00765974
# B1	50.00	0.033333..	0.69265974	0.00765974	0.70031948	0.70	0.00031948
# C1	50.00	0.033333..	0.69265974	0.00031948	0.69297922	0.69	0.00297922
# D1	50.00	0.033333..	0.69265974	0.00297922	0.69563896	0.69	0.00563896
# E1	100.00	0.066666..	1.38531948	0.00563896	1.39095844	1.39	0.00095844
# F1	250.00	0.166666..	3.46331948	0.00095844	3.46427792	3.46	0.00427792
# G1	264.00	0.176000	3.65728000	0.00427792	3.66155792	3.66	0.00155792
# H1	686.00	0.457333..	9.50337974	0.00155792	9.50493766	9.50	0.00493766
#