BackgroundStrategic planning is critical to the growth and sustainability of any organization. An organization cannot design and implement strategic initiatives without an estimate of future profitability. Organizations acquire this insight by constructing profit projections. If a firm's profit projection is inaccurate, it will ultimately lead to misguided decisions that may adversely impact the firm's performance. Thus, firms must be diligent and meticulous in the construction of their profit projections.InstructionsYou were recently promoted to a senior financial analyst at Capital Financial, and have been tasked with forecasting the firm's 2018 profits. To develop the profit projection, you will apply the Percent of Sales method. The key consideration for this method is that income statement data sets will increase with sales.Create Capital Financial's profit projection for 2018 using the spreadsheet provided below.File download: Profit Projection SpreadsheetImportant notes regarding the 2017 forecast information:Costs, excluding depreciation, were 78% of sales.Depreciation was 7.333% of sales in 2017.Capital Financial pays a 35% tax rate.Where "n/a" is specified, the abbreviation indicates that percentage of sales is not applicable for that set of data.Capital Financial is forecasting an 18% growth in sales from 2017 to 2018.Part 1Download and open the spreadsheet template provided above. Consider the values within the spreadsheet and the information above, then do the following:In the first table in the spreadsheet, calculate the following as a percentage of sales for 2017:EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)EBIT (Earnings Before Interest, and Taxes)Pretax IncomeNet IncomeIn the second table in the spreadsheet calculate the following for 2018:Cost Except DepreciationDepreciationInterest ExpenseIncome Tax (35%)In the second table in the spreadsheet, forecast the following profitability metrics for 2018:EBITDAEBITPretax IncomeNet IncomeSave your Microsoft Excel Spreadsheet. (Mac users, please remember to append the ".xlsx" extension to the filename.)The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:Jstudent_exampleproblem_101504Part 2In a separate Word document, address the following:Explain the premise for the percentage of sales method.Describe how an accurate profit projection supports the decision making process within the organization.Save your Microsoft Word document. (Mac users, please remember to append the ".docx" extension to the filename.)The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:Jstudent_exampleproblem_101504

*Complete your response in 750-1,000 words. Select one problem below, use the petroleum industry for this assignment. Imagine that you work for a domestic oil refinery, and answer either question G11-1 or G11-2. Scenario: You do not work for an oil producer, but rather for a refinery, which turns crude oil into many different petroleum products, from jet fuel to gasoline, which are then sold to world markets. You have the option of purchasing crude oil from U.S. sources or from various foreign countries. You must purchase crude oil in order to make products that you can sell in the United States or in other countries. Questions: G11-1. Exchange Rate Effects on Industry: Using shifts in supply and demand curves, describe how a change in the exchange rate affected your industry. Label the axes, and time dimensions of the demand and supply curves you are drawing. Explain what happened to industry price and quantity by making specific references to the demand and supply curves. How can you profit from future shifts in the exchange rate? How do you predict future changes in the exchange rate? G11-2. Exchange Rate Effects on Your Firm: Describe how a change in the exchange rate affected your firm. Explain what happened to your price and quantity. How can you profit from future shifts in the exchange rate? How do you predict future changes in the exchange rate? **You are required to use at a minimum of three academic references to support your reason and findings. ***Prepare this assignment according to the guidelines found in the APA Style Guide. ****You will be graded on: 1. Chapter 11 Problem G11-1 or 11-2: Chapter 11 Problem G11-1 or 11-2 is extremely thorough with substantial supporting detail. 2. Thesis Development and Purpose: Thesis is comprehensive and contains the essence of the paper. Thesis statement makes the purpose of the paper clear. 3. Argument Logic and Construction: Clear and convincing argument that presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative. 4. Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style): Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error.

a) Consider the usual linear model, where y XB E. We now compare two regressions, which differ in how many variables are included in the matrix X... find the full question atached.PLEASE HELP. I HAVE BEEN LOOKING ALL OVER FOR SOME ASSISTANCE.