80.2K

Verified Solution

Link Copied!

FORECASTING ASSIGNMENT Lindgren Industries

Assume you are the Financial Analyst for Lindgren Industries, and it is January 1, 2022.

Lindgren Industries, a manufacturing company, has been growing quickly, but it has found that its financial situation is continually under pressure. Production has fluctuated to meet demand in an attempt to provide first-class service, resulting in larger inventory positions. Also, the collection of accounts has worsened to approximately 60 days, which is well above the invoice terms of net 30 days. To address the financial concerns, Lindgren Industries has proposed level production and an expected effort by the credit department to bring the average collection period down to 35 days.

Estimated sales for the upcoming months are as follows:

January	$5,872,500
February	6,210,000
March	6,615,000
April	7,087,500
May	7,425,000
June	7,695,000

Sales for November were $5,197,500 and will be approximately $5,535,000 for the just completed month of December. It is projected that the current collection period of 60 days will be reduced to 50 days for January and February and to 42 days for March and April, and will meet the target of 35 days in May and June.

Inventory purchases are forecast to be $1,755,000 a month beginning in January. In November they were $2,025,000, and in December they were $1,822,500. The purchases are paid in 40 days. Manufacturing labour expense will be paid as incurred and will be $585,000 a month. Other expenses of manufacturing will also be paid as incurred and are expected to be $1,125,000 a month. Cost of goods sold has regularly been 70% of sales.

Amortization is $114,000 per month. Selling and administrative expenses are expected to be 13 percent of sales (and paid as incurred). The tax rate is 42 percent.

There will be payments on Notes Payable of $2,025,000 in each of February and May. Income taxes of $1,014,000 are due in April. Dividends of $67,500 and interest of $810,000 (3 months of interest) are payable in January and April.

LINDGREN INDUSTRIES

Balance Sheet (Estimated)

December 31, 2021

($ thousands)

ASSETS
Current Assets:
	Cash				$1,332
	Accounts Receivable				7,156
	Inventory				16,462
			Total Current Assets		$24,950
Capital Assets:
	Plant and Equipment			$22,546
	Less: Accumulated Amortization			9,568	12,978
Total Assets					$37,928
LIABILITIES AND SHAREHOLDERS EQUITY
Current Liabilities:
	Accounts Payable				$1,890
	Notes Payable				7,400
	Accrued Liabilities				5,192
		Total Current Liabilities			$14,482
	Long-term Debt				9,450
	Common Stock				9,000
	Retained Earnings				4,996
Total Liabilities and Shareholders Equity					$37,928

Required:

Prepare a monthly pro forma Balance Sheet (for the six months June 2022). No accounts are effected other than those shown above. Explain calculate and step by step

Answer & Explanation Solved by verified expert

See Answer