Homework Help is Here – Start Your Trial Now!
Business
Accounting
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

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
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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.
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
SEE MORE TEXTBOOKS