Paste Clipboard A1 1 2 WN FILE 3 5 6 7 8 9 A B 1. Calculate the additional funds needed. HOME Calibri INSERT READY Attempt(s) BIU Font 11 Y Sales last year Profit margin Retention ratio Sheet1 с PAGE LAYOUT A A fxx Y Additional Funds Needed - Excel FORMULAS DATA REVIEW % Alignment Number Conditional Format as Cell Formatting Table Styles Styles D Assets Liabilities and Equity Current assets $2,124,000 Fixed assets 4,200,000 $ VIEW E 10,200,000 30% 20% LL F Suppose that Gyp Sum Industries currently has the balance sheet shown below, and that sales for the year just ended were $10.2 million. The firm also has a profit margin of 30 percent, a retention ratio of 20 percent, and expects sales of $8.2 million next year. I Cells Current liabilities $ 1,707,480 Long-term debt 1,600,000 3,016,520 Equity Total assets $6,324,000 Total liabilities and equity $ 6,324,000 If all assets and current liabilities are expected to shrink with sales, what amount of additional funds will Gyp Sum need from external sources to fund the expected growth? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign.) G C Editing H 4 Sign In 100% Hint

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question
X-
Paste
Clipboard
A1
1
2
3
5
6
7
FILE
8
00
9
1. Calculate the additional funds needed.
A B
HOME
Calibri
INSERT
READY
Attempt(s)
BIU
Font
X
11
с
Sales last year
Profit margin
Retention ratio
Sheet1
PAGE LAYOUT
A A
fxx
Additional Funds Needed - Excel
FORMULAS DATA
%
Alignment Number
D
Assets Liabilities and Equity
Current assets $ 2,124,000
Fixed assets 4,200,000
REVIEW
Conditional Format as Cell
Formatting Table Styles
Styles
$
VIEW
E
10,200,000
30%
20%
Suppose that Gyp Sum Industries currently has the balance sheet shown below, and that
sales for the year just ended were $10.2 million. The firm also has a profit margin of 30
percent, a retention ratio of 20 percent, and expects sales of $8.2 million next year.
F
Cells
Current liabilities $ 1,707,480
Long-term debt
1,600,000
3,016,520
Equity
Total assets $ 6,324,000 Total liabilities and equity $6,324,000
If all assets and current liabilities are expected to shrink with sales, what amount of
additional funds will Gyp Sum need from external sources to fund the expected growth?
(Enter your answer in dollars not in millions. Negative amount should be indicated by a
minus sign.)
B
G
Editing
H
I
2
Sign In
I
X
▶
+ 100%
Hint
Transcribed Image Text:X- Paste Clipboard A1 1 2 3 5 6 7 FILE 8 00 9 1. Calculate the additional funds needed. A B HOME Calibri INSERT READY Attempt(s) BIU Font X 11 с Sales last year Profit margin Retention ratio Sheet1 PAGE LAYOUT A A fxx Additional Funds Needed - Excel FORMULAS DATA % Alignment Number D Assets Liabilities and Equity Current assets $ 2,124,000 Fixed assets 4,200,000 REVIEW Conditional Format as Cell Formatting Table Styles Styles $ VIEW E 10,200,000 30% 20% Suppose that Gyp Sum Industries currently has the balance sheet shown below, and that sales for the year just ended were $10.2 million. The firm also has a profit margin of 30 percent, a retention ratio of 20 percent, and expects sales of $8.2 million next year. F Cells Current liabilities $ 1,707,480 Long-term debt 1,600,000 3,016,520 Equity Total assets $ 6,324,000 Total liabilities and equity $6,324,000 If all assets and current liabilities are expected to shrink with sales, what amount of additional funds will Gyp Sum need from external sources to fund the expected growth? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign.) B G Editing H I 2 Sign In I X ▶ + 100% Hint
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,