2 3 4 5 6 Sales 7 Espresso 8 Drip Coffee 9 Food/Beverage 10 Merchandise 11 Computer 12 Total Sales 13 Expenses 14 15 16 Payroll 17 Internet 18 Building 19 20 21 22 23 Income 24 Net Income 25 Profit Margin 26 Cost of Goods Cost of Merchandise Advertising Capital Assets Miscellaneous Total Exp 27 Student's Name: K‹ First Q $ $ $ $ $ $ $ S $ Downtown Internet Café First Quarter Forecast JAN FEB 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,100 $ $10,800 $ 11,000 4,400 $ 5,300 $ 4,500 $ 1,050 $ 1,165 $ 1,245 $ 58,250 $ 58,265 $ 57,845 $ $ $ $ $ $ 1,300 $ MAR 17,580 $ 3,710 $ 12,000 $ 12,000 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 17,750 $ 17,545 $ 3,080 $ 3,150 $ $12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ $ 58,250 $ 58,265 $ 57,845 $ TOTAL First Q Goal Seek Minivan Loan P AVG 80,100 $26,700 43,700 $14,567 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 52,875 $17,625 9,940 $3,313 36,000 $12,000 325 975 $ 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 174,360 $58,120 Proportion Proportion shows the ratio (%) of each sales item over the Total Sales. Add Net Income Sparkline for the months of Jan. to Mar. in Cell H24.
2 3 4 5 6 Sales 7 Espresso 8 Drip Coffee 9 Food/Beverage 10 Merchandise 11 Computer 12 Total Sales 13 Expenses 14 15 16 Payroll 17 Internet 18 Building 19 20 21 22 23 Income 24 Net Income 25 Profit Margin 26 Cost of Goods Cost of Merchandise Advertising Capital Assets Miscellaneous Total Exp 27 Student's Name: K‹ First Q $ $ $ $ $ $ $ S $ Downtown Internet Café First Quarter Forecast JAN FEB 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,100 $ $10,800 $ 11,000 4,400 $ 5,300 $ 4,500 $ 1,050 $ 1,165 $ 1,245 $ 58,250 $ 58,265 $ 57,845 $ $ $ $ $ $ 1,300 $ MAR 17,580 $ 3,710 $ 12,000 $ 12,000 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 17,750 $ 17,545 $ 3,080 $ 3,150 $ $12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ $ 58,250 $ 58,265 $ 57,845 $ TOTAL First Q Goal Seek Minivan Loan P AVG 80,100 $26,700 43,700 $14,567 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 52,875 $17,625 9,940 $3,313 36,000 $12,000 325 975 $ 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 174,360 $58,120 Proportion Proportion shows the ratio (%) of each sales item over the Total Sales. Add Net Income Sparkline for the months of Jan. to Mar. in Cell H24.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx).
Instructions:
. There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan.
• The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab,
• Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale.
Calculate the Net Income row, cells B24 through F24.
o Compute the Profit Margin row, Cells B25 through E25.
o Add Net Income Sparkline for January through March in Cell H24.
in For this tab
Transcribed Image Text:2
3
4
5
6
7 Espresso
8
9
10 Merchandise
11
Computer
12 Total Sales
Sales
Drip Coffee
Food/Beverage
13 Expenses
14 Cost of Goods
15 Cost of Merchandise
16 Payroll
17 Internet
18 Building
19 Advertising
20
21
22
23 Income
Capital Assets
Miscellaneous
Total Exp
24 Net Income
25 Profit Margin
26
B
Downtown Internet Café
First Quarter Forecast
$
$
JAN
FEB
MAR
17,580 $
17,750 $
3,710 $
3,080 $
$
12,000 $ 12,000 $
$
325 $
325 $
$
2,100 $
2,100 $
$
600 $
600 $
$ 1,500 $
1,500 $
$
1,300 $
1,300 $
$
26,400 $ 27,200 $ 26,500 $ 80,100 $26,700
$ 14,400 $ 14,500 $ 14,800 $
43,700 $14,567
$
32,900 $10,967
11,100 $
5,300 $
1,050 $
11,000
4,400 $
$
14,200 $4,733
$
1,165 $
3,460 $ 1,153
$ 58,250 $
58,265 $
174,360 $58,120
$10,800 $
4,500 $
1,245 $
57,845 $
17,545 $
3,150 $
12,000 $
325 $
2,100 $
600 $
1,500 $
1,300 $
TOTAL
AVG
27 Student's Name:
KAYA First Q First Q Goal Seek Minivan Loan
52,875 $17,625
9,940 $3,313
36,000 $12,000
975 $325
6,300 $2,100
1,800 $ 600
4,500 $1,500
3,900 $1,300
$ 58,250 $ 58,265 $ 57,845 $ 174,360 $58,120
Proportion
Proportion shows
the ratio (%) of each
sales item over the
Total Sales.
Add Net Income
Sparkline for the
months of Jan. to
Mar. in Cell H24.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education