Business

A Skills Approach: Excel 2016 Chapter 8: Exploring Advanced Data Analysis1 | Page Challenge Yourself 8.4 Last Updated 4/9/18Challenge Yourself 8.4 In this project, you will use scenarios and a scenario summary to analyze car purchasing options. The data forthis project were downloaded from: https://www.fueleconomy.gov/feg/download.shtml You will use customfiltering to find the data you are interested in and copy it from this very large data set to another worksheet.You will then use Advanced Filter, conditional formatting, sorting, and subtotals to further analyze this subsetof data. You will manipulate a PivotTable created from the main vehicle data set. Finally, you will use Solverto solve a business problem to help you pay for your new car.Skills needed to complete this project: • Creating What-If Analysis Scenarios• Creating Scenario Summary Reports• Creating a Custom Filter• Using Advanced Filter• Creating New Conditional Formatting Rules• Sorting Data on Multiple Criteria• Adding Subtotals• Changing the Look of a PivotTable• Filtering PivotTable Data• Activating the Solver Add-Inn• Using Solver1. Open the start file EX2016-ChallengeYourself-8-4. The file will be renamed automatically to includeyour name. Change the project file name if directed to do so by your instructor, and save it.2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the]top of the workbook so you can modify the workbook.3. You want to purchase a new car. Your current car is worth $3,500 as a trade-in. The base sticker price onthe car you want is $24,595. The first financing offer from the dealer is 1.9% APR for 24 months, withno cash back. The original financing offer terms are listed in cells A3:B9 on the Car Loan worksheet. CellB10 contains a formula with a PMT function to calculate the monthly payment. Use what-if analysis toolsto compare financing options. Create scenarios to compare financing options for the car loan.a. Create names for the following cells on the Car Loan worksheet to make the scenarios easier to

On the tab marked ‘Depreciation Schedule’ complete the following items:1 Apply the appropriate tax depreciable life to each asset2 Calculate any allowable bonus depreciation on each asset. Assume no sec. 179 deduction has been taken on any asset.3 Calculate the beginning accumulated depreciation for each asset. Include any allowable bonus depreciation in this amount4 Calculate the current year tax depreciation for each asset.5 Calculate the book to tax difference on the depreciation of these assets. Use the book depreciation schedule provided. Do not adjust or review the calculations on the book schedule.All of this is to be done in Excel:

I need this done in 6 hours. Budget is $60Using the templates below, complete the Section 1-3 of the attached Project Management Plan (PMP) Template and Stakeholder Register. Embed and submit Stakeholder Register in section 3 of the PMP template. Please review the rubric before getting started.

Topic: Comparison of various aspects of consolidation among different countries and IFRSRequirements:1. The result of the study should be at least 10 pages (double spaced), excluding charts, graphs, or any other supporting schedules. The paper is expected to be supported by charts, graphs, and or any other techniques that best explain to a reader. It is strongly expected to devote a small portion of your paper indicating your experience with this project (the positive and negative aspects of working on the project). An executive summary of the paper should be prepared and submit.2. . You are expected to include recent Statement, Exposure Draft, or new development by FASB, SEC, IFRB, etc. on the selected subject in your study. Before starting your work contact your professor and get his approval of the topic as well as some guidelines in each area.3. The written report (minimum 10 pages) should be typed (double space) and be carefully organized and submitted as an attachment to your email. An executive summary is compulsory and the report can include tables, charts, graphs, appendices, and bibliography in addition to the minimum of 10-page report.

10-15 pages for Powerpoint300-400 words for the speech draftthis is a group ppt, my part is “Corporate identity and its 5 dimensions”

The midterm project will evaluate your mastery of the concepts presented in the first four modules of the course. Your emphasis should be on applying and analyzing content rather than on the actual performance of calculations.Topics covered include:Basic financial statementsConceptual framework of financial reportingInternal controls and fraudBudgeting and responsibility accountingPROJECT GUIDELINESWalmart Inc. is an American company that operates more than 11,500 retail stores worldwide; approximately 40 percent of these locations are in the United States. Walmart has approximately 2.3 million full-time employees.Use the Internet and /or the University library to find the most recent financial statements and annual report for Walmart. Write an academic paper of between 2000 and 2750 words (8 to 10 pages) that presents a discussion and analysis of the following topics:Describe the overall financial health of Walmart. Do the reports show an increase in net income, total revenues, total assets, and earnings per share?State the total retained earnings and total stockholders’ equity.How many shares of common stock have been issued and how many are outstanding?Identify different assets/liabilities that are measured by (a) historical costs, (b) market value, (c) net realizable value, and (d) present value.Discuss three ways in which you see application of the financial reporting conceptual framework at Walmart.Through research and (where appropriate) visits to a local Walmart location, identify five internal controls activities that have been implemented to prevent misappropriation of assets or fraudulent financial reporting. Do you think these internal control activities are effective? Do they address issues surrounding fraud risk? Please provide an explanation and present suggestions to improve internal controls effectiveness in the Walmart store.Describe how Walmart could use responsibility accounting performance reports to effectively manage its more than 11,000 stores and 2 million employees. What are the basic components of these performance reports?PROJECT SPECIFICATIONS? Follow accepted research approaches and citation format (APA style).? Convey your understanding of the readings and concepts and their application to the topic.? Write in an organized and coherent way.? Check for and correct spelling, sentence structure, and grammatical errors.? Demonstrate graduate-level analytical skills.Course objectives covered in this project include CO1, CO2, CO3, CO4, CO

What’s the difference between the arithmetic and geometric average return (conceptually, not mathematically), and when is it best to use each?Please keep your answer as concise as possible (no more than 150 words).

For this assignment, you will document your hypothetical company’s background information and mission statement, your company’s short-term and long-term goals, an environmental analysis, and a SWOT analysis.Note: You should make all assumptions needed for the completion of this assignment.InstructionsCreate the first part of your marketing plan in 8–12 pages:Write an introduction to your company. Describe your hypothetical company, its location, the product it makes or the service it provides, and introduce the contents of your marketing plan.Develop your company’s mission statement.Decide the main goals that you would like to achieve within the next year (short term) and the main goals that you would like to achieve within the next 5 years (long term). Determine the most appropriate ways to measure both short- and long-term goals.Note: Consider the following metrics: tracking downloads of website content; website visitors; increases in market share; customer value; new product or service adoption rates; retention; rate of growth compared to competition; and the market, margin, and customer engagement.Develop an environmental analysis that includes competitive, economic, political, legal, technological, and sociocultural forces.Develop both a SWOT analysis and needs analysis for your product or service. Each analysis should examine three strengths, weaknesses, opportunities, and threats for your company.Use at least three academic resources as quantitative marketing research to determine the feasibility of your product or service. These resources should be industry specific and relate to your chosen product or service.Use the Part A Marketing Plan Template [DOCX] to complete the assignment.The Part A Mission Statement and SWOT Analysis Sample [PDF] containing examples has been provided for your reference.This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.The specific course learning outcomes associated with this assignment are:Evaluate a company’s goals, environment, needs, strengths, and weaknesses based on its respective market.

Read the case study below regarding capital-budgeting techniques. In a paper of between 750 and 1475 words (3 to 5 pages), address the questions that follow the case study.Case Study: Alexander & SonsAlexander & Sons Company is currently considering the purchase of equipment that produces mugs.The equipment needed would cost $3 million, with a disposal value of $400,000.The equipment would be able to produce 55 million mugs over its 5-year life.The company has estimated that approximately 11 million mugs would be sold for each of the next 5 years, at the following prices:$1.00 for year 1 and 2$1.20 for year 3 and 4$1.25 for year 5The company would hire seven new employees.These seven individuals would be full-time employees.Each will work 2,000 hours per year and earn:$31 per hour in the first 3 years.$32 per hour in year 4 and 5.All employees would also receive annual benefits making up 20 percent of wages, in addition to an annual $10,000 cost for health benefits for each employee.It is estimated that:The raw materials needed will cost 0.50 per mug.Other variable costs would be 0.20 per mug.No additional fixed costs would be incurred if this project is accepted.The company’s discount rate is 10 percent, and the current tax rate of 35 percent is anticipated to remain unchanged. The company uses the straight-line method for depreciation.Case Study QuestionsBased on the above information, calculate the following items:Annual net cash flows over the expected life of the equipmentPayback periodNet present valueThe accounting rate of returnWould you recommend the acceptance of this project? Explain your analysis fully, based on the calculations you have made as well data-informed strategic planning principles.Be sure to:Follow accepted research approaches and citation format (APA style).Convey your understanding of the readings and concepts and their application to the topic.Write in an organized and coherent way.Check for and correct spelling, sentence structure, and grammatical errors.Demonstrate graduate-level analytical skills. [MO7.2, MO7.3, MO7.4]

Financial managers have access to a variety of tools to help them make well informed financial and investment decisions. Some of the most common strategic concepts are break-even analysis, the cost of capital concept, and optimal capital structure. Write an academic paper of between 1000 and 1475 words (4 to 5 pages) describing how financial managers can improve their performance by using different techniques. Where there are related ethical or legal issues, be sure to include them in your paper. Your paper should include discussion on:Differences between financial structure and capital structure.Objectives of capital structure management.Optimal capital structure.Assumptions of the break-even analysis.Weakness points of the break-even analysis.The nonlinear break-even analysis.Ethical and legal issues related to these concepts.Be sure to:Follow accepted research approaches and citation format (APA style).Convey your understanding of the readings and concepts and their application to the topic.Write in an organized and coherent way.Check for and correct spelling, sentence structure, and grammatical errors.Demonstrate graduate-level analytical skills. [MO6.3]