Question

The accountant for Kaya's Dress Shop prepared the following cash budget. Kaya's desires to maintain a...

The accountant for Kaya's Dress Shop prepared the following cash budget. Kaya's desires to maintain a cash cushion of $21,000 at the end of each month. Funds are assumed to be borrowed at the beginning of the month the shortage is anticipated and repaid on the last day of each month. Interest is charged at 12% annual rate or 1 percent per month and be paid next month after the first borrowing (interest for August is paid in September). Cash Budget July August September Section 1: Cash receipts Beginning cash balance $46,000 $21,000 $21,000 Add cash receipts 187,000 207,000 247,600 Total cash available 233,000 228,000 268,600 Section 2: Cash payments For inventory purchases 169,026 143,730 177,652 For S&A expenses 58,000 64,060 64,932 For interest expense 0 150 Total budgeted disbursements 227,026 207,940 Section 3: Financing activities Surplus (shortage) 5,974 20,059 Borrowing (repayments) 15,026 941 Ending cash balance $21,000 $21,000 What was interest cash payment in September? A. 150.26 B. 94 C. 160 D. 320

Homework Answers

Answer #1

cash budget

July August September
Beginning cash balance 46000 21000 21000
Cash receipts 187000 207000 247600
Total cash available 233000 228000 268600
Less: Cash payment
Inventory purchase -169026 -143730 -177652
For S&A -58000 -64060 -64932
For interest expense 0 -151 -160
Total cash payment -227026 -207941 -242744
Surplus (Shortage) 5974 20059 25856
Borrowing 15026 941 -4856
Ending cash balance 21000 21000 21000

Interest expense = (15026+941)*1% -= $160

So answer is c) $160

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
The accountant for Kaya's Dress Shop prepared the following cash budget. Kaya's desires to maintain a...
The accountant for Kaya's Dress Shop prepared the following cash budget. Kaya's desires to maintain a cash cushion of $21,000 at the end of each month. Funds are assumed to be borrowed at the beginning of the month the shortage is anticipated and repaid on the last day of each month. Interest is charged at 12% annual rate or 1 percent per month and be paid next month after the first borrowing. Cash Budget July August September Section 1: Cash...
The accountant for Kaya's Dress Shop prepared the following cash budget. Kaya's desires to maintain a...
The accountant for Kaya's Dress Shop prepared the following cash budget. Kaya's desires to maintain a cash cushion of $21,000 at the end of each month. Funds are assumed to be borrowed at the beginning of the month the shortage is anticipated and repaid on the last day of each month. Interest is charged at 12% annual rate or 1 percent per month and be paid next month after the first borrowing. Cash Budget July August September Section 1: Cash...
Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions...
Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 64,000 $ 80,000 $ 48,000 Budgeted cash payments for Direct materials 16,160 13,440 13,760 Direct labor 4,040 3,360 3,440 Factory overhead 20,200 16,800 17,200 Sales are 20% cash and 80% on...
The cash budget was prepared with the following assumptions: The Company has borrowed a $500,000 revolving...
The cash budget was prepared with the following assumptions: The Company has borrowed a $500,000 revolving loan on 31 December last year, charging 1% interest per month.   Borrowing should be made to bring the Company to minimum $4,000 cash balance at each month end. Partially loan repayment should be made whenever there is any excess cash. Borrowing and repayment of the loans should be in multiples of $1,000. It is assumed that borrowing occurs at the beginning of the month...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600 Total cash available Preliminary cash balance Ending cash balance Loan balance Loan balance - Beginning of month $0 Additional loan (loan repayment) Loan balance - End of month Karim Corp. requires a minimum $8,200 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at...
Deedre Manufacturing has a cash balance of $8,000 on August 1 of the current year. The...
Deedre Manufacturing has a cash balance of $8,000 on August 1 of the current year. The company's controller forecast the following cash receipts and cash disbursements: Cash Receipts Cash Payments August $45,000 $57,000 September $66,000 $67,000 October $70,000 $56,000 Management desires a minimum balance of $8,000 at all times. If necessary, additional financing can be obtained at a 12% interest rate. Interest is paid at the time of repaying loan principal. Note: for calculating interest, if our budget indicates we...
C) Complete a manufacturing overhead budget from the given information: July August September Total Budgeted MHs...
C) Complete a manufacturing overhead budget from the given information: July August September Total Budgeted MHs 2,000 5,000 7,000 14,000 The company’s variable overhead rate is $4 per machine hour (MH). Total expected fixed overhead costs are $12,000 per month. Total non-cash fixed overhead expenses are $3,000 per month. July August September Total Budgeted MHs VMOH rate VMOH costs FMOH costs Total MOH costs Less: non-cash Cash disbursements for MOH D) Complete a cash budget from the given information: July...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 60,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following...
Use the following information to prepare the September cash budget for PTO Manufacturing Co. The following information relates to expected cash receipts and cash payments for the month ended September 30. Beginning cash balance, September 1, $41,000. Budgeted cash receipts from sales in September, $264,000. Raw materials are purchased on account. Purchase amounts are: August (actual), $77,000, and September (budgeted), $108,000. Payments for direct materials are made as follows: 65% in the month of purchase and 35% in the month...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $139,000 $167,000 $231,000 Manufacturing costs 58,000 72,000 83,000 Selling and administrative expenses 49,000 50,000 88,000 Capital expenditures _ _ 55,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...