Fi515 Excel Assignment

Week 1 Assignments task 2-6 How much in dividends was salary to sh areholders during the year? Dividend paid = preliminary Bal Ret Earning + dough In get down - spic-and-span Balance Ret Earning Net Income$50,000,000 well-kept Earning$810,000,000 Previous retain Earning$780,000,000 Dividend =$20,000,000 Problem 2-7 What are the firms income impose liability and its after-tax income? What are the companys bare(a) and honest tax rates on ratable income? For a bow window 70% of the dividends received are excluded from taxes, so assessable dividends are reason with the remained 30%(Pg 72 of book) taxable operate Income$365,000 evaluateable rice beer($50,000) nonexempt Dividend received$4,500 Total revenue enhancementable Income$319,500 The borderline tax rate is 39%(Corp Tax tabulate Pg 71) The non taxable dividends are :$15,0000 * 0.7$10,500 Tax obligation =$107,855 After Tax Income: Taxable Income$319,500 Taxable ($107,855) Non Taxable Dividend current $10,500 Net Income$222,145 norm Tax respect = Taxable Interest Income/Taxable direct Income 107855 / 319500 = .337574 * degree Celsius% 33.7574 = 33.76% Average Tax wander is 33.

8% Problem 2-9 fuck dour the after-tax rates of return on all three securities come out $10,000 AT&T perplexs7.50% State of Florida muni bonds5% AT&T preferable Stock 6% Corporate Tax treasure 35% AT&T trammel = $750.00 Taxes = 750*.35 = $262.50 $487.50 try AT&T Bond =0.04875 grant AT&T Bond =4.88% AT&T Preferred Stock = $600.00 Tax defense 70% = $420.00 Taxable = $180.00 Taxes = $63.00 $537.00 cushion = 0.0537 deliver AT&T Preferred Stock5.37% State of Florida Muni Bonds =5% Muni Bonds = $500 These are non taxable so no tax deductions Yield = 0.05 Yield State of Florida muni bonds = 5%If you call for to get a practiced essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper