Morio Sacco - Money Market Accounts Report

Total Accounts: {{ $moneyMarketAccounts->count() }}

Active Accounts: {{ $moneyMarketAccounts->where('status', 'active')->count() }}

Total Principal Amount: {{ \App\Helpers\CurrencyHelper::format($moneyMarketAccounts->sum('principal_amount')) }}

Total Interest Earned: {{ \App\Helpers\CurrencyHelper::format($moneyMarketAccounts->sum('interest_earned')) }}

Total Portfolio Value: {{ \App\Helpers\CurrencyHelper::format($moneyMarketAccounts->sum('total_amount')) }}

Report Date: {{ date('Y-m-d H:i:s') }}

Generated By: {{ auth()->user()->full_name ?? 'System' }}

@foreach($moneyMarketAccounts as $account) @endforeach

ID	Account #	Member	Membership #	Principal	Rate	Type	Term	Interest	Total	Start Date	Maturity	Status
{{ $account->id }}	{{ $account->account_number }}	{{ $account->membership->user->full_name ?? 'N/A' }}	{{ $account->membership->membership_number ?? 'N/A' }}	{{ \App\Helpers\CurrencyHelper::format($account->principal_amount, $account->currency_code) }}	{{ number_format($account->interest_rate, 2) }}%	{{ ucfirst($account->interest_type) }}	{{ $account->term_months }}m	{{ \App\Helpers\CurrencyHelper::format($account->interest_earned, $account->currency_code) }}	{{ \App\Helpers\CurrencyHelper::format($account->total_amount, $account->currency_code) }}	{{ $account->start_date->format('M d, Y') }}	{{ $account->maturity_date->format('M d, Y') }}	{{ ucfirst($account->status) }}

Investment Summary

Average Interest Rate: {{ $moneyMarketAccounts->count() > 0 ? number_format($moneyMarketAccounts->avg('interest_rate'), 2) : 0 }}%

Average Term: {{ $moneyMarketAccounts->count() > 0 ? number_format($moneyMarketAccounts->avg('term_months'), 1) : 0 }} months

Highest Principal: {{ \App\Helpers\CurrencyHelper::format($moneyMarketAccounts->max('principal_amount')) }}

Most Profitable Account: {{ \App\Helpers\CurrencyHelper::format($moneyMarketAccounts->max('interest_earned')) }} interest earned

Accounts Nearing Maturity: {{ $moneyMarketAccounts->where('maturity_date', '<=', now()->addDays(30))->count() }}

Compound Interest Accounts: {{ $moneyMarketAccounts->where('interest_type', 'compound')->count() }}

{{ \App\Models\SystemSetting::get('system_name', 'Morio Sacco') }} Management System

{{ \App\Models\SystemSetting::get('contact_phone', '+254 700 000 000') }} | {{ \App\Models\SystemSetting::get('contact_email', 'info@morio-sacco.co.ke') }} | {{ \App\Models\SystemSetting::get('contact_address', 'Koinange Street, Nairobi, Kenya') }}

{{ \App\Models\SystemSetting::get('app_url', 'https://morio-sacco.co.ke') }} | Report generated on {{ now()->format('l, F j, Y \a\t g:i A') }} | Confidential Document