Wq.4. Dato for Oxford State Bank follow(Click the icon to view the data)Evaluate the common stock of Oxford State Bank as an investment Specifically, use the three stock ratios to determine whether the common stock has increased or decreased in atractiveness duringthe past year. Round to two decimal places.Begin by selecting the formula to calculate the pricelearnings ratioPricelearnings ratioData tableNet IncomeDividends CommonDividends-PreferredTotal Stockholders' Equity at Year-End (includes95,000 shares of common stock)Preferred StockMarket Price per Share of Common StockPrintDoneS202471,900 $22,00016,800770,000200,00010.50 S2023- X64,30022,00016,600GELES610,000200,00010.00

Ratio analysis is quantitive method of getting inside review of an organisation to compare data with…

Datafor Oxford State Bank follow (Click the icon to view the data) Evaluate the common stock of Oxford State Bank as an investment Specifically, use the three stock ratios to determine whether the common stock has increased or decreased in atractiveness during the past year Round to two decimal places Begin by selecting the formula to calculate the priceleamings ratio Pricelearnings ratio Data table Net Income Dividends-Common Dividends-Preferred Total Stockholders' Equity at Year-End (includes 95,000 shares of common stock) Preferred Stock Market Price per Share of Common Stock Print Done 5 2024 71,900 S 22,000 16,800 2023 S 16:50 S - X 64,300 22.000 16,800 720,000 610.000 200,000 200,000 10.00

Datafor Oxford State Bank follow (Click the icon to view the data) Evaluate the common stock of Oxford State Bank as an investment Specifically, use the three stock ratios to determine whether the common stock has increased or decreased in atractiveness during the past year Round to two decimal places Begin by selecting the formula to calculate the priceleamings ratio Pricelearnings ratio Data table Net Income Dividends-Common Dividends-Preferred Total Stockholders' Equity at Year-End (includes 95,000 shares of common stock) Preferred Stock Market Price per Share of Common Stock Print Done 5 2024 71,900 S 22,000 16,800 2023 S 16:50 S - X 64,300 22.000 16,800 720,000 610.000 200,000 200,000 10.00

College Accounting, Chapters 1-27

23rd Edition

ISBN:9781337794756

Author:HEINTZ, James A.

Publisher:HEINTZ, James A.

Chapter24: Analysis Of Financial Statements

Section: Chapter Questions

Problem 3SEA: ANALY SIS OF PROFITABILITY Based on the financial statement data in Exercise 24-1A, compute the...

See similar textbooks

Similar questions

Ratio Analysis Consider the following information. Required: Calculate the stockholder payout ratios. (Note: Round answers to two decimal places.) Calculate the stockholder profitability ratios. (Note: Round answers to two decimal places.)
The income statement, statement of retained earnings, and balance sheet for Santiago Systems are as follows: Includes both state and federal taxes. Refer to the information for Santiago Systems above. Required: Note: Round answers to four decimal places. 1. Calculate the average common stockholders equity. 2. Calculate the return on stockholders equity.
Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock Ais %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 2013 Stock A - 5% 17% - 6% Stock B 29% 21% - 1% 2012 7% 4% 2014 1% - 15% 2015 13% 20%
Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 20% 2013 - 1% - 13% Stock A Stock B 20% 12% - 9% Print 2012 8% 9% C Done 2014 4% - 9% 2015 11% 27% - X
The attached file contains hypothetical data for working this problem. Goodman Corporation’s and Landry Incorporated’s stock prices and dividends, along with the Market Index, are shown in the file. Stock prices are reported for December 31 of each year, and dividends reflect those paid during the year. The market data are adjusted to include dividends. Estimate Goodman’s and Landry’s betas as the slopes of regression lines with stock returns on the vertical axis (y-axis) and market return on the horizontal axis (x-axis). (Hint: use Excel’s SLOPE function.) Are these betas consistent with your graph?
Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A 2010 2011 2012 2013 2014 2015 - 1% 6% 2% -5% 4% 6% Stock B 20% 9% 8% -3% - 5% 21% Print Done ☑ Clear
From the information attached below, calculate: a. the average stock return from 20x1- 20x3. b. The standard deviation over the same period.
Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 2013 Stock A - 10% 20% - 5% Stock B 21% 7% - 3% 2012 5% 30% 2014 2% - 8% 2015 9% 25% I
a. Compute the current ratio for the current year. (Abbreviations used: STI = Short-term investments. Round your answer to two decimal places, X.XX.) Current ratio More Info a. Current ratio b. Cash ratio c. Acid-test ratio d. Inventory turnover e. Days' sales in inventory f. Days' sales in receivables g. Gross profit percentage Print Done Choose from any list or enter any number in the input fields a Financial Statements Balance Sheet: Cash Short-term Investments Net Accounts Receivables Merchandise Inventory Prepaid Expenses Total Current Assets Total Current Liabilities Income Statement: Net Credit Sales Cost of Goods Sold $ Current Year Preceding Year 15,000 $ 11,000 56,000 64,000 13,000 159,000 132,000 465,000 317,000 29,000 27,000 94,000 82,000 7,000 239,000 89,000
Using ratios to evaluate a stock investment Comparative financial statement data of Garfield Inc. follow: Market price of Garfield’s common stock:$69.36 at December 31 2018 and $38.04 at December 31, 2017. Common shares outstanding 14, 000 on December 31, 2018 and 12,000 on December 31 2017 and 2016. All sales are on credit. Requirements Compute the following ratios tor 2018 and 2017: a. current ratio b. Cash ratio c. Times-interest-earned ratio d. Inventory turnover e. Gross profit percentage f. Debt to equity ratio g. Rate of return on common stockholder’s equity h. Earnings per share of common stock i. Price/earnings ratio 2. Decide (a) whether Garfield’s ability to pat debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.
Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity Interest expense Income tax expense Total costs and expenses Net income Current Year $ 35,467 102,794 127,925 11,888 335,329 $ 613,403 For both the current year and one year ago, compute the following ratios: ه له مه له :. .: له The company's income statements for the Current Year and 1 Year Ago, follow. For Year Ended December 31 Sales Cost of goods sold Other operating expenses $ 149,683 117,626 162,500 183,594 $ 613,403 $ 486,429 247,201 Current Year 13,556 10,367 Vanu $ 797,424 Earnings per share Additional information about the company follows. Common stock market price, December 31, Current Year Common stock market price, December 31, 1 Year Ago Annual cash dividends per share…
Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity Interest expense Income tax expense Total costs and expenses Net income Current Year $ 35,467 102,794 127,925 11,888 335,329 $ 613,403 For both the current year and one year ago, compute the following ratios: ه له مه له :. .: له The company's income statements for the Current Year and 1 Year Ago, follow. For Year Ended December 31 Sales Cost of goods sold Other operating expenses $ 149,683 117,626 162,500 183,594 $ 613,403 $ 486,429 247,201 Current Year 13,556 10,367 Vanu $ 797,424 Earnings per share Additional information about the company follows. Common stock market price, December 31, Current Year Common stock market price, December 31, 1 Year Ago Annual cash dividends per share…