| Particular | @if ($searchType == 1)Previous Year ({{$cashFlowStatementLoadTableArr['fiscalYearsSelected2']->name}}) |
Current Year ({{$cashFlowStatementLoadTableArr['fiscalYearsSelected1']->name}}) |
@elseif ($searchType == 2)
Current Month | Current Year ({{$cashFlowStatementLoadTableArr['fiscalYearsSelected1']->name}}) |
Cumulative | @endif||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A. Cash flows from operating activities | |||||||||||||||
| Surplus | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($pySurplusAmount)) }} | {{ App\Service\EasyCode::negativeReplace(round($cySurplusAmount)) }} | @else{{ App\Service\EasyCode::negativeReplace($pySurplusAmount) }} | {{ App\Service\EasyCode::negativeReplace($cySurplusAmount) }} | @endif|||||||||||
| Surplus | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($thisMonthSurplusAmount)) }} | {{ App\Service\EasyCode::negativeReplace(round($cySurplusAmount)) }} | {{ App\Service\EasyCode::negativeReplace(round($cumulativeSurplusAmount)) }} | @else{{ App\Service\EasyCode::negativeReplace($thisMonthSurplusAmount) }} | {{ App\Service\EasyCode::negativeReplace($cySurplusAmount) }} | {{ App\Service\EasyCode::negativeReplace($cumulativeSurplusAmount) }} | @endif|||||||||
| Add: Amount considered as non cash items Expenses | |||||||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['pyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['pyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | @endif|||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['thisMonthBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cumulativeBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['thisMonthBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cumulativeBalance']) }} | @endif|||||||||
| Sub-total of non cash items expenses | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalPYCashItemsExpenses)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYCashItemsExpenses)) }} | @else{{ App\Service\EasyCode::negativeReplace($subTotalPYCashItemsExpenses) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCYCashItemsExpenses) }} | @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalThisMonthCashItemsExpenses)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYCashItemsExpenses)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCumulativeCashItemsExpenses)) }} | @else{{ App\Service\EasyCode::negativeReplace($subTotalThisMonthCashItemsExpenses) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCYCashItemsExpenses) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCumulativeCashItemsExpenses) }} | @endif @endif|||||
| Less: Amount considered as non cash items income | |||||||||||||||
| {{ $nonCashItemsIncomeBalance['name'].' ['.$nonCashItemsIncomeBalance['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($nonCashItemsIncomeBalance['pyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($nonCashItemsIncomeBalance['cyBalance'])) }} | @else @if ($nonCashItemsIncomeBalance['pyBalance'] == 0){{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['pyBalance']) }} | @else({{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['pyBalance']) }}) | @endif @if ($nonCashItemsIncomeBalance['cyBalance'] == 0){{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['cyBalance']) }} | @else({{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['cyBalance']) }}) | @endif @endif|||||||||
| {{ $nonCashItemsIncomeBalance['name'].' ['.$nonCashItemsIncomeBalance['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($nonCashItemsIncomeBalance['thisMonthBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($nonCashItemsIncomeBalance['cyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($nonCashItemsIncomeBalance['cumulativeBalance'])) }} | @else @if ($nonCashItemsIncomeBalance['thisMonthBalance'] == 0){{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['thisMonthBalance']) }} | @else({{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['thisMonthBalance']) }}) | @endif @if ($nonCashItemsIncomeBalance['cyBalance'] == 0){{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['cyBalance']) }} | @else({{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['cyBalance']) }}) | @endif @if ($nonCashItemsIncomeBalance['cumulativeBalance'] == 0){{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['cumulativeBalance']) }} | @else({{ App\Service\EasyCode::negativeReplace($nonCashItemsIncomeBalance['cumulativeBalance']) }}) | @endif @endif||||||
| Sub-total of non cash items income | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalPYNonCashItemsIncome)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYNonCashItemsIncome)) }} | @else @if ($subTotalPYNonCashItemsIncome == 0){{ App\Service\EasyCode::negativeReplace($subTotalPYNonCashItemsIncome) }} | @else({{ App\Service\EasyCode::negativeReplace($subTotalPYNonCashItemsIncome) }}) | @endif @if ($subTotalCYNonCashItemsIncome == 0){{ App\Service\EasyCode::negativeReplace($subTotalCYNonCashItemsIncome) }} | @else({{ App\Service\EasyCode::negativeReplace($subTotalCYNonCashItemsIncome) }}) | @endif @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalThisMonthNonCashItemsIncome)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYNonCashItemsIncome)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCumulativeNonCashItemsIncome)) }} | @else @if ($subTotalThisMonthNonCashItemsIncome == 0){{ App\Service\EasyCode::negativeReplace($subTotalThisMonthNonCashItemsIncome) }} | @else({{ App\Service\EasyCode::negativeReplace($subTotalThisMonthNonCashItemsIncome) }}) | @endif @if ($subTotalCYNonCashItemsIncome == 0){{ App\Service\EasyCode::negativeReplace($subTotalCYNonCashItemsIncome) }} | @else({{ App\Service\EasyCode::negativeReplace($subTotalCYNonCashItemsIncome) }}) | @endif @if ($subTotalCumulativeNonCashItemsIncome == 0){{ App\Service\EasyCode::negativeReplace($subTotalCumulativeNonCashItemsIncome) }} | @else({{ App\Service\EasyCode::negativeReplace($subTotalCumulativeNonCashItemsIncome) }}) | @endif @endif @endif
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['pyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['pyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | @endif|||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['thisMonthBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cumulativeBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['thisMonthBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cumulativeBalance']) }} | @endif|||||||||
| Net cash used in Operating Activities | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($totalPYCashOperating)) }} | {{ App\Service\EasyCode::negativeReplace(round($totalCYCashOperating)) }} | @else{{ App\Service\EasyCode::negativeReplace($totalPYCashOperating) }} | {{ App\Service\EasyCode::negativeReplace($totalCYCashOperating) }} | @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($totalThisMonthCashOperating)) }} | {{ App\Service\EasyCode::negativeReplace(round($totalCYCashOperating)) }} | {{ App\Service\EasyCode::negativeReplace(round($totalCumulativeCashOperating)) }} | @else{{ App\Service\EasyCode::negativeReplace($totalThisMonthCashOperating) }} | {{ App\Service\EasyCode::negativeReplace($totalCYCashOperating) }} | {{ App\Service\EasyCode::negativeReplace($totalCumulativeCashOperating) }} | @endif @endif|||||
| B. Cash flows from Investing Activities | |||||||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['pyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['pyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | @endif|||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['thisMonthBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cumulativeBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['thisMonthBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cumulativeBalance']) }} | @endif|||||||||
| Net cash used in Investing Activities | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalPYNetCashInvesting)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYNetCashInvesting)) }} | @else{{ App\Service\EasyCode::negativeReplace($subTotalPYNetCashInvesting) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCYNetCashInvesting) }} | @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalThisMonthNetCashInvesting)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYNetCashInvesting)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCumulativeNetCashInvesting)) }} | @else{{ App\Service\EasyCode::negativeReplace($subTotalThisMonthNetCashInvesting) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCYNetCashInvesting) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCumulativeNetCashInvesting) }} | @endif @endif|||||
| C. Cash flows from Financing Activities | |||||||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['pyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['pyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | @endif|||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['thisMonthBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cumulativeBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['thisMonthBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cumulativeBalance']) }} | @endif|||||||||
| Net cash used in Financing Activities | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalPYNetCashFinancial)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYNetCashFinancial)) }} | @else{{ App\Service\EasyCode::negativeReplace($subTotalPYNetCashFinancial) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCYNetCashFinancial) }} | @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($subTotalThisMonthNetCashFinancial)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCYNetCashFinancial)) }} | {{ App\Service\EasyCode::negativeReplace(round($subTotalCumulativeNetCashFinancial)) }} | @else{{ App\Service\EasyCode::negativeReplace($subTotalThisMonthNetCashFinancial) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCYNetCashFinancial) }} | {{ App\Service\EasyCode::negativeReplace($subTotalCumulativeNetCashFinancial) }} | @endif @endif|||||
| D. Net cash increase/decrease (A+B+C) | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($pyNetCashIncreaseDecrease)) }} | {{ App\Service\EasyCode::negativeReplace(round($cyNetCashIncreaseDecrease)) }} | @else{{ App\Service\EasyCode::negativeReplace($pyNetCashIncreaseDecrease) }} | {{ App\Service\EasyCode::negativeReplace($cyNetCashIncreaseDecrease) }} | @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($thisMonthNetCashIncreaseDecrease)) }} | {{ App\Service\EasyCode::negativeReplace(round($cyNetCashIncreaseDecrease)) }} | {{ App\Service\EasyCode::negativeReplace(round($cumulativeNetCashIncreaseDecrease)) }} | @else{{ App\Service\EasyCode::negativeReplace($thisMonthNetCashIncreaseDecrease) }} | {{ App\Service\EasyCode::negativeReplace($cyNetCashIncreaseDecrease) }} | {{ App\Service\EasyCode::negativeReplace($cumulativeNetCashIncreaseDecrease) }} | @endif @endif|||||
| Add. {{ $item['name'].' ['.$item['code'].']' }} at Beginning of the year | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['pyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['pyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | @endif|||||||||||
| {{ $item['name'].' ['.$item['code'].']' }} | @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($item['thisMonthBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cyBalance'])) }} | {{ App\Service\EasyCode::negativeReplace(round($item['cumulativeBalance'])) }} | @else{{ App\Service\EasyCode::negativeReplace($item['thisMonthBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cyBalance']) }} | {{ App\Service\EasyCode::negativeReplace($item['cumulativeBalance']) }} | @endif|||||||||
| Cash And Bank Balance at the end of the year | @if ($searchType == 1) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($pyNetCashIncreaseDecrease + $netCashAndBankPreviousYear)) }} | {{ App\Service\EasyCode::negativeReplace(round($cyNetCashIncreaseDecrease + $netCashAndBankCurrentYear)) }} | @else{{ App\Service\EasyCode::negativeReplace($pyNetCashIncreaseDecrease + $netCashAndBankPreviousYear) }} | {{ App\Service\EasyCode::negativeReplace($cyNetCashIncreaseDecrease + $netCashAndBankCurrentYear) }} | @endif @elseif ($searchType == 2) @if ($roundUp == 1){{ App\Service\EasyCode::negativeReplace(round($thisMonthNetCashIncreaseDecrease + $netCashAndBankCurrentMonth)) }} | {{ App\Service\EasyCode::negativeReplace(round($cyNetCashIncreaseDecrease + $netCashAndBankCurrentYear)) }} | {{ App\Service\EasyCode::negativeReplace(round($cumulativeNetCashIncreaseDecrease + $netCashAndBankCumulative)) }} | @else{{ App\Service\EasyCode::negativeReplace($thisMonthNetCashIncreaseDecrease + $netCashAndBankCurrentMonth) }} | {{ App\Service\EasyCode::negativeReplace($cyNetCashIncreaseDecrease + $netCashAndBankCurrentYear) }} | {{ App\Service\EasyCode::negativeReplace($cumulativeNetCashIncreaseDecrease + $netCashAndBankCumulative) }} | @endif @endif|||||