Bank Balance Sheet (Note: Use this information for all three problems)

Item                             Amount            Duration       Interest Rate       

Cash-type Securities       $50m                1.2 year             2.25%

Commercial Loans          $100m             2.4 years           4.50%

Mortgages                     $350m             8.0 years           6.50%

Core Deposits                $270m             1.0 year             2.00%

Notes Payable                $180m             2.0 years           4.50%

2. On-Balance Sheet Immunization Analysis (Use balance sheet information above, 6 points)

Immunization formulas: 1) Setting D_A x A = D_L x L will immunize the bank against interest rate risk.

2) Setting the Leverage-Adjusted Duration Gap equal to 0 will also immunize the bank against interest rate risk

(0 = D_A – k D_L ).

a. Calculate the duration of assets as a group and the duration of liabilities as a group, using a weighted-average approach (weight each item by the percentage it represents of the total amount). Also, calculate and report the adjusted duration gap.

Assume the bank wants to leave its assets unchanged, and change the composition of its liabilities, but keep the current dollar amount of liabilities the same.

b. What D_L would immunize the bank against interest rate risk? Use either immunization formula.

c. Assume the bank wants to keep its core deposits unchanged, but can issue new zero coupon bonds of any maturity to replace all of the current notes payable, and thereby achieve the desired D_L. Calculate the required maturity of the zero-coupon bonds to immunize the bank against interest rate risk.

d. If the strategy in part b immunizes the bank from interest rate risk, and interest rates do rise from an average rate of 6.0% to 7.0%, calculate the new value of the bank’s assets (A), the bank’s liabilities (L) and the net worth (E). Use the formula: %A or %L = -D x [ ΔR / (1 + R) ]

e. Explain the main implications of this exercise in a full essay of a full paragraph or more, and refer specifically to your numerical results above.

Use the dataset RuralLand.xls to test for Multicollinearity. Price is observed land price per acre excluding improvements; WL is the proportion of acreage that is wooded; DA is the distance from parcel to Sarasota airport; D75 is the distance form parcel to I-75; A is acreage of parcel; and MO is month in which the parcel was sold. Price is assumed to be dependent on these other factors.

Please provide a thorough walk through on analysis and any testing done as opposed to just posting the answers.

11-The ability of the human body to maintain a relatively constant internal environment is known as homeostasis

Select one:

True

False

12-Children born with Down syndrome have inherited an extra chromosome, so their diploid number is 47 rather than 46 chromosomes. What is this genetic condition called?

Select one:

a.

haploid 21

b.

monoploidy

c. trisomy 21

d.

triploid

13-In which phase of meiosis I do homologues separate?

Select one:

a.

prophase II

b. anaphase

c.

anaphase I

d.

metaphase I

14-Crossing over occurs during ________ and is important because it ________.

Select one:

a. telophase II; creates daughter cells

b.

anaphase II; separates the homologous pairs

c.

metaphase I; reduces the chromosome number by half

d. prophase I; generates variation

15-If a cell begins mitosis with 36 chromosomes, there will be ________ chromosomes in each cell after mitosis, and each daughter cell will be ________ genetically.

Select one:

a. 36; different

b.

18; different

c. 36; identical

d. 18; identical

16-Polar bodies are unique products of ________.

Select one:

a.

spermatogenesis

b.

mitosis

c.

oogenesis

d.

cytokinesis

17-The dark chemical that accumulates in the skin after exposure to the sun is called melanin

Select one:

True

False

18-From which of these phases of cellular respiration does the cell get the most ATP?

Select one:

a.

glycolysis

b. transition reaction

c. electron transport chain

d.

citric acid cycle

19-Albinism is due to the inability to make melanin

Select one:

True

False

20-These skin cells fight infections: neuroglia

Select one:

True

False

What are the human rights? Discuss this in relation to the universal declaration of human rights and your workplace or community sector?

(Word limit 250 )

Explain how Aristotle understands human happiness (Eudaimonia)

How does moral virtue correlate to human happiness, according to Aristotle?

Is it easier to change human resources to fit the corporate strategy as discussed by Michael Porter or change the corporate strategy to fit human resources.

Describe the person handles the human resources or personnel issues for your company? Have you experienced any human resources issues?

What is the term used to describe the ‘internal organs’ of a human cell and which parts of the human cell are considered as its internal organs.