Mitchell's Industries wishes to prepare a pro forma balance sheet for December 31, 2020. Use the judgemental approach to prepare a proforma balance sheet dated December 31, 2020, for Mitchell's Industries

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
17
File Home
X
Paste
C9
Clipboard
AutoSave Off H
A
유
JĮ
31 Total current assets
32 Net fixed assets
33 Total assets
18
19
20
21
22
23
24
25
26 Assets
27 Cash
28 Marketable Securities
29 Accounts receivable
30 Inventories
B
menims necprontmargims
10) It expects to pay out cash dividends of $
40 Long-term debt
41 Total liabilities
42 Common stock
43 Retained earnings
Insert Page Layout
Calibri
<
BIU
U
Ready
34
35 Liabilities and stockholder's equity
36 Accounts payable
37 Accruals
38
Other current liabilities.
39 Total current liabilities
The December 31, 2019, balance sheet follows:
> ...
X✓ fx
32°C
Mostly sunny
✓11
H
Font
Mitchell's Industries
Pro Forma Balance Sheet
December 31, 2019
Accessibility: Investigate
$
$
44 Total liabilities and stockholder's equity $
45
46
47
$
$
$
$
V
Formulas Data Review View Automate Help
11 A A
~A~
Horizontal Analysis
ī FIRSTNAME_LASTNAME_Accounting-Finance MBA Assignm.... Saved to this PC ✓
■
V
47.
45,000
15,000
255,000
340.000
655,000
600,000
1,255,000
70,000 during 2020
395,000
60,000
30.000
485.000
350,000
835,000
200,000
220,000
1,255,000
= =
Vertical Analysis
Q Search
D
Alignment
E
ab
F
Proforma-Balance Sheet
Custom
$%90000000
-%
G
Number
H
I
5
Conditional Format as Cell
Formatting Table Styles
Styles
J
Proforma -Income Statement
99+
K
0 Search
a
L
M
N
myho
Insert V
x Delete
Format
Cells
Time Value of Money Problems
0
P
Σ
↓
AY
Sort & Find &
Filter Select
Editing
+
deslyn douglas DD
I
R
B
S
D
m
T
Comments
Analyze Add-ins
Data
Analysis
ENG
INTL
00
00
Add-ins
U
Y
Share ✔
W
+ 70%
11:16 am
15/10/2023
Transcribed Image Text:17 File Home X Paste C9 Clipboard AutoSave Off H A 유 JĮ 31 Total current assets 32 Net fixed assets 33 Total assets 18 19 20 21 22 23 24 25 26 Assets 27 Cash 28 Marketable Securities 29 Accounts receivable 30 Inventories B menims necprontmargims 10) It expects to pay out cash dividends of $ 40 Long-term debt 41 Total liabilities 42 Common stock 43 Retained earnings Insert Page Layout Calibri < BIU U Ready 34 35 Liabilities and stockholder's equity 36 Accounts payable 37 Accruals 38 Other current liabilities. 39 Total current liabilities The December 31, 2019, balance sheet follows: > ... X✓ fx 32°C Mostly sunny ✓11 H Font Mitchell's Industries Pro Forma Balance Sheet December 31, 2019 Accessibility: Investigate $ $ 44 Total liabilities and stockholder's equity $ 45 46 47 $ $ $ $ V Formulas Data Review View Automate Help 11 A A ~A~ Horizontal Analysis ī FIRSTNAME_LASTNAME_Accounting-Finance MBA Assignm.... Saved to this PC ✓ ■ V 47. 45,000 15,000 255,000 340.000 655,000 600,000 1,255,000 70,000 during 2020 395,000 60,000 30.000 485.000 350,000 835,000 200,000 220,000 1,255,000 = = Vertical Analysis Q Search D Alignment E ab F Proforma-Balance Sheet Custom $%90000000 -% G Number H I 5 Conditional Format as Cell Formatting Table Styles Styles J Proforma -Income Statement 99+ K 0 Search a L M N myho Insert V x Delete Format Cells Time Value of Money Problems 0 P Σ ↓ AY Sort & Find & Filter Select Editing + deslyn douglas DD I R B S D m T Comments Analyze Add-ins Data Analysis ENG INTL 00 00 Add-ins U Y Share ✔ W + 70% 11:16 am 15/10/2023
3
4
C9
9
10
AutoSave Off H
File Home
X
13
Paste
14
15
Clipboard
17
Problem:
Insert Page Layout
Calibri
BIU
U
X✓ fx
5
6 Assumption(s)
7 The following information has been gathered:
B
8 1) The firm expects 2020 sales to total $
Marketable securities are expected to
11
12 5) Inventories represent
6) A new machine costing
2) remain unchanged
3) The desired minimum cash balance
4) Accounts receivable represents
32°C
Mostly sunny
Font
Total depreciation for the year will be
7) Accounts payable represent
H
✓11
Accruals, other current liabilities, long-
term debt, and common stock are
16 8) expected to remain unchanged
9) The firm's net profit margin is
10) It expects to pay out cash dividends of
Ready Accessibility: Investigate
$
Formulas Data Review View Automate Help
11 A A
~A~
$
$
18
19
20 The December 31, 2019, balance sheet follows:
>
Horizontal Analysis
V
ī FIRSTNAME_LASTNAME_Accounting-Finance MBA Assignm.... Saved to this PC ✓
■
V
C
Mitchell's Industries wishes to prepare a pro forma balance sheet for December 31, 2020. Use the judgemental approach to prepare a
proforma balance sheet dated December 31, 2020, for Mitchell's Industries
3,000,000
50,000
=
14% of sales
D
10% of sales
12% of sales
90,000 will be acquired during 2020
32.000
4%
70,000 during 2020
Vertical Analysis
Q Search
Alignment
E
ap
F
Custom
$%90000000
-%
G
Number
H
I
5
Conditional Format as Cell
Formatting Table Styles
Styles
J
Proforma-Balance Sheet Proforma -Income Statement
99+
K
Search
L
a
M
Insert V
x Delete
Format
Cells
myha
N
Time Value of Money Problems
0
P
Σ
↓
AY
Sort & Find &
Filter Select
Editing
+
deslyn douglas DD
KI
R
B
S
D
m
T
Comments
Analyze Add-ins
Data
Analysis
ENG
INTL
00
00
Add-ins
U
V
Share ✔
W
+ 70%
11:16 am
15/10/2023
Transcribed Image Text:3 4 C9 9 10 AutoSave Off H File Home X 13 Paste 14 15 Clipboard 17 Problem: Insert Page Layout Calibri BIU U X✓ fx 5 6 Assumption(s) 7 The following information has been gathered: B 8 1) The firm expects 2020 sales to total $ Marketable securities are expected to 11 12 5) Inventories represent 6) A new machine costing 2) remain unchanged 3) The desired minimum cash balance 4) Accounts receivable represents 32°C Mostly sunny Font Total depreciation for the year will be 7) Accounts payable represent H ✓11 Accruals, other current liabilities, long- term debt, and common stock are 16 8) expected to remain unchanged 9) The firm's net profit margin is 10) It expects to pay out cash dividends of Ready Accessibility: Investigate $ Formulas Data Review View Automate Help 11 A A ~A~ $ $ 18 19 20 The December 31, 2019, balance sheet follows: > Horizontal Analysis V ī FIRSTNAME_LASTNAME_Accounting-Finance MBA Assignm.... Saved to this PC ✓ ■ V C Mitchell's Industries wishes to prepare a pro forma balance sheet for December 31, 2020. Use the judgemental approach to prepare a proforma balance sheet dated December 31, 2020, for Mitchell's Industries 3,000,000 50,000 = 14% of sales D 10% of sales 12% of sales 90,000 will be acquired during 2020 32.000 4% 70,000 during 2020 Vertical Analysis Q Search Alignment E ap F Custom $%90000000 -% G Number H I 5 Conditional Format as Cell Formatting Table Styles Styles J Proforma-Balance Sheet Proforma -Income Statement 99+ K Search L a M Insert V x Delete Format Cells myha N Time Value of Money Problems 0 P Σ ↓ AY Sort & Find & Filter Select Editing + deslyn douglas DD KI R B S D m T Comments Analyze Add-ins Data Analysis ENG INTL 00 00 Add-ins U V Share ✔ W + 70% 11:16 am 15/10/2023
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
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