Tools › Finance and Business › Accounting

Accounting

2 tools in the Finance and Business area.

Depreciation (MACRS)

Depreciation schedules of a business asset by every common method: straight line, 150 % and 200 % declining balance with the switch to straight line, sum-of-years digits, units of production, and the United States tax methods of IRS Publication 946, MACRS GDS with the half-year, mid-quarter and mid-month conventions from Tables A-1 to A-7a and ADS straight line from Table A-8, with Section 179 expensing, the special (bonus) allowance and the convention rules for a disposal before the recovery period ends. The page shows the schedule of the chosen method, every method side by side with its book-value curve, the present value of each method's tax shield at the after-tax discount rate, the after-tax cash flow and NPV of the asset with the entered annual saving, the recapture or gain on disposal, and the book-against-tax difference with the deferred tax. The default case is a 100,000 seven-year property placed in service in August, whose MACRS percentages are Publication 946's own 7-year example (14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, 4.46 %).

1 worked example reproduced, listed on the tool page.

Financial Ratios and Statement Analysis

Ratio analysis of pasted income statement, balance sheet and cash-flow lines for up to five periods: liquidity (current, quick, cash), leverage (debt to equity and to assets, equity multiplier, interest and debt-service coverage, net debt), efficiency (asset, inventory, receivable and payable turnover with their days and the cash conversion cycle), profitability (gross, operating, EBITDA and net margins, ROA, ROE, ROIC with an entered tax rate), the three- and five-step DuPont decomposition, market ratios when price and shares are entered (EPS, P/E, EV/EBITDA, dividend yield, payout, price to book), growth rates with the sustainable and internal growth rates, common-size and trend-index statements, the Altman Z, Z-prime and Z-double-prime scores, the Beneish M-score, free cash flow to the firm and to equity, an EBITDA reconciliation, a working-capital bridge and a comparison against entered industry medians.

1 worked example reproduced, listed on the tool page.

Other Finance and Business sections

Finance · Economics and Damages · Personal Finance · Pricing · Marketing · Insurance · Operations and Capacity