| BILLS | MATERIALS | SERVICES | GDEPOSIT | PRINCIPAL | INT RATE | INT AMT | NET AMT | PENALTY | PAST DUE INT | TERMS | TERMS RMNG | AMT PAID | BALANCE | {{ number_format($loan->bills_amt,2,".",",") }} | {{ number_format($loan->materials_amt,2,".",",") }} | {{ number_format($loan->services_amt,2,".",",") }} | {{ number_format($loan->gdeposit_amt,2,".",",") }} | {{ number_format($loan->principal_amt,2,".",",") }} | {{ $loan->interest_rate }}% | {{ number_format($loan->interest_amt,2,".",",") }} | {{ number_format($loan->net_amt,2,".",",") }} | {{ number_format($loan->penalty_amt,2,".",",") }} | {{ number_format($loan->past_due_int_amt,2,".",",") }} | {{ $loan->terms }} | {{ $loan->terms_remaining }} | {{ number_format($loan->amt_paid,2,".",",") }} | {{ number_format($loan->amt_remaining,2,".",",") }} |
|---|
| COLLECTION DATE | PR NUMBER | TERM | PRINCIPAL | NET AMOUNT | PENALTY | PAST DUE INTEREST | AMOUNT PAID | PRINCIPAL BAL | OUTSTANDING BAL | |||
| {{ date_format(date_create($p->created_at), "M d, Y") }} | {{ $p->pr_number }} | {{ $p->term }} amortization | {{ number_format($p->principal_amt,2,".",",") }} | {{ number_format($p->net_amt,2,".",",") }} | {{ number_format($p->penalty_amt,2,".",",") }} | {{ number_format($p->past_due_int_amt,2,".",",") }} | {{ number_format($p->amt_paid,2,".",",") }} | {{ number_format($p->principal_bal,2,".",",") }} | {{ number_format($p->outstanding_bal,2,".",",") }} | |||
| NO PAYMENT(S) FOUND | ||||||||||||
| --}} | TOTAL AMOUNT PAID | {{ number_format($payment->sum('principal_amt'),2,".",",") }} | {{ number_format($payment->sum('net_amt'),2,".",",") }} | {{ number_format($payment->sum('penalty_amt'),2,".",",") }} | {{ number_format($payment->sum('past_due_int_amt'),2,".",",") }} | {{ number_format($payment->sum('amt_paid'),2,".",",") }} | ||||||