The following table shows historical end-of-week adjusted close prices (including dividends) for a stock and the S&P 500.
A | B | C | |
1 | Week | Stock | S&P 500 |
2 | 0 | 39.53 | 2,758 |
3 | 1 | 40.17 | 2,700 |
4 | 2 | 43.1 | 2,742 |
5 | 3 | 42.47 | 2,783 |
6 | 4 | 39.77 | 2,836 |
7 | 5 | 42.07 | 2,762 |
8 | 6 | 43.84 | 2,829 |
9 | 7 | 39.77 | 2,768 |
10 | 8 | 40.1 | 2,866 |
11 | 9 | 40.98 | 3,019 |
12 | 10 | 42.15 | 2,982 |
2. What is the geometric average weekly return for the S&P 500?
3. What is the annualized return for the S&P 500 (EAR)?
4. Calculate the weekly returns. What is standard deviation of weekly returns for the S&P 500?
5. What is the beta of the stock?
In: Finance
Hello, I need an expert answer for one of my JAVA homework assignments. I will be providing the instructions for this homework below:
For this lab, you will write the following files:
As you can expect, AbstractDataCalc is an abstract class, that AverageDataCalc, MaximumDataCalc and MinimumDataCalc all inherit.
We will provide the following files to you:
Sample Input / Output
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Given the following CSV file
1,2,3,4,5,6,7 10,20,30,40,50,60 10.1,12.2,13.3,11.1,14.4,15.5
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The output of the provided main is:
Dataset Results (Method: AVERAGE) Row 1: 4.0 Row 2: 35.0 Row 3: 12.8 Dataset Results (Method: MIN) Row 1: 1.0 Row 2: 10.0 Row 3: 10.1 Dataset Results (Method: MAX) Row 1: 7.0 Row 2: 60.0 Row 3: 15.5
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Specifications
You will need to implement the following methods at a minimum. You are free to add additional methods.
AbstractDataCalc
AverageDataCalc
Extends AbstractDataCalc. Will implement the required constructor and abstract methods only.
MaximumDataCalc
Extends AbstractDataCalc. Will implement the required constructor and abstract methods only.
MinimumDataCalc
Extends AbstractDataCalc. Will implement the required constructor and abstract methods only.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CSVReader.java
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
public class CSVReader {
private static final char DELIMINATOR =
',';
private Scanner fileScanner;
public CSVReader(String file) {
this(file, true);
}
public CSVReader(String file, boolean
skipHeader) {
try {
fileScanner = new Scanner(new File(file));
if(skipHeader) this.getNext();
}catch (IOException io)
{
System.err.println(io.getMessage());
System.exit(1);
}
}
public List<String> getNext() {
if(hasNext()){
String toSplit = fileScanner.nextLine();
List<String> result = new ArrayList<>();
int start = 0;
boolean inQuotes = false;
for (int current = 0; current < toSplit.length(); current++)
{
if (toSplit.charAt(current) == '\"') { // the char uses the '', but
the \" is a simple "
inQuotes = !inQuotes; // toggle state
}
boolean atLastChar = (current == toSplit.length() - 1);
if (atLastChar) {
result.add(toSplit.substring(start).replace("\"", "")); // remove
the quotes from the quoted item
} else {
if (toSplit.charAt(current) == DELIMINATOR && !inQuotes)
{
result.add(toSplit.substring(start, current).replace("\"",
""));
start = current + 1;
}
}
}
return result;
}
return null;
}
public boolean hasNext() {
return (fileScanner !=
null) && fileScanner.hasNext();
}
}
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DataSet.java
import java.util.ArrayList;
import java.util.List;
public class DataSet {
private final List<List<Double>>
data = new ArrayList<>();
public DataSet(String fileName) {
this(new
CSVReader(fileName, false));
}
public DataSet(CSVReader csvReader) {
loadData(csvReader);
}
public int rowCount() {
return
data.size();
}
public List<Double> getRow(int i) {
return
data.get(i);
}
private void loadData(CSVReader file) {
while(file.hasNext())
{
List<Double> dbl = convertToDouble(file.getNext());
if(dbl.size()> 0) {
data.add(dbl);
}
}
}
private List<Double>
convertToDouble(List<String> next) {
List<Double>
dblList = new ArrayList<>(next.size());
for(String item : next)
{
try {
dblList.add(Double.parseDouble(item));
}catch (NumberFormatException ex) {
System.err.println("Number format!");
}
}
return dblList;
}
public String toString() {
return
data.toString();
}
}
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Main.java
public class Main {
public static void main(String[] args) {
String testFile =
"sample.csv";
DataSet set = new
DataSet(testFile);
AverageDataCalc averages
= new AverageDataCalc(set);
System.out.println(averages);
MinimumDataCalc minimum
= new MinimumDataCalc(set);
System.out.println(minimum);
MaximumDataCalc max =
new MaximumDataCalc(set);
System.out.println(max);
}
}
In: Computer Science
Item 8
Item 8
Loaded-Up Fund charges
a 12b-1 fee of 1% and maintains an expense ratio of 0.65%. Economy
Fund charges a front-end load of 2%, but has no 12b-1 fee and an
expense ratio of 0.35%. Assume the rate of return on both funds’
portfolios (before any fees) is 10% per year.
a. How much will an investment of $100 in each
fund grow to after 1 year? (Do not round intermediate
calculations. Round your answers to 2 decimal
places.)
b. How much will an investment of $100 in each
fund grow to after 3 years? (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
In: Finance
MARKETING
Integrating All Four Ps
Search the Internet for an article that supports your position and post the link in your discussion, using APA or SWS formatting,
In: Operations Management
You work for a lab that is considering leasing diagnostic equipment. The cost of the equipment is $6,300,000, and it would be depreciated straight-line to zero over four years. The equipment will be completely valueless in four years. You can lease it for $1,875,000 per year for four years.
Year |
1 |
2 |
3 |
4 |
MACRS Percentage |
33.33% |
44.45% |
14.81% |
7.41% |
In: Finance
How is drug addiction a social inequality, on a micro and macro level, perpetuates the social problem related to drug addiction. How is social inequality is influenced by individual and institutional discrimination with drug addiction? Identify an actual solution to the problem of drug addiction in social inequality. Summarize the solution you identified and compare it to historical solutions proposed in the past
In: Psychology
firm is considering renewing its equipment to meet increased demand for its product. The cost of equipment modifications is $ 1.90 million plus $ 100000 in installation costs. The firm will depreciate the equipment modifications under MACRS, using a 5-year recovery period. Additional sales revenue from the renewal should amount to $ 1.20 million per year, and additional operating expenses and other costs (excluding depreciation and interest) will amount to 40 % of the additional sales. The firm is subject to a tax rate of 40 %. (Note: Answer the following questions for each of the next 6 years.) a. What incremental earnings before depreciation, interest, and taxes will result from the renewal? b. What incremental net operating profits after taxes will result from the renewal? c. What incremental operating cash inflows will result from the renewal?
In: Finance
Manpower Electric Company has 6 percent convertible bonds outstanding. Each bond has a $1,000 par value. The conversion ratio is 20, the stock price $37, and the bonds mature in 11 years. Use Appendix B and Appendix D as an approximate answer, but calculate your final answer using the formula and financial calculator methods.
a. What is the conversion value of the bond?
(Do not round intermediate calculations and round your
answer to the nearest whole dollar.)
CONVERSION VALUE ________
b. Assume after one year that the common stock price falls to $30.00. What is the conversion value of the bond? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
CONVERSION VALUE ________
c. Also assume that after one year interest rates go up to 10 percent on similar bonds. There are 10 years left to maturity. What is the pure value of the bond? Use semiannual analysis. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
PURE VALUE OF THE BOND ____________
d. Will the conversion value of the bond (part
b) or the pure value of the bond (part c) have a
stronger influence on its price in the market?
Conversion value of the bond
Pure value of the bond
e. If the bond trades in the market at its pure bond value, what would be the conversion premium (stated as a percentage of the conversion value)? (Do not round intermediate calculations. Input your answer as a percent rounded to 2 decimal places.)
CONVERSION PREMIUM PERCENTAGE ________%
In: Finance
Answer the following question through the prism of before the current economic downturn related to the coronavirus:
You are the HR director for a restaurant group that owns 20 restaurants and employs around 1,000 people. All of the restaurants are located in New Orleans, LA. Due to economic conditions, change in tastes of its customers, and rising food costs, the company will have to close five of its restaurants, resulting in significant layoffs. How would you go about "rightsizing" this organization? What are the ethical and legal issues to consider?
In: Operations Management
Your client is 23 years old. She wants to begin saving for retirement, with the first payment to come one year from now. She can save $15,000 per year, and you advise her to invest it in the stock market, which you expect to provide an average return of 11% in the future.
If she follows your advice, how much money will she have at 65? Round your answer to the nearest cent.
$
How much will she have at 70? Round your answer to the nearest cent.
$
She expects to live for 20 years if she retires at 65 and for 15 years if she retires at 70. If her investments continue to earn the same rate, how much will she be able to withdraw at the end of each year after retirement at each retirement age? Round your answers to the nearest cent.
Annual withdrawals if she retires at 65: $
Annual withdrawals if she retires at 70: $
In: Finance
In: Accounting
Suppose that a company currently manufactures widgets and requires immediate cash payment upfront for all sales. They also pay immediately for all goods produced.
Suppose the following:
Current Price per unit (P) = $9
Current average monthly sales quantity (Q) = 10,000
Variable cost per unit (v) = $4
Fixed costs = $0 per month
In order to solve this problem, you will need to model the cash flows in each month. For simplicity, assume that ALL cash flows (both positive and negative) occur on the same day each month. Also, assume that today is time 0, next month is time 1, the following month is time 2, etc.). Assume that cash flows will happen each period forever.
ANNUAL required rate of return = 15%
i) What is the present value of all cash flows, including those occurring today?
Present Value = $ (Round to the nearest dollar, with NO decimal! Do NOT use commas!)
The company is considering a change to its credit policy whereby it will require payment within 30 days of the sale (Net 30) instead of cash upfront. Assume that all customers will pay on the due date. It is believed that, under the new policy, price will increase by $1/unit and average monthly sales will increase to 10,500. There is no anticipated change to variable unit costs.
ii) What is the net present value (NPV) of this proposed policy change if the company were to make the change immediately (ie. today, in period 0)? (HINT: Be careful! I am not asking for the present value of the new cash flows, I am asking for the NPV of the CHANGE in cash flows!)
NPV = $ (Round to the nearest dollar, with NO decimal! Do NOT use commas!)
In: Finance
Create an Employee class having the following functions and
print
the final salary in c++ program.
- getInfo; which takes the salary, number of hours of work per
day
of employee as parameters
- AddSal; which adds $10 to the salary of the employee if it is
less
than $500.
- AddWork; which adds $5 to the salary of the employee if the
number of hours of work per day is more than 6 hours.
In: Computer Science
Part 2:
NEWCREST |
CASH FLOW FROM OPERATING ACTIVITIES |
CASH FLOW FROM INVESTING ACTIVITIES |
CASH FLOW FROM FINANCING |
2018 US $M |
$1434 |
$-833 |
$-140 |
NEWCREST |
Ratio |
Working Capital Ratio -Current assets/ Current liabilities= |
1672/651=2.57 |
Cash Flow Adequacy Ratio (Liquidity): Acid Ration= Current assets (excluding inventory and prepayments)/ current liabilities= |
1672(554-77)/651=1.60 |
Debt to Total Assets Ratio Short-Term Debt + Long-Term Debt/ Total Assets= |
4018/11480=0.35 |
Debt Coverage Ratio (Solvency)= Net Operating Income/ The Debt Service= |
1590/179=0.89 |
Cash Flow to Sales Ratio (Profitability) Operating cash flow/net sales= |
1434/3562=0.40 |
FORESCUE |
CASH FLOW FROM OPERATING ACTIVITIES |
CASH FLOW FROM INVESTING ACTIVITIES |
CASH FLOW FROM FINANCING |
2018 US $M |
$1,601 |
$-936 |
$-1,626 |
Forescue |
Ratio |
Working Capital Ratio -Current assets/ Current liabilities= |
1650/1239=1.33 |
Cash Flow Adequacy Ratio (Liquidity): Acid Ration= Current assets (excluding inventory and prepayments)/ current liabilities= |
1650(496+120)/1239=0.83 |
Debt to Total Assets Ratio (Short-Term Debt+Long-Term Debt/ Total Assets= |
8117/1650=4.92 |
Debt Coverage Ratio (Solvency)= Net Operating Income/ The Debt Service= |
1601/8117=0.20 |
Cash Flow to Sales Ratio (Profitability) Operating cash flow/net sales= |
1601/6718=0.24 |
Part 3:
Based on the analysis, you are required to make conclusions and recommendation which will answer the following questions:
In: Accounting
A stock's returns have the following distribution:
Demand for the Company's Products |
Probability of This Demand Occurring |
Rate of Return If This Demand Occurs |
Weak | 0.1 | (38%) |
Below average | 0.1 | (12) |
Average | 0.4 | 13 |
Above average | 0.3 | 20 |
Strong | 0.1 | 47 |
1.0 |
Assume the risk-free rate is 3%. Calculate the stock's expected return, standard deviation, coefficient of variation, and Sharpe ratio. Do not round intermediate calculations. Round your answers to two decimal places.
Stock's expected return: %
Standard deviation: %
Coefficient of variation:
Sharpe ratio:
In: Finance