Homework Help is Here – Start Your Trial Now!
Business
Accounting
Balance Sheet: Assets (Millions of Dollars) Assets (million $) Cash S-T investment Accounts receivable Inventories Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets Liabilities and Equity (million $) Accounts payable (A/P) Notes payable Accruals Total current liabilities (CL) Long-term dept Total liabilities Common Stock Retained earnings Total equity Total L&E X x 2039 80 120 420 600 4000 1000 2039 340 50 300 2729 800 3529 1200 1730 2930 6459 X X 2040 70 20 540 800 4820 1320 2040 440 250 340 3070 1100 4170 1200 1910 3110 7280 Background Assumptions Tax Rate Interest rate on short-term debt Interest rate on long-term debt Forecasted Sales (2041) Forecasted L-T growth rate Constant dividend policy Income Statement (Millions of Dollars) (million $) Sales COGS Depreciation Other expenses Tot, op. costs EBIT Business Plan For Next Year (2041) 1) Accounts cleanup for efficency: Short-term investemnt and NP will net out 2) A new cost saving plan: COGS/Sales-70%. Other expenses 4% 3) No expansion: FA, depreciation and Net FA will not change. Intrest expense Pre-tax ernings Taxes (25%) Net Income X X X Tax Rate 25% 4.00% 9% Notes 2039 5,500 4500 300 350 5,150 350 70 280 25% 70 210 2040 6,000 5000 350 420 5,770 230 120 110 25% 27.5 83

Balance Sheet: Assets (Millions of Dollars) Assets (million $) Cash S-T investment Accounts receivable Inventories Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets Liabilities and Equity (million $) Accounts payable (A/P) Notes payable Accruals Total current liabilities (CL) Long-term dept Total liabilities Common Stock Retained earnings Total equity Total L&E X x 2039 80 120 420 600 4000 1000 2039 340 50 300 2729 800 3529 1200 1730 2930 6459 X X 2040 70 20 540 800 4820 1320 2040 440 250 340 3070 1100 4170 1200 1910 3110 7280 Background Assumptions Tax Rate Interest rate on short-term debt Interest rate on long-term debt Forecasted Sales (2041) Forecasted L-T growth rate Constant dividend policy Income Statement (Millions of Dollars) (million $) Sales COGS Depreciation Other expenses Tot, op. costs EBIT Business Plan For Next Year (2041) 1) Accounts cleanup for efficency: Short-term investemnt and NP will net out 2) A new cost saving plan: COGS/Sales-70%. Other expenses 4% 3) No expansion: FA, depreciation and Net FA will not change. Intrest expense Pre-tax ernings Taxes (25%) Net Income X X X Tax Rate 25% 4.00% 9% Notes 2039 5,500 4500 300 350 5,150 350 70 280 25% 70 210 2040 6,000 5000 350 420 5,770 230 120 110 25% 27.5 83

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 fill in any Xs' with given excell statements thanks!!!!

A B C 1 Balance Sheet: Assets (Millions of Dollars) 2 3 Assets (million $) 4 Cash 5 S-T investment 6 Accounts receivable 7 Inventories 8 Total current assets (CA) 9 Gross fixed assets (FA) 10 Less: Depreciation 11 Net FA 12 Total assets 13 14 15 16 17 Liabilities and Equity (million $) 18 Accounts payable (A/P) 19 Notes payable 20 Accruals 21 Total current liabilities (CL) 22 Long-term dept 23 Total liabilities 24 Common Stock 25 Retained earnings 26 Total equity 27 Total L&E 28 29 30 31 32 33 34 35 36 37 38 D E X X F 2039 80 120 420 600 4000 1000 2039 340 50 300 2729 800 3529 1200 1730 2930 6459 G X X H 2040 70 20 540 800 4820 1320 2040 440 250 340 3070 1100 4170 1200 1910 3110 7280 I J K L Background Assumptions Tax Rate Interest rate on short-term debt Interest rate on long-term debt Forecasted Sales (2041) Forecasted L-T growth rate Constant dividend policy M (million $) Sales COGS Income Statement (Millions of Dollars) Depreciation Other expenses Tot. op. costs EBIT Intrest expense Pre-tax ernings N Taxes (25%) Net Income Tax Rate X X X Business Plan For Next Year (2041) 1) Accounts cleanup for efficency: Short-term investemnt and NP will net out 2) A new cost saving plan: COGS/Sales=70%. Other expenses 4% 3) No expansion: FA, depreciation and Net FA will not change O 25% 4.00% 9% P Notes 2039 5,500 4500 300 350 Q 5,150 350 70 280 25% 70 210 R 2040 6,000 5000 350 420 5,770 230 120 110 25% 27.5 83 S T U V
Transcribed Image Text:A B C 1 Balance Sheet: Assets (Millions of Dollars) 2 3 Assets (million $) 4 Cash 5 S-T investment 6 Accounts receivable 7 Inventories 8 Total current assets (CA) 9 Gross fixed assets (FA) 10 Less: Depreciation 11 Net FA 12 Total assets 13 14 15 16 17 Liabilities and Equity (million $) 18 Accounts payable (A/P) 19 Notes payable 20 Accruals 21 Total current liabilities (CL) 22 Long-term dept 23 Total liabilities 24 Common Stock 25 Retained earnings 26 Total equity 27 Total L&E 28 29 30 31 32 33 34 35 36 37 38 D E X X F 2039 80 120 420 600 4000 1000 2039 340 50 300 2729 800 3529 1200 1730 2930 6459 G X X H 2040 70 20 540 800 4820 1320 2040 440 250 340 3070 1100 4170 1200 1910 3110 7280 I J K L Background Assumptions Tax Rate Interest rate on short-term debt Interest rate on long-term debt Forecasted Sales (2041) Forecasted L-T growth rate Constant dividend policy M (million $) Sales COGS Income Statement (Millions of Dollars) Depreciation Other expenses Tot. op. costs EBIT Intrest expense Pre-tax ernings N Taxes (25%) Net Income Tax Rate X X X Business Plan For Next Year (2041) 1) Accounts cleanup for efficency: Short-term investemnt and NP will net out 2) A new cost saving plan: COGS/Sales=70%. Other expenses 4% 3) No expansion: FA, depreciation and Net FA will not change O 25% 4.00% 9% P Notes 2039 5,500 4500 300 350 Q 5,150 350 70 280 25% 70 210 R 2040 6,000 5000 350 420 5,770 230 120 110 25% 27.5 83 S T U V
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Accounting for Notes
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
SEE MORE TEXTBOOKS