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. 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 151 160 Total budgeted disbursements 227,026 207,941 242,744 Section 3: Financing activities Surplus (shortage) 5,974 20,059 25,856 Borrowing (repayments) 15,026 941 -4,856 Ending cash balance $21,000 $21,000 $21,000 What is net cash flow from financing activities for three months? A. 15,026 inflow B. 11,111 inflow C. 15,966 inflow D. 4,856 outflow

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

Net cash inflow (outflow) = 15026+941-4856 = 11111 inflow

So answer is b) $11111 inflow

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 (interest for August is paid in September). Cash...
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...
Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 110,000...
Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 110,000 $ 116,000 $ 136,000 Cash payments For inventory purchases 95,000 77,000 90,000 For S&A expenses 36,000 37,000 32,000 Newman Medical had a cash balance of $13,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...
Franklin Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 107,000...
Franklin Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 107,000 $ 113,000 $ 133,000 Cash payments For inventory purchases 93,500 75,500 88,500 For S&A expenses 34,500 35,500 30,500 Franklin Medical had a cash balance of $11,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...
Finch Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000...
Finch Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000 $ 112,000 $ 132,000 Cash payments For inventory purchases 93,000 75,000 88,000 For S&A expenses 34,000 35,000 30,000 Finch Medical had a cash balance of $11,000 on January 1. The company desires to maintain a cash cushion of $5,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent...
Crane Company is preparing a cash summary budget using the data below. They have already prepared...
Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $39,458 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
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...
Use the following information to answer Question 3.   Harvest Oaks’ beginning balance of cash on April...
Use the following information to answer Question 3.   Harvest Oaks’ beginning balance of cash on April 1 is $450,000. Harvest Oaks wants to maintain a minimum cash balance of $400,000. The company has an agreement with a local bank that allows the company to borrow money in any increment at the beginning of each month. The interest rate on these loans is 1% per month and is not compounded. The company would, as far as it is able, repay the...
Topper, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts,...
Topper, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Topper desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) October November December Quarter Beginning cash balance $ $15,500 $ $16,500 Collections from sales 55,000 238,600 Total cash...