70.2K

Verified Solution

Link Copied!

The Iggy Store is a retail fashion outlet. You are the controller of the company. Use Exercise 8-12 as a reference. Prepare a master budget for the months October, November, and December 2021, and for the quarter, using the information provided below. You must use Excel to prepare the budget and submit an Excel workbook. The master budget must include: Budgeted Sales Revenue: August September October November December January 2022 $ 60,000 60,000 70,000 85,000 90,000 50,000 Schedule of Expected Cash Collections Merchandise Purchases Budget Schedule of Expected Cash Disbursements for Merchandise Purchases Selling and Administrative Expenses Budget Cash Budget Budgeted Income Statement Budgeted Balance Sheet Budgeted Expenses (per month): Salaries and wages Advertising Depreciation Shipping as a percent of sales Other expenses as a percent of sales $ 7,500 6,000 2,000 6% 4% The project will be graded based on accuracy of calculations, proper use of Excel formulas and references, as well as professional formatting. 40% The Iggy Store Balance Sheet as at September 30, 2021 20% 50% 30% Additional Information: Gross profit rate Sales revenue collected in the month of sale first month following the sale second month following the sale Merchandise purchase paid in the month of purchase first month following the purchase second month following the purchase Required minimum inventory as a percent of next month's cost of goods sold Borrowing interest rate (per month) Required minimum cash balance 60% 30% 10% Assets Cash Accounts receivable Inventory Plant and equipment, net Total assets $ 11,000 66,000 12,600 200,000 $ 289,600 30% 1% $ 10,000 $ 18,720 Liabilities Accounts payable Stockholders' Equity Common stock Retained earnings Total liabilities and stockholders' equity Salaries and wages, advertising, shipping, and other expenses are paid in cash in the month incurred. The company plans to purchase equipment in October for $20,000 in cash and pay dividends of $5,000 in December. 180,000 90,880 $ 289,600 The company has an agreement with a local bank that allows the company to borrow and repay in increments of $1,000. Interest is paid at the end of every month based on the loan outstanding

Answer & Explanation Solved by verified expert

See Answer