XS FILE Paste A1 5 Clipboard C 6 7 8 9 10 11 12 1. Calculate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
XS FILE Paste A1 5 Clipboard C 6 7 8 9 10 11 12 1. Calculate the additional funds needed. a A B V HOME INSERT B Calibri BIU- E Font X Sales last year Profit margin Sheet1 11 Α Α΄ -A- Retention ratio Sales next year Assets Current liabilities PAGE LAYOUT ✓ C Current assets $2,124,000 Fixed assets 4,200,000 A G + Additional Funds Needed - Excel FORMULAS DATA Epic % 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. Assets Liabilities and Equity Current liabilities Long-term debt 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.) REVIEW Alignment Number Conditional Format as Cell Formatting Table Styles Styles $ $ $ $ VIEW $ 1,707,480 1,600,000 3,016,520 10,200,000 30% 20% ? 8,200,000 6,324,000 1,707,480 3 Cells Editing < Prev Sign In 8 of 9 C Next > FILE Paste A1 769 Clipboard F 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1. Calculate the additional funds needed. 25 26 - A B HOME Calibri INSERT BIU- H Font B X Sales last year Profit margin Retention ratio Sales next year Assets Current liabilities PAGE LAYOUT 11 Α Α΄ -A- Sheet1 ✓ C fx Additional Funds Needed - Excel FORMULAS DATA % Alignment Number Necessary increase in assets Spontaneous increase in liabilities Projected increase in retained earnings Additional Funds Needed $ $ $ $ REVIEW D Cell Conditional Format as Formatting Table Styles Styles 10,200,000 30% 20% 8,200,000 6,324,000 1,707,480 VIEW E Cells ? Complete the following analysis. Do not hard code values in your calculations, and do not round intermediate calculations. Editing H < Prev Sign In 8 of 9 H X 4 Next > XS FILE Paste A1 5 Clipboard C 6 7 8 9 10 11 12 1. Calculate the additional funds needed. a A B V HOME INSERT B Calibri BIU- E Font X Sales last year Profit margin Sheet1 11 Α Α΄ -A- Retention ratio Sales next year Assets Current liabilities PAGE LAYOUT ✓ C Current assets $2,124,000 Fixed assets 4,200,000 A G + Additional Funds Needed - Excel FORMULAS DATA Epic % 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. Assets Liabilities and Equity Current liabilities Long-term debt 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.) REVIEW Alignment Number Conditional Format as Cell Formatting Table Styles Styles $ $ $ $ VIEW $ 1,707,480 1,600,000 3,016,520 10,200,000 30% 20% ? 8,200,000 6,324,000 1,707,480 3 Cells Editing < Prev Sign In 8 of 9 C Next > FILE Paste A1 769 Clipboard F 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1. Calculate the additional funds needed. 25 26 - A B HOME Calibri INSERT BIU- H Font B X Sales last year Profit margin Retention ratio Sales next year Assets Current liabilities PAGE LAYOUT 11 Α Α΄ -A- Sheet1 ✓ C fx Additional Funds Needed - Excel FORMULAS DATA % Alignment Number Necessary increase in assets Spontaneous increase in liabilities Projected increase in retained earnings Additional Funds Needed $ $ $ $ REVIEW D Cell Conditional Format as Formatting Table Styles Styles 10,200,000 30% 20% 8,200,000 6,324,000 1,707,480 VIEW E Cells ? Complete the following analysis. Do not hard code values in your calculations, and do not round intermediate calculations. Editing H < Prev Sign In 8 of 9 H X 4 Next >
Expert Answer:
Answer rating: 100% (QA)
To determine the additional funds needed to fund the expected growth we need to calculate the necess... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
On the April 4 billing date, Michaelle Chappell had a balance due of $1065.77 on her credit card. From April 4 through May 3, Michaelle charged an additional $402.89 and made a payment of $600. a)...
-
Suppose that Gyp Sum Industries currently has the following balance sheet, and that sales for the year just ended were $10 million. The firm also has a profit margin of 25 percent, a retention ratio...
-
Eagle Corporation operates Magnetic Resonance Imaging (MRI) clinics throughout the Northeast. At the end of the current period, the company reports the following amounts: Assets = $48,000;...
-
A force of 24N is applied to a wrench which is 0.4m in length. If the force is applied at an angle of 15 degrees, find the torque in N-m. Round off to two decimal places.
-
A flexible rope of length 1.0 m slides from a frictionless table top as shown in Figure 9-E the rope is initially released from rest with 30 cm hanging over the edge of the table. Find the time at...
-
If 43x+2=16x+4, then x equals
-
a. Beginning with the score function for the logit case in equation (11.5), show that the information matrix can be expressed as \[\mathbf{I}(\boldsymbol{\beta})=\sum_{i=1}^{n} \sigma_{i}^{2}...
-
Kroger, Safeway Inc., and Whole Foods Markets, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets...
-
A block placed under the head of the claw hammer as shown greatly facilitates the extraction of the nail. If a 47-lb pull on the handle is required to pull the nail, calculate the tension T in the...
-
a. During February, $194,500 was paid to creditors on account, and purchases on account were $210,400. Assuming that the February 28 balance of Accounts Payable was $62,500, determine the account...
-
"How do we evaluate a child's language development in a naturalistic setting using Roger Brown's procedures? Specifically, describe how we calculate MLU and name some of the most important bound...
-
What does a staffing management plan address?
-
Who leads an Agile project team? Might this change throughout the project?
-
What does RAM stand for, and what is its purpose?
-
What are the three r activities that take place near the end of a project, regarding team members and timing issues?
-
Apps for an Apple iPhone or Google Android phone are examples of ____________ innovations, whereas the use of robotics in performing manufacturing tasks previously done by humans is an example of...
-
Display the ename, salary, hiredate and the date when Friday comes after the hiredate for all employees.
-
An annual report of The Campbell Soup Company reported on its income statement $2.4 million as equity in earnings of affiliates. Journalize the entry that Campbell would have made to record this...
-
Leslie and Leon Lazo are married and file a joint return for 2012. Leslie's Social Security number is 466-47-3311 and Leon's is 467-74-4451. They live at 143 Snapdragon Drive, Reno, NV 82102. For...
-
Matthew borrows $250,000 to invest in bonds. During 2012, his interest on the loan is $30,000. Matthew's interest income from the bonds is $10,000. This is Matthew's only investment income. a....
-
Skyler is covered by his company's health insurance plan. The health insurance costs his company $3,500 a year. During the year, Skyler is diagnosed with a serious illness and the health insurance...
-
Your firms bank has offered you two options for short-term financing in the amount of \($400,000.\) The first option is a committed line of credit with a commitment fee of 0.5% (EAR) and an interest...
-
The Row Cannery wants to borrow \($2\) million for one month. Using its inventory as collateral, it can obtain a 12% (APR) loan. The lender requires that a warehouse arrangement be used. The...
-
What do you think is the optimum container ship size?
Study smarter with the SolutionInn App