Question

In: Accounting

Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable,...

Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable, $135,000; and Accounts payable, $100,000. Its budgeted sales, merchandise purchases, and various expenses for the next three months follow.

July August September
Sales $220,000 $300,000 $380,000
Merchandise purchases 210,000 180,000 220,000
Payroll, rent, and other expenses 96,000 41,000 51,000

20% of the sales are for cash. Of the remaining credit sales, 30% are collected in the same month as the sale, and 70% are collected the month following the sale.

All merchandise is purchased on credit. 20% of the balance is paid in the month of the purchase, and the remaining 80% is paid in the month following the purchase. All other cash expenses are paid in the month incurred. Included in the payroll, rent, and other expenses is $10,000 of depreciation expense.

The company requires a minimum cash balance of $10,000. If cash falls below $10,000, the company borrows on a line of credit with an annual rate of interest of 12% to bring the balance to $10,000. If cash is above $10,000, the company repays as much as possible on any outstanding line of credit but does not allow cash to fall below $10,000. On July 1, the line of credit has a $0 balance.

Complete the following blanks to prepare the cash budget. If a blank has an amount of $0, you are required to enter 0. Note: You have schedules provided below the cash budget that will need to be completed to enable you to prepare certain calculations needed for the cash budget.

Sunny Corporation

Cash Budget

July, 2020 - September, 2020

July August September
Total cash available
Less cash payments for:
Interest expense
Total cash payments
Loan activity:
Additional loan from bank
Repayment of loan to bank
Ending cash balance
Loan balance, end of month

Schedule to Calculate Cash Sales and Credit Sales

July August September
Cash Sales
Credit Sales
Total Sales

Cash Receipts

July August September
Cash sales
Accounts receivable
credit sales
credit sales
credit sales
Total cash receipts

Cash payments for Merchandise Purchases

July August September
Accounts payable
merchandise purchases
merchandise purchases
merchandise purchases
Total cash payments for merchandise purchases

Solutions

Expert Solution

Budgets


Related Solutions

Initial balances: Capital Stock $ 41,000, Advance sale $ 3,000, Cash $ 55,000, Accounts receivable $...
Initial balances: Capital Stock $ 41,000, Advance sale $ 3,000, Cash $ 55,000, Accounts receivable $ 15,000, Inventory $ 41,000, Notes receivable (2 years) $ 2,300, accumulated profits $ 69,300 Register the following transactions of a company in T accounts a. Purchase inventory for $ 10,000 from x company on credit. b. The company pays $ 40 freight on the purchase. c Sells $ 57,000 of inventory on credit to Adam. d. Adam returns the inventory for $ 5,200. e....
The following are the selected account balances or total as of January 1, 2020: Accounts receivable                          
The following are the selected account balances or total as of January 1, 2020: Accounts receivable                                        $380,000 Merchandise Inventory   $260,000 Current Liabilities $280,000 Selected relationship for the year: Gross profit rate                                               40% DSO based on average                                   40 days Inventory turnover based on COGS 8X Current ratio                                                      3:1 Acid Test ratio                                                   2:1 The balance of accounts receivable as of December 31, 2020 is $380,000 $390,000 $400,000 $420,000
Cachet Inc. had a $93,000 balance in Accounts Receivable on July 1. In July, it expects...
Cachet Inc. had a $93,000 balance in Accounts Receivable on July 1. In July, it expects to collect 55% of these receivables and 30% of the July credit sales, which are budgeted at $138,000. What is the budgeted accounts receivable at the end of July? $41,400 $92,550 $138,450 $51,150
1 Palmer Hand Clinic has the following accounts and balances: Cash, $2,350 Accounts Receivable, $280 Professional...
1 Palmer Hand Clinic has the following accounts and balances: Cash, $2,350 Accounts Receivable, $280 Professional Equipment, $1,200 Office Equipment, $6,700 Accounts Payable, $4,380 P. Palmer, Capital, $2,000 Income from Services, $6,000 Rent Expense, $1,850 What is the amount of owner's equity? a.$6,150 b.$4,150 c.$8,000 d.$2,000 2 Which of the following is an example of an asset? a.Accounts Payable b.Outstanding Rent c.Prepaid Insurance d.Capital 3 When an owner withdraws cash from the business, it results in a decrease in: a.Cash...
Northern Pine Company had the following account balances on December 31, 2017: Accounts Balances Cash $3,000...
Northern Pine Company had the following account balances on December 31, 2017: Accounts Balances Cash $3,000 Accounts Receivable $3,500 Prepaid Insurance $2,800 Equipment $16,000 Accumulated Depreciation $7,000 Accounts Payable $1,500 Deferred Revenue $800 Notes Payable $1,200 Common Stock $3,200 Retained Earnings $8,600 Dividends $1,700 Service Revenue $18,200 Salaries Expense $9,250 Rent Expense $4,250 How much is Northern Pine Company's net income for the year ended December 31, 2017
Northern Pine Company had the following account balances on December 31, 2017: Accounts Balances Cash $3,000...
Northern Pine Company had the following account balances on December 31, 2017: Accounts Balances Cash $3,000 Accounts Receivable $3,500 Prepaid Insurance $2,800 Equipment $16,000 Accumulated Depreciation $7,000 Accounts Payable $1,500 Deferred Revenue $800 Notes Payable $1,200 Common Stock $3,200 Retained Earnings $8,600 Dividends $1,700 Service Revenue $18,200 Salaries Expense $9,250 Rent Expense $4,250 How much is Northern Pine Company's net income for the year ended December 31, 2017
A review of Ace Industries, a U.S. corporation, shows the following balances in accounts receivable and...
A review of Ace Industries, a U.S. corporation, shows the following balances in accounts receivable and accounts payable detail at September 30, 2014, their fiscal year end. ACCOUNTS RECEIVABLE Receivables denominated in U.S. dollar                                                                         $426,000 Receivable denominated in 40,000 Australian dollar                                                      43,000 Receivable denominated in 70,000 Canadian dollar                                                       71,750                                                                                                                                                      $ 540,750 ACCOUNTS PAYABLE Payables denominated in U.S. dollar                                                                              $ 107,000 Payable denominated in 50,000 Canadian dollar                                                             51,250 Payable denominated in 200,000 Hong Kong dollar                                                       26,500                                                                                                                                                      $ 184,750 As...
Which of the following groups contain only accounts that normally have credit balances? Accounts Receivable and...
Which of the following groups contain only accounts that normally have credit balances? Accounts Receivable and Fees Income b.    Salaries Expense and Accounts Payable c.     Fees Income and Notes Payable d.   Accounts Payable and Equipment The Chef Manager received a vendor shipment on the last day of the accounting period, after submitting the period’s ending inventory. What should be done to make sure the financials are correctly stated? Nothing Adjust the ending inventory Adjust the ending inventory and process the...
The company has the following account balances on June 1, 2020. (all accounts have their ‘normal’...
The company has the following account balances on June 1, 2020. (all accounts have their ‘normal’ balances) Drawings: 1000 Cash: 20000 Service revenue: 50000 Capital: 15000 Depreciation Expense: 700 Equipment: 30000 Accounts Payable: 5000 Insurance Expense: 500 Unearned Service Revenue: 4000 Prepaid Service Revenue: 500 Accounts Receivable: 4000 Rent Expense: 5000 Salaries Expense: 16000 Accumulated Depreciation - Equipment: 3000 During June 2018, the following events took place. Where appropriate, record a journal entry for each transaction. If no journal entry...
The company has the following account balances on June 1, 2020. (all accounts have their ‘normal’...
The company has the following account balances on June 1, 2020. (all accounts have their ‘normal’ balances) Drawings: 1000 Cash: 20000 Service revenue: 50000 Capital: 15000 Depreciation Expense: 700 Equipment: 30000 Accounts Payable: 5000 Insurance Expense: 500 Unearned Service Revenue: 4000 Prepaid Service Revenue: 500 Accounts Receivable: 4000 Rent Expense: 5000 Salaries Expense: 16000 Accumulated Depreciation - Equipment: 3000 During June 2018, the following events took place. Where appropriate, record a journal entry for each transaction. If no journal entry...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT