U01a1

This Excel document contains unique details and cells specific to the problems that you must use to derive your solutions. Where numeric solutions are expected, provide full detail of the process used to reach the solution using Excel. Where analysis is expected, use information from the textbook to inform your analysis, not replace it, incorporating creativity, critical thinking, and real-life perspectives. Cite all resource materials used in your analysis, using proper APA format. A thorough, professional presentation of your analysis and results is an important consideration. Enhance your presentation skills by using applicable tools such as tables, graphs, diagrams, and commentary as appropriate in all assignments in this course.

UNIT 1: TEXTBOOK PROBLEMS CHAPTER 2: PROBLEM 1 Current Assets Net Fixed Assets Current Liabilities Long-Term Debt $7,300 $26,200 $5,700 $12,900 Shareholder Equity = Net Working Capital = CHAPTER 2: PROBLEM 2 Sales Costs Depreciation Expense EBIT Interest Expense EBT Taxes @ 35% Net Income = Cash Dividends Addition to Retained Earnings = Tax Rate = Income Statement $675,300 $297,800 $45,100 $20,700 $62,000 35% CHAPTER 2: PROBLEM 4 Taxable Income $315,000 Table 2.3 Income Taxes = Average Tax Rate = Marginal Tax Rate = Taxable Income Taxable Income (cont) Tax Rate 0 50,001 75,001 100,001 335,001 10,000,001 15,000,001 18,333,334 50,000 75,000 100,000 335,000 10,000,000 15,000,000 18,333,333 + 15% 25% 34% 39% 34% 35% 38% 35% (Note: No formula needed. Just inpu CHAPTER 2: PROBLEM 5 Sales Costs Depreciation Expense EBIT Interest Expense EBT Taxes @ 40% Net Income Tax Rate $29,200 $10,400 $1,800 $1,050 40% Operating Cash Flow = CHAPTER 3: PROBLEM 2 Debt/Equity Ratio Return on Assets Total Equity 0.65 9.80% $850,000 Equity Multiplier = Return on Equity = Net Income = CHAPTER 3: PROBLEM 6 ROE Payout Ratio Retention Ratio Sustainable Growth Rate = 16% 25% (Note: You must calculate the retent te: No formula needed. Just input the correct rate from the Tax Rate column.) te: You must calculate the retention ratio first then the sustainable growth rate.)