Question

Bill’s Stereo Shop wants to borrow $50,000 from April 1st. until April 30th. It sales equipment...

  1. Bill’s Stereo Shop wants to borrow $50,000 from April 1st. until April 30th. It sales equipment in an area where its typical customer is a member of the armed services or a veteran. Prepare a cash budget for Bill’s Stereo Shop for April using the following data:
    1. March 30th. cash balance $5,000
    2. Merchandise purchases: $50,000 in February, and $55,000 in March. (Bill’s history suggests that 50% of purchases is paid in cash 30 days after purchase and 50% is paid in 60 days after purchase.
    3. Merchandise sales: $100,000 in February, and $125,000 in March. (All sales are credit sales. Bill’s history suggests that 75% of sales are collected in 30 days, and 20% of the sales are collected in 60 days. The other 5% are never collected.)
    4. Interest on bank loan $1,000.
    5. Bill’s expects sequestration to cause somewhere between 5% and 10% of additional customers not to pay.

(Show all work)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cash Budget Problem: Mia Company Prepare Cash Budget for April, May, June 2018 Follow the following...
Cash Budget Problem: Mia Company Prepare Cash Budget for April, May, June 2018 Follow the following to prepare the budget: 1.         Real Sales 2018:         January                        - $100,000                                                 February                      - $200,000                                                 March                          - $150,000             Projected for 2018:     April                            - $400,000                                                 May                             - $300,000                                                 June                             - $200,000             Sales Payment History:           10% cash                                                             40% Accts. Rec. – collected n/30 days                                                             50% Accts. Rec. – collected n/60...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $254,600 $39,100 February 220,900 46,100 March 326,000 48,500 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
The PM Company has planned the following sales for the next three months: January February March...
The PM Company has planned the following sales for the next three months: January February March Budgeted Sales $40,000 $50,000 $70,000 Sales are made 20% for cash and 80% on account (A/R). From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale: 60% First month following sale: 30% Second month following sale: 8% Uncollectible: 2% The following additional information has been provided for March: Inventory purchases (70% paid...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $215,000 $33,800 February 253,000 44,500 March 262,000 39,200 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $237,300 $33,500 February 230,100 38,900 March 329,800 38,300 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months...
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The cost of goods sold is 76% of...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 60,000 Accounts receivable 30,000 Inventory 43,900 Buildings and equipment, net of depreciation 131,000 Total assets $ 264,900 Liabilities and Stockholders’ Equity Accounts payable $ 72,000 Common stock 70,000 Retained earnings 122,900 Total liabilities and stockholders’ equity $ 264,900 Budgeted Income Statements April May June Sales $ 113,000 $...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 7,000 March $    15,000 February $    12,000 April $    18,000 Monthly purchases of raw materials accounts for 50 % of sales forecast for the next month. Of total raw material purchases , payments are 50% in cash in the same month and 50% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT