Avon's Foreign-Source Income. Avon is a U.S.-based direct seller of a wide array of products. Avon markets leading beauty, fashion, and home products in more than 100 countries. As part of the training in its corporate treasury offices, it has its interns build a spreadsheet analysis of the following hypothetical subsidiary earnings/distribution analysis. Use the tax analysis presented in the popup window for your basic structure,

LOADING...

.

a. What is the total tax payment, foreign and domestic combined, for this income?

b. What is the effective tax rate paid on this income by the U.S.-based parent company?

c. What would be the total tax payment and effective tax rate if the foreign corporate tax rate was 45% and there were no withholding taxes on dividends?

d. What would be the total tax payment and effective tax rate if the income was earned by a branch of the U.S. corporation?

* Data Table and there were no withholding ta e US corporation? a Case 1 30% 38% 15% 100% 100% Case 2 45% 38% 0% 100% 100% holding taxes on dividends? Eling taxes on dividends? Baseline Values Foreign corporate income tax rate b U.S. corporate income tax rate c Foreign dividend withholding tax rate d U.S. ownership in foreign firm e Dividend payout rate of foreign firm Foreign Subsidiary Tax Computation 1 Taxable income of foreign subsidiary 2 Foreign corporate income tax 3 Net income available for distribution 4 Retained earnings 5 Distributed earnings 6 Distribution to U.S. parent company 7 Withholding taxes on dividends 8 Net remittance to US parent U.S. Corporate Tax Computation on Foreign Income 9 Dividend received before withholding 10 Add back foreign deem-paid tax 11 Grossed-up foreign dividend 12 Tentative U.S. liability 13 Less credit for foreign taxes a foreign income taxes paid b foreign withholding taxes paid c total 14 Additional U.S. taxes due 15 Excess foreign tax credits 16 After-tax income from foreign subsidiary $3,300,000 (990,000) $2,310,000 0 2,310,000 2.310,000 346,500 $1,963,500 $3,300,000 (1,485,000) $1,815,000 0 1,815,000 1,815,000 0 $1,815,000 $2,310,000 990,000 $3,300,000 1.254,000 $1,815,000 1,485,000 $3,300,000 1.254,000 (990,000) (346,500) ($1,336,500) $0 82,500 $2,046,000 (1,485,000) (0) ($1,485.000) SO 231,000 $2,046,000 Print Done Bas a C d e a. What is the total tax payment, foreign and domestic combined for this income? b. What is the effective tax rate paid on this income by the US-based parent company? c. What would be the total tax payment and effective tax rate if the foreign corporate tax rate was 45% and there were no withholding ta d. What would be the total tax payment and effective tax rate if the income was earned by a branch of the U.S. corporation? a. What is the total tax payment, foreign and domestic combined for this income? (Round to the nearest dollar) b. What is the effective tax rate paid on this income by the US-based parent company? % (Round to one decimal place) c. What would be the total tax payment if the foreign corporate tax rate was 45% and there were no withholding taxes on dividends? s(Round to the nearest dollar.) What would be the effective tax rate if the foreign corporate tax rate was 45% and there were no withholding taxes on dividends? 1% (Round to one decimal place) d. What would be the total tax payment if the income was earned by a branch of the U.S. corporation? $(Round to the nearest dollar.) What would be the effective tax rate if the income was earned by a branch of the U.S. corporation? % (Round to one decimal place.) For 1 5 6 7 8 U.S 9 10 11 12 13 14 15 16