Portions of the financial statements for Parnell Company are provided below.

Required:
1. Prepare the cash flows from operating activities section of the statement of cash flows for Parnell Company using the direct method. (Enter your answers in thousands (i.e., 10,000 should be entered as 10). Amounts to be deducted should be indicated with a minus sign.)

The following information applies to the questions displayed below.]

Portions of the financial statements for Parnell Company are provided below.

Required:
1. Prepare the cash flows from operating activities section of the statement of cash flows for Parnell Company using the direct method. (Enter your answers in thousands (i.e., 10,000 should be entered as 10). Amounts to be deducted should be indicated with a minus sign.)

We all currently or in the future will participate or be impacted by the stockmarket with our retirement, the companies we work for or frequent with our purchases or those companies that bring us the latest technology to help us live a more comfortable life. Since I have been watching the stockmarket over 40 years ago, I've seen companies sadly leave but others have also arrived. Some of the largest companies in the US that no one would have ever thought would no longer exist or much smaller than it once was is an indication of how the returns of a company can impact its sustainability. If the company whether stocks or bonds cannot provide the returns investors require, the company will lose needed capital to help it sustain itself.

Comments?

A large University system, which currently uses a standard grading system of A, B, C, D or F for their students, is analyzing the possibility of changing to a plus-minus grading policy. In addition to the computer system, which stores and manages all the student records, the faculty and the students would also be affected by this possible change. One of the concerns that students have, is that changing this policy might lower the overall GPA (grade point average) of the students. One statement from students makes the conjecture that only 20% of all the students in the system are supportive of the proposed change.

A)You draw a random sample of 260 students from this university system. Assuming that the student conjecture is true, would you expect to see 80 students supportive of the change? Explain.

B)Suppose in your random sample of 260 students from this university system, 80 students are supportive of the change. Based on the data do you think that the student’s conjecture that 20% of all the students in the system are supportive of the proposed change could be correct?

It is not uncommon to see that alumni often give back to their schools. The question is, what factors influence their gratitude and goodwill and play an important role in them deciding how much to contribute? A sample of some top universities has been analyzed to determine if there is a relationship between the Alumni Giving rate (percentage of alumni who give) and factors like Graduation rate (percentage), % of class Under 20, and Student / Faculty ratio. Run a regression model to determine the relationship.  Answer the following questions based on the Excel table.    

School   State     Graduation Rate   % of Classes Under 20   Student / Faculty Ratio   Alumni Giving Rate
Boston College   MA   85   39   13   25%
Brandeis University    MA   79   68   8   33%
Brown University   RI   93   60   8   40%
California Institute of Technology   CA   85   65   3   46%
Carnegie Mellon University   PA   75   67   10   28%
Case Western Reserve University   OH   72   52   8   31%
College of William and Mary   VA   89   45   12   27%
Columbia University   NY   90   69   7   31%
Cornell University   NY   91   72   13   35%
Dartmouth College   NH   94   61   10   53%
Duke University   NC   92   68   8   45%
Emory University   GA   84   65   7   37%
Georgetown University   DC   91   54   10   29%
Harvard University   MA   97   73   8   46%
John Hopkins University   MD   89   64   9   27%
Lehigh University   PA   81   55   11   40%
Massachusetts Inst. of Technology   MA   92   65   6   44%
New York University   NY   72   63   13   13%
Northwestern University   IL   90   66   8   30%
Pennsylvania State University   PA   80   32   19   21%
Princeton University   NJ   95   68   5   67%
Rice University   TX   92   62   8   40%
Stanford University   CA   92   69   7   34%
Tufts University   MA   87   67   9   29%
Tulane University   LA   72   56   12   17%
U. of California-Berleley   CA   83   58   17   18%
U. of California-Davis   CA   74   32   19   7%
U. of California-Irvine   CA   74   42   20   9%
U. of California-Los Angeles   CA   78   41   18   13%
U. of California-San Diego   CA   80   48   19   8%
U. of California-Santa Barbara   CA   70   45   20   12%
U. of Chicago   IL   84   65   4   36%
U. of Florida   FL   67   31   23   19%
U. of Illinois-Urbana Champaign   IL   77   29   15   23%
U. of Michigan-Ann Arbor   MI   83   51   15   13%
U. of North Carolina-Chapel Hill   NC   82   40   16   26%
U. of Notre Dame   IN   94   53   13   49%
U. of Pennsylvania   PA   90   65   7   41%
U. of Rochester   NY   76   63   10   23%
U. of Southern California   CA   70   53   13   22%
U. of Texas-Austin   TX   66   39   21   13%
U. of Virginia   VA   92   44   13   28%
U. of Washington   WA   70   37   12   12%
U. of Wisconsin-Madison   WI   73   37   13   13%
Vanderbuilt University   TN   82   68   9   31%
Wake Forest University   NC   82   59   11   38%
Washington University - St. Louis   MO   86   73   7   33%
Yale University   CT   94   77   7   50%
1.  Do you think this model is good?  That is, do you see an evidence of relationship? Pick the right option.  
2. What proportion of the variation in Alumni giving is explained by the three variables?
3. Suggest 2 variables (reasons) not in the table that can also be affecting the alumni giving rate.   
3. The coefficient for student / faculty ratio is negative in Excel output.  Give a reason as to why this is the case.  
5.  Find the alumni giving rate for Carnegie-Mellon from the table.  Compare this to your results in Q4.  What is the residual (error)?  

Applehead Technology is a company that purchases a device called the EyePod from a supplier and then sells the devices to retail customers. If the company makes no changes in its operations, the company expects the following for the coming year.

# of units sold                                                              30,000

Price                                                                           $300 per unit

Cost of merchandise                                                 $100 per unit                       

Rent and Salaries for the year                                 $1,300,000

The company is holding a meeting to discuss ways to increase its profit – that is the company’s goal. At that meeting, Maria Garcia, the marketing manager, says “If we make the changes I suggest, I think we can attract more customers and increase our share of the market. Currently, our customers pay for shipping. Market research says customers hate shipping charges, so rather than having customers pay it, we should pay it. Shipping would cost us $3 per unit. Market research also shows that our prices are not competitive. So, we should lower our price to $270. If we take these actions, I estimate we will increase the number of units sold to 32,000.”

1. On the spreadsheet provided labeled “For Problem 3a”, prepare the contribution margin income statements to analyze each of the 2 possibilities for the coming year, namely
   1. Applehead makes no changes
   2.    Applehead adopts Garcia’s proposal

Answer the following questions on the separate answer sheet labeled “For Problem 3b, c, d, e”:

2. Mr. Big, the CEO of the company says to Maria “Clearly your suggestion is a good one. Based on your estimates, we will see an additional 2,000 units. Let’ do it!” How would you answer Mr. Big?
3. Assume Maria’s suggestions are NOT implemented. What is the breakeven point for Applehead? (Can be in $ or in units – your choice.) Show all work.
4. Calculate Applehead’s margin of safety. You can measure it in units or dollars or as a % of sales (your choice, but you only need to compute one of those). In making your margin of safety computation, assume Maria’s suggestions are NOT implemented and that the company sells the 30,000 units. Show all work.
5. Explain briefly what margin of safety tells the company – what is the meaning of the number you computed?

A sample of nine public universities and nine private universities was taken. The total cost for the year (including room and board) and the median SAT score (maximum total is 2400) at each school were recorded. It was felt that schools with higher median SAT scores would have a better reputation and would charge more tuition as a result of that. The data are in the following table. Run the regression one time without dummy variable and one time with dummy variable

a)         Write the predicted regression equation and highlight it for both models

b)         High light the r2 and explain it for both models

c)         Highlight Significance F and explain it for both models

d)         Highlight the p-value and discuss if independent variable is significant or not for both models

e)         Discuss the sign of the co-efficient for both models

f)          Are private schools more expensive than public schools when SAT scores are taken into consideration?

g)         Discuss how accurate you believe these results are using information related to the regression models. ( not for this session).

Hint: Dummy variable gets the value of 0 for public universities and1 for private universities.

please show screenshots and what formulas used in excel/the labels thank you

Hi, could you please assist with this question?

You are an investment banking consultant advising a mining company. The CEO of the company tells you that she believes that capital structure does not have an impact on firm value. On what basis might they make this comment? State whether you agree or not with this position and explain why. Does the nature of this firm’s business risk change your answer? Fully explain your reasoning.

Thanks kindly

Hoping to learn what issues may resonate with voters in the coming election, the campaign director for a mayoral candidate selects one block at random from each of the city’s election districts. Staff members go there and interview all the residents they can find.

Select the correct answer:

a) The population:

b) The parameter of interest:

c) The sampling frame:

d) The sample:

e) The sampling method:

f) Any bias present:

Learning Activity #1

Frank Pulley was the General Manager of Fred Arnold’s, “Arnold’s Moving and Storage”, a family-owned business. He had been with the company since he got out of high school. He worked summers and vacations to make money during his college years. The company had grown as did Frank. When Frank graduated from college with his degree in business management, he was given the job of Office Accounts Manager. He managed the money for the business. During the evening, Frank went to school and received his MBA in Finance. By then, Arnold’s had expanded to include long distance moving as well as office moves in the Mid-Atlantic area. The company was making over $3,000,000 in sales and was growing at a rate of 8% -10 % a year. Competition was strong in the Mid-Atlantic region so Fred wanted to expand southward. About this time, Fred’s son decided it was time to come back into the business. He had been working in IT in Miami. He liked Miami and felt he could work from there and bring the business down the Eastern Seaboard.

Frank had been with the business for 12 years now and felt that with Fred’s son now back in the business, it might be time to leave. Fred saw Frank at lunch one day shortly after Frank started looking for a new job. “Frank, I just heard that you are looking for a senior management position. In fact, I had to hear it from Janice Jeppy of all people. I ran into her at the bank. She says you applied to Jeppy Movers for a job and was wondering why you would want to switch moving companies. I am wondering too. Don’t you want to stay with us?”

Frank was surprised. The thought had never occurred to him. He assumed that Mr. Arnold’s son and daughter would take over the business. Both of Fred’s children had been working in the business since they were in high school. “I don’t want to leave Mr. Arnold,” Frank replied, “but I assumed that with Frank back in the business, he would take over. I just couldn’t see where there was room for advancement.” Fred was afraid this is what the boy would say. His son was bright and showed promise, but Fred knew they needed experienced people like Frank to keep the company moving forward. Frank was great support for the business and would be the best support that he and his son could have. Fred wondered how he could keep Frank in the business. “Come see me tomorrow at 10 a.m., Frank and we will talk. I can’t let you go to Jeppy Movers, can I”?

Learning Activity #2

How might Arnold’s son attempt to engage the business in the Miami community to solidify the company’s move southward?

Explain how small businesses and community support is important to business sustainability?