Dear Tutors, Can you please be of help with this assignment.. Look up your Company?s Income Statement (e.g Walmart) in Yahoo Finance and create an
Dear Tutors,
Can you please be of help with this assignment..
Look up your Company?s Income Statement (e.g Walmart) in Yahoo Finance and create an Excel spreadsheet using the class template :3 IncomeStatementTemplate.xls. Provide the following information:
- 3 years of Income Statement data expressed in dollars - Common-size Income Statement - Average Tax Rate and Earnings Per Share
Provide your analysis and comments for the following: -Revenues, Expenses and Profit Measures including: Gross Profit Margin, Operating Profit Margin, and Net Profit Margin. - Note any unusual issues. - Would you invest in this company based on your analysis?
1. Bear Tracks, Inc., has current assets of $2,340, net fixed assets of $11,000, current liabilities of $1,435, and long-term debt of $4,150. What is the value of the shareholders' equity account for this firm? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Shareholders' equity $ How much is the company's net working capital? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Net working capital $ 2. Pharrell, Inc., has sales of $597,000, costs of $261,000, depreciation expense of $65,000, interest expense of $32,000, and a tax rate of 35 percent. What is the net income for this firm? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Net income $ 3. Pharrell, Inc., has sales of $599,000, costs of $259,000, depreciation expense of $64,000, interest expense of $31,000, and a tax rate of 30 percent. The firm paid out $43,000 in cash dividends. What is the addition to retained earnings? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Addition to retained earnings $ 4. Pharrell, Inc., has sales of $585,000, costs of $273,000, depreciation expense of $71,000, interest expense of $38,000, and a tax rate of 35 percent. The firm paid out $36,000 in cash dividends and has 40,000 shares of common stock outstanding. What is the earnings per share figure? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Earnings per share $ What is the dividends per share figure? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Dividends per share $ 5. The SGS Co. had $182,000 in taxable income. Use the rates from Table 2.3. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Calculate the company's income taxes. Income taxes $ 6. The SGS Co. had $243,000 in taxable income. Use the rates from Table 2.3. What is the average tax rate? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Average tax rate % What is the marginal tax rate? (Enter your answer as a percent rounded to the nearest whole number, e.g., 32.) Marginal tax rate 7. Hailey, Inc., has sales of $19,570, costs of $9,460, depreciation expense of $2,130, and interest expense of $1,620. Assume the tax rate is 35 percent. What is the operating cash flow, or OCF? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Operating cash flow $ 8. Rotweiler Obedience School's December 31, 2015, balance sheet showed net fixed assets of $1,755,000, and the December 31, 2016, balance sheet showed net fixed assets of $2,100,000. The company's 2016 income statement showed a depreciation expense of $327,000. What was the company's net capital spending for 2016? (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Net capital spending $ 9. The December 31, 2015, balance sheet of Maria's Tennis Shop, Inc., showed current assets of $1,145 and current liabilities of $935. The December 31, 2016, balance sheet showed current assets of $1,360 and current liabilities of $1,035. What was the company's 2016 change in net working capital, or NWC? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Change in net working capital $ 10. (Refer to Table 2.3.) Corporation Growth has $87,000 in taxable income, and Corporation Income has $8,700,000 in taxable income. a. What is the tax bill for each firm? (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Corporation Growth Corporation Income Tax bill $ $ b. Suppose both firms have identified a new project that will increase taxable income by $5,000. How much in additional taxes will each firm pay? (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Corporation Growth Corporation Income Additional taxes $ $