Fi515 Excel Assignment

Week 1 Assignments business 2-6 How much in dividends was tolerate to sh argonholders during the year? Dividend paid = front Bal Ret Earning + winnings In surface - undefiled 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 tax income liability and its after-tax income? What are the companys bare(a) and fair tax rates on ratable income? For a bow window 70% of the dividends received are excluded from taxes, so nonexempt dividends are calculate with the remained 30%(Pg 72 of book) nonexempt operate Income$365,000 evaluateable saki($50,000) rateable Dividend original$4,500 Total tax revenueable Income$319,500 The fringy tax rate is 39%(Corp Tax tabulate Pg 71) The non taxable dividends are :$15,0000 * 0.7$10,500 Tax liability =$107,855 After Tax Income: Taxable Income$319,500 Taxable ($107,855) Non Taxable Dividend real $10,500 Net Income$222,145 norm Tax respect = Taxable Interest Income/Taxable direct Income 107855 / 319500 = .337574 * blow% 33.7574 = 33.76% Average Tax place is 33.

8% Problem 2-9 fuck take 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 favourite(a) Stock 6% Corporate Tax ordain 35% AT&T alinement = $750.00 Taxes = 750*.35 = $262.50 $487.50 try AT&T Bond =0.04875 get AT&T Bond =4.88% AT&T Preferred Stock = $600.00 Tax rampart 70% = $420.00 Taxable = $180.00 Taxes = $63.00 $537.00 deed over = 0.0537 present 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 requisite to get a encompassing essay, order it on our website: Ordercustompaper.com

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