Questions
River community operating metrics form question Profit per inpatient discharge. What metric is used to get...

River community operating metrics form question Profit per inpatient discharge. What metric is used to get the profit for inpatient discharge, profit per outpatient visit and the net revenue per discharge and net revenue per visit.

In: Finance

You have invested a portfolio comprised of Dell, Apple and Microsoft. Calculate the expected return and...

You have invested a portfolio comprised of Dell, Apple and Microsoft. Calculate the expected return and standard deviation of the portfolio given the information below. (SHOW IN EXCEL). Provide step by step solution.

1)Calculate the Expected return of the portfolio. (EXCEL)

2) The variance of the portfolio (EXCEL)

3) The standard deviation of the portfolio ( EXCEL)

Money spent Dell $1680
Money spent Apple $1805
Money spent Microsoft $1584
Expected Return Dell 41%
expected return Apple 23%
expected return Microsoft 20%
standard deviation dell 14%
standard deviation apple 15%
standard deviation Microsoft 11%
correlation coefficient dell and apple 0.22
correlation coefficient dell and Microsoft 0.42
correlation coefficient Apple and Microsoft 0.25

  

In: Finance

Name Enbridge Inc. S&P/TSX Composite Index 1974 -47.18% -29.78% 1975 -5.83% 5.33% 1976 16.49% 2.81% 1977...

Name Enbridge Inc. S&P/TSX Composite Index
1974 -47.18% -29.78%
1975 -5.83% 5.33%
1976 16.49% 2.81%
1977 6.19% -1.65%
1978 10.83% 23.95%
1979 0.75% 29.72%
1980 -4.48% 41.29%
1981 -14.06% -13.92%
1982 67.27% -2.53%
1983 33.70% 29.29%
1984 3.25% 0.16%
1985 40.94% 13.79%
1986 -12.57% 11.70%
1987 5.75% -3.49%
1988 0.00% 10.64%
1989 13.90% 20.10%
1990 2.12% -22.26%
1991 1.04% 16.37%
1992 -20.57% -7.04%
1993 20.39% 27.35%
1994 -2.96% -0.17%
1995 13.30% 8.73%
1996 25.18% 25.84%
1997 36.72% 18.98%
1998 19.86% -6.33%
1999 -10.01% 13.55%
2000 29.14% 31.08%
2001 16.00% -25.25%
2002 0.00% -10.51%
2003 17.24% 23.01%
2004 -2.56% 12.28%
2005 38.31% 20.29%
2006 10.35% 16.60%
2007 -0.30% 14.14%
2008 2.95% -32.08%
2009 5.63% 17.24%
2010 31.99% 16.02%
2011 25.27% -4.32%
2012 10.86% -2.38%
2013 16.97% 9.74%
2014 13.53% 9.81%
2015 -0.58% -7.74%
2016 10.34% 8.14%
2017 -17.97% 9.88%
2018 -7.50% -4.64%
2019 14.38% 9.90%

This question requires the use of the Excel file ‘Assignment 3 Data’ found on ACORN. In the file, you will find the annual returns for Enbridge Inc. (ENB) and the S&P/TSX Composite Index (which we will use for the market portfolio). All parts of this question are to be done in Excel with your results printed and submitted with the other questions in this assignment.

  1. Use the data for each of ENB and the S&P/TSX Composite Index to find the historical 95% confidence interval of each. [10 points]

  2. Plot the returns of the market against the returns of ENB. Add a trendline to the graph and determine the beta of the stock from your trendline. [5 points]

  3. Determine the variance and average annual return of the market portfolio. [3 points]

  4. Determine the correlation coefficient between the market portfolio and ENB. [3 points]

  5. What is the calculated beta for ENB using the information derived from parts a, c, and d? How does this compare with your answer to part b? [2 points]

  6. The current Government of Canada Benchmark 10 Year Bond Yield (which will be our risk-free rate) is 1.61%. What is the required return on ENB stock according to the CAPM? [2 points]

In: Finance

The following information is available about an investment opportunity. Investment will occur at year 0 and...

The following information is available about an investment opportunity. Investment will occur at year 0 and sales will occur from year 1 to year 8. Use a nominal discount rate, calculated as in = (1 + ir)(1 + p) – 1, where ir is the real discount rate, and p is expected inflation.

Facts and assumptions

Initial cost $28,000,000

Unit sales $400,000

Selling price per unit, year 1 $60

Variable cost per unit, year 1 $42

Life expectancy (years) 8

Salvage value $0

Depreciation Straight-line

Tax rate 37%

Real discount rate 10.0%

Inflation rate 0.0%

a. Prepare a spreadsheet to estimate the project’s annual after-tax cash flows.

b. Calculate the investment’s internal rate of return and its net present value assuming zero inflation.

c.

How do the internal rate of return and net present value change when you assume an inflation rate of 8 percent per year in price and variable cost per unit?

d. How do you explain the fact that inflation causes the internal rate of return to increase and the NPV to decrease?

e. Does inflation make this investment more attractive or less attractive? Why?

In: Finance

Information on lightening power Co. is show below. Assume the company's tax rate is 24 percent....

Information on lightening power Co. is show below. Assume the company's tax rate is 24 percent.

DEBT: 16,900 5.9 percent coupon bonds outstanding, $1000 par value, 26 years to maturity, selling for 106.5 percent of par; semi annual payments

COMMON STOCK: 555,000 shares outstanding, selling for $82.00 per share; Beta is 1.20

PREFERRED STOCK: 22,000 shares of 4.2 percent preferred stock outstanding, currently selling for $91.40 per share. the par value is $100.

MARKET: 6.5 percent market risk premium and 3.1 percent risk-free rate.

A.) What is the company's cost of each form of financing?

B.) Calculate the company's WACC.

Show all work, Please and thank you :)

In: Finance

Futures What is the implied interest rate on a Treasury bond ($100,000, 6% coupon, semiannual payment...

Futures

What is the implied interest rate on a Treasury bond ($100,000, 6% coupon, semiannual payment with 20 years to maturity) futures contract that settled at 100'16? Do not round intermediate calculations. Round your answer to two decimal places.

%??????

If interest rates increased by 1%, what would be the contract's new value? Do not round intermediate calculations. Round your answer to the nearest cent.

$ ??????

PLEASE SHOW FORMULA!! Thank you :)

In: Finance

Belarus Bearing Just paid a dividend of £7.20 per share on its stock. The dividends are...

Belarus Bearing Just paid a dividend of £7.20 per share on its stock. The dividends are expected to grow at a constant rate of 6% per year, indefinitely. If investors require (the discount rate) a 12% return on Belarus Bearing stock, what is the current price (Po)? What will the price be in 3 (P3) years? In 15 years (P15)?

n  If the stock is marketable at $95, what would be your investment decisions? Why?

n  If the firm’s risk as perceived by market participants suddenly increases, causing the required return to rise to 20 percent, what will be the common stock value today?

In: Finance

XYZ corp. is considering investing in a new machine. The new machine cost will $10,000 installed....

XYZ corp. is considering investing in a new machine. The new machine cost will $10,000 installed. Depreciation expense will be $1000 per year for the next five years. At the end of the fifth year XYZ expects to sell the machine for $6000. XYZ will also sell its old equipment today that has a book value of $3000 for $3000. In five years, the old machine will be fully depreciated and have a salvage value of zero. Additionally, XYZ Corp expects that the new machine will increase its EBIT by $2000 in each of the next five years. Assuming that XYZ’s tax rate is 21% and the new machines WACC is 15%, what is the projects NPV. Round your final answer to two decimals.

NOTE: Answer is not $13,651.94 as someone else put that

In: Finance

Weston Enterprises is an all-equity firm with two divisions. The soft drink division has an asset...

Weston Enterprises is an all-equity firm with two divisions. The soft drink division has an asset beta of 0.55, expects to generate free cash flow of $ 40 million this year, and anticipates a 3 % perpetual growth rate. The industrial chemicals division has an asset beta of 1.06, expects to generate free cash flow of $ 56 million this year, and anticipates a 2 % perpetual growth rate. Suppose the risk-free rate is 4 % and the market risk premium is 5 %. a. Estimate the value of each division. b. Estimate Weston's current equity beta c. Estimate Weston's current cost of capital. Is this cost of capital useful for valuing Weston's projects? How is Weston's equity beta likely to change over time? a. Estimate the value of each division.

In: Finance

You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door...

You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control.

After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March:

Cost Formula Actual Cost in March
Utilities $16,800 plus $0.14 per machine-hour $ 20,980
Maintenance $38,500 plus $1.50 per machine-hour $ 57,800
Supplies $0.90 per machine-hour $ 15,100
Indirect labor $95,000 plus $1.40 per machine-hour $ 119,700
Depreciation $68,400 $ 70,100

During March, the company worked 15,000 machine-hours and produced 9,000 units. The company had originally planned to work 17,000 machine-hours during March.

Required:

1. Calculate the activity variances for March.

2. Calculate the spending variances for March.

Calculate the activity variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

In: Finance

Why do some overpriced/overvalued IPO's under perform in the long run?

Why do some overpriced/overvalued IPO's under perform in the long run?

In: Finance

As an intern in a manufacturing company, you are assigned to evaluate two alternative production quality-tracking...

As an intern in a manufacturing company, you are assigned to evaluate two alternative production quality-tracking systems. System I costs $285 000 and has three-year life. The before-tax cash operating costs are $62 000 per year. System II costs $420 000, has a five year life with the after tax costs of $34 000 per year. For both systems, straight-line depreciation is used. The resulting book value will be zero for both systems but the estimated value is around 10% of the purchase price. The tax rate is 30% and the cost of capital is 10%. Evaluate the after-tax cash flows for both alternatives and find the best alternative by considering equivalent annuities (more precisely equivalent annual cost, EAC).


yes, it is ocf

In: Finance

An 8% coupon bond matures in 5 years. The face value is $1,000 and has a...

An 8% coupon bond matures in 5 years. The face value is $1,000 and has a current yield of 9.1%. What is the bond's current market price?

In: Finance

Amanda works in the currency trading unit of Sumara Workers Bank in Togliatti, Russia. Her latest...

Amanda works in the currency trading unit of Sumara Workers Bank in Togliatti, Russia. Her latest speculative position is to profit from her expectation that the U.S. dollar will rise significantly against the Japanese yen. The current spot rate is ¥120.00/USD$. She must choose between the 90-day options on the Japanese yen. The premium is 2.75 yen per USD. a. Should Amanda buy a put on yen or a call on yen? b. What is Amanda's break-even price on her option of choice in part a)? c. What is Amanda's gross profit and net profit if the end spot rate is 140 yen/$?

Should it be a put option? Because USD will rise significantly, we expect it to be 120+ Yen/USD right?
The breakeven will then be 122.75 and the gross and net profit will be 20Yen/USD and 17.25 Yen/USD respectively right?

In: Finance

“Set off right is applicable in Trust Account.” Comment on the statement. (300-400 Words)

“Set off right is applicable in Trust Account.” Comment on the statement. (300-400 Words)

In: Finance