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.

Allocating Joint Costs Using the Weighted Average Method

Orchard Fresh, Inc., purchases apples from local orchards and sorts them into four categories. Grade A are large blemish-free apples that can be sold to gourmet fruit sellers. Grade B apples are smaller and may be slightly out of proportion. These are packed in boxes and sold to grocery stores. Apples for slices are even smaller than Grade B apples and have blemishes. Apples for applesauce are of lower grade than apples for slices, yet still suitable for canning.

Information on a recent purchase of 20,000 pounds of apples is as follows: Assume that Orchard Fresh, Inc., uses the weighted average method of joint cost allocation and has assigned the following weights to the four grades of apples:

Total joint cost is $19,000.

Required:

1. Allocate the joint cost to the four grades of apples using the weighted average method. Round your allocation percentages to four decimal places and round the allocated costs to the nearest dollar.

(Note: The joint cost allocation does not equal $19,000 due to rounding.)

2. What if the factory found that Grade A apples were being valued less by customers and decided to decrease the weight factor for Grade A apples to 3.0? How would that affect the allocation of cost to Grade A apples? How would it affect the allocation of cost to the remaining grades? Round your allocation percentages to four decimal places and round the allocated costs to the nearest dollar.

Consider the following table for the U.S.

a) Does the AD curve shift to the right more or less than the LRAS curve in a dynamic AD-AS model from 2006 to 2007? Explain why verbally.

b) Explain why the Federate Funds Rate declines from 2007 to 2009 using Taylor Rule. Based on the Federate Funds Rate data in the table, explain the limitation of monetary policy that is implemented through open market operation during severe recession.

c) Suppose a military operation that costs $200 billion in 2011 can help the real GDP recover to $16.2 trillion one year earlier. What is the minimal required MPC of households in the Aggregate Expenditure model if there is no tax wedge on household income? What if the tax wedge is 1/3 of the pretax household income? What is the difference between the answer based on the Aggregate Expenditure model and the answer based on the static AD-AS model.

d) There was large fiscal stimulus during 2009-2011. People believe that fiscal stimulus is more powerful in 2011 compared to 2017. Explain why this can be true using the Federal Funds Rate data.

California​ Dreamin' manufactures​ 1960’s style clothing and accessories. The company produces two main​ products: Floral and​ Tie-Dye. Currently the company uses a traditional overhead rate in which Manufacturing Overhead is allocated to products based on direct labor hours logged. The projected production levels for the period are​ 1,000 units of Floral and 500 units of​ Tie-Dye.

Due to profitability​ concerns, management is considering switching to Activity Based Costing​ (ABC). Management has divided Manufacturing Overhead Costs into three activities and cost​ pools: Assembly​ $32,000; Machine Setup​ $12,000; and Product Movement​ $102,600. Management has identified the following cost drivers for each overhead​ activity: direct labor hours for​ assembly, number of setups for machine​ setup, and number of moves for product movement.

The following information has been compiled for each product​ line:

The direct material cost for each Floral unit is​ $10.50; the direct material cost for each​ Tie-Dye unit is​ $15.25. Direct laborers are paid at a rate of​ $20 per direct labor hour.

QUESTION​ 1: Using the above​ information, determine the per unit amount by which the​ Tie-Dye line is​ overcosted/undercosted by the current costing system

A.

​$19.28 overcosted

B.

​$9.64 undercosted

C.

​$1.18 overcosted

D.

​$25.01 undercosted

E.

​$20.71 undercosted

QUESTION​ 2: Using the above​ information, complete the following statement . . . Assuming the company marks up costs​ 75% to determine sales​ price, the Floral line is being ​____ (enter the word​ "over" or the word​ "under") priced by ____ per unit ​(round answer to the nearest ​penny).

You are a pension fund manager looking for an investment that will provide a reliable stream of income over the next 5 years. You want to find the best yield possible while still conforming to the pension fund covenant of investing in investment grade bonds or better. Decide among the following investment options for your fund.

a. Eastern Telecommunications Inc.: 5 years, 10% yield, EBIT Interest Coverage ratio = 4.4, EBITDA interest coverage ratio = 5.8, total debt of $72,625,000 (all of which is long term), total equity of $175,000,000, and a return on equity (ROE) of 7.9%.

b. Anderson Nuclear Power: 5 years, 15% yield, EBIT Interest Coverage ratio = 0.75, EBITDA interest coverage ratio = 0.9, total debt of $48,000,000, total equity of $70,000,000, and a return on capital (ROE) of 7.8%.

c. Titan Tech Company: 5 years, 6% yield, EBIT Interest Coverage ratio = 24.1, EBITDA interest coverage ratio = 30.5, total debt of $90,000,000 (all of which is long term), total equity of $1,500,000,000, and a return on equity (ROE) of 19.9%.

The following table shows the three-year median ratios for U.S. Industrials with long-term debt. Use the table to discuss the pros and cons of each investment option, described above. Determine the grade of each bond (as closely as you can). Which bond is appropriate for your pension fund?

Answer:

a. Eastern Telecommunications Inc.:

b. Anderson Nuclear Power:

c. Titan Tech Company

d. Summary recommendation:

1,) J.W. is a 25-year old female. She is currently pregnant in her first trimester and has been suffering from hyperemesis gravidarum. Because of this, she is struggling to stay hydrated and nourished. She is 5’4” and her pre-pregnancy weight was 155 lb. Now, at 10 weeks pregnant, she is 138 lb. Her Obstetrician is very concern and refers her to you for nutrition advice. What are you recommendations?
Key topics to cover: % weight loss, % UBW, risk of malnutrition, nutrition management of hyperemesis gravidarum, calorie and protein target, ideal weight gain throughout remainder of pregnancy. Please be specific.

2.)  Three weeks after your visit with J.W., she is continuing to lose weight and still struggling to keep any food down. Her weight is now 135 lb. Her Obstetrician feels she would really benefit from tube feedings. He has selected the tube feeding formula Osmolite 1.0 (which is 1 kcal/mL tube feeding formula). Describe the tube feeding regimen you would recommend.
Key topics to cover type of tube, type of infusion (continuous, intermittent, bolus), daily kcal needed, goal rate of tube feeding, clinical outcomes to monitor.

3.) With much credit to your nutrition recommendations, J.W. had a safe and healthy pregnancy and delivered a healthy baby girl, G.W. Fast-forward 5 years later and J.W. is at the Pediatrician’s office because she is concerned that G.W. is a very picky eater. She is worried that G.W. is underweight because of her picky eating. She is 30 lb, 40 inches. Plot her weight-for-age, stature-for-age, and BMI-for-age (see attached) on each growth curve. Describe your findings.
Key topics to cover: What is G.W.’s percentile for each growth curve? Is she underweight, normal weight, overweight, obese? About how many calories does she need? What are some general nutrition tips you have for J.W. and G.W.?

PLEASE ANS ALL THE SUB-QUESTIONS.

Suppose an electric utility is considering whether to install a wind farm with 30 megawatts (mw) of capacity or a natural gas generator that would produce the same amount of annual electricity. An engineering study showed that the site for the wind farm would produce a load factor of 25 percent. (Actual generation would be 25 percent of capacity on average over the course of a year.) The natural gas plant could be operated with a load factor of 50 percent. Capital costs for the wind farm would $1.5 million per megawatt, compared to $1.0 million per megawatt for the natural gas plant. Operating costs for both plants would be $2 million per year excluding fuel costs.

a. If the gas plant has a thermal efficiency of 0.4 (that is, 40 percent of the energy in the fuel gets converted to electric energy), and the cost of natural gas is $5 per million Btu, how much natural gas would be needed, and what would be the annual fuel cost for the gas plant? Show your calculations, including the assumptions you make about converting Btus to mwh.

b. What would be the levelized cost of electricity per mwh from the wind farm and from the natural gas plant, assuming a 10 percent annual interest rate and that both facilities have a 25 year life? Explain your calculations. Which is the least cost source of electricity?

c. The electric utility is investor-owned and subject to rate of return regulation. The capital costs are allowed in the rate base, but not operating or fuel costs. If the regulatory agency allows the firm to earn a 10 percent return on the rate base, what would be the regulated price of electricity with each type of generation? Which source would the utility prefer? Explain how you derived your answer.

d. If the electric utility has to pay an emission fee of $25 per metric ton of carbon dioxide emitted from fuel consumption, what would be the effect on the levelized cost of power and the regulated price? Use the emission factors for natural gas combustion on the EIA's website to derive your answer.

Assume that you recently graduated from ADU’s MHA program and landed a job as an assistant financial officer with the Cleveland Clinic. The clinic has $100,000 sitting in a checking account. The funds were designated by the board for the construction of a proton therapy facility. Construction of the facility will start one year from now. Your first assignment is to invest the $100,000 with the understanding that you need to plan for a one-year holding period because the funds must be available when construction begins in one year. Further, your boss has restricted you to the following investment alternatives, shown with their probabilities and associated outcomes.                 

Barney Smith Investment Advisors recently issued estimates for the state of the economy and the rate of return on each state of the economy. Alta Industries, Inc. is an electronics firm; Repo Men Inc. collects past due debts; and American Foam manufactures mattresses and various other foam products. Barney Smith also maintains an "index fund" which owns a market-weighted fraction of all publicly traded stocks; you can invest in that fund and thus obtain average stock market results. Given the situation as described, answer the following questions.                  

a. Calculate the expected rate of return on each alternative.

b. Calculate the standard deviation of returns on each alternative.

c. Calculate the coefficient of variation on each alternative.

d. Calculate the beta on each alternative.

g. Suppose you create a two-stock portfolio by investing $50,000 in Alta Industries and $50,000 in Repo    Men. Calculate the expected return, standard deviation, coefficient of variation, and beta for this    portfolio. How does the risk of this two-stock portfolio compare with the risk of the individual stocks if they were held in isolation?

SPD Tax Service is a regional tax preparation firm that competes with such national chains as H&R Block. The company is considering expanding and needs a financial model to analyze the decision to open a new store. Key factors affecting this decision include the demographics of the proposed location, price points that can be achieved in the target market, and the availability of funds for marketing and advertising. Capital expenditures will be ignored because unused equipment from other locations can often be shifted to a new store for the first year until they can be replaced periodically through the fixed cost budget. SPD’s target markets being considered are communities with populations between 30,000 and 50,000, assumed to be uniformly distributed. Market demand for tax preparation service is directly related to the number of households in the territory; approximately 15% of households are anticipated to use a tax preparation service. Assuming an average of 2.5 people per household, this can be expressed as 0.15*population/2.5. SPD estimates that its first year demand will have a mean of 5% of the total market demand, and for every dollar of advertising, the mean increases by 2%. The first year demand is assumed to be normal with a standard deviation of 20% of the mean demand. An advertising budget of $5,000 has been approved but is limited to 10% of annual revenues. Demand grows fairly aggressively in the second and third year and is assumed to have a triangular distribution with a minimum value of 20%, most likely value of 35%, and maximum value of 40%. After year 3, demand growth is between 5% and 15%, with a most likely value of 7%. The average charge for each tax return is $175, and increases at a rate that is normally distributed with a mean of 4% with a standard deviation of 1.0% each year. Variable costs average $15 per customer, and increase annually at a rate that is normally distributed with a mean of 3% with a standard deviation of 1.5%. Fixed costs are estimated to be approximately $35,000 for the first year, and grow annually at a rate between 1.5% and 3%. Develop a Monte Carlo simulation model to find the distribution of the net present value of the profitability of a new store over a 5-year period using a discount rate of 5%.

Siegel Company manufactures a product that is available in both a deluxe model and a regular model. The company has manufactured the regular model for years. The deluxe model was introduced several years ago to tap a new segment of the market. Since introduction of the deluxe model, the company’s profits have steadily declined and management has become increasingly concerned about the accuracy of its costing system. Sales of the deluxe model have been increasing rapidly.

Manufacturing overhead is assigned to products on the basis of direct labor-hours. For the current year, the company has estimated that it will incur $6,665,100 in manufacturing overhead cost and produce 17,000 units of the deluxe model and 115,000 units of the regular model. The deluxe model requires 1.0 hours of direct labor time per unit, and the regular model requires 0.5 hour. Material and labor costs per unit are as follows:

Determine the predetermined overhead rate for each of the four activity cost pools.

3. Using the predetermined overhead rates you computed in part (2), do the following:

a. Compute the total amount of manufacturing overhead cost that would be applied to each model using the activity-based absorption costing system. After these totals have been computed, determine the amount of manufacturing overhead cost per unit of each model.

b. Compute the unit product cost of each model (direct materials, direct labor, and manufacturing overhead).