The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,000,000, and it would cost another $17,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $597,000. The machine would require an increase in net working capital (inventory) of $11,500. The sprayer would not change revenues, but it is expected to save the firm $356,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 30%.

1. What is the Year 0 net cash flow?
   $
2. 
   
3. 
   
4. 
   
5. What are the net operating cash flows in Years 1, 2, and 3? Do not round intermediate calculations. Round your answers to the nearest dollar.

   Year 1	$
   Year 2	$
   Year 3	$

6. 
   
7. What is the additional Year 3 cash flow (i.e, the after-tax salvage and the return of working capital)? Do not round intermediate calculations. Round your answer to the nearest dollar.
   $
8. 
   
9. 
   
10. 
    
11. If the project's cost of capital is 10 %, what is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar.
    $

Consider a 1-year option with exercise price $100 on a stock with annual standard deviation 15%. The T-bill rate is 2% per year. Find N(d1) for stock prices (a) $95, (b) $100, and (c) $105. (Do not round intermediate calculations. Round your answers to 4 decimal places.)

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%.

1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
   $  
2. 
   
3. Why is this AFN different from the one when the company pays dividends?
   
   1. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.
   2. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
   3. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.
   4. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
   5. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.

A portfolio has 20% of its funds invested in Security A, 75% of its funds invested in Security B, and 5% invested in the risk free asset. The risk-free asset earns 4%. Security A has an expected return of 8% and a standard deviation of 18%. Security B has an expected return of 10% and a standard deviation of 22%. Securities A and B have a coefficient of correlation of 0.60.

This single question has two parts (below)

I am overwhelmed with this 2 part question please provide detailed instruction. typed out formulas are preferred, and if you have to use excel, please explain the excel process. No financial calculator please.

What is the standard deviation of the portfolio?

What is the expected return of the portfolio?

Calculate the amount to be paid by the buyer of the 10-year bond 20/05/2008-2018, at a fixed interest rate of 8.60%, with a par value of 500,000,000$, with price at 98.5 on

a) 20/06/2012

b) 20/04/2013

c) 20/07/2013.

Sway's Back Store is considering a project which will require the purchase of $1 million in new equipment. The equipment will be depreciated straight-line to $200,000 over the 5-year life of the project. The first-year sale from this project is estimated at $800,000, then it keeps growing at a 5% rate. The variable cost is always 50% of the annual sales and there is an annual fixed cost of $100,000. Sway's Back Store will sell the equipment at the end of the project at a market value of $240,000. The net working capital for the project equals to 10% of sales across years. All of the net working capital will be recouped at the end of the project. The firm desires a minimal 10% rate of return on this project. The tax rate is 40%. Please calculate the NPV for this project

Nanticoke Industries had the following operating results for 2018: sales $30,420; cost of goods sold = $20,060; depreciation expense = $5,500; interest expense = $2,940; dividends paid = $1,750. At the beginning of the year, net assets were $17,410, current assets were $5,920, and current liabilities were $3,475. At the end of the year, net fixed assets were $20,960, current assets were $7,390, and current liabilities were $4,050. The tax rate for 2018 was 30 %.

a. What is net income for 2018? (Negative answers should be indicated by a minus sign. Omit $ sign in your response.)

Net income           $

b. What is the operating cash flow for 2018? (Negative answers should be indicated by a minus sign. Omit $ sign in your response.)

Operating cash flow           $

c. What is the cash flow from assets for 2018? (Negative answer should be indicated by a minus sign. Omit $ sign in your response.)

Cash flow from assets           $

d. If no new debt was issued during the year, what is the cash flow to creditors? What is the cash flow to shareholders? (Negative answers should be indicated by a minus sign. Omit $ sign in your response.)

Raymond Mining Corporation has 9.2 million shares of common stock outstanding, 360,000 shares of 5% $100 par value preferred stock outstanding, and 157,000 7.50% semiannual bonds outstanding, par value $1,000 each. The common stock currently sells for $40 per share and has a beta of 1.60, the preferred stock currently sells for $96 per share, and the bonds have 15 years to maturity and sell for 111% of par. The market risk premium is 8.0%, T-bills are yielding 5%, and Raymond Mining’s tax is 40%.

a. What is the firm’s market value capital structure? (Enter your answers in whole dollars.)

b. If Raymond Mining is evaluating a new investment project that has the same risk as the firm’s typical project, what rate should the firm use to discount the project’s cash flows? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 3 decimal places.)

Discount rate              %

18

Which of the following statements is most correct?

A bond portfolio named DEX, comprises four bonds (face value=$1000):

1)50 semi-annual bond, 5-year maturity, a coupon rate of 4%.

2)100 annual bonds, 30-year maturity, 8% coupon bond.

3)150 zero coupon bonds, 10-year maturity.

4) 200 zero coupon bonds, 20-year maturity.

YTM/discount rate: 6%

Considering DEX’s convexity, if each bond’s convexity is given as follow:

Bond 1 (semi-annual coupon bond): 23.19

Bond 2 (annual coupon bond): 212.40

Bond 3 (zero coupon bond): 98.97

Bond 4 (zero coupon bond): 107.00

Given DEX’ convexity, when the interest rate increases from 6% to 7%, the DEX’s market value should fall by?

ABC has just issued a $1,000 par value bond that will mature in 10 years. This bond pays interest of $45 every six months. If the annual yield to maturity of this bond is 7%, what is the price of the ABC bond if the market is in equilibrium?