Kolby’s Korndogs is looking at a new sausage system with an installed cost of $685,000. The asset qualifies for 100 percent bonus depreciation and can be scrapped for $91,000 at the end of the project’s 5-year life. The sausage system will save the firm $195,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $47,000. If the tax rate is 21 percent and the discount rate is 10 percent, what is the NPV of this project?
In: Finance
Use the information in the table
|
State |
Probabilty |
Ret(US) |
Ret(UK) |
Ret(Brazil) |
|
1 |
.30 |
.10 |
.14 |
.06 |
|
2 |
.30 |
.08 |
.07 |
.20 |
|
3 |
.40 |
.14 |
.11 |
.06 |
In: Finance
CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $411,000 is estimated to result in $152,000 in annual pretax cost savings. The press is eligible for 100 percent bonus depreciation and it will have a salvage value at the end of the project of $53,000. The press also requires an initial investment in spare parts inventory of $15,800, along with an additional $2,800 in inventory for each succeeding year of the project. The shop’s tax rate is 23 percent and its discount rate is 10 percent. Calculate the project's NPV.
In: Finance
| Suppose the average return on Asset A is 6.8 percent and the standard deviation is 8 percent, and the average return and standard deviation on Asset B are 3.9 percent and 3.3 percent, respectively. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel® to answer the following questions. |
| a. | What is the probability that in any given year, the return on Asset A will be greater than 10 percent? Less than 0 percent? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) |
| b. | What is the probability that in any given year, the return on Asset B will be greater than 10 percent? Less than 0 percent? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) |
| c-1. | In a particular year, the return on Asset A was −4.35 percent. How likely is it that such a low return will recur at some point in the future? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
| c-2. | Asset B had a return of 10.6 percent in this same year. How likely is it that such a high return will recur at some point in the future? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
In: Finance
Major concepts with which you should have some familiarity include:
FINANCE
Financial instrument types (e.g., stocks, bonds) and pricing concepts
Financial ratio interpretation
Financial criteria for evaluating projects (e.g., cash flows, NPV, payback period,
etc.)
Valuation of stocks and bonds
Break-even – term and applicatio
Goals of the corporation
Market beta and risk analysis
Benchmarking
In: Finance
Briefly discuss the advantages and disadvantages of statistical sampling.
In: Finance
t year-end 2018, Wallace Landscaping’s total assets were $2.17 million, and its accounts payable were $505,000. Sales, which in 2018 were $2.8 million, are expected to increase by 15% in 2019. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to $405,000 in 2018, and retained earnings were $280,000. Wallace has arranged to sell $120,000 of new common stock in 2019 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2019. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on sales is 7%, and 60% of earnings will be paid out as dividends.
What was Wallace's total long-term debt in 2018? Do not round intermediate calculations. Round your answer to the nearest dollar. $
What were Wallace's total liabilities in 2018? Do not round intermediate calculations. Round your answer to the nearest dollar. $
How much new long-term debt financing will be needed in 2019? (Hint: AFN - New stock = New long-term debt.) Do not round intermediate calculations. Round your answer to the nearest dollar. $
In: Finance
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 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 | 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.
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]
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]
Determine the variance and average annual return of the market portfolio. [3 points]
Determine the correlation coefficient between the market portfolio and ENB. [3 points]
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]
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 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.
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 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 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. 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