60.1K

Verified Solution

Link Copied!

How do you calculate Line of Credit when you have all this data:

Garlington Technologies Inc.'s 2019 financial statements are shown below:

Income Statement for December 31, 2019

Sales	$4,000,000
Operating costs	3,200,000
EBIT	$ 800,000
Interest	120,000
Pre-tax earnings	$ 680,000
Taxes (25%)	170,000
Net income	510,000
Dividends	$ 190,000

Balance Sheet as of December 31, 2019

Cash	$ 160,000		Accounts payable	$ 360,000
Receivables	360,000		Line of credit	0
Inventories	720,000		Accruals	200,000
Total CA	$1,240,000		Total CL	$ 560,000
Fixed assets	4,000,000		Long-term bonds	1,000,000
Total Assets	$5,240,000		Common stock	1,100,000
			RE	2,580,000
			Total L&E	$5,240,000

Suppose that in 2020 sales increase to $4.4 million and that 2020 dividends will increase to $166,000. Forecast the financial statements using the forecasted financial statement method. Assume the firm operated at full capacity in 2019. The long-term bonds have an interest rate of 11%. New financing will be with a line of credit. Assume it will be added at the end of the year. Cash does not earn any interest income. Enter your answers as positive values. Do not round intermediate calculations. Round your answers to the nearest dollar.

Garlington Technologies Inc. Pro Forma Income Statement December 31, 2020
Sales		$ 4,440,000
Operating costs		$ 3,552,000
EBIT		$ 880,000
Interest		$ 110,000
Pre-tax earnings		$ 770,000
Taxes (25%)		$ 192,500
Net income		$ 577,500
Dividends:		$ 166,000
Addition to RE:		$ 411,500

Garlington Technologies Inc. Pro Forma Balance Statement December 31, 2020
Cash		$ 177,600
Receivables		$ 399,600
Inventories		$ 799,200
Total current assets		$ 1,376,400
Fixed assets		$ 4,440,000
Total assets		$ 5,816,400
Accounts payable		$ 399,600
Line of credit
Accruals		$ 222,000
Total current liabilities		$
LT bonds		$ 1,000,000
Common stock		1,100,000$
Retained earnings		2,991,500$
Total L&E		$ 5,816,400

Answer & Explanation Solved by verified expert

See Answer