Minion, Inc., has no debt outstanding and a total market value of $332,100. Earnings before interest and taxes, EBIT, are projected to be $48,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 29 percent lower. The company is considering a $170,000 debt issue with an interest rate of 7 percent. The proceeds will be used to repurchase shares of stock. There are currently 8,100 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.)

Castle, Inc., has no debt outstanding and a total market value of $240,000. Earnings before interest and taxes, EBIT, are projected to be $32,000 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 15 percent higher. If there is a recession, then EBIT will be 30 percent lower. The firm is considering a debt issue of $80,000 with an interest rate of 7 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.)

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: