FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

Question
Home
Excel File Edit View
CP
Page Layout
J28
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Paste
34
35
36
Insert
X
Calibri (Body)
B I U v
A
1
Ratios
2 Operating profitability (OP) ratio
3 Capital requirement (CR) ratio
4 Return on invested capital (ROIC)
Economic value added (EVA)
B
I
fx
Balance Sheet
TAAREDZAV
C
O
Insert Format Tools
Formulas Data Review
V 12
V
Income Statement
Select destination and press ENTER or choose Paste
D
X
X
X
X
V
APR
23
A^ A
A
E
V
2038
Data Window Help
F
=
X
X
X
X
280
View
G
Percentage Change
2039
H
XA_FIN Statements, CFs and Taxes_Last Name.xlsx
ab Wrap Text
Merge & Center ✓
I
Statement of CFs
الله
J
FCF
S
General
K
V
♫
%
L
500
Performance Ratios
.00
M
+
Conditional Format
Formatting as Table
tv A i
N
S
X
O
Cell
Styles
P
Greenwolde
4
Insert v
Delete v
Format v
Q
XLSX
((.
WE
R
V
E
Sun Apr 23 6:58 PM
8. Ou
Sort &
Filter
Find &
Select
S
T
Sensitivity
Share
U
+ 100%
expand button
Transcribed Image Text:Home Excel File Edit View CP Page Layout J28 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Paste 34 35 36 Insert X Calibri (Body) B I U v A 1 Ratios 2 Operating profitability (OP) ratio 3 Capital requirement (CR) ratio 4 Return on invested capital (ROIC) Economic value added (EVA) B I fx Balance Sheet TAAREDZAV C O Insert Format Tools Formulas Data Review V 12 V Income Statement Select destination and press ENTER or choose Paste D X X X X V APR 23 A^ A A E V 2038 Data Window Help F = X X X X 280 View G Percentage Change 2039 H XA_FIN Statements, CFs and Taxes_Last Name.xlsx ab Wrap Text Merge & Center ✓ I Statement of CFs الله J FCF S General K V ♫ % L 500 Performance Ratios .00 M + Conditional Format Formatting as Table tv A i N S X O Cell Styles P Greenwolde 4 Insert v Delete v Format v Q XLSX ((. WE R V E Sun Apr 23 6:58 PM 8. Ou Sort & Filter Find & Select S T Sensitivity Share U + 100%
A
1 Operating Capital
2 Net operating working capital
3 Long-term assets (Net FA)
4 Total operating capital
5
6
7 (million $)
9 NOPAT
8 Necessary investment in OP. Cap.
10 FCF
B
11
12
13
14
O
2038
X
X
X
X
X
X
2038
2039
80
70
120
20
2038
2039
420
540
EGE 11
X
X
600
800
X
X
1220
1430
X
X
4000
4820
1000
1320
3000
3500
4220
C
18
19 (million $)
20 Sales
21 COGS
22 Depreciation
23 Other expenses
24 Tot. op. costs
25 EBIT
26 Intrest expense
27 Pre-tax ernings
28
29 Taxes (25%)
30 Net Income
31
32
33
34
15
16 Income Statement (Millions of Dollars)
17
Tax Rate
D
E
F
2038
5,500
4500
300
350
5150
350
70
280
25%
70
210
G
2039
2039
6,000
5000
350
420
5770
230
120
110
25%
27.5
82.5
لاع
H
LO
I
Assets (million $)
Cash
Balance Sheet: Assets (Millions of Dollars)
S-T investment
Accounts receivable
Inventories
J
Total current assets (CA)
Gross fixed assets (FA)
Less: Depreciation
Net FA
Total assets
K
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
L
M
N
P
2038
340
50
300
690
800
1490
1200
1730
2930
4420
4930
2039
440
250
340
1030
1100
2130
1200
1910
3110
5240
Q
R
S
T
U
expand button
Transcribed Image Text:A 1 Operating Capital 2 Net operating working capital 3 Long-term assets (Net FA) 4 Total operating capital 5 6 7 (million $) 9 NOPAT 8 Necessary investment in OP. Cap. 10 FCF B 11 12 13 14 O 2038 X X X X X X 2038 2039 80 70 120 20 2038 2039 420 540 EGE 11 X X 600 800 X X 1220 1430 X X 4000 4820 1000 1320 3000 3500 4220 C 18 19 (million $) 20 Sales 21 COGS 22 Depreciation 23 Other expenses 24 Tot. op. costs 25 EBIT 26 Intrest expense 27 Pre-tax ernings 28 29 Taxes (25%) 30 Net Income 31 32 33 34 15 16 Income Statement (Millions of Dollars) 17 Tax Rate D E F 2038 5,500 4500 300 350 5150 350 70 280 25% 70 210 G 2039 2039 6,000 5000 350 420 5770 230 120 110 25% 27.5 82.5 لاع H LO I Assets (million $) Cash Balance Sheet: Assets (Millions of Dollars) S-T investment Accounts receivable Inventories J Total current assets (CA) Gross fixed assets (FA) Less: Depreciation Net FA Total assets K 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 L M N P 2038 340 50 300 690 800 1490 1200 1730 2930 4420 4930 2039 440 250 340 1030 1100 2130 1200 1910 3110 5240 Q R S T U
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Accounting
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
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education