Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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 30th

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Lawyers In A Nutshell

Authors: Charles Meyer

7th Edition

1647083001, 9781647083007

More Books

Students also viewed these Accounting questions

Question

Who or what is affected by this situation?

Answered: 1 week ago

Question

How important is this situation to the organizations mission?

Answered: 1 week ago