MyITLab Excel Chapter 4 Grader Project and Unit 15 Skills Test

Do Excel Chapter 4 Grader Report.Do Unit 15 Skills Text Excel in MyitLabHomework sheet and instructions attached.

Discussion(350 words)

Consider the potential conflict between corporate social responsibility and ethics while maximizing share holder wealth.  How does exercising Christian principles play a part in running a successful business while operating within state and federal regulations?

Discussion

Go to the popular press (can be newspaper or web-based news) for a current events story that deals with a corporation that had to “make a decision”Post requires an external research citation to be completeArticle must be from either 2020 or 2021!!

proforma income statement

Reviewing the previous quarter’s financial statements will provide  you with data to construct pro forma financial statements for Starbucks  and make some basic projections. This week, you will be charged with  constructing two pro forma financial statements and addressing some  questions about your projections. The two financial statements will  include an Income Statement and Balance Sheet.To begin your assignment, download the Financial Forecasting Template.Part 1Use Yahoo! Finance (Links to an external site.) or the EDGAR | Company Filings  (Links to an external site.)database  to download the last 10Q from Starbucks into excel. Use the downloaded  data to complete the Income Statement and Balance Sheet on the  appropriate tabs in the Financial Forecasting Template. Assume the  following:Sales will increase for the next quarter by the same percentage  increase from the previous quarter to the last reported quarter. For  example, if sales increased 8% from the last quarter to the current  reported quarter, you will use 8% as the sales increase for your pro  formas.Calculate the expenses to determine what will change and what will remain the same.Note: Not all costs are associated with the cost of  sales. It will be up to you to determine which line items need to be  increased and which ones need to be left alone. This will require you to  distinguish between fixed and variable costs. For a reminder of the  difference between fixed and variable costs, please watch the video Business Costs (Fixed Costs and Variable Costs) Explained (Links to an external site.).Within each line item expense explain your rationale, as well as provide a brief summary.Part 2Then, calculate a quarterly variance analysis using the Variance  Analysis tab of the Financial Forecasting Template (the same template  you used for Part 1). Complete the following in your variance analysis:In the Excel template, insert the line items.In Column C, (Q4, 20NN) enter the previous quarter’s numbers as the budget.In Column D, (Q1, 20NN) enter the current quarter’s actual numbers.In Column E, the spreadsheet will calculate the dollar difference between the budget and actual numbers.In Column F, the spreadsheet will calculate the percentage change.In Column G, analyze and speculate the rationale for the variances.I have the data and the template

Ratio Analysis and Cash Flow Problems

Ratio Analysis and Cash Flow ProblemsDue Date: Oct 14, 2015 23:59:59       Max Points: 50Details:Using Excel, and the Gitman chapter 4 Excel resource (there is no resource for chapter 3), if needed, complete the following problems from chapters 3 and 4 in Principles of Managerial Finance:P3-5P3-12P3-14P3-21P4-3P4-7P4-10Please show all work for each problem.You are not required to submit this assignment to Turnitin.

IBUS 211 Semester Project

IBUS 211 Semester ProjectDescriptionYou are an attorney (“in-house counsel”) for a U.S. based company ready to expand into the international market. Your company will be doing business in a country of your choice. It is your job as in-house counsel to advise the company on legal issues, strategy, and risk management.InstructionsCreate your own company/product/service (i.e. licensing intellectual property rights to use technology your company has created, or investing in a logging operation in Brazil for use of raw materials in your luxury boat company). See examples below.Decide what methods your company will use to penetrate the international market –trade (import/export)licensing/franchising (IPRs)foreign direct investment (joint venture, merger/acquisition, wholly owned subsidiary)You must combine at least two methods (i.e. trade and foreign direct investment; licensing and trade; franchising and foreign direct investment).Examples:BrazilYou are a U.S. company that builds luxury boats. Your company merges with a Brazilian firm to open a logging operation (foreign direct investment) in Brazil, managed by Americans and staffed by Brazilians. You export the raw materials from Brazil to the United States for processing and manufacturing.GermanyYou are a U.S. company that owns a patented technology for building personal space rockets. Your company licenses your patent rights to a factory in Germany to manufacture the rockets. Once built, you import the rockets back into the United States for use.Be creative!Please use single spacing with a double space between paragraphs.  12 pt font.  Follow the outline below to format your paper.Written Portion (180 points total)***********Youmustcite your sources.*******************Section I. INTRODUCTION (5 points)The type of business/product proposed and a brief description, including logistics (i.e. method of transportation for goods (sea or air), staffing of employees in a manufacturing plant overseas, whatever is applicable). A brief description of the country proposed for business, identification of major existing tariff/non-tariff barriers, and the conclusion and rationale for selecting each business entry method.Section II. ANALYSIS OF THE INTERNATIONAL BUSINESS RISKS AND BENEFITS: Legal, Political, and Economic analysis of United States and proposed trading country (50 points)Describe and provide an analysis of domestic (United States) laws and regulations that will likely apply to your business activities (i.e. UCC, import/export regulations, labor laws, restrictions on licensing intellectual property rights, consumer safety standards, etc.) This should include a brief overview of major treaties that may apply to your business (i.e. UNCITRAL treaties (includes CISG and COGSA) WIPO Conventions, etc.).Describe and provide an analysis of your chosen country’s legal system (common law, civil law, theocratic). How will this affect your business activities?Describe and provide an overview of major laws and regulations in your chosen country that will likely apply to your business activities (i.e. consumer protection laws, tariffs/non-tariff barriers, health and safety regulations, intellectual property protection laws (if applicable), trade laws, WTO rules] This should include a brief overview of major treaties your chosen country is party to that may apply to your business activities.Describe and provide an analysis of logistical issues your company will face. Are you shipping goods overseas via ocean or air transport? What kind of insurance will your company require (marine/air cargo/etc.)? Are you purchasing a factory abroad? What kind of payment terms and/or insurance should you have?Analyze the risk of being sued in your chosen country. Describe your chosen country’s trade area and cultural, including important geographic and demographic information, important customs and traditions, other pertinent cultural information, competitive advantages and disadvantages for company negotiationsSection III. STRATEGY, CONTROL, MARKETING, AND CORPORATE SOCIAL RESPONSIBILITY (50 points)Explain the business entry strategies you have selected for your target country. Why did you chose this particular strategy over other methods? (i.e. minimize cost, expand production overseas to avoid tariffs, etc.)Draft a mission statement for your business. The statement should identify why your business exists and what it strives to accomplish.Describe the methods of marketing/promotion for your business/product you believe would be the most successful. This should take into account the type of product/service and the current political/legal/economic/cultural environment your target country is in. Explain your reasons for choosing the methods you chose.Create a promotional tool for your business/product. This should be based on your analysis from the section above. (i.e. online ad, Groupon, website, billboard, radio ad, newspaper print ad, etc etc etc). This is what you will use for your “pitch” to the class.What are ways you can ensure that your company fulfills its social responsibility? Form a proposal for how your business will respond to the following concerns:EnvironmentalLaborPublic TransparencyCommunity InvolvementSection IV. LEGAL AND BUSINESS RECOMMENDATIONS (Business Hat and Lawyer Hat) (25 points)Comparative Legal/Business Analysis of the overall risks and benefits of doing business in your chosen country. Based on such risks, and your chosen country’s legal, political, and economic environment, make recommendations and provide an analysis of negotiation points for the company (i.e. importance of choice of law, forum clauses, cultural influences, dispute resolution, etc.)Section V. CONCLUSION AND APPLICATION (50 points)Draft a contract to minimize your company’s overall risk for one of the methods you chose to conduct business (for example, if you chose to license a patent and export the goods, you can draft either a licensing agreement or a trade/sales agreement. Or if you chose to build a factory in a foreign country and import raw materials for production, you can draft a business contract or a sales agreement). Remember to consider:definite terms (who? What? How much? How many? How long?)responsibilities of partieschoice of law clauseforum/venue clause – dispute resolution clausewhat constitutes a fundamental breachallocation of risk (risk of loss) – insurance, cost, freightremedies, how to calculate damages

Healthcare business q ASAP

See attached question. NEED done ASAP

33u[]l.;l,./

7t6d[];’.,

Business Ethics Week 8 Discussion ( Shay )

This week we are covering materials in Chapter 9, pages 326–360, regarding workplace environment. Privacy is an important part of our daily lives. For example, as a student you should be aware of the Family Rights and Privacy Act (FERPA), which is a federal law protecting school records. Another well known federal privacy act, Health Insurance Portability and Accountability Act (HIPAA), protects your health information. It is obvious that a large number of individuals take for granted that their personal information will be safe and secure when doing business with small or large companies. However, over the past five years, security breaches have become a common occurrence.There are rules and regulations that keep employee records, such as social security numbers, work evaluations and other pertinent information secure. All of these rules and regulations tend to benefit the employee or individual, but what about the company?Let’s think for a moment about that. Should a company, regardless of size, be able to impose on its employees or customers policies regarding company privacy? Should a company have the right to regulate its employees’ activities on their off-the-clock time? Can an employee be held accountable for misrepresenting their employer on their personal social media accounts?Your discussion post for this week is to provide your own opinion on the following questions.In today’s technologically advanced society, is there really privacy? Based on your own personal experiences with social media (Facebook, Twitter, Tik Tok, Instagram, or Snapchat), do you feel that individuals should be held accountable for their actions outside of the workplace?Is it possible that, due to the technological advances in smart phones, tablets, and other communication devices, workplace and personal privacy have meshed together to a point that what was once personal space is now fair game in the hiring and firing practices?

Dilemma

Details is in attachment, due in 15 hours