Please solve the problem below and include the excel formulas to the answers: Date MSFT SFY...

Please solve the problem below and include the excel formulas to the answers:

Date	MSFT	SFY	GM	Portfolio	Russell 3000
7/2/2012	-0.0364	-0.1328	-0.0005	-0.0566	0.0087
8/1/2012	0.0529	0.0062	0.0832	0.0474	0.0225
9/4/2012	-0.0275	0.0392	0.0655	0.0257	0.0246
10/1/2012	-0.0412	0.0249	0.1212	0.0350	-0.0185
11/1/2012	-0.0595	0.0489	0.0147	0.0014	0.0051
12/3/2012	0.0128	0.0682	0.1142	0.0651	0.0102
1/2/2013	0.0275	0.0741	-0.0257	0.0253	0.0537
2/1/2013	0.0210	0.2394	-0.0334	0.0757	0.0110
3/1/2013	0.0380	0.1122	0.0246	0.0583	0.0376
4/1/2013	0.1571	-0.1383	0.1084	0.0424	0.0153
5/1/2013	0.0616	0.0218	0.0992	0.0609	0.0212
6/3/2013	-0.0033	0.0366	-0.0172	0.0054	-0.0146
7/1/2013	-0.0781	0.0991	0.0768	0.0326	0.0535
8/1/2013	0.0564	0.0041	-0.0498	0.0036	-0.0300
9/3/2013	0.0034	0.2438	0.0554	0.1009	0.0355
10/1/2013	0.0642	0.0976	0.0273	0.0630	0.0413
11/1/2013	0.0848	0.0020	0.0480	0.0449	0.0269
12/2/2013	-0.0111	-0.0630	0.0553	-0.0063	0.0247
1/2/2014	0.0113	-0.0345	-0.1172	-0.0468	-0.0325
2/3/2014	0.0200	0.1988	0.0035	0.0741	0.0451
3/3/2014	0.0775	-0.0086	-0.0407	0.0094	0.0038
4/1/2014	-0.0143	0.0355	0.0105	0.0106	0.0002
5/1/2014	0.0206	0.0084	0.0030	0.0107	0.0196
6/2/2014	0.0254	0.0068	0.0586	0.0303	0.0234
7/1/2014	0.0350	0.0103	-0.0599	-0.0049	-0.0209
8/1/2014	0.0593	0.0091	0.0288	0.0324	0.0399
9/2/2014	0.0265	-0.0073	-0.0740	-0.0183	-0.0223
10/1/2014	0.0129	0.0232	-0.0073	0.0096	0.0264
11/3/2014	0.0246	-0.0006	0.0645	0.0295	0.0221
12/1/2014	-0.0219	0.0147	0.0539	0.0156	-0.0016
1/2/2015	-0.1303	0.0060	-0.0572	-0.0605	-0.0287

Weights	0.3333	0.3333	0.3333	1.000
Beta	0.4359745	1.249262	1.136421	1
Portfolio Beta				0.940552

Mean Monthly Portfolio Return
Standard Deviation: Monthly Portfolio Return
Mean Annualized Monthly Portfolio Return
Covariance(Portfolio, Market)
Mean Monthly Market Return
Standard Deviation: Monthly Market Return
Mean Annualized MonthlyMarket Return
Covariance(Market, Market) (e.g., Variance)

Portfolio Beta

Expert Solution

jeff jeffy answered 2 years ago

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$ 26,500 Units started during April ......................................................................................................................................100,000 Units...

Please show work and answers with the excel formulas According to the Sleep Foundation, the average...

Please show work and answers with the excel formulas According to the Sleep Foundation, the average night's sleep is 6.5 hours. Assume the standard deviation is 0.5 hours and thatthe probability distribution is normal. A. What is the probability that a randomly selected person sleeps more than 8 hours? B).What is the probability that a randomly selected person sleeps 6 hours or less? C). Doctors suggest getting between 7 and 9 hours of sleep each night? What percentage of the population...

Please answer each question set on a separate Excel worksheet, labeled appropriately and include excel Formulas...

Please answer each question set on a separate Excel worksheet, labeled appropriately and include excel Formulas Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per batch. So, you should have an average defect...

1) (note: Please also provide the excel formulas used to solve it ) You work for a...

1) (note: Please also provide the excel formulas used to solve it ) You work for a soft-drink company in the quality control division. You are interested in the standard deviation of one of your production lines as a measure of consistency. The product is intended to have a mean of 12 ounces, and your team would like the standard deviation to be as low as possible. You gather a random sample of 18 containers. Estimate the population standard deviation at...

PLEASE INCLUDE EXCEL FORMULAS OR WORK Prepare (7) operating budgets for the year by quarter &...

PLEASE INCLUDE EXCEL FORMULAS OR WORK Prepare (7) operating budgets for the year by quarter & budgeted Income Statement for the Candy business Sales Information: Company advertises that it will match the competition (Internal factor) Five year historical selling total units per year: 220k, 210k, 180k, 196k, & 200k Surrounding shopping area includes discount stores (i.e. Target, Walmart) selling similar product for $15, $20 respectively (external factor) Stock Market down 25% in last 3 months, oil per barrel at record...

For this problem, you must use Excel to perform the necessary calculations. Below are the formulas...

For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. Click on the image below to download a power point version if the text is blurry or too small. If it is appropirate to use the binomial distribution, use the formula=binom.dist(number_s,trails,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trails, trails is the total number of trails, probability is the probability for...

Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...

Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study. Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an...

Question