The Royal Corp has a defined benefit pension plan. As of January 1, 2019, the company had a Projected Benefit Obligation (PBO) of $80 million and Plan Assets of $75 million. The beginning balance of Prior Service Cost – AOCI is $2.5 million and the Net Gain – AOCI beginning balance is $1.2 million (2019 amortization: $.14 million).

The following data relates to the plan for the company’s current fiscal year, ended December 31, 2019.

$’s in millions Actual Return on Assets $6.2 Amortization of Prior Service Cost .7
Service Cost 3.2
Benefits Paid to Retirees 4.1 Contribution 3.8
Prior service cost amortization .7

Expected Rate of Return 7.0% Discount Rate 5.5%

REQUIRED: Complete the pension worksheet (provided in the Excel file) for the current fiscal year, 2019.

Please show computations if possible & be clear, Thank you!

Complete both a trend and comparative analysis for Kohls. Comment on their liquidity position, asset utilization, debt management, and profitability over time and vs. competitors. Is Kohls in a stronger or weaker financial position than its average competitor? Why?

The data in the table is the number of absences for 7 students and their corresponding grade.

Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=4.1440 and b1=−0.3047 for the calculations. Round your answer to three decimal places.

Step 2 of 5: Calculate the estimated variance of errors, Round your answer to three decimal places.

Step 3 of 5: Calculate the estimated variance of slope, . Round your answer to three decimal places.

Step 4 of 5: Construct the 95% confidence interval for the slope. Round your answers to three decimal places.

Step 5 of 5: Construct the 90% confidence interval for the slope. Round your answers to three decimal places.

Table below shows the multiple logistic regression for factors associated with having three or more cardiovascular disease risk factors among a population of 500 participants who participated in a cross-sectional survey.

Table 4. Multiple Logistic Regression for the predictors of having three or more Cardio Vascular Disease risk factors (N=500)

Which variable(s) is considered to be statistically significant? Interpret the odds ratio and the 95% confidence interval for the significant variable(s). [PROVIDE JUSTIFICATION(S) AND RATIONALES]

I need to have this done within 1 hour and a half. Thank YOU!:)

17. Minnesota Department of Health wants to test the claim that variability in COVID-19 within Minnesota is greater than 12.75. For this, they took a sample of 25 days data and found that the mean is 215 and standard deviation was 14.17. At alpha=5% what will be the decision?  

Question 17 options:

21. To test the claim that mean weight is not equal to 156.3 lbs., a sample of 14 people showed that the sample mean was 172.55 and the sample standard deviation (s) was found to be 26.33 lbs. Find the p value for this test (note that population standard deviation sigma is unknown so that this is t-test).

Question 21 options:

*PLEASE SHOW ALL WORK FOR EVERY QUESTION*

QUESTION 1:

An investor purchased a bond one year ago for $980. He received $17 in interest and sold the bond for $987. What is the holding-period return on his investment?

Note: Express your answer as a percentage with no percentage sign.

QUESTION 2:
The stock of company XYZ currently trades at $190 and just paid a dividend of $3.8. Suppose that your expectations regarding the stock price and dividends next year are as follows:

A: Compute the expected rate of return of XYZ. Express your answer as a percentage with two decimals and no percentage sign.

B: Compute the standard deviation of the rate of return of XYZ. Express your answer as a percentage with two decimals and no percentage sign.

I need to have this done within half hour. Thank YOU!:)

17. Minnesota Department of Health wants to test the claim that variability in COVID-19 within Minnesota is greater than 12.75. For this, they took a sample of 25 days data and found that the mean is 215 and standard deviation was 14.17. At alpha=5% what will be the decision?  

Question 17 options:

21. To test the claim that mean weight is not equal to 156.3 lbs., a sample of 14 people showed that the sample mean was 172.55 and the sample standard deviation (s) was found to be 26.33 lbs. Find the p value for this test (note that population standard deviation sigma is unknown so that this is t-test).

Question 21 options:

Make-or-Buy Decision, Alternatives, Relevant Costs

Each year, Basu Company produces 19,000 units of a component used in microwave ovens. An outside supplier has offered to supply the part for $1.18. The unit cost is:

Required:

1. What are the alternatives for Basu Company?

2. Assume that none of the fixed cost is avoidable. List the relevant cost(s) of internal production.

List the relevant cost(s) of external purchase.

3. Which alternative is more cost effective and by how much?

  by $

4. What if $21,200 of fixed overhead is rental of equipment used only in production of the component that can be avoided if the component is purchased? Which alternative is more cost effective and by how much?
  by $

A study was designed to compare the mortality rate of two drugs – Drug A and Drug B. There were 7720 patients assigned to Drug A and 7780 patients assigned to Drug B (randomly assigned). The mortality rate in Drug A was 5.4% and the mortality rate in drug B was 3.8%. Use to test whether the mortality rates across the two drugs are significantly different.

Round your solution to two significant digits after decimal.

a. Specify the null and alternate hypothesis using appropriate notation. (1 point)

b. Compute the test statistic. (4 points)

c. Compute the p-value based on test statistic obtained in part b. (2 points)

d. Based on the p-value obtained in part c) specify your decision regarding the null hypothesis. (1 point)

e. Interpret the findings based on part d) in the context of this question. (2 point)

use Excel : The Mann company belongs to a risk class for which the appropriate discount rate is 10%. The company currently has 260,000 outstanding shares selling at $107 each. The firm is contemplating the declaration of a $4 dividend at the end of the fiscal year that just began. Assume there are no taxes on dividends. Answer the following questions based on the Miller and Modigliani model, which is discussed in the text.

A. What will be the price of the stock on the ex-dividend date if the dividend is declared?

B. What will be the price of the stock at the end of the year if the dividend is not declared?

C. If the company makes $3.8 million of new investments at the beginning of the period, earns net income of $1.75 million, and pays the dividend at the end of the year, how many shares of new stock must the firm issue to meet its funding needs?

D. Is it realistic to use the MM model in the real world to value stock? Why or why not?