The following table contains the historic returns from a portfolio consisting of large stocks and a portfolio consisting of long-term Treasury bonds over the last 20 years. T-bills returns represent risk-free returns. Analyze the risk-return trade-off that would have characterized these portfolios. The following dataset is also available in Excel format in Module 3 Resources on Canvas. Returns in the dataset are in percents. For example, 31.33 means 31.33% per year.

a. Estimate the annual risk premium of large stocks and T-bonds, respectively.

b. Estimate the annual volatility of large stocks and long-term T-bonds, respectively.

c. Estimate the Sharpe ratio of large stocks and long-term T-bonds, respectively.

d. Now assume that you have always invested half of your wealth in the stock and the other half in the T-bonds. Estimate the Sharpe ratio of your portfolio.

1) Using the excel data file “US violent crime” which shows the violent crime rate in the US from 1960 to 2012:

(20 pts) Make a time series plot of the data

(5 pts each 25 pts total) Determine the following: Mean, Median, Standard deviation, Q1 and Q3. (25 pts)

Make a histogram of the data. Hint the year is not used, you need to determine how many years fall into each of the classes.

(7) What are your thoughts on the time series plot, i.e. trends etc.?

(8) Thoughts on the histogram i.e. shape of distribution etc.?

[Excel sheet]

a) Using the 1949 oil price and the 1969 oil price, compute the annual growth rate in oil prices during the 20 yr period. b) Compute the growth rate between 1969 & 1989 and between 1989 & 2017. c) given the price in 2017 and your growth rate between 1989 and 2017 compute the future price of oil in 2020 & 2025.

You receive a year-end statement from your broker that details your stock ownership over the years, and the total gain or loss over the holding period for each. You want to devise a method to make a meaningful comparison of the returns in order to determine which stock performed the best and which performed the worst. The problem is, the holding periods all have different starting and ending dates and are different lengths.

Stock returns
Stock   Buy date   Buy price (P0)   Sell date   Sell price (P1)   Total return
((P1-P0)/P0)
A   1/1/2002   16.00   1/1/2016   25.00   56.3%
B   1/1/2014   87.00   1/1/2015   80.00   -8.0%
C   1/1/2008   26.00   1/1/2014   28.00   7.7%
D   1/1/2001   17.50   1/1/2008   23.50   34.3%
E   1/1/2004   76.00   1/1/2007   68.00   -10.5%
F   1/1/2006   12.00   1/1/2016   13.00   8.3%


What is the best way to compare the returns of these stocks?
   Use the return over the entire holding period for each stock to compare
   Using the total return over the holding period for each stock, take the geometric mean to get the one year average return, and compare
   Find the dollar change of each stock (Sell price minus Buy price) and compare
   Using the total return over the holding period for each stock, take the straight average to get the one year average return, and compare

Answer the following question using R:

(a) Use linear regression to estimate the GDP of the missing years 1955 and 1960. Use the Population estimate for the missing years found using M1.

(b) Create a new data frame showing Population and GDP from 1947 to 1964 including the values for 1955 and 1960 predicted by regression models M1 and M2.

(c) Use this data frame (b) to plot the GDP and Population in a scatter plot for the years 1947 -1964, clearly marking the missing years in the original data

The following table provides the project annual budget, total number of projects, and total number of people working on the projects for City of Killingcovid annually:

For A to F, use the data between Yr 2006 and Yr 2015 to calculate the following:

A. The mean of the Number of People Working on the Project.
B. The median of the Budget.
C. The range of Budget.
D. The variance (3 significant figures) of Number of Projects.
E. The standard deviation (nearest integer) of Number of People Working on the Project.
F. The 20% trimmed mean of Number of Projects.

G. Draw a dot plot comparing the Number of People Working on the Project from Yr 1997 to Yr 2006 and those from Yr 2009 to Yr 2018.

H. Using the data for Annual Budget from Yr 2001 to Yr 2017, draw a double stem leaf plot, then calculate the relative frequency.

Preparation of accounts and Cash flow statement.

The following is a listing of the accounts of Sally’s Struthers Co. at December 31, 2002.

Cash                   $20,000
Accounts Receivable 30,000
Inventory (8 Struthers @ $5,000 each) 40,000
Prepaid Insurance 1,000
Vehicles           100,000
Accumulated Depreciation-Vehicles              36,000
Equipment           300,000
Accumulated Depreciation-Equipment        150,000
Security Deposits                                              3,000
Accounts Payable 12,000
Taxes Payable 10,000
Wages Payable    5,000
Rent Payable                                                     2,000
Common Stock (5,000 shares)               50,000
Retained Earnings           229,000

During 2003 the following transactions occurred:
Jan 1,    Paid all accounts payable for merchandise.
Jan 1,    Received all accounts receivable.
Jan 1,    Borrowed $120,000 from bank. Note is repayable $20,000 per year plus interest. The first payment is due on Dec 31, 2003. The interest rate is 10%.
Feb 1,    Bought 10 more Struthers at $6,000 each, 40% down and the rest payable in one year.
Mar 1,    Paid 2002 taxes payable.
Apr 1,    Paid $4,000 for utilities.
May 1,   Issued 2,000 shares of common stock for $20,000.
            June 1,   Sold 6 Struthers for $20,000 each. Customers pay 70% down and the rest payable in one year.
July 1,    Purchased 4 Struthers at $7,000 each - same terms.
Aug 1,   Paid dividend of $2.00 per share.
Sept 1,   Sold 5 Struthers for $22,000 each - same terms.
Nov 1,    Purchased two year insurance policy for $3,000.
Dec 1,    Exchanged 5,000 shares of common stock for a piece of land worth $50,000.
Dec 20, Received $20,000 from accounts receivable.
Dec 31, Paid first payment on Note Payable-Bank.

During the year the company paid wages of $ 40,000 in cash. At the end of the year they owed
wages of $2,000.
During the year they paid 14 months rent at $2,000 per month.

Tax rate is 30%.   2003 taxes are to be paid in 2004.
The vehicles were all purchased on the same date and have a total salvage value of $10,000 and are expected to have a useful life of 5 years.
All equipment is expected to last 20 years and have no salvage value.
The company uses FIFO when accounting for inventory.
At December 31, 2003 the stock was selling for $50 per share.

Required:
a) Prepare Cash flow statement
b) Journalize the transactions using

When WorldCom Inc.’s former chief executive Bernard Ebbers was found guilty of participating

In one of the largest U.S. accounting frauds ever, the ruling sent a message to corporate

Executives: Professing ignorance won’t necessarily save you.

Mr. Ebbers, who died Feb. 2 at age 78, was a former gym teacher who rose to head a

Telecommunications Company with a peak market value of about $180 billion. In the late 1990s

And early 2000s, WorldCom improperly boosted profit by booking operating expenses as capital

Spending, which can be deducted from earnings in small chunks over time.

During a trial in 2005, he pleaded not guilty to accounting fraud and said he didn’t know about

The misdeeds. The jury didn’t buy it. His 25-year prison sentence “put an exclamation point behind the old phrase ‘the buck stops here,’ ” said Patrick McGurn, special counsel at proxy advisor Institutional Shareholder Services. The dot-com bust and accounting scandals at WorldCom and Enron Corp. helped spur Congress to enact the Sarbanes-Oxley Act of 2002, whose provisions include requiring a public company’s chief executive and chief financial officer to certify that financial statements are accurate. The scandals also hastened a trend toward more independent corporate directors willing to challenge CEOs. Charles Elson, who heads a corporate-governance center at the University of Delaware, has this epitaph for the WorldCom fiasco: “As bad as it was, some good came out of it.” The regulatory changes didn’t mean corporate scandals would automatically land CEOs in prison. The aftermath of the 2008 financial crisis was notable for a lack of CEO scalps. Corporate leaders, wary of prison, may have become more cautious and less likely to leave paper or email trails, said Peter Henning, a law professor at Wayne State University, in Detroit. Mr. Ebbers, who built WorldCom through dozens of takeovers, was released from prison 13 years into his sentence in December because of deteriorating health. He followed an unconventional route to the CEO suite. The second of five children, Bernard John Ebbers was born Aug. 27, 1941, in Edmonton, Alberta, in Canada. His father worked as a traveling salesman and mechanic. The family moved to California in the late 1940s. Mr. Ebbers attended a boarding school on a Navajo reservation in New Mexico. As a young man he held odd jobs as a milk delivery man and a nightclub bouncer. Twice he gave up on college because of poor grades. He graduated from Mississippi College, where he played basketball, with a degree in education in 1967. Early in his career, Mr. Ebbers taught physical education and worked in a garment factory. He later began buying motels, starting with one in Columbia, Miss., where he lived in a two bedroom trailer in the parking lot. When AT&T’s “Ma Bell” system was broken up in the early 1980s, small rivals began reselling long-distance service. Mr. Ebbers and a handful of investors backed a company called Long Distance Discount Service, later renamed WorldCom. Dubbed the “Telecom Cowboy,” he earned a reputation as a hard-driving boss. He began to borrow money from the company in the late 1990s and used some of it to buy company stock. As the company expanded, Mr. Ebbers said he relied heavily on experts. “I’m not an engineer by training; I’m not an accountant by training,” he told the New York Times in 1998. “I’m the coach. I’m not the point guard who shoots the ball.” WorldCom began to show signs of stress in 2000 as its share price sank amid the dot-com meltdown. Mr. Ebbers was fired as CEO in April 2002. Soon afterward, an internal auditor spotted accounting irregularities. After his ouster, Mr. Ebbers appeared at his Mississippi church. At the end of the service, he walked to the front of the church and spoke to the congregation: “I just want you to know you aren’t going to church with a crook.” WorldCom’s former chief financial officer, Scott Sullivan, who engineered the fraud and worked closely with Mr. Ebbers, was sentenced to five years in prison after cooperating with prosecutors. He testified that Mr. Ebbers knew of the accounting methods used. Mr. Ebbers insisted he was blind-sided by the fraud. “I know what I don’t know,” he testified in a federal court. “I don’t, to this day, know technology. I don’t know finance and accounting.” As a judge delivered the sentence in 2005, Mr. Ebbers hung his head and cried while hugging his wife, Kristie Ebbers, who filed for divorce in 2008. He drove himself to prison in a Mercedes the following year and spent part of his sentence as inmate No. 56022-054 in a low-security prison in Louisiana. He was later transferred to FMC Fort Worth, a federal prison hospital in Texas. Paul Watson, a Mississippi resident and former WorldCom investor, lost $135,000 when the company collapsed, and supports a relative who lost $2.2 million. Still, he said, he feels little anger toward Mr. Ebbers and thinks “others have done far worse and been punished less.”

1. Why do you think, Charles Elson, from University of Delaware, said: “As bad as it was, some good came out of it.”?
2. Do you believe Mr. Ebbers was at fault of what happened with Worldcom despite he claimed in court that”…. I don’t know finance and accounting.” Why?
3. Why was Bernie Ebbers called the Telecom Cowboy?
4. Did the agency problem take a role in the Worldcom fiasco? Explain why yes or no? (note: there is not a clear answer here, so whatever you answer will be ok as long as you can explain it)

elaborate Acquisitions implemented by KNM GROUP in 2004 (800 words)

Use view of Corporate strategy analysis.

Please answer with directly, (don't write something no related)

i will rate the answer

According to a report by the Commerce Department in the fall of 2004, 20% of U.S. households had some type of high-speed Internet connection. Let N_n denote the number of U.S. households with a high-speed Internet connection in n households. What is the probability that 20 of the first 200 households surveyed have high-speed Internet given that 5 of the first 75 households surveyed have it?