In: Finance
Assume that sales will grow at 5.00%. The following accounts (cash, accounts receivable, inventory, net fixed assets, accounts payable and accruals, as well as operating costs) are assumed to change with sales and will maintain their current percentage of sales rates into 2016. The dividend payout ratio will remain the same. Long-term debt and notes payable will remain constant into 2016 as will interest expense, as a result. The firm also does not plan to issue any additional common stock or conduct any share repurchases. The firm’s tax rate is 40%. Any additional funds needed will be sourced through a line-of-credit (LOC) and surpluses will be paid out through a special dividend.
2015 | |
---|---|
Sales | $1,425.00 |
Operating Costs: | $1,265.00 |
EBIT | $160.00 |
Interest | $35.00 |
Earnings Before Taxes | $125.00 |
Taxes (40%) | $50.00 |
Net Income | $75.00 |
Dividends | $37.50 |
Addition to Retained Earnings | $37.50 |
BALANCE SHEET AS OF 12/31/2015:
ASSETS | 2015 |
---|---|
Cash | $71.25 |
Accounts Receivable | $142.50 |
Inventory | $285.00 |
Current Assets | $498.75 |
Net Fixed Assets (Net PPE) | $356.25 |
Total Assets (TA) | $855.00 |
LIABILITIES & SHAREHOLDER EQUITY | 2015 |
---|---|
Accounts Payable and Accruals | $35.63 |
Notes Payable | $40.00 |
Current Liabilities | $75.63 |
Long Term Debt | $310.00 |
Total Liabilities | $385.63 |
Common Stock | $300.00 |
Retained Earnings | $169.38 |
Owners' Equity | $469.38 |
Total Liabilities and Shareholder Equity | $855.00 |
Using the percent-of-sales forecast approach, forecast the 2016 income statement and balance sheet. Be sure the balance sheet balances.
What is the Projected LOC (if any)?
Enter 0 if none.
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
ACTUALLY IF YOU ADD UP, LIABILITIES SIDE IS COMING 855.01. JUST FOR INFORMATION