Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If able to give me answers to all that would be greatly but really just need clue 7 and clue 8. Thanks! Nordic Company Balance
If able to give me answers to all that would be greatly but really just need clue 7 and clue 8. Thanks!
Nordic Company Balance Sheet March 31, 2020 Assets Cash Accounts Receivable Inventory Buildings & equipment (net) $17,100 $91,200 $23,940 $406,790 $539,030 Total Assets $34,770 Liabilities & Owners' Equity Liabilities Accounts Payable Owners' Equity Capital Stock Retained earnings $361,000 $143,260 Total liab. & Owners' equity $539,030 Clue #1- Sales Budget The marketing department has estimated sales in units as follows: March (actual) 22,800 April 26,600 May 32,300 June 34,200 July 19,000 The selling price of each unit is $5. What are the total sales budgeted for the second quarter? Clue #2- Cash Collections Schedule Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at March 31 are a result of March credit sales. . What is the expected amount of cash to be collected in June? (Hint: You may want to calculate April and May also to help you later in the race.) Clue #3- Accounts Receivable What is the budgeted accounts receivable amount for June 30th? A Question 5 (5 points) Clue #4- Merchandise Purchases Budget The company's gross margin percentage is 40% of sales (i.e. cost of goods sold is 60% of sales). Each month's inventory should equal 30% of the following month's cost of goods sold. Beginning inventory has been given to you. What are total required purchases for June? Question 6 (5 points) Clue #5- Cash Disbursements for Purchases Half of a month's inventory purchases are paid for in the month of purchase and half in the following month. Accounts payable for March 31 have been given to you. What are total expected cash disbursements for purchase of inventory for the month of June? Clue #6- Cash Disbursements for Selling and Administrative Expenses Monthly selling and administrative expenses are budgeted as follows: salaries and wages, $14,250 per month; shipping, 6% of sales; advertising, $11,400 per month; other expenses, 4% of sales; Depreciation, including depreciation on new assets acquired during the quarter, will be $11,400 for the quarter. . . What are total expected cash disbursements for selling and administrative expenses for June? Clue #7 - Cash Budget Equipment purchases during the quarter will be: April $21,850 May $5,700 Dividends of $6,650 will be paid in June. Management wants to maintain a minimum cash balance of $10,000. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $30,000. Interest is 1% per month Nordic can repay the loan at the end of the quarter if it is able to do so. The beginning cash balance has been given to you. What amount will Nordic Company plan to borrow (repay) during June? Note: Repayments must be listed in parenthesis. Clue #8- Balance Sheet You should have all the information in your various schedules. How much are the current assets at June 30thStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started