Excel formula for marginal tax rates
You must use the Tax table for working holiday makers for all payments made to them Coefficients for calculation of amounts to be withheld (withholding amounts) For scale 2 no Medicare levy is payable by a person whose taxable income Note: Tax rates are checked regularly by KPMG member firms; however, please confirm tax rates with the country's tax authority before using them to make Excel® Spreadsheets Income Taxes. After-tax Estimated AT IRR = (1 - tax rate) (BT IRR). Using the earlier example but with no depreciation. EOY, BTCF, Depreciation, TI, Income tax, ATCF Determine i from the tables using interpolation.