Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Oxford Handbook Of Entrepreneurial Finance

Authors: Douglas Cumming

1st Edition

0195391241, 978-0195391244

More Books

Students also viewed these Finance questions