Questions
The following table shows historical end-of-week adjusted close prices (including dividends) for a stock and the...

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...

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:

  • AbstractDataCalc
  • AverageDataCalc
  • MaximumDataCalc
  • MinimumDataCalc

As you can expect, AbstractDataCalc is an abstract class, that AverageDataCalc, MaximumDataCalc and MinimumDataCalc all inherit.

We will provide the following files to you:

  • CSVReader
    A simple CSV reader for Excel files
  • DataSet
    This file uses CSVReader to read the data into a List> type structure. This of this as a Matrix using ArrayLists. The important methods for you are rowCount() and getRow(int i)
  • Main
    This contains a public static void String[] args. You are very free to completely change this main (and you should!). We don't test your main, but instead your methods directly.

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

  • public AbstractDataCalc(DataSet set) - Your constructor that sets your dataset to an instance variable, and runCalculations() based on the dataset if the passed in set is not null. (hint: call setAndRun)
  • public void setAndRun(DataSet set) - sets the DataSet to an instance variable, and if the passed in value is not null, runCalculations on that data
  • private void runCalculations() - as this is private, technically it is optional, but you are going to want it (as compared to putting it all in setAndRun). This builds an array (or list) of doubles, with an item for each row in the dataset. The item is the result returned from calcLine.
  • public String toString() - Override toString, so it generates the format seen above. Method is the type returned from get type, row counting is the more human readable - starting at 1, instead of 0.
  • public abstract String getType() - see below
  • public abstract double calcLine(List line) - see below

AverageDataCalc

Extends AbstractDataCalc. Will implement the required constructor and abstract methods only.

  • public abstract String getType() - The type returned is "AVERAGE"
  • public abstract double calcLine(List line) - runs through all items in the line and returns the average value (sum / count).

MaximumDataCalc

Extends AbstractDataCalc. Will implement the required constructor and abstract methods only.

  • public abstract String getType() - The type returned is "MAX"
  • public abstract double calcLine(List line) - runs through all items, returning the largest item in the list.

MinimumDataCalc

Extends AbstractDataCalc. Will implement the required constructor and abstract methods only.

  • public abstract String getType() - The type returned is "MIN"
  • public abstract double calcLine(List line) - runs through all items, returning the smallest item in the list.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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...

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 Describe a company that you believe represents the 4Ps well in...

MARKETING

Integrating All Four Ps

  • Describe a company that you believe represents the 4Ps well in its response to the COVID-19 virus. Provide at least one specific example of a P that shows why you believe this company is successful in the current environment.
  • Describe a company that you believe does not do well putting the 4Ps into practice in response to the COVID-19 virus. Using the 4Ps, provide at least one example of why you believe the company is struggling in the current environment.
  • What recommendations would you give the company who is struggling with their 4Ps to better focus on the current environment with COVID-19?

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

Use the following information to work Problems (1) through (4): You work for a lab that...

  1. Use the following information to work Problems (1) through (4):

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.

  1. Assume that the tax rate is 35 percent. You can borrow at 8 percent before taxes. Should you lease or buy?
  2. What would the lease payment have to be for you to be indifferent about the lease?   
  3. Assume that your company does not anticipate paying taxes for the next several years (you can not use the tax shield from leasing payment or asset depreciation; the cost of debt is the same as pretax cost). What are the cash flows from leasing in this case? Should you lease or buy?
  4. Rework Problem 1 assuming that the scanner will be depreciated as three-year property under MACRS.

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...

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...

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....

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...

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...

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.

  1. If she follows your advice, how much money will she have at 65? Round your answer to the nearest cent.

    $  

  2. How much will she have at 70? Round your answer to the nearest cent.

    $  

  3. 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

Question 4.1 (Total: 24 marks; 2 marks each) For each of the events listed below, select...

Question 4.1 (Total: 24 marks; 2 marks each)

For each of the events listed below, select the category that best describes its effect on a statement of cash flows. Your categories are as follows:

a. Cash provided/used by operating activities

b. Cash provided/used by investing activities

c. Cash provided/used by financing activities

d. Not a cash flow item

Events:

_____ 1. Payment on long-term debt

_____ 2. Issuance of bonds at a premium

_____ 3. Collection of accounts receivable

_____ 4. Cash dividends declared

_____ 5. Issuance of shares to acquire land

_____ 6. Sale of marketable securities (long-term)

_____ 7. Payment of employees' wages

_____ 8. Issuance of common shares for cash

_____ 9. Payment of income taxes payable

_____ 10. Purchase of equipment

_____ 11. Purchase of treasury stock (common)

_____ 12. Sale of real estate held as a long-term investment

In: Accounting

Suppose that a company currently manufactures widgets and requires immediate cash payment upfront for all sales....

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....

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...

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:

  1. Which business would you expect to be a better short-term credit risk?
    1. Do you think both companies have adequate cash resources?
    2. Assess both companies’ ability to survive in the longer term.
    1. Which company is better at generating cash from their sales revenue?

In: Accounting

A stock's returns have the following distribution: Demand for the Company's Products Probability of This Demand...

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