Question

Use the following information to prepare a budgeted income statement for Arbor Company for the month of June.
a. Beginning cash balance on June 1 is $52,000.
b. Cash receipts from sales: 40% is collected in the month of sale, 50% in the next month, and 10% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: April (actual), $1,450,000, May (actual), $1,600,000, and June (budgeted), $1,700,000.
c. Payments on merchandise purchases: 80% in the month of purchase and 20% in the month following purchase. Purchases amounts are May (actual), $830,000; and June (budgeted), $867,000.
d. Budgeted cash disbursements for salaries in June: $260,000. Salaries payable on May 31 are $60,000 and are expected to be $50,000 on June 30.
e. Budgeted depreciation expense for June: $24,000.
f. Other cash expenses budgeted for June: $282,000.
g. Accrued income taxes due in June: $48,000.
h. Bank loan interest due in June: $8,000 which represents the 1% monthly expense on a bank loan of $800,000.
i. Loan payment of $50,000 if the preliminary cash balance is greater than $100,000.
j. Cost of goods sold is 53% of sales.
k. The income tax rate applicable to the company is 30%.

Answer

This answer is hidden. It contains 372 characters.