Our Services

Get 15% Discount on your First Order

Prior to beginning work on this assignment, read Chapter 4:

December 4, 2021

Prior to beginning work on this assignment, read Chapter 4: Financial Forecasting in the textbook, and review the current financial statements of Starbucks through Yahoo! Finance (Links to an external site.)or the EDGAR | Company Filings (Links to an external site.)database in the Filings and Forms page. You can access the financial statements by going to the Yahoo! Finance webpage, typing in the stock symbol of Starbucks, and then clicking on the “Financials” tab. Watch the Week 1 Assignment video with Dr. Kevin Kuznia, DBA, CSSBB, PMP.

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 1

Use the EDGAR | Company Filings (Links to an external site.)or Yahoo! Finance (Links to an external site.)database to download the last 10-Q 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 2

Then, 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.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Control is an important element in any type of research.

Control is an important element in any type of research. Considering experimental research, come up with a hypothetical research scenario and apply each of the five types of control to the scenario. Use specific examples to illustrate your point. Control group: Attention control group: Nonrandomly assigned control group: Wait-list control

Literature/Article Review In this assignment, you are to critically read

Literature/Article Review In this assignment, you are to critically read and evaluate a scholarly article’s strengths, weaknesses, and contributions to the study field. Learning how to critique a journal article has several benefits, including preparing you for publishing in the future and keeping you current on the literature in your

What are the thought about spending money on nutrition for

What are the thought about spending money on nutrition for all student athletes? In your response, include whether you agree or disagree with investing great amounts of money into nutrition for college athletes, and justify your position. In your responses to classmates, examine their arguments for or against nutrition spending,

Wisdom and courage

Description Chapter 9 focuses on what wisdom and courage and is an important piece to the human condition. We learn and grow into wisdom and courage is something that comes easily to some and harder to others. Follow the criteria below to learn more about these very important pieces for

Using the topic you have developed in PSY-530 (if you

Using the topic you have developed in PSY-530 (if you have not taken PSY-530, please check with your instructor about a topic), write a Research Proposal (2,000-2,500 words) on a topic relevant to the course. To complete the Research Proposal, do the following: Review the attached document “Research Proposal

Health care system in United States

write a 3 paragraph reflection paper based on a movie and a chapter of the book. There are 3 questions that need to be answered in these 3 paragraphs Each paragraph should be at least 150 words and it should include at least 1 quote. There should be at least

Application – Rank and Yank on page 408 in the

Application – Rank and Yank on page 408 in the textbook. Do you agree or disagree with this philosophy? Why? Application – Your Turn: Performance Appraisal at American Energy Development on page 420 in the textbook, answer questions on page 422. 1-4 include on reference page: Gerhart, B., & Newman,

TOPIC: HOW HAS COVID-19 AFFECTED NYC HOUSING CRISIS Literature Review:

TOPIC: HOW HAS COVID-19 AFFECTED NYC HOUSING CRISIS Literature Review: 5 pages total The literature review should be a greatly expanded version of the one written for the proposal. It should both summarize and synthesize the relevant literature (http://libguides.usc.edu/writringguide/literaturereview). It should include a minimum of 15 references that are fairly

Ella Fitzgerald

“For the research paper, you are to chose a notable jazz musician from either the past or present, and study his/her life, art, and impact on society/culture. A quality research paper must also have a thesis (organizing argument) stating a proposition. The paper should begin with an introduction describing the

In what ways will critical thinking help you to become

In what ways will critical thinking help you to become a more successful student? In what ways will critical thinking help you to achieve lifelong goals? In a minimum of 250 words, respond to the initial discussion question. Please note that your initial response to this Discussion question is due

DISCUSSION TOPIC TO BE ANSWERED: Based on the theory of

DISCUSSION TOPIC TO BE ANSWERED: Based on the theory of attachment, what behaviors would a nurse attempt to stimulate when working with parent to promote health attachment? OBJECTIVE: Discuss the underpinning of the attachment theory, Define the key concepts of attachment theory, Apply the attachment theory to clinical practice and

Mahjong Solitaire est un excellent jeu de cartes qui permet

Mahjong Solitaire est un excellent jeu de cartes qui permet aux joueurs de faire leurs propres règles. Il peut être joué avec ou sans blocs. L’objectif est de trouver des paires de cartes assorties et de bloquer pour créer un ensemble complet. Le jeu se termine lorsque tous les blocs

Gospel according to … Prompt spring 2019 NT (1) (1)

Prompt: From the link below rewrite a passage of the gospel based on your minimal research, knowledge of the text book and the bible. Write this paper in the format of a creative journal, online newspaper article, blog. Your paper could include a series of twitter feeds or Facebook post.

Discuss the pros and cons of establishing a business analytics

Discuss the pros and cons of establishing a business analytics competency center. You need to include what industry and company-type you would be establishing this for (small, medium, large business in a specific industry such as automotive, healthcare, retail, service, and so forth). Also include information on the type and

This Week’s Topics Case Studies 1 & 2 Suggested Reading

This Week’s Topics Suggested Reading Material Jarvis, C. (2016). Physical examination & health assessment. Seventh edition. St. Louis, Mo.: Elsevier Mosby’s manual of diagnostic and laboratory tests (6th ed) CSLO’s Apply knowledge to differentiate subjective and objective information to construct an accurate and thorough past medical history (PMH). history

This discussion thread covers Joel Mokyr’s book “A Culture of

This discussion thread covers Joel Mokyr’s book “A Culture of Growth.” After you read the book, and watch the presentation videos, you are expected to (1) post an original comment addressing one of the prompts below and (2) comment on one other student’s existing post on the topic. In doing

Please respond to all questions in the prompt of this

Please respond to all questions in the prompt of this discussion forum. Your initial post should be 75-150 words in length and is due on Sunday. By Tuesday, you should respond to two additional posts from your peers. Neue Sachlichkeit (New Objectivity) The Neue Sachlichkeit or New Objectivity modern

Assessment Description Understanding the data sampling procedure and the description

Assessment Description Understanding the data sampling procedure and the description of the data is critical to accurately interpreting the results of a study. In this assignment, you will practice describing data from an SPSS data set. General Requirements: Use the following information to ensure successful completion of the assignment: