Please help me with all parts

Problem 15-1 (algorithmic) Question Help 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, 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 a Baseline Values Foreign corporate income tax rate b U.S. corporate income tax rate Foreign dividend withholding tax rate U.S. ownership in foreign firm Dividend payout rate of foreign firm Case 1 28% 36% 15% 100% 100% Case 2 45% 36% 0% 100% 100% d e 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 U.S. parent $3,300,000 (924,000) $2,376,000 0 2,376,000 2,376,000 356,400 $2,019,600 $3,300,000 (1,485,000) $1,815,000 0 1,815,000 1,815,000 0 $1,815,000 $2,376,000 924,000 $3,300,000 1,188,000 $1,815,000 1,485,000 $3,300,000 1,188,000 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 (924,000) (356,400) ($1,280,400) $0 92,400 $2,112,000 (1,485,000) (0) ($1,485,000) $0 297,000 $2,112,000 Print Done Problem 15-1 (algorithmic) Question Help 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, 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 a Baseline Values Foreign corporate income tax rate b U.S. corporate income tax rate Foreign dividend withholding tax rate U.S. ownership in foreign firm Dividend payout rate of foreign firm Case 1 28% 36% 15% 100% 100% Case 2 45% 36% 0% 100% 100% d e 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 U.S. parent $3,300,000 (924,000) $2,376,000 0 2,376,000 2,376,000 356,400 $2,019,600 $3,300,000 (1,485,000) $1,815,000 0 1,815,000 1,815,000 0 $1,815,000 $2,376,000 924,000 $3,300,000 1,188,000 $1,815,000 1,485,000 $3,300,000 1,188,000 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 (924,000) (356,400) ($1,280,400) $0 92,400 $2,112,000 (1,485,000) (0) ($1,485,000) $0 297,000 $2,112,000 Print Done