Philips, Inc has a debt ratio of 22.5% and ROE = 15%. What is Phillips? ROA? (Enter answer as a percent).

FI 3300 - CORPORATION FINANCE Take-Home Problem Set Two (THPS-2) Fall 2016 Directions: This problem set covers chapters 1, 3 and 4 in the textbook. Determine or compute an answer for each question/problem. After you have computed an answer for every question, enter your answers online via the \"quiz\" function entitled \"THPS-2 ANSWER SUBMISSION FORM.\" See the course calendar for when the answer submission form will open and close. I will post a detailed solution key to the problem set right after the Answer Submission Form closes. See the course calendar for the day(s) on which I will answer questions about these problems in the chat room. This is a take-home, open book, open notes financial statement analysis problem set. Work on this Assignment is to be yours alone - any discussion of either the questions on the assignment or your answers with anyone other than your instructor will be considered as cheating and, thus, as a violation of the GSU honor code. _______________________________________________ 1. The primary goal of the management of a publicly traded corporation should be to ______________. a. create jobs b. promote social good c. maximize profits d. maximize shareholder wealth e. minimize risk 2. In conducting a common-size analysis, every income statement item is divided by __________ and every balance sheet account is divided by __________. a. its corresponding base year balance sheet item; its corresponding base year income statement item. b. its corresponding base year income statement item; its corresponding base year balance sheet item. c. net sales or revenues; total assets. d. total assets; total liabilities and equity. e. total assets; net sales or revenues. 3. __________ is an accounting statement that lists a company's assets, liabilities and equity. The statement is a stock measure that displays these account values at a specific point in time. a. b. c. d. e. The income statement The balance sheet The statement of cash flows The sources and uses statement None of the above 4. According to the textbook, finance is divided into three separate subject areas. Two of the subject areas of finance are Corporate Financial Management and Financial Markets and Institutions. The third subject area of finance is: a. b. c. d. e. International Trade Banking Accounting Microeconomics None of the above 5. Which of the following are items/accounts that typically appear on a balance sheet? a. b. c. d. e. net sales, cost of goods sold, retained earnings cash, accounts receivable, inventories net sales, inventories, notes payable net sales, depreciation expense, advertising expense cash, depreciation expense, taxes 6. Which of the following would directly affect (either increase or decrease) net cash flow from operating activities (assuming all else remains constant)? Note: there more be more than one answer for this questions - record the letter of all that apply (this is an all or nothing answer). a. b. c. d. e. f. g. h. i. An increase in dividends paid. A decrease in accounts receivable. A decrease in notes payable (i.e., bank loans). An increase in inventory. An increase in accounts payable. An increase in retained earnings. A decrease in cash. A decrease in gross plant and equipment. An increase in accruals. 7. If a firm's net sales (i.e., revenue) increases, but total assets, its debt ratio, and its net profit margin and remain the same as they were before net sales increased, the firm's: a. ROE would not change. b. ROE could either increase or decrease depending on the interaction between the equity multiplier and the days payable ratio. c. ROE would increase. d. ROE would decrease. e. There is insufficient information to determine the effect on ROE. 8. Which of the following steps is most likely to decrease a company's cash conversion cycle (assume that none of the following actions has any impact on sales or COGS)? Note: there more be more than one answer for this questions - record the letter of all that apply (this is an all or nothing answer). a. Change its receivables policy from net 45 to net 35 (note that this action will decrease the firm's average collection period from 45 days to 35 days). b. Change its payables policy to pay bills in 30 days instead of in 40 days. c. Decrease the inventory conversion period from 50 days to 40 days. d. Reduce the firm's notes payable (i.e., bank loan) balance by 20%. e. None of the actions listed above will decrease the firm's cash conversion cycle. 9. Which of the following actions would decrease the current ratio (assuming an initial current ratio of 0.8, and current liabilities equal to $1,000,000)? a. Borrow $100,000 in short term debt and deposit this money (i.e., $100,000) into the firm's cash account. b. Borrow $200,000 in long-term debt to buy $200,000 worth of additional inventory. c. Borrow $50,000 of short-term debt and use the proceeds to pay all operating expenses sooner, thus lowering accruals (i.e., accrued expenses) by $50,000. d. Sell $250,000 of fixed assets to pay off an equal amount of long-term debt. e. None of the above - that is, none of the actions listed about will decrease the current ratio. 10. RedCap Manufacturing, Inc. is planning to borrow money by taking out a short term loan (i.e., increase notes payable) and depositing this money directly into the firm's checking account (i.e., increase cash). RedCap believes that this event will have no affect on either sales or costs, and therefore no affect on net income. All else constant, this new policy should cause the firm's quick ratio (assuming an initial quick ratio of 1.5) to: a. b. c. d. Decrease Increase No Change Not enough information is provided to answer this question. 11. BlueHat, Inc. is planning to use excess cash that the company has in its checking account (i.e., reduce cash) to pay off a long term loan balance. (i.e., decrease long-term debt). BlueHat believes that this event will have no affect on either sales or costs, and therefore no affect on net income. All else constant, this new policy should cause the firm's debt ratio (assuming an initial debt ratio of 45%) to: a. b. c. d. Decrease Increase No Change Not enough information is provided to answer this question. 12. GreenChapeau, Inc. is planning to increase its short-term loans (i.e., increase notes payable) to pay for an increase in the firm's basic inventory level (i.e., increase inventory). GreenChapeau believes that this event will have no affect on either sales or costs, and therefore no affect on net income. All else constant, this new policy should cause the firm's current ratio (assuming a current ratio of 0.75) to: a. b. c. d. Decrease Increase No Change Not enough information is provided to answer this question. All of the following questions are open-ended problems. You must compute an answer for every problem. For percentage answers, calculate your answer as a percent rounded to 2 decimal places. For example, you would record ROA = .1263974 as 12.64% (note that on D2L you will enter 12.64 without the percent sign). For dollar answers, round to the nearest dollar. For example, you would record $12,345.83943 as $12,346 (note that on D2L you will enter 12346 without a comma and without the dollar sign). 13. Felton Farm Supplies, Inc. has an ROA (return on assets) of 12 percent, total assets of $400,000 and a net profit margin of 4.5 percent. What are Felton Farm Supplies annual sales? 14. Krisle and Kringle's debt-to-total assets ratio is 0.54.4 (i.e., debt ratio = 54.4%). What is the company's debtto-equity ratio? (Enter answer as a ratio rounded to 2 decimal places - that is, do not convert to a percent; for example, enter 80/35 = 2.2857 as 2.29). 15. Philips, Inc has a debt ratio of 22.5% and ROE = 15%. What is Phillips' ROA? (Enter answer as a percent). 16. A firm has an ROA of 18% and a debt/equity ratio of 0.55. The firm's ROE is _________. (Enter answer as a percent). 17. Assume that XYZ, Inc. has: Debt ratio = 70% Net profit margin = 15% Return on assets (ROA) = 7.5% Find XYZ's Total Asset Turnover ratio. (Enter answer as a ratio - that is, do not convert to a percent). 18. Assume that your firm has ROA of 20.5%, ROE of 42% and Total Asset Turnover ratio of 3.5. Calculate the debt ratio for the firm. (Enter answer as a percent). USE THE DATA IN THE TABLE BELOW TO ANSWER QUESTIONS 19 - 24 (Assume all account figures are in dollars) Accounts payable Accounts receivable, net Accruals Cash Capital surplus Common stock Cost of goods sold Depreciation expense Interest expense Inventory (end of year) Long-term debt Net fixed assets Net sales Notes payable Operating expenses (excluding depreciation) Retained earnings Taxes 2014 440 1,810 95 120 1,120 1,000 6,610 1,550 140 5,720 3,890 7,530 10,750 800 1,680 7,835 250 2015 380 2,040 120 100 1,290 1,100 6,420 1,650 170 5,530 4,150 8,050 11,050 740 1,780 7,940 360 19. This company's operating profit margin (as a percent rounded to 1 decimal place) in 2014 was ________. 20. The total asset turnover ratio for this company in 2015 = _______. 21. ROE for 2015 is _____%. 22. Cash flow from operating activities in 2015 is $ _______. 23. Cash flow from investing activities in 2015 is $ _________. 24. Cash flow from financing activities in 2015 is $ _________. USE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS Mellon Company Balance Sheet For the Years Ending December 31, 2010 and 2011 (All figures in dollars) 2010 2011 Cash Account receivable Inventory 1,500 3,740 10,120 1,820 3,980 8,470 Total current assets Gross fixed assets (Accumulated depreciation) Net fixed assets 15,360 56,100 (9,590) 46,510 14,270 63,840 (11,000) 52,840 61,870 67,110 1,000 2,260 1,570 470 1,000 4,150 1,640 1,730 5,300 37,750 1,000 4,800 13,020 8,520 34,790 1,500 9,460 12,840 61,870 67,110 Total assets Notes payable Accounts payable Accruals Current portion of LT debt Total current liabilities Lont-term debt Common stock Paid in capital Retained earnings Total liabilities and equity Additional Data from 2011 Income Statement: Sales in 2011 Net income in 2011 25. Calculate the Cash flows from operating activities for 2011. 26. Calculate the Cash flows from investing activities for 2011. 27. Calculate the Cash flows from financing activities for 2011. 238,000 9,940 USE THE FOLLOWING INFORMATION TO CONSTRUCT A BALANCE SHEET TO ANSWER QUESTIONS 28 through 30 Sales Gross profit margin Inventory turnover ratio (Cost of goods sold/Inventory) Net profit margin Average collection period Return on equity $ 2,000,000 20% 25 4% 45 25% Accumulated depreciation Return on assets Accounts payable days Notes payable Gross fixed assets Percent of sales on credit (remainder are cash sales) $ $ $ 75,000 12.5% 18 18,000 400,000 80% NOTE: Assume a 360 day year for all ratios, etc. Assume that the only accounts on the balance sheet are those listed below. Fill in this chart with the data provided and then answer questions 28, 29 and 30. Cash ____________ Notes payable ____________ Accounts receivable ____________ Accounts payable ____________ Inventory ____________ Long-term debt ____________ Gross fixed assets ____________ Equity ____________ (Accumulated depreciation) ____________ Net fixed assets ____________ Total assets 28. Cash = ____________. 29. Long-term debt = ____________. 30. Total assets =____________. ____________ Total liab & equity ____________ USE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE SHEET BELOW TO ANSWER QUESTIONS 31 through 34 Number of shares outstanding Sales Gross profit margin Inventory turnover ratio Notes payable Net profit margin Return on assets 15,000 $ 200,000 20% 4 $ 8,000 15% 8% Average collection period (days) Accounts payable days Retained earnings (2010) Dividend payout ratio Accruals Current ratio Debt ratio 60 90 $ 23,700 80% $ 4,000 1.5 40% Note: Of total sales, 60 percent are on credit and the remainder are cash sales. Assume a 360-day year. All data in the table above, unless otherwise stated, is for the year 2015. Hodun, Inc. Balance Sheet for the Year Ending December 31, 2015 Cash __________ Notes payable __________ Accounts receivable __________ Accounts payable __________ Inventory __________ Accruals __________ Net fixed assets __________ Long-term debt __________ __________ Common stock ($2 par value) __________ Capital surplus __________ Retained earnings __________ Total assets Total liab. & equity 31. Cash = ____________. 32. Long-term debt = ____________. 33. Total assets =____________. 34. Capital surplus = __________. __________ USE THE FOLLOWING DATA TO ANSWER QUESTIONS 35 - 40 Annual Income Statements 2013 Sales 500,000 ???? COGS Gross profit 380,000 Oper. exp 225,000 15,000 Depreciation Operating profit 140,000 5,000 Interest exp. EBT 135,000 50,000 Taxes Net Income 85,000 2014 560,000 149,350 410,650 250,100 15,000 145,550 5,000 140,550 56,000 84,550 Annual Balance Sheets Cash Accounts rec Inventories Current Assets Net fixed assets Total Assets 2013 450,000 275,000 280,000 1,005,000 1,125,000 2,130,000 2014 478,500 250,000 325,000 1,053,500 ??? 2,293,500 Notes payable Accounts payable Accruals Current Liabilities Long-term debt Common stock @ ($0.25 par) Additional paid in capital Retained earnings Total Liabilities & Equity 150,000 90,000 15,000 255,000 1,000,000 25,000 500,000 350,000 2,130,000 125,000 115,000 25,000 265,000 1,050,000 28,500 570,000 380,000 2,293,500 35. Net fixed assets in 2014 were $__________. 36. COGS on the 2013 common-sized income statement was 24%. Therefore, COGS in 2013 was 37. The debt ratio for 2014 was ____%. 38. Cash flow from operations in 2014 was $________. 39. Cash flow from investing in 2014 was $__________. 40. Total dividends paid in 2014 was $_______