Calculate the sample covariance and also calculate the sample mean and variance for the advertising and sales variables.

Company ABC has liabilities of 20,000, 50,000, and 70,000 due at the end of years 1, 2, and 3 respectively. The company would like to exactly match these liabilities using the following assets:

A one-year zero coupon bond with a yield of 4%

A two-year zero coupon bond with a yield of 5%

A three-year coupon bond with annual coupons of 6% and a yield of 5.5%

What is the total cost of the asset portfolio that will match the liabilities?

Please answer as soon as possible!!!

Thank you

7. Refinancing decision. Two years ago Peter borrowed from a bank 40 000 euros for 6 years. The interest rate for the bank loan was 9% and the repayment schedule is based on monthly annuity payments. Now, after two years have passed, the interest rates have declined and his economic situation has improved (e.g. interest margin declined). Peter now has an opportunity to refinance the remaining loan balance with a 4% interest rate. However, there is a catch. The fee for refinancing is 700 euros paid upfront.

Questions:

1. Find the initial monthly loan payment
2. Find the loan balance after two years
3. Now find the new monthly payment if loan is refinanced
4. Should Peter refinance? (Hint: Compare the refinancing fee with present value of savings)

MUST BE DONE IN C (NOT C++))

Here, we will create a structure that resembles a university’s profile (you can pick any university name, just so long as the program runs properly). The structure must contain 5 members:

- One member for number of undergraduate students

- One member for number of graduate students

- One member for number of classrooms

- One member for the name of the university (an array)

- One member for the term (fall, summer or spring; also an array)

Once you define a structure with these members (don’t forget to give your arrays a default length), go ahead and declare one structure of this type in main. Then, also inside main, initialize the members that aren’t arrays. After this, you will ask the user for the estimated lengths of the other two members. For example, “How many letters do we expect for the name of the university? ”. When you receive these two values (one for each array), make sure to check that they do not surpass the default length you gave each array. If any of these two surpass the default length(s), print out a message and exit the program (all of this is done in main as well).

Next, if the program didn’t ended, the next step is to initialize the arrays with the help of a function. You will initialize one array at a time (keep in mind that these arrays are members of a structure, so you will have to manipulate them a little different than before). This function will not return anything and it will accept an array. Inside the function, you will scan for a set of characters given by the user. Indicate the user to end with a "dot" (be sure you understand what a dot is in programming).

You will have to call this function twice, a first time for the University’s name, and a second time for the term. Once you call this function two times, your structure will be fully initialized. All is left, is to print out all the members. Go ahead and print the non-array members. Then, use a function to print out the array members (you will also have to call this function twice; once for the University’s name and once for the term). This function should not return anything and it should accept an array.

There are two toy shops in Chicago, in East Street and West Street. The mean monthly sales at East and West are equal, however the manager at the East Street believes his sales are more consistent. With the 0.01 significance level, can we conclude that his statement is true?

Below is the number of toys sold at East Street in the last seven months and for the last eight months at West Street :

East Street

98

78

54

57

68

64

70

West Street

75

81

81

30

82

46

58

101

Egerton Manufacturing Ltd produces a range of products at seven separate sites. The directors have decided to introduce Activity Based Costing (ABC) and have asked each site manager to obtain and analyse the relevant data for their site. Product costs are currently calculated using absorption costing, with overheads being absorbed on a machine hour basis. As part of the process of introducing ABC, the directors wish to assess the profitability of individual products, with the possibility that the product range may be reduced. You are the Manager of the Brumley site and you have obtained the following data:

The budgeted overheads of the site for the period are:

Machine hours are limited to 1,140 hours per period.

Required:

a) Calculate the cost of each product using ABC. Choose appropriate cost drivers for each activity

b) Draft a memo to the Managing Director which:

            (i) Using the ABC information, indicates which product(s) should no longer be manufactured and justify your recommendation;   

            (ii) Discuss any other factors which should be considered before a final decision is made.

Jane MacFarlene wants a weekly schedule for two business services, X and Y. Each 'unit' of X delivered to customers needs one service package, while each unit of Y uses two of the packages, and Jane has a maximum of 110 packages available a week. Each unit of X and Y needs 10 hours of subcontracted work, and Jane has signed agreements with subcontractors for a weekly minimum of 130 hours and a maximum of 650 hours. Jane knows from market surveys that demand for Y is high, and she will have no trouble selling any number of units. However, there is a maximum demand of 50 units of X, despite a long-term contract to supply 10 units to one customer. The net profit on each unit of X and Y is $2000 and $3000 respectively.

State the objective function mathematically State the constraints mathematically Do not solve problem graphically Setup the model in excel and use solver to determine the optimized solution (please give step by step excel instructions).

Olney Company is a small manufacturing firm located in Allentown, Pennsylvania. The company has a workforce of both hourly and salaried employees. Each employee is paid for hours actually worked during each week, with the time worked being recorded in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked beyond the 40 regular hours.

   Wages are paid every Friday, with one week’s pay being held back by the company. Thus, the first payday for Olney Company is January 14 for the workweek ending January 8 (Saturday).

You will now determine the amount of income tax to withhold for each employee, proceeding as follows:

Record the amount of federal income taxes using wage-bracket method.

Record the state income taxes on the gross weekly earnings for each employee. The rate is 3.07% for the state of Pennsylvania.

Record the city income taxes on the gross weekly earnings of each employee. The rate is 1.65% for the city of Allentown residents.

Click here to access the Wage-Bracket Method Tables.

Feedback

Your stock portfolio consists of two American companies; Apple Inc. and Ford Motor Company. You are living in Australia and those shares are purchased in the USD. During the last 12 months, Apple’s stock went up by 40%, while Ford went down by 30%. During the same period, the USD went up by 3% against the AUD. Assume that you have invested 60% of your money into Apple and allocated 40% of your money into Ford. Furthermore, assume that the standard deviations of stock returns are 5% for Apple and 7% for Ford, and the correlation coefficient between the two stock is 0.6. (a) What is the portfolio’s return over the 12 months in the USD, (b) what is its return in the AUD, and (c) what is the standard deviation of your portfolio return? Provide all the workings (use up to 3 decimal places).