Longbranch is expecting a 20 percent increase in sales next year, and management is concerned about the companys need for external funds. The increase in sales is expected to be carried out without any expansion of capital assets; instead, it will be done through more efficient asset utilization in the existing stores. The Dividends Payout Ratio remains unchanged and forecasted taxes are $24,400.

1. Using a percentofsales method, determine whether Longbranch Western Wear has external financing needs.
2. Prepare a pro forma income statement and balance sheet with any financing adjustment made to notes payable, i.e. including the external financing needs (the plug). If external financing is not required, excess funds are first used to reduce notes payable with the difference going towards reducing long-term debt.
3. Calculate the current ratio and total debt-to-assets ratio for each year.

The Longbranch Western Wear Company has the following financial statements, which are representative of the company's historical average. \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Income Statement } \\ \hline & \multicolumn{3}{|c|}{$200,000} \\ \hline & \multicolumn{3}{|c|}{158,000} \\ \hline \multicolumn{2}{|c|}{ Earnings before interest and taxes } & \multicolumn{3}{|c|}{42,000} \\ \hline & \multicolumn{3}{|l|}{2,000} \\ \hline \multicolumn{2}{|c|}{ Earnings before taxes............ } & \multicolumn{3}{|l|}{40,000} \\ \hline & \multicolumn{3}{|c|}{20,000} \\ \hline \multicolumn{2}{|c|}{ Earnings after taxes................ } & \multicolumn{3}{|c|}{$20,000} \\ \hline \multicolumn{2}{|c|}{ Dividends............................... } & \multicolumn{3}{|c|}{$10,000} \\ \hline \multicolumn{5}{|c|}{ Balance Sheet } \\ \hline \multicolumn{2}{|l|}{ Assets } & \multicolumn{3}{|c|}{ Liabilities and Shareholders' Equity } \\ \hline Cash.............................. $ & 10,000 & Accounts payable.............. & $ & 5,000 \\ \hline Accounts receivable..... & 10,000 & Accrued wages................. & & 1,000 \\ \hline Inventory..................... & 15,000 & Accrued taxes.................. & & 2,000 \\ \hline Current assets............. & 35,000 & Current liabilities................ & & 8,000 \\ \hline \multirow[t]{6}{*}{ Capital assets................ } & 70,000 & Notes payable.................... & & 7,000 \\ \hline & & Long-term debt.................... & & 15,000 \\ \hline & & Common stock (at Par) & 20,000 & \\ \hline & & Paid In Capital & 5,000 & \\ \hline & & Retained earnings & 50,000 & \\ \hline & & Total Common Equity & 75,000 & \\ \hline \multicolumn{2}{|c|}{ Total assets.................\$105,000 } & Total liabilities and equity.... & & $105,000 \\ \hline \end{tabular}