Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the required​ return.)

What is the arithmetic growth rate of the dividends for Davy's Crock Pot Stores​? (Round to two decimal​ places.)

What is the geometric growth rate of the dividends for Davy's Crock Pot Stores​? Round to two decimal​ places.)

What is the required rate of return for Davy's Crock Pot Stores​? Round to two decimal​ places.)

Sales of roof material, by quarter, since 2005 for Carolina Home Construction Inc. are shown below (in $ thousands).

1. Determine the typical seasonal patterns for sales using the ratio-to-moving-average method. (PLEASE DONOT USE EXCEL. PLEASE SHOW ALL MANUAL WORKINGS HOW DID YOU GET ANSWER IN THE TABLE)

2. Deseasonalize the data and determine the trend equation. PLEASE DONOT USE EXCEL. PLEASE SHOW ALL MANUAL WORKINGS HOW DID YOU GET ANSWER IN THE TABLE)

3. Project the sales for 2012, and then seasonally adjust each quarter.

Publicly traded corporations are required to file an annual report each year. Please locate an annual report for a publicly traded corporation. In your post, attach a copy of the latest annual report you found. Summarize what the company you chose does, and state what type of business this company is in. Would the company fall under the category of a service, merchandising, or manufacturing operation? Explain how this is evident in the financial statements. Summarize what you found in this annual financial filing.

300 words

Publicly traded corporations are required to file an annual report each year. Please locate an annual report for a publicly traded corporation. In your post, attach a copy of the latest annual report you found. Summarize what the company you chose does, and state what type of business this company is in. Would the company fall under the category of a service, merchandising, or manufacturing operation? Explain how this is evident in the financial statements. Summarize what you found in this annual financial filing.

300 words

Publicly traded corporations are required to file an annual report each year. Please locate an annual report for a publicly traded corporation. In your post, attach a copy of the latest annual report you found. Summarize what the company you chose does, and state what type of business this company is in. Would the company fall under the category of a service, merchandising, or manufacturing operation? Explain how this is evident in the financial statements. Summarize what you found in this annual financial filing.

300 words

Compute and Interpret Altman's Z-scores Following is selected financial information for ebay, for its fiscal years 2005 and 2006. (In millions, except per share data) 2006 2005 Current assets $ 4,972.59 $3,185.24 Current liabilities 2,518.39 1,484.93 Total assets 13,491.01 11,785.99 Total liabilities 2,584.38 1,736.00 Shares outstanding 1,364.51 1,400.18 Retained earnings 4,543.35 2,824.64 Stock price per share 31.07 44.22 Sales 5,967.74 4,550.40 Earnings before interest and taxes 1,444.77 1,450.18 Compute and interpret Altman Z-scores for the company for both years. (Do not round until your final answer; then round your answers to two decimal places.) 2006 z-score = Answer 2005 z-score = Answer.

Compute and Interpret Altman's Z-scores
Following is selected financial information for ebay, for its fiscal years 2005 and 2006.

Compute and interpret Altman Z-scores for the company for both years. (Do not round until your final answer; then round your answers to two decimal places.)
2006 z-score = Answer

2005 z-score = Answer

Compute and Interpret Liquidity, Solvency and Coverage Ratios
Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements.

(a) Compute Lockheed Martin's current ratio and quick ratio for 2005 and 2004. (Round your answers to two decimal places.)
2005 current ratio = Answer

2004 current ratio = Answer

2005 quick ratio = Answer
2004 quick ratio = Answer

Which of the following best describes the company's current ratio and quick ratio for 2005 and 2004?

The current ratio has increased while the quick ratio has decreased in the period from 2004 to 2005, which suggests the company has a shortage of liquid assets.

Both the current and quick ratios have decreased from 2004 to 2005. The company is fairly illiquid.

Both the current and quick ratios have increased from 2004 to 2005. The company is fairly liquid.

The current ratio has decreased while the quick ratio has increased in the period from 2004 to 2005, which suggests the company has a shortage of current assets.

(b) Compute total liabilities-to-equity ratios and total debt-to-equity ratios for 2005 and 2004. (Round your answers to two decimal places.)
2005 total liabilities-to-stockholders' equity = Answer
2004 total liabilities-to-stockholders' equity = Answer

2005 total debt-to-equity = Answer
2004 total debt-to-equity = Answer

Which of the following best describes the company's total liabilities-to-equity ratios and total debt-to-equity ratios for 2005 and 2004?

The total liabilities-to-equity ratio has decreased while the total debt-to-equity ratio has increased in the period from 2004 to 2005, which suggests the company has decreased the use of short-term debt financing.

The total liabilities-to-equity ratio has increased while the total debt-to-equity ratio has decreased in the period from 2004 to 2005, which suggests the company has increased the use of short-term debt financing.

Both the total liabilities-to-equity and total debt-to-equity ratios have increased from 2004 to 2005. These increases suggest that the company is less solvent.

Both the total liabilities-to-equity and total debt-to-equity ratios have decreased from 2004 to 2005. The difference between these two measures reveals that any solvency concerns would be for the short run.

(c) Compute times interest earned ratio, cash from operations to total debt ratio, and free operating cash flow to total debt ratios. (Round your answers to two decimal places.)
2005 times interest earned = Answer
2004 times interest earned = Answer

2005 cash from operations to total debt = Answer
2004 cash from operations to total debt = Answer

2005 free operating cash flow to total debt = Answer
2004 free operating cash flow to total debt = Answer

Which of the following describes the company's times interest earned, cash from operations to total debt, and free operating cash flow to total debt ratios for 2005 and 2004? (Select all that apply)
Answeryesno Lockheed Martin's free operating cash flow to total debt ratio increased slightly over the year 2005 due to increased cash flow from operations and decreased levels of debt.
Answeryesno Lockheed Martin's cash from operations to total debt ratio increased slightly over the year 2005 due to increased cash flow from operations and decreased levels of debt.
Answeryesno Lockheed Martin's times interest earned increased significantly during 2005, due to both an increase in profitability and a decrease in interest expense.
Answeryesno Lockheed Martin's times interest earned decreased significantly during 2005, due to both a decrease in profitability and an increase in interest expense.

(d) Summarize your findings in a conclusion about the company's credit risk. Do you have any concerns about the company's ability to meet its debt obligations?

Lockheed Martin's total debt-to-equity is very low, thus increasing any immediate solvency concerns. The company's ability to meet its debt requirements will depend on increasing short-term debt.

Lockheed Martin's quick ratio is very low, thus increasing immediate solvency concerns. The company's ability to meet its debt requirements will depend on liquidating inventories for emergency cash.

Lockheed Martin's times interest earned ratio is high, thus lessening any immediate solvency concerns. The company's ability to meet its debt requirements will depend on its continued profitability.

Lockheed Martin's total liabilities-to-equity is high, thus lessening any immediate solvency concerns. The company's ability to meet its debt requirements will depend on its use of equity financing.

Compute and Interpret Liquidity, Solvency and Coverage Ratios
Balance sheets and income statements for Lockheed Martin Corporation follow. Refer to these financial statements to answer the requirements.

(a) Compute Lockheed Martin's current ratio and quick ratio for 2005 and 2004. (Round your answers to two decimal places.)
2005 current ratio = Answer

2004 current ratio = Answer

2005 quick ratio = Answer

2004 quick ratio = Answer

Which of the following best describes the company's current ratio and quick ratio for 2005 and 2004?

The current ratio has increased while the quick ratio has decreased in the period from 2004 to 2005, which suggests the company has a shortage of liquid assets.

Both the current and quick ratios have decreased from 2004 to 2005. The company is fairly illiquid.

Both the current and quick ratios have increased from 2004 to 2005. The company is fairly liquid.

The current ratio has decreased while the quick ratio has increased in the period from 2004 to 2005, which suggests the company has a shortage of current assets.

(b) Compute total liabilities-to-equity ratios and total debt-to-equity ratios for 2005 and 2004. (Round your answers to two decimal places.)
2005 total liabilities-to-stockholders' equity = Answer

2004 total liabilities-to-stockholders' equity = Answer

2005 total debt-to-equity = Answer

2004 total debt-to-equity = Answer

Which of the following best describes the company's total liabilities-to-equity ratios and total debt-to-equity ratios for 2005 and 2004?

The total liabilities-to-equity ratio has decreased while the total debt-to-equity ratio has increased in the period from 2004 to 2005, which suggests the company has decreased the use of short-term debt financing.

The total liabilities-to-equity ratio has increased while the total debt-to-equity ratio has decreased in the period from 2004 to 2005, which suggests the company has increased the use of short-term debt financing.

Both the total liabilities-to-equity and total debt-to-equity ratios have increased from 2004 to 2005. These increases suggest that the company is less solvent.

Both the total liabilities-to-equity and total debt-to-equity ratios have decreased from 2004 to 2005. The difference between these two measures reveals that any solvency concerns would be for the short run.

(c) Compute times interest earned ratio, cash from operations to total debt ratio, and free operating cash flow to total debt ratios. (Round your answers to two decimal places.)
2005 times interest earned = Answer

2004 times interest earned = Answer

2005 cash from operations to total debt = Answer

2004 cash from operations to total debt = Answer

2005 free operating cash flow to total debt = Answer

2004 free operating cash flow to total debt = Answer

Which of the following describes the company's times interest earned, cash from operations to total debt, and free operating cash flow to total debt ratios for 2005 and 2004? (Select all that apply)
Answeryesno

Lockheed Martin's free operating cash flow to total debt ratio increased slightly over the year 2005 due to increased cash flow from operations and decreased levels of debt.
Answeryesno

Lockheed Martin's times interest earned decreased significantly during 2005, due to both a decrease in profitability and an increase in interest expense.
Answeryesno

Lockheed Martin's cash from operations to total debt ratio increased slightly over the year 2005 due to increased cash flow from operations and decreased levels of debt.
Answeryesno

Lockheed Martin's times interest earned increased significantly during 2005, due to both an increase in profitability and a decrease in interest expense.

(d) Summarize your findings in a conclusion about the company's credit risk. Do you have any concerns about the company's ability to meet its debt obligations?

Lockheed Martin's total debt-to-equity is very low, thus increasing any immediate solvency concerns. The company's ability to meet its debt requirements will depend on increasing short-term debt.

Lockheed Martin's quick ratio is very low, thus increasing immediate solvency concerns. The company's ability to meet its debt requirements will depend on liquidating inventories for emergency cash.

Lockheed Martin's times interest earned ratio is high, thus lessening any immediate solvency concerns. The company's ability to meet its debt requirements will depend on its continued profitability.

Lockheed Martin's total liabilities-to-equity is high, thus lessening any immediate solvency concerns. The company's ability to meet its debt requirements will depend on its use of equity financing.

1. Apple’s Worldwide Revenues from 2004 to 2019 is as follows:

1. Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in your spreadsheet.
2. Make the following forecasts for 2020. For all of them, use Mean Squared Error to determine which of the forecasts is the best. Make sure your answers are clearly labeled.
   1. Naïve forecast from one prior time period
   2. Calculate a 4-period moving average
   3. Calculate a 3-period moving average with the following weights for time t: time period t-1=0.8, t-2 = 0.15, t-3=.05
3. In the tab called Apple Smoothing, use the data from 3. to forecast 2020 using an alpha equal to 0.7, 0.8, and 0.9. Using MSE, which one offers the best estimate for 2020?
4. In the tab called Apple Regression, use the information from 3. and run a regression to determine your forecast for 2020
   1. Put your regression output in F1 of the same workbook.
   2. Calculate what your forecast is for 2020 in F21.
   3. How does well does this regression equation predict revenue? Write your answer in F22. In addition, explain what your numerical answer means in words.

PLEASE PROVIDE STEP BY STEP AND FORMULAS FOR EXCEL, THANK YOU