Modeling Problem John is tasked with writing a report on the state of the econom

Modeling Problem
John is tasked with writing a report on the state of the econom

Modeling Problem
John is tasked with writing a report on the state of the economy and where it is heading. John thinks that the current state of the stock market is useful in predicting the future state of the economy, but his opinion is not enough, and he needs to determine it empirically. He comes to you and asks to help him in empirically determining whether a relationship exists between the stock market and the state of the economy, and, if it does, what is the empirical directionality of this relationship, or, in layman’s terms, whether the stock market is a leading indicator or lagging indicator.
Your mission, should you choose to accept it, is to create the best model capturing the relationship between GDP and the Wilkshire 5000 as a market proxy, and determine not only whether such relationship exists, but also the empirical directionality of such relationship should it exist, to see whether the stock market is any good at predicting whether we are heading towards a recession.
To that end, John provides you with the Wilkshire 5000 daily data since 1989, and nominal GDP seasonally adjusted quarterly data between since 1947. You refuse to accept it, since you only trust the data you gather yourself. So John gives you the following instructions:
1- Get the data from Fred and Yahoo Finance using R. Group the data in a dataframe of quarterly observations, and programmatically save the dataframe to an excel file so you can import it into E-Views where you will do the modelling. You can use the raw data or a transformation of it (log-level, difference / returns / growth, log difference / log-returns / log-growth, you can add dummies, do whatever you deem fit) to write an empirical report. (15 pts)
2- Answers to the following questions: Are the series stationary, and what is the order of integration of each series (I(0), I(1), or I(2))? Do we need to test them for cointegration and why? Which is best for modeling them: Simple Regression, VAR at levels, VAR differences, VECM, or ARDL, and why? (5 pts).
3- Assuming you decide that error correction modeling is the way to go, you would run a VECM and an ARDL and choose between them. The criteria you must consider for choosing the best model are the breadth of time coverage, model and coefficient stability, “cleanliness” of the residuals (uncorrelated, normal, and homoscedastic), and whether the model is well-specified (RAMSEY RESET test) and captures long- and short-run dynamics. (30 points).
4- Analyze the two error-correction models and use the know-how you acquired in this class to identify whether there is a relationship between the market and the economy, identify its characteristics and study its directionality. (20 points)
5- Your submission consists of (1) one pdf file containing the modeling and analysis with the necessary E-Views output, and (2) an R file containing the code used to compile and pre-process the data.

Thereare 3 files I want you to send the complete correct solutions to an assignm

Thereare 3 files
I want you to send the complete correct solutions to an assignm

Thereare 3 files
I want you to send the complete correct solutions to an assignment and all files within only 4 hours of accepting the assignment
I want you to send the complete correct solutions to an assignment and all files within only 4 hours of accepting the assignment
Assignment 1
Assignment 2
Assignment 3
Proper referencing in APA format is must
Text size 12-Times New Roman only.
Avoid plagiarisms
Avoid copying from any source
Avoid using another teacher’s solution or a similar previous student’s solution because it is a university whose system can access even the solutions published on the study pool website
You must give 100/100 correct solution
Avoid using paraphrasing programs or websites
You must provide a correct answer 100/100
You must do the solution in the same attached file
You must do the solution in the same attached file
Use APA style for writing references.
You must provide a full explanation for each question

Modeling Problem John is tasked with writing a report on the state of the econo

Modeling Problem
John is tasked with writing a report on the state of the econo

Modeling Problem
John is tasked with writing a report on the state of the economy and where it is heading. John thinks that the current state of the stock market is useful in predicting the future state of the economy, but his opinion is not enough, and he needs to determine it empirically. He comes to you and asks to help him in empirically determining whether a relationship exists between the stock market and the state of the economy, and, if it does, what is the empirical directionality of this relationship, or, in layman’s terms, whether the stock market is a leading indicator or lagging indicator.
Your mission, should you choose to accept it, is to create the best model capturing the relationship between GDP and the Wilkshire 5000 as a market proxy, and determine not only whether such relationship exists, but also the empirical directionality of such relationship should it exist, to see whether the stock market is any good at predicting whether we are heading towards a recession.
To that end, John provides you with the Wilkshire 5000 daily data since 1989, and nominal GDP seasonally adjusted quarterly data between since 1947. You refuse to accept it, since you only trust the data you gather yourself. So John gives you the following instructions:
1- Get the data from Fred and Yahoo Finance using R. Group the data in a dataframe of quarterly observations, and programmatically save the dataframe to an excel file so you can import it into E-Views where you will do the modelling. You can use the raw data or a transformation of it (log-level, difference / returns / growth, log difference / log-returns / log-growth, you can add dummies, do whatever you deem fit) to write an empirical report. (15 pts)
2- Answers to the following questions: Are the series stationary, and what is the order of integration of each series (I(0), I(1), or I(2))? Do we need to test them for cointegration and why? Which is best for modeling them: Simple Regression, VAR at levels, VAR differences, VECM, or ARDL, and why? (5 pts).
3- Assuming you decide that error correction modeling is the way to go, you would run a VECM and an ARDL and choose between them. The criteria you must consider for choosing the best model are the breadth of time coverage, model and coefficient stability, “cleanliness” of the residuals (uncorrelated, normal, and homoscedastic), and whether the model is well-specified (RAMSEY RESET test) and captures long- and short-run dynamics. (30 points).
4- Analyze the two error-correction models and use the know-how you acquired in this class to identify whether there is a relationship between the market and the economy, identify its characteristics and study its directionality. (20 points)
5- Your submission consists of (1) one pdf file containing the modeling and analysis with the necessary E-Views output, and (2) an R file containing the code used to compile and pre-process the data.

Thereare 3 files I want you to send the complete correct solutions to an assignm

Thereare 3 files
I want you to send the complete correct solutions to an assignm

Thereare 3 files
I want you to send the complete correct solutions to an assignment and all files within only 4 hours of accepting the assignment
I want you to send the complete correct solutions to an assignment and all files within only 4 hours of accepting the assignment
Assignment 1
Assignment 2
Assignment 3
Proper referencing in APA format is must
Text size 12-Times New Roman only.
Avoid plagiarisms
Avoid copying from any source
Avoid using another teacher’s solution or a similar previous student’s solution because it is a university whose system can access even the solutions published on the study pool website
You must give 100/100 correct solution
Avoid using paraphrasing programs or websites
You must provide a correct answer 100/100
You must do the solution in the same attached file
You must do the solution in the same attached file
Use APA style for writing references.
You must provide a full explanation for each question

Please, see instructions in terms of project report 3000 words (weight 70%). An

Please, see instructions in terms of project report 3000 words (weight 70%).
An

Please, see instructions in terms of project report 3000 words (weight 70%).
Analyse two companies according to the plan.
Also, I’ve attached two example reports received from the Professor.
Use Booking.com and Amazon companies data to prepare the report.

A public company’s value can be calculated by different approaches depending on

A public company’s value can be calculated by different approaches depending on

A public company’s value can be calculated by different approaches depending on the data available and are often shared through quarterly or annual reports, or financial statements.
If you were a financial and investment analyst for a publicly traded company, you may be asked to give a presentation on how the company uses performance metrics in corporate valuation. Think about how you would present return on equity (ROE) and earnings per share (EPS) to a group of investors or senior management. Review a publicly traded company’s ROE and EPS. What do these results say about the company?

The first 3 questions can be answered either on the @RISK platform OR in Excel w

The first 3 questions can be answered either on the @RISK platform OR in Excel w

The first 3 questions can be answered either on the @RISK platform OR in Excel without @RISK.. These first 3 questions require short answers. Please show your work or attach your spreadsheet. Please do not copy any answers off the internet.
The last question is open-ended. I am looking for quality of risk-related thought, not word volume.
Question 1
The data in the file “Question 1 Data” shows the cash flow from three factories which are all owned by the same firm. The value of factory A, B and C is 10, 20 and 5, respectively. What is the average cash flow of the firm? What is the standard deviation of the cash flow of the firm?
Question 2
The data in the file “Question 2 Data” shows the claims an insurance firm is paying out to its policyholders. These claims are representative of the population of claims facing the insurer. What is the Value-at-Risk at the 95% percentile of claims? What is Conditional-Value-at-Risk at the 95% percentile of claims?
Question 3
You grow corn. You have already invested 60,000 in the crop. The crop will be ready for harvest in a few days. According to the local weather report there is a 50-50 chance of rain. If it rains your crop will be damaged and your revenue will be 50,000. If there is no rain, your revenue will be 90,000. A pig farm is willing to buy your crop now, as is, for 64,000. You can buy a specialized micro-climate rain report. The reports costs 1,000. The specialized report does not disclose its accuracy, but by talking to others who have bought the report you are able to deduce that in 70% of the cases when there was rain, the specialized report also predicted rain. You also deduced that of the days the report predicted rain, there was no rain 20% of the days. What do you do?
Question 4
Based on the totality of the knowledge this class offered to you to formulate a reasoned opinion, how would you qualify the chances for a meaningful resolution of climate change risk? Explain your position. (If your position is bleak, do try to end on a hopeful note.)
Comments from Customer
you need to do 1-3 in excel and show your work for each. Please dont copy answers off the internet since Chegg has similar answers but different numbers.
This is in relation to a finance risk management class so please complete your answers with a risk management perspective in mind. Thank you!