x fx B D E F G 15 42 42 Month October November December January February March April May June July August September Beginning Inventory Production Sales 5 42 22 42 49 81 42 113 145 42 172 42 189 42 176 148 42 70 42 32 42 Ending Inventory Inventory cost 25 22 $ 11,000 49 24,500 10 81 40,500 10 113 56,500 10 145 72,500 15 172 86,000 25 189 94,500 55 176 88,000 70 148 74,000 120 70 35,000 80 32 16,000 65 9 4,500 42 . The balance sheet for the beginning of the year is given below: Thruster Corporation Balance sheet Sept 30 2018 Assets Liabilities Cash $ 25,000 Accounts Payable $ 20,000 Accounts receivable 30,000 Line of Credit Inventory 2,500 Long term debt 150,000 Current Assets 57,500 total liabilities 170,000 Stock - 80,000 Capital Assets 200,000 Retained earnings 7,500 lotai lailles Total Assets $ 257,500 and equity $ 257,500 Additional Information The surfboards sell for $800 each. 25% of the sales are cash sales and the remainder are accounts receivable paid the following month. The cost per board is $500 these costs are all paid the month following production Fixed costs are $132,000 paid in equal amounts each month Taxes are 25% you may assume the amount calculated on your income statement is paid in April The corporation pays a 20% dividend in May The company would like to maintain a minimum cash balance of $5,000 and will borrow on its line of credit when necessary and repay the line of credit as soon as they are able Required 1. Complete the income statement and calculate the amount to be transferred to retained earnings. The beginning inventory is @ 500 per board. 2. Complete the schedules of collections and payments Complete the cash budget and balance sheet Bonus - use a formula to calculate the required borrowing and repayments. The formula should be able to recognize whether there will be borrowings or repayments - an if function perhaps