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