@php $less_amount = $purchases->accountControls->sum(function($accountControl) { return $accountControl->accounts->sum('balance'); }) @endphp {{-- --}}
Particular 2021
Sales {{-- {{ number_format($sale_amount = optional(optional($revenues)->accountControls)->sum(function($accountControl) {--}} {{-- return $accountControl->accounts->sum('balance');--}} {{-- }), 0) }}--}} {{ number_format($sale_amount = optional(optional($revenues)->accountControls->where('id','!=',47))->sum(function($accountControl) { return $accountControl->accounts->sum('balance'); }), 0) }}
{{-- @foreach ($revenues->accountControls as $accountControl)--}} @foreach ($revenues->accountControls->where('id','!=',47) as $accountControl) @foreach ($accountControl->accounts as $account) @endforeach @endforeach
{{ $account->name }} {{ number_format($account->balance, 2) }}
Less: Cost of Goods Sold {{ number_format($less_amount, 0) }}
@foreach ($purchases->accountControls as $accountControl) @foreach ($accountControl->accounts as $account) @endforeach @endforeach
{{ $account->name }} {{ number_format($account->balance, 2) }}
Gross Profit: {{ number_format($gross_profit = $sale_amount - $less_amount, 0) }}
 
Operating Expenses:
Administrative Expenses {{ number_format( $expense = $expenses->accountControls->sum(function($accountControl) { return $accountControl->accounts->sum('balance'); }), 0) }}
@foreach ($expenses->accountControls as $accountControl) @foreach ($accountControl->accounts as $account) @endforeach @endforeach
{{ $account->name }} {{ number_format($account->balance, 2) }}
Depreciation {{ number_format( $depreciation = $depreciations->accountControls->sum(function($accountControl) { return $accountControl->accounts->sum('balance'); }), 0) }}
@foreach ($depreciations->accountControls as $accountControl) @foreach ($accountControl->accounts as $account) @endforeach @endforeach
{{ $account->name }} {{ number_format($account->balance, 2) }}
Operating Profit: {{ number_format($operative_profit = $gross_profit - $expense - $depreciation, 0) }}
Add: Non-operating Income {{ number_format($none_operating_income = $equity->accountControls->sum(function($accountControl) {--}} {{-- return $accountControl->accounts->sum('balance');--}} {{-- }), 0) }} {{ number_format($none_operating_income = $revenues->accountControls->where('id','=',47)->sum(function($accountControl) { return $accountControl->accounts->sum('balance'); }), 0) }}
{{-- @foreach ($equity->accountControls as $accountControl)--}} {{-- @foreach ($accountControl->accounts as $account)--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @endforeach--}} {{-- @endforeach--}} {{-- @foreach ($revenues->accountControls as $accountControl)--}} @foreach ($revenues->accountControls->where('id','=',47) as $accountControl) @foreach ($accountControl->accounts as $account) @endforeach @endforeach
{{ $account->name }}--}} {{-- {{ number_format($account->balance, 2) }}--}} {{--
{{ $account->name }} {{ number_format($account->balance, 2) }}
Earnings Before Interest & Tax: {{ number_format($earning_interest_and_tax = $operative_profit + $none_operating_income, 0) }}
Less: Financial Expenses {{ $financial_expendex = 0 }}
Earnings Before Tax: {{ number_format($earning_before_tax = $earning_interest_and_tax + $financial_expendex, 0) }}
Less: Provision for Income Tax {{ $income_tax = 0 }}
Net Profit/(Loss) after Tax: {{ number_format($net_profit_and_loss = $earning_before_tax + $income_tax, 0) }}