Ysu are a shareholder in a Ccoporation. The corporation carns $2 per share befor
ID: 1170653 • Letter: Y
Question
Ysu are a shareholder in a Ccoporation. The corporation carns $2 per share before aves Once it has paid taxes it will distribute the rest of its earnings to you asa dividend The corporate tax rate is 40% and the personal tax rate on (both dividend and INm-dividend) itNeeme is 30%. How much is left for you after all taxes are paid? Earnings per share Corperate tax rate Personal ax rate 2.00 40% 30% Remaining after corporate tax Remaining after all taxes qairements 1. tn cel Dta, bhy using cell references, calculate the amount that is left after paying eursrate taves (t pt.) 2. In cell D1t, by using cell references, calculate the amount that is left after paying all taxes (1 pt.)Explanation / Answer
Remaining after Corporate Taxes , Formula =D6(1-D7)
The answer will be 1.2
Remaining after all Taxes , Formula =D10(1-D8)
The answer will be 0.84
D6,D7,D8,D10 here are the cell references for excel formulaes.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.