1 answer

1) The following information is available for Natural Cleaning Services (NCS): • Company sales are expected...

Question:

1) The following information is available for Natural Cleaning Services (NCS): • Company sales are expected to increase by 20% from $10 million in 2019 to $12 million in 2020. • Assets totaled $7 million at the end of 2019. • NCS is at full capacity and its assets must grow at the same rate as sales. • At the end of 2019, current liabilities were $2.2 million, consisting of $750,000 of accounts payable, $600,000 of notes payable and $850,000 of accruals. • The after-tax profit margin is forecasted to be 10% and the forecasted payout ratio is 35%. Use the AFN equation to forecast NCS’s additional funds needed for 2020:


Answers

Additional Funds Needed [AFN] for 2020

Expected Next Year Sales = $12,000,000

After Tax profit Margin

After Tax profit Margin = Expected Next Year Sales x Profit Margin

= $12,000,000 x 10%

= $1,200,000

Dividend Pay-out

Dividend Pay-out = After Tax profit Margin x Dividend Pay-out Ratio

= $1,200,000 x 35%

= $420,000

Additions to Retained Earnings

Additions to Retained Earnings = After Tax profit Margin - Dividend Pay-out

= $1,200,000 - $420,000

= $780,000

Increase in Total Assets

Increase in Total Assets = Total Assets x Percentage of Increase in sales

= $7,000,000 x 20%

= $1,400,000

Increase in Spontaneous liabilities

Increase in Spontaneous liabilities = [Accounts Payable + Accruals] x Percentage of Increase in sales

= [$750,000 + $850,000] x 20%

= $1,600,000 x 20%

= $320,000

Additional Funds Needed [AFN]

Therefore, the Additional Funds Needed [AFN] = Increase in Total Assets – Increase in in Spontaneous liabilities – Additions to retained earnings

= $1,400,000 - $320,000 - $780,000

= $300,000

Therefore, the Additional Funds Needed (AFN) for 2020 is $300,000

.

Similar Solved Questions

1 answer
Column 2 159.26 463.54 161.02 483.5553.8 3124.84 575.85 56.9 60.6 65.2 72.6 82.4 90.9 96.5 10...
Column 2 159.26 463.54 161.02 483.5553.8 3124.84 575.85 56.9 60.6 65.2 72.6 82.4 90.9 96.5 10 424.35 979.52 99.6 11 360.48 977.33103.9 147.71567.66 193.22 567.81 6 306.68 616.68 612.56720.15 460.03782.62 375.67 728.84 7 4. What is ΣΣΧ, 5 using the Σ operator write the notation ...
1 answer
Discuss the roles and practices of healthcare workers, particularly nurses, in Mexico (at least 400 words).
Discuss the roles and practices of healthcare workers, particularly nurses, in Mexico (at least 400 words)....
1 answer
On page 1, you can find the executive summary. Often times in executive summaries, you should...
On page 1, you can find the executive summary. Often times in executive summaries, you should divide it into a broad problem, and a specific, or underlying problem. Based on the 'problem' part of the executive summary, rewrite the section and divide it into an overarching problem, and an und...
1 answer
Search the web for three different hospital systems: one inner city, one academic-focused, and one rural....
Search the web for three different hospital systems: one inner city, one academic-focused, and one rural. (For a list of hospitals in Michigan, look through the web sites for the Michigan Health and Hospital Association and the Michigan Department of Community of Health.) The hospitals you select ca...
1 answer
Question 2: (Points 15) Figure 1 shows a simple circuit consisting of a voltage source, a...
Question 2: (Points 15) Figure 1 shows a simple circuit consisting of a voltage source, a resistor, and woeactancesFind the Thevenin eqd impedance of this circuit at the teminals. Then derive the expressions for the magnitude of VTH and for RTH jXM TH Q2: Fig. 1...
1 answer
What two major events prompted England in particular to consider North American colonization in the early...
What two major events prompted England in particular to consider North American colonization in the early 17th century? How did these events shape England's colonization efforts of North America?...
1 answer
(5) The following data represent the potentials of a fluoride ion-selective electrode vs SCE for several...
(5) The following data represent the potentials of a fluoride ion-selective electrode vs SCE for several solutions. All solutions are made up in a way to control their pH and ionic strength, and contain added EDTA. Prepare an excel plot of the measured potential vs pF based on this information and d...
1 answer
III Question Help U The following data represent the pH of rain for a random sample...
III Question Help U The following data represent the pH of rain for a random sample of 12 rain dates. A normal probability plot suxests the data could come from a population that is normally distributed. A boxplot indicates there are no outliers. Complete parts a) through d) below. 5.05 5.02 5 34 5....
1 answer
Hargrave Limited is selling a new bond to raise capital for their factory in Indonesia. The...
Hargrave Limited is selling a new bond to raise capital for their factory in Indonesia. The bond has a face value of $100,000 and pays a coupon rate of 8.25% p.a. Coupon payments will be made on June 30 and December 31 of each year. The bond’s issue date is January 1, 2019 and matures on Decem...
1 answer
Check into a hotel... Palapildomy ULU 5 pts Question 13 Molen Inc. has an outstanding issue...
Check into a hotel... Palapildomy ULU 5 pts Question 13 Molen Inc. has an outstanding issue of preferred stock with an annual dividend of $1.50 per share. If the required return on this preferred stock is 6.5%, at what price should the stock sell? $13.99 $23.08 $19.50 $15.74 $12.51 Question 14 5 pts...
1 answer
Assign the R/S-configuration for each of the following "molecules" and convert each perspective drawing into a...
Assign the R/S-configuration for each of the following "molecules" and convert each perspective drawing into a Fischer projection. For consistency, please place the highest priority group at the top position. (6 pts) Perspective Drawing R/S-configuration Fischer Projection...
1 answer
How do you solve the system of equations algebraically #1.8x-z=0.7, 1.2y+z=-0.7, 1.5x-3y=3#?
How do you solve the system of equations algebraically #1.8x-z=0.7, 1.2y+z=-0.7, 1.5x-3y=3#?...
1 answer
The figure shows a rod of length L = 14.5 cm that is forced to move...
The figure shows a rod of length L = 14.5 cm that is forced to move at constant speed v = 5.06 m/s along horizontal rails. The rod, rails, and connecting strip at the right form a conducting loop. The rod has resistance 0.527 2; the rest of the loop has negligible resistance. A current i = 103 A thr...
1 answer
Question 1 of 10 1.) Inst: Calculate the volume (mL) per dose to be administered of...
question 1 of 10 1.) Inst: Calculate the volume (mL) per dose to be administered of these oral medications in liquid form. Round to the nearest tenth mL. A provider orders phenytoin 120 mg, PO, three times daily. The pharmacy provides phenytoin in an oral suspension containing 125 mg in 5 mL. mL...
1 answer
Ter 6: Applications of Integral Calculus Compute the length of the arc f(x) = 1+ 2...
ter 6: Applications of Integral Calculus Compute the length of the arc f(x) = 1+ 2 + 2 , xe[0,1]. Select one: O a. e-1 1 O b. Alw Alw - e-104 o de+1 PREVIOUS PAGE...