Castle, Inc., has no debt outstanding and a total market value of $240,000. Earnings before interest and taxes, EBIT, are projected to be $26,000 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 18 percent higher. If there is a recession, then EBIT will be 20 percent lower. The firm is considering a debt issue of $150,000 with an interest rate of 8 percent. The proceeds will be used to repurchase shares of stock. There are currently 15,000 shares outstanding. Ignore taxes for questions a and b. Assume the stock price remains constant.

a-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

a-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to the nearest whole number, e.g., 32.)

Assume the firm goes through with the proposed recapitalization.

b-1. Calculate the return on equity (ROE) under each of the three economic scenarios. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

b-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Assume the firm has a tax rate of 35 percent.

c-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

c-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to the nearest whole number, e.g., 32.)

c-3. Calculate the return on equity (ROE) under each of the three economic scenarios assuming the firm goes through with the recapitalization. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

c-4. Given the recapitalization, calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Can you please show how you would solve the following using excel? Step by Step?

Kaelea, Inc., has no debt outstanding and a total market value of $117,000. Earnings before interest and taxes, EBIT, are projected to be $8,300 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 23 percent higher. If there is a recession, then EBIT will be 32 percent lower. The company is considering a $41,700 debt issue with an interest rate of 5 percent. The proceeds will be used to repurchase shares of stock. There are currently 3,900 shares outstanding. Assume the company has a market-to-book ratio of 1.0.

a. Calculate return on equity, ROE, under each of the three economic scenarios before any debt is issued, assuming no taxes. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

b. Calculate the percentage changes in ROE when the economy expands or enters a recession, assuming no taxes. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to the nearest whole number, e.g., 32.)

  
Assume the firm goes through with the proposed recapitalization and no taxes.

c. Calculate return on equity, ROE, under each of the three economic scenarios after the recapitalization. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

d. Calculate the percentage changes in ROE for economic expansion and recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Assume the firm has a tax rate of 40 percent.

e. Calculate return on equity, ROE, under each of the three economic scenarios before any debt is issued. Also, calculate the percentage changes in ROE for economic expansion and recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

f. Calculate return on equity, ROE, under each of the three economic scenarios after the recapitalization. Also, calculate the percentage changes in ROE for economic expansion and recession, assuming the firm goes through with the proposed recapitalization. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Castle, Inc., has no debt outstanding and a total market value of $220,000. Earnings before interest and taxes, EBIT, are projected to be $36,000 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 18 percent higher. If there is a recession, then EBIT will be 25 percent lower. The firm is considering a debt issue of $125,000 with an interest rate of 8 percent. The proceeds will be used to repurchase shares of stock. There are currently 11,000 shares outstanding. Ignore taxes for questions a and b. Assume the stock price remains constant.

a-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

a-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to the nearest whole number, e.g., 32.)

Assume the firm goes through with the proposed recapitalization.
b-1. Calculate the return on equity (ROE) under each of the three economic scenarios. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

b-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)  

Assume the firm has a tax rate of 35 percent.
c-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)  

c-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to the nearest whole number, e.g., 32.)

c-3. Calculate the return on equity (ROE) under each of the three economic scenarios assuming the firm goes through with the recapitalization. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

c-4. Given the recapitalization, calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

Variables typically included in a multivariate demand function (other than the price and quantity of the item the demand function represents) are consumer tastes and preferences, the number of buyers, spendable (disposable) income, prices of substitute goods, prices of complementary goods, advertising expenditures, weather, and expectations. Recalling that the price of the item being considered is placed on the vertical axis, and the quantity on the horizontal axis, the other variables are termed demand shifters. Please answer the following questions about the affect changes in other variables might have on the demand for the item. These changes will either cause demand to increase (shift right) or decrease (shift left). Use either word as applicable, for the short answer.

1. If the demand for a specific brand of a good (for which many substitutes exist) decreases and there is no decrease in the demand for this type of good, then the demand for a substitute _____________ .

2. If the number of potential consumers for the good being considered decreases, then the demand for the good being considered likely:

3. If the demand for Lattes increases, then the demand for biscotti (a complementary good) should:

4. Suppose new antioxidant properties for broccoli are discovered. Antioxidant properties supposedly help prevent cancer. As a result of this discovery, the demand for broccoli can be expected to:

5. The Organic Light Emitting Diode (OLED) is a new and promising display technology. It promises to permit display screens to be thin, flexible, and bright. It is currently available only in small size. This technology works somewhat like a firefly, utilizing electroluminescence. However its competitor, the Liquid Crystal Display (LCD), can now be produced as one piece panels up to six feet tall. The OLED is its own light source, requiring no backlighting as does a LCD. Assuming the LCD and OLED have the same sized screen, future demand for the older LCD display can probably be expected to __________ .

Variables typically included in a multivariate supply function (other than the price and quantity of the item the supply function represents) are prices of other goods that use similar input resources for production, the number of suppliers, techniques of production, taxes and subsidies, prices of input resources, weather, and expectations. Please answer the following questions about the affect changes in other variables might have on the supply of the item. These changes will either cause supply to increase (shift right) or decrease (shift left). Use either word as applicable, for the short answer.

1. If the market price of gasoline returns to the near $4.00 per gallon level then demand for gas-gulping large autos is likely to decrease and manufacturers of these autos are likely to _____________ their supply:

2. A relative increase in the productivity of the technology used to produce the item being considered is likely to _____________________ its supply.

3. Hailstorms have pelted south central Texas grape vineyards, spoiling acres of grapes. This is likely to ______________ the supply of grapes for Texas wine.

4. A manufacturer, operating with a fixed production budget, discovers that the cost of input resources is increasing. The manufacturer is likely to ___________________ the quantity of the product produced.

5. The six-spotted evil weevil has attacked California’s broccoli crops. Their supply of broccoli is thus likely to:

EMU ELECTRONICS

Emu electronics is an electronics manufacturer located in Box Hill, Victoria. The company’s managing director is Shelly Chan, who inherited the company from the father. The company originally repaired radios and other household appliances when it was founded more than 50 years ago. Over the years. The company has expanded, and it is now a reputable manufacturer of various specialty electronics items. Robert McCanless, a recent MBA graduate, has been hired by the company in the finance department.     

One of the major revenue-producing items manufactured by Emu electronics is a smart phone. Emu electronics currently has a smart phone model on the market and sales have been excellent. The smart phone is a unique item in that it comes in a variety of colours and is pre-programmed to play Jimmy Barne’s music. However, as with any electronic item, technology changes rapidly, and the current smart phone has limited features in comparison with newer models. Emu electronics has spent $1 200 000 developing a prototype for a new smart phone that has all the features of the existing one, but adds new features, such as Wifi tethering. The company has spent a further $250 000 for a marketing study to determine the expected sales figures for the new smart phones.

   Emu electronics production manager has produced estimates of the costs associated with manufacture of the new smart phone. Variable costs are estimated at $210 per unit and fixed costs for the operation are expected to run at $5.3 million per year. The estimated sales volume is 64 000 units in the year 1; 106 000 units in the year 2; 87 000 units in the year 3; 78 000 units in Year 4; and 54 000 units in the final year. The unit price of the smart phone will be $515. The necessary manufacturing equipment can be purchased for $38.5 million and will be depreciated for tax purposes over a seven-year life (straight-line to zero). It is believed the value of the manufacturing equipment in five years’ time will be $5.8 million.

    Net working capital for the smart phones will be 20% of sales and will have to be purchased at the end of the year. The cost of the raw materials is reflected in the variable unit cost. Changes in NWC will first occur at the end of Year 1 based on the first years’ sales. Emu electronics has a 30% corporate tax rate and a 12% required return.

    Shelly has asked Robert to prepare a report that answers the following questions.

Based on the given data, pls find below steps, workings, data and
answers:
1. What is the payback period of the project?
2. What is the profitability index of the project?
3. What is the IRR of the project?
4. What is the NPV of the project?
5. How sensitive is the NPV to changes in the price of the smart
phone?

6. How sensitive is the NPV to changes in the quantity
sold?

7. Should Emu electronics produce the new smart phone?

NOTE: Please show full working and explanation on the steps.

Castle, Inc., has no debt outstanding and a total market value of $250,000. Earnings before interest and taxes, EBIT, are projected to be $40,000 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 20 percent higher. If there is a recession, then EBIT will be 20 percent lower. The firm is considering a debt issue of $105,000 with an interest rate of 4 percent. The proceeds will be used to repurchase shares of stock. There are currently 10,000 shares outstanding. Ignore taxes for questions a and b. Assume the stock price remains constant.

a-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) ROE Recession % Normal % Expansion %

a-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to the nearest whole number, e.g., 32.) % change in ROE Recession % Expansion % Assume the firm goes through with the proposed recapitalization.

b-1. Calculate the return on equity (ROE) under each of the three economic scenarios. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) ROE Recession % Normal % Expansion %

b-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) % change in ROE Recession % Expansion % Assume the firm has a tax rate of 35 percent.

c-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) ROE Recession % Normal % Expansion %

c-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to the nearest whole number, e.g., 32.) % change in ROE Recession % Expansion %

c-3. Calculate the return on equity (ROE) under each of the three economic scenarios assuming the firm goes through with the recapitalization. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) ROE Recession % Normal % Expansion %

c-4. Given the recapitalization, calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) % change in ROE Recession % Expansion %

Sunrise, Inc., has no debt outstanding and a total market value of $450,000. Earnings before interest and taxes, EBIT, are projected to be $57,000 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 16 percent higher. If there is a recession, then EBIT will be 24 percent lower. The company is considering a $215,000 debt issue with an interest rate of 8 percent. The proceeds will be used to repurchase shares of stock. There are currently 9,000 shares outstanding. Ignore taxes for questions a and b. Assume the company has a market-to-book ratio of 1.0 and the stock price remains constant. a-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) a-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b-1. Assume the firm goes through with the proposed recapitalization. Calculate the return on equity (ROE) under each of the three economic scenarios. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) b-2. Assume the firm goes through with the proposed recapitalization. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Assume the firm has a tax rate of 25 percent. c-1. Calculate return on equity (ROE) under each of the three economic scenarios before any debt is issued. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c-2. Calculate the percentage changes in ROE when the economy expands or enters a recession. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c-3. Calculate the return on equity (ROE) under each of the three economic scenarios assuming the firm goes through with the recapitalization. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c-4. Given the recapitalization, calculate the percentage changes in ROE when the economy expands or enters a recession.(A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)