23 4 5 6 7 EN3 Prepare a projected Income statement for 2018 Prepare a projected year-end Balance Sheet for 2018 3. Prepare a projected Cash flow statement for 2018 1. 2. = 9 Assumptions for 2018 based on the company's expansion plans: 8 Cost of goods sold = 43.33% of sales 9 Operating expense = 15% of sales 10 Depreciation = No change, assuming the addition (Purchases) occur at the end of 2018. 11 Repayment of principal (Long-term debt) = $20 12 Cost of borrowing is 10%, stays the same FOR 2018 13 Income tax Tax exp./Pre-tax income = 35% Dividend payout of 20% of EAT (Net Income), 14 15 16 17 18 Inventories 19 Net plant (PP&E) 20 Accounts payable 21 22 Reduce Long-term debt by $20 in the B/S 23 Long-term debt-$20 will be repaid in 2011 Assuming the repayment of $20 will not take place until December 2018, 74 External Fin B/S accounts: Accounts receivable = 23.3% of sales = 28.3% of sales = 30.00% of sales = 41.67% of sales D H
23 4 5 6 7 EN3 Prepare a projected Income statement for 2018 Prepare a projected year-end Balance Sheet for 2018 3. Prepare a projected Cash flow statement for 2018 1. 2. = 9 Assumptions for 2018 based on the company's expansion plans: 8 Cost of goods sold = 43.33% of sales 9 Operating expense = 15% of sales 10 Depreciation = No change, assuming the addition (Purchases) occur at the end of 2018. 11 Repayment of principal (Long-term debt) = $20 12 Cost of borrowing is 10%, stays the same FOR 2018 13 Income tax Tax exp./Pre-tax income = 35% Dividend payout of 20% of EAT (Net Income), 14 15 16 17 18 Inventories 19 Net plant (PP&E) 20 Accounts payable 21 22 Reduce Long-term debt by $20 in the B/S 23 Long-term debt-$20 will be repaid in 2011 Assuming the repayment of $20 will not take place until December 2018, 74 External Fin B/S accounts: Accounts receivable = 23.3% of sales = 28.3% of sales = 30.00% of sales = 41.67% of sales D H
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Transcribed Image Text:23
4
5
6
7
EN3
Prepare a projected Income statement for 2018
Prepare a projected year-end Balance Sheet for 2018
3. Prepare a projected Cash flow statement for 2018
1.
2.
=
9
Assumptions for 2018 based on the company's expansion plans:
8
Cost of goods sold = 43.33% of sales
9 Operating expense = 15% of sales
10 Depreciation = No change, assuming the addition (Purchases) occur at the end of 2018.
11 Repayment of principal (Long-term debt) = $20
12
Cost of borrowing is 10%, stays the same FOR 2018
13
Income tax
Tax exp./Pre-tax income = 35%
Dividend payout of 20% of EAT (Net Income),
14
15
16
17
18 Inventories
19
Net plant (PP&E)
20 Accounts payable
21
22 Reduce Long-term debt by $20 in the B/S
23 Long-term debt-$20 will be repaid in 2011 Assuming the repayment of $20 will not take place until December 2018,
74
External Fin
B/S accounts:
Accounts receivable = 23.3% of sales
= 28.3% of sales
= 30.00% of sales
= 41.67% of sales
D
H
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education