Numerical

download here

ECO 500: Excel Assignment One - $11

ECO 500: Excel Assignment One 

Below are data for U.S. DPI and PCE on two major components of consumer spending, motor vehicles and parts and housing and utilities. One is a durable good and the other is comprised of housing and other services and non-durables, such as natural gas purchases. Using scatter diagrams and trendlines, generate graphs showing the relationship of each of the consumption categories to DPI and find the equation of the graph and the R squared. Use your results to answer the questions to the right.                        
       
Data       
                              
Year DPI Motor Vehicles and Parts                      
1964. 462,3     25,8                       
1965. 497,8     29,6                       
1966. 537,4     29,9                       
1967. 575,1     29,6...

to view the entire page, click here

I need help with my regression analysis homework - $14

I need help with my regression analysis homework

Step 1
Download the Regression Analysis Practice document (Excel file).
 Step 2
Make sure you have the Data Analysis ToolPak add-in for your Excel. You can do that by going to the Data tab and searching for Data Analysis. If it does not appear, you will need to download it. The steps to download add-ins varies with each version of Excel. Here are the steps for the 2007 version:
 Click on the Excel icon in the upper-left corner of your spreadsheet.
Click on Excel Options...

to view the entire page, click here

HW of Corporate Bond's Analysis - $7

Numerical analysis homework help

I chose 3M company’s  Fixed Rate Notes, Ser F 2s 2002 Corporation Bond
 
EVALUATION OF THE CORPORATE BOND’S INVESTMENT RETURN AND
    SYSTEMATIC RISK
 
1. Determine the Yield-To-Maturity (YTM) based on quarterly periods (March, June, September, December) for the past nineteen periods. (March 2010 through September 2014). [If September 2014 is not available, use data through June 2014.]...

to view the entire page, click here

QMB 3600 CUMULATIVE FINAL EXAM - $45

QMB 3600 CUMULATIVE FINAL EXAM   

This document is for review purposes and does not represent every type of problem that may be on the 40 question QMB3600 cumulative final exam.
 
1. This problem is in reference to students who may or may not take advantage of the     opportunities provided in QMB such as homework.  Some of the students pass the     course, and some of them do not pass. Research indicates that 40% of the students do   the assigned homework. Of the students who do homework, there is an 80% chance they will pass the course. The probability of not passing if the student does not do the home    work is 90%.  What is the probability of a student not doing homework or     passing?...

to view the entire page, click here

Hartley-Davis - $9

The Hartley-Davis motorcycle dealer in the Minneapolis– St. Paul area wants to be able to forecast accurately the demand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year.
Month Motorcycle Sales
January = 9
February = 7
March = 10
April = 8
May = 7
June = 12
July = 10
August = 11
September = 12
October = 10
November = 14
December = 16

1) Compute a three-month moving average forecast of demand for April through January (of the next year).
2) Compute a five-month moving average forecast for June through January. 

to view the entire page, click here

SPSS - $9

SPSS 

View the following:

SPSS for Beginners 1 -- Introduction
SPSS for Beginners 2a: Frequency Counts
SPSS for Beginners 2b:
Descriptive Statistics and Z-scores
Graphing and Descriptive
Stats in SPSS With Dr. Ami Gates
Open SPSS (for help see the attached file, SPSS Installation Instructions) and complete the following:Obtain an output (as in the tutorials) with the following values highlighted and upload it into LoudCloud: Determine the statistics for each gender as follows: Frequency Counts, Mean, Standard Deviation, Minimum, and Maximum Graphing and Descriptive Stats in SPSS: Create a bar graph with gender (axis X) and height (axis Y) Upload the output into LC.

Data set:Men: 74, 71, 75, 62
Female: 62, 68, 61, 71, 68, 80 

to view the entire page, click here

Ratio Analysis - $19

Hello again, I thought I was going to be able to do this, but I am really struggling with this.
Select a publicly traded company and locate their most recent annual report (10-k report). Perform ratio analysis for the most recent 2 years of data in the financial statements. Select at least 10 of the ratios from Section 3 of Chapter 23. 
Some ratios may not be applicable. For example, if a company does not have any bonds, you will not be able to provide a ratio of the number of times bond interest was earned. Compare the two year's data and discuss in a one-page paper the overall performance of the company. Would you invest in them? Are there any areas of concern? Please include your ratios in your discussion.
To locate a publicly traded company and their annual report check out the following sources:
I chose Google. Here is the link I found for their annual report: https://www.google.com/finance?q=NASDAQ:GOOG&fstype=ii
Here is the e-book again.
Price, J. E., Haddack, M. D., & Farina, M. J. (2012). College Accounting (13th ed.). New York, NY: McGraw-Hill. 
The first ratio listed is Profitability Ratios
RATE OF RETURN ON SALES
The rate of return on sales is a measure of managerial efficiency and profitability. It is computed as follows:
Net income divided by net sales = Rate of return on net sales.
My problem is when I look at that link I provided above from Google's Annual Report, I don't know how to come up with a ratio because in order to come up with a ratio I say to myself "Okay, I see net income listed as 2,813.00 for 3 months ending 2014-09-30, but I dont' see net sales listed, therefore, I don't know how to go about dividing this up.
I have the same problem with some other ratios because my instructor wants 10 ratios.

to view the entire page, click here