@extends('layouts.app') @section('title', 'Repayment Schedule - ' . $loan->loan_number) @section('content')
Loan Summary
{{ $loan->client->first_name }} {{ $loan->client->last_name }}
${{ number_format($loan->amount, 2) }}
${{ number_format($loan->outstanding_balance, 2) }}
{{ $loan->interest_rate }}%
{{ $loan->duration_months }} months
${{ number_format($loan->monthly_payment, 2) }}
Progress Overview
@php $totalPaid = $loan->repayments->sum('amount'); $progressPercentage = $loan->total_repayment > 0 ? ($totalPaid / $loan->total_repayment) * 100 : 0; @endphp
Repayment Progress {{ number_format($progressPercentage, 1) }}%
${{ number_format($totalPaid, 2) }}
Total Paid
${{ number_format($loan->outstanding_balance, 2) }}
Outstanding
${{ number_format($loan->total_repayment, 2) }}
Total Repayment
{{ $loan->duration_months }}
Total Months
@php $paidCount = 0; $dueCount = 0; $overdueCount = 0; $pendingCount = 0; foreach ($schedule as $installment) { if ($installment['status'] === 'paid') $paidCount++; elseif ($installment['status'] === 'due') $dueCount++; elseif ($installment['status'] === 'overdue') $overdueCount++; else $pendingCount++; } $paymentStats = [ 'paid_count' => $paidCount, 'due_count' => $dueCount, 'overdue_count' => $overdueCount, 'pending_count' => $pendingCount ]; @endphp

{{ $paymentStats['paid_count'] }}

Paid

{{ $paymentStats['due_count'] }}

Due

{{ $paymentStats['overdue_count'] }}

Overdue

{{ $paymentStats['pending_count'] }}

Pending

Repayment Schedule
@php $runningBalance = $loan->amount; $totalPrincipal = 0; $totalInterest = 0; $totalDue = 0; $totalPaid = 0; @endphp @foreach($schedule as $installment) @php $principal = $loan->total_repayment > 0 ? $installment['due_amount'] * ($loan->amount / $loan->total_repayment) : 0; $interest = $installment['due_amount'] - $principal; $dueAmount = $installment['due_amount']; $paidAmount = $installment['paid_amount']; $balance = $dueAmount - $paidAmount; $totalPrincipal += $principal; $totalInterest += $interest; $totalDue += $dueAmount; $totalPaid += $paidAmount; @endphp @endforeach
# Due Date Principal Interest Total Due Amount Paid Balance Status
{{ $installment['installment_number'] }}
{{ $installment['due_date']->format('M d, Y') }}
{{ $installment['due_date']->diffForHumans() }}
${{ number_format($principal, 2) }} ${{ number_format($interest, 2) }} ${{ number_format($dueAmount, 2) }} ${{ number_format($paidAmount, 2) }} @if($balance > 0) ${{ number_format($balance, 2) }} @else $0.00 @endif {{ ucfirst($installment['status']) }}
Totals ${{ number_format($totalPrincipal, 2) }} ${{ number_format($totalInterest, 2) }} ${{ number_format($totalDue, 2) }} ${{ number_format($totalPaid, 2) }} ${{ number_format($totalDue - $totalPaid, 2) }}
Status Legend
Paid - Payment completed successfully
Due - Payment is currently due
Overdue - Payment is past due date
Pending - Future payment
@endsection