James Furnishings generated $2 million in sales during 2016, and its year-end total assets were $1.5 million. Also, at year-end 2016, current liabilities were $500,000, consisting of $200,000 of notes payable, $200,000 of accounts payable, and $100,000 of accrued liabilities. Looking ahead to 2017, the company estimates that its assets must increase by $0.75 for every $1.00 increase in sales. James' profit margin is 3%, and its retention ratio is 35%. How large of a sales increase can the company achieve without having to raise funds externally? Write out your answer completely. For example, 25 million should be entered as 25,000,000. Do not round intermediate calculations. Round your answer to the nearest cent.

Fundamentals of Financial Management, Concise Edition (MindTap Course List)
9th Edition
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter4: Analysis Of Financial Statements
Section: Chapter Questions
Problem 7DQ: From the Google Finance site, use the DuPont analysis to determine the total assets turnover ratio...
icon
Related questions
Question
James Furnishings generated $2 million in sales during 2016, and its year-end total assets were $1.5 million. Also, at year-end 2016, current liabilities were $500,000, consisting of $200,000 of notes payable, $200,000 of accounts payable, and $100,000 of accrued liabilities. Looking ahead to 2017, the company estimates that its assets must increase by $0.75 for every $1.00 increase in sales. James' profit margin is 3%, and its retention ratio is 35%. How large of a sales increase can the company achieve without having to raise funds externally? Write out your answer completely. For example, 25 million should be entered as 25,000,000. Do not round intermediate calculations. Round your answer to the nearest cent.
File
2
814
5
6
7
Minc Tao - Cengage Learning
C
18
20
template Saved
Home
3 Sales (So)
4 Rate of asset growth
about blank
H
8
9 Notes payable
10 Accounts payable
11 Accrued liabilities
12
13
Insert Draw Page Layout
Total assets Ap
Profit margin
Retention ratio
Current liabilities L
14 Projected increase in assets
15 Spontaneous increase in liabilities
16 Increase in retained earnings
Arial
Workbook Statistics
Next Year's Sales (S₁) =
Increase in Sales =
Sheett
Excel in ine Student Work
Type here to search
10
$2,000,000
75.00%
$1,500,000
3.00%
35.00%
$500,000
$200,000
$200,000
$100,000
Formulas Data
B
(S₁ - So)
x (S1- So)
x S₁
Bi
D
Search for tools, help, and more (Alt + Q)
Review View Help
A
Untitled document - Google [ X
Formulas
V ...
#N/A
#N/A
#N/A
47
E
F
(S1-So)
<(St - So)
S₁
Number
Transcribed Image Text:File 2 814 5 6 7 Minc Tao - Cengage Learning C 18 20 template Saved Home 3 Sales (So) 4 Rate of asset growth about blank H 8 9 Notes payable 10 Accounts payable 11 Accrued liabilities 12 13 Insert Draw Page Layout Total assets Ap Profit margin Retention ratio Current liabilities L 14 Projected increase in assets 15 Spontaneous increase in liabilities 16 Increase in retained earnings Arial Workbook Statistics Next Year's Sales (S₁) = Increase in Sales = Sheett Excel in ine Student Work Type here to search 10 $2,000,000 75.00% $1,500,000 3.00% 35.00% $500,000 $200,000 $200,000 $100,000 Formulas Data B (S₁ - So) x (S1- So) x S₁ Bi D Search for tools, help, and more (Alt + Q) Review View Help A Untitled document - Google [ X Formulas V ... #N/A #N/A #N/A 47 E F (S1-So) <(St - So) S₁ Number
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Forecasting Financial Statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning