Did you know that you can use the SUBTOTAL Function to SUM filtered data in Excel? We all know filtering of data using either by inserting tables or by using filter feature in Sort and filter group. For general adding operation, we use SUM Function. But when we filter the data the total displayed is […]
Balance Sheet Vertical analysis means the vertical evaluation of Balance sheet and other financial statements in terms of relative percentage change in line items. While performing Balance sheet Vertical analysis, each amount from all 3 major categories of accounts in a balance sheet, viz; assets, liabilities and shareholder’s equities are represented as the proportion of […]
Returns the depreciation of an asset for a period based on the straight-line depreciation method.
Calculates the amount received at maturity for a fully invested security.
Rounds a number down to the nearest integer.