Question

In: Finance

Suppose the expected growth of net sales for 2021 is 10%, calculate the Edge Corp. Additional Fund Needed (AFN) for 2021 based on the 2020 status quo

Use this table to answer this question (All are stated in million dollars)

Edge Corp. Balance Sheet

2020

2019

Edge Corp. Balance Sheet

2020

2019

Cash and cash equivalents

2,768

2,879

Accounts payable

8,022

7,251

Short-term investment sec.

954

1,029

Accruals

9,290

8,559

Accounts receivable

5,321

4,306

Notes Payables

9,981

8,472

Total inventories

7,077

6,384

Long-term debt

22,033

21,360

Prepaid expenses

5,548

4,184

Other borrowings

21,027

21,091

TOTAL CURRENT ASSETS

21,970

18,782

TOTAL LIABILITIES

70,353

66,733

Net Property Plants (Net PPE)

21,293

19,244

Common stock+ paid in Cap

58,134

58,134

Other long-term assets

95,091

90,146

Retained earnings

9,565

3,305

TOTAL ASSETS

138,052

128,172

TOTAL LIAB & EQUITY

138,052

128,172

Edge Corp. Income Statement

2020

2019

NET SALES

82,559

78,938

Cost of products sold

40,768

37,919

Selling, general and administrative expense

23,135

21,890

Depreciation expense

2,838

3,108

OPERATING INCOME

15,818

16,021

Interest expense

629

974

EARNINGS BEFORE INCOME TAXES

15,189

15,047

Income taxes

3,392

3,360

NET INCOME

11,797

11,687

Total Dividends Payments

5,537

5,186

Suppose the expected growth of net sales for 2021 is 10%, calculate the Edge Corp. Additional Fund Needed (AFN) for 2021 based on the 2020 status quo. Also, please explain the meaning of the Additional Fund Needed (AFN) for 2021 that you calculated to the firm.

Solutions

Expert Solution

In the absence of detailed information
assuming all assets will need to be increased
with sales increase next year
Spontaneous Assets =Total Assets $                         138,052
Spontaneous Laibilities :
Accounts Payable $                             8,022
Accruals $                             9,290
Total Spontaneous Liability= $                           17,312
Amt $
a Current Sales =S=                               82,559
b Net Income =                               11,797
c Net Income % m =b/a= 14.29%
d Spontanueous Total Asset =A =                             138,052
e Total Spontaneous Current Liability:L=                               17,312
f A/S =                               1.6722
g L/S= 0.20969
h Sales Growth = 10%
i Prejected Sales Next Year =S1=                         90,814.90
j Delta Sales =Sales growth =                            8,255.90
k Dividend payout =d=5537/11797 46.94%
External Finance needed =
AFN= A/S*deltaS-L/S*deltaS-m*S1*(1-d)
AFN=1.6722*8255.9-0.20969*8255.9-14.29%*90814.9*(1-46.94%)
AFN =5188
So Additional Fund needed for 2021 is $5188
The meaning of AFN $5188 is that there will be an increase in the
requirement of assets to deliver the sales gowth next year.
Part of the assets increase will be funded by increase in spontaneous
loabilities that will grow with sales , part will be funded from the
additional retained earning from the additional income from
increased sales . The remaining amount that need to be borrowed
additionally to fund the increase in assets is the AFN =$5188.

Related Solutions

Suppose the expected growth of net sales for 2021 is 8%, calculate the Quantum Inc. Additional Fund Needed (AFN) for 2021 based on the 2020 status quo
Use this table to answer this question (All are stated in million dollars) Quantum Inc. Balance Sheet 2020 2019 Quantum Inc. Balance Sheet 2020 2019 Cash and cash equivalents 2,768 2,879 Accounts payable 8,022 7,251 Accounts receivable 6,275 5,335 Accruals 9,290 8,559 Total inventories 7,379 6,384 Notes Payables 9,981 8,472 Prepaid expenses 5,548 4,184 Long-term debt 22,033 21,360 TOTAL CURRENT ASSETS 21,970 18,782 Other borrowings 21,027 21,091 Net Property Plants (Net PPE) 21,293 19,244 Common stock+ paid in Cap 58,134...
a) Calculate the price to sales ratio when the payout ratio is 35% and net profit margin is 2.5% with a growth rate of 3%and required return on the part of investors is 10%
Please answer all following short questions for Upvote. 1. a) Calculate the price to sales ratio when the payout ratio is 35% and net profit margin is 2.5% with a growth rate of 3%and required return on the part of investors is 10%. b) If sales rise by $0.65 per share, what would be the change in stock price? 2. a) Calculate price to book value if the payout ratio is 30%, ROE is 25% growth in earnings is 4%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT