Operating Forecasts US Sales International Sales Net Sales Cost of Goods Sold Depreciation Marketing Expense Other SG&A EBIT Supplementary Schedules Net Working Capital working cash A/R Inventory Other CA A/P Net working capital 9 Other assets 10 ANWC A Other assets 1 2 Beginning net PP&E 3 Capital Expenditures 4 Depreciation 45 Ending Net PP&E 2010 250 225 475 200 40 52 148 35 40 175 250 33 83 415 24 307 10 40 277 2011 255 240 495 205 55 53 152 30 30 179 262 34 85 419 24 277 10 55 232 History Pro Forma > 2012 2013 265 260 525 230 46 53 152 44 21 181 271 34 86 422 24 232 10 46 195 276 281 556 244 56 161 2014 287 303 590 258 59 171 2015 2016 298 310 328 354 626 664 274 291 63 181 66 193 2017 Pro forma assumptions 322 382 705 309 70 204 4.0% annual growth 8.0% annual growth 43.8% of sales 20.0% of beginning net PP&E 10.0% of sales 29.0% of sales 4.0% of sales 126 days sales outstanding 430 days of COGS 6.5% of sales 136 days of COGS 4.7% of sales given 20% of beginning net PP&E

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please solve for hightlighted areas and show how to get the answer in excel. Thank you!

Operating Forecasts
OUS Sales
1 International Sales
2 Net Sales
3 Cost of Goods Sold
4 Depreciation
5 Marketing Expense
6 Other SG&A
7 EBIT
8
9 Supplementary Schedules
20 Net Working Capital
21
22
23
24
working cash
A/R
Inventory
Other CA
25
A/P
26 Net working capital
27
28
29 Other assets
30
ANWC
A Other assets
31
32 Beginning net PP&E
33 Capital Expenditures
34 Depreciation
35 Ending Net PP&E
2010
250
225
475
200
40
52
148
35
40
175
250
33
83
415
24
307
10
40
277
2011
255
240
495
205
55
53
152
30
30
179
262
34
<History Pro Forma">
2012
2013
85
419
24
277
10
55
232
265
260
525
230
46
53
152
44
21
181
271
34
86
422
24
232
10
46
195
276
281
556
244|
56
161
2014
287
303
590
258
59
171
2015
298
328
626
274
63
181
2016
310
354
664
291
66
193
2017 Pro forma assumptions
322
382
705
309
70
204
4.0% annual growth
8.0% annual growth
43.8% of sales
20.0% of beginning net PP&E
10.0% of sales
29.0% of sales
4.0% of sales
126 days sales outstanding
430 days of COGS
6.5% of sales
136 days of COGS
4.7% of sales
given
20% of beginning net PP&E
Transcribed Image Text:Operating Forecasts OUS Sales 1 International Sales 2 Net Sales 3 Cost of Goods Sold 4 Depreciation 5 Marketing Expense 6 Other SG&A 7 EBIT 8 9 Supplementary Schedules 20 Net Working Capital 21 22 23 24 working cash A/R Inventory Other CA 25 A/P 26 Net working capital 27 28 29 Other assets 30 ANWC A Other assets 31 32 Beginning net PP&E 33 Capital Expenditures 34 Depreciation 35 Ending Net PP&E 2010 250 225 475 200 40 52 148 35 40 175 250 33 83 415 24 307 10 40 277 2011 255 240 495 205 55 53 152 30 30 179 262 34 <History Pro Forma"> 2012 2013 85 419 24 277 10 55 232 265 260 525 230 46 53 152 44 21 181 271 34 86 422 24 232 10 46 195 276 281 556 244| 56 161 2014 287 303 590 258 59 171 2015 298 328 626 274 63 181 2016 310 354 664 291 66 193 2017 Pro forma assumptions 322 382 705 309 70 204 4.0% annual growth 8.0% annual growth 43.8% of sales 20.0% of beginning net PP&E 10.0% of sales 29.0% of sales 4.0% of sales 126 days sales outstanding 430 days of COGS 6.5% of sales 136 days of COGS 4.7% of sales given 20% of beginning net PP&E
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Receivables Management
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education