Using the percentage of sales forecast method fill in the chart below. Sales are forecasted at…

Using the percentage of sales forecast method fill in the chart below. Sales are forecasted at….

Using the percentage of sales forecast method fill in the chart below. Sales are forecasted at $100,000,000 for Year 2. The debtholders of the company have two covenants: (1) a minimum 1:1 current ratio and (2) a maximum 0.5:1 long-term debt to equity ratio. The company does not want to issue common stock and prefers to issue long-term debt. It pays no dividends. (10 marks).

Forecast (7 marks)

Year 1

% of Sales Method

Year 2

Sales

COGS

50,000,000

(32,000,000)

100,000,000

Gross margin

18,000,000

Fixed

(4,000,000)

EBT

14,000,000

Taxes

-4,200,000

Net Income

9,800,000

Current assets

Long-term assets

11,000,000

39,000,000

Total

50,000,000

Current liabilities

9,000,000

Long-term debt

12,700,000

Common stock

18,500,000

Retained earnings

9,800,000

Total

50,000,000

Current ratio

1.222 to1

Long-Term debt to equity ratio

0.449 to 1

Sustainable Growth Rate

52.973%

(3 marks for answers below):

  1. Will the company meet its covenants in Year 2 (yes or no?): _____
  2. What is the growth rate of the company? ___________
  3. To keep ratios constant what should the growth rate be (same, higher or lower?): _________________

Using the percentage of sales forecast method fill in the chart below. Sales are forecasted at…