Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started