Fast Feet Inc makes running shoes and they have gathered the following data for the month of October:Cash on 10/1Expected Cash CollectionsDirect Materials Cash DisbursementsDirect Labor Cash DisbursementsMOH Cash DisbursementsOperating Expenses Cash DisbursementsCapital Expenditures Cash DisbursementsData$16,000$459,000$86,000$41,000$28,000$113,000$205,000Fast Feet Inc requires an ending cash balance of at least $12,000 and can borrow from a line of credit in $1,000 increments. How much will the company need to borrow at the end of October?OA. $10,000OB. $2,000OC. $16,000OD. $0+

The objective of the question is to determine how much Fast Feet Inc will need to borrow at the end…

Answered: Fast Feet Inc makes running shoes and…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…
Baird Medical Clinic has budgeted the following cash flows. February $108,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $102,000 $128,000 91,000 73,000 33,000 86,000 28,000 32,000 Baird Medical had a cash balance of $9,000 on January 1. The company desires to maintain a cash cushion of $7,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 3 percent per month. Repayments may be made in any amount available. Baird pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign. ) Cash Budget January February March Section 1: Cash Receipts $ $ Total cash available Section 2: Cash Payments Total…
Schedule of Cash Payments Tadpole Learning Systems Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $184,900 April 172,000 May 156,500 Depreciation, insurance, and property taxes represent $39,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taves for the year will be paid in November. 71% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, Apri, and May. Enter all amounts as positive numbers. TADPOLE LEARNING SYSTEMS INC. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March Apr May March expenses Paid in March Paid in April Apri expenses Paidin April Pad in May May expenses Prepare a…
Marie Marx, the management accountant at “Go Jamdown” is in the process ofplanning the company’s cash needs for the third quarter of 2008. She has receivedthe following information to assist in the preparation of the cash budget for thebusiness.Month Cash Sales Credit Sales Purchases SellingExpensesMay $140,000 $500,000 $0June $160,000 $600,000 $600,000July $180,000 $700,000 $675,000 $ 75,000August $156,000 $580,000 $575,000 $105,000September $160,000 $600,000 $600,000 $ 85,000The following additional information is also available:i) An analysis of the records show that the collection of accounts receivable aresettled, according to the following pattern, in accordance with the creditterms 10/30, n90:o 50% collected in the month of saleo 40% collected in the month following saleo 10% collected two months following saleii) Eighty percent (80%) of monthly purchases is paid in the month of purchase &the remaining 20% will be paid two months following the purchase. The creditterms of…
Fayette Medical Clinic has budgeted the following cash flows. February $232,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $240,000 $272,000 220,000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round intermediate and final answers to the nearest whole dollar amounts.) X Answer is not complete. Cash Budget January February March Section 1: Cash receipts Beginning cash…
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: a. Cash balance on October 1 is $1,120. b. Actual sales for August and September are as follows: August September Cash sales $6,000 $4,500 Credit sales 58,000 62,000 Total sales $64,000 $66,500 c. Credit sales are collected over a three-month period: 40 percent in the month of sale, 36 percent in the next month, and 22 percent in the second month after the sale. The remaining sales are uncollectible. d. Inventory purchases average 70 percent of a month's total sales. Of those purchases, 45 percent are paid for in the month of purchase. The remaining 55 percent are paid for in the following e. Salaries and wages total $3,850 per month. f. Rent is $3,150 per month. g. Taxes to be paid in October are $1,635. h. Janet usually withdraws $3,500 each month as her salary. i. Advertising is…
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Cash Receipts $519,000 407,500 455,000 раynente $461,400 349,900 524,000 January February March According to a credit agreement with the company's bank, Kayak promises to have a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month, The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. ces Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be…
Garden Depot Is a retailer that provided the following budgeted cash flows for next year. 1st Quarter 2nd Quarter $410,000 $ 260,000 $ 316,000 $ 286,000 3rd Quarter $ 290,000 $ 276,000 Total cash receipts Total cash disbursements The company's beginning cash balance for next year will be $36,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume Interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance…
Please answer with excel forumlas and step by step explanations. Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
Lim Auto Parts, a family-owned auto parts store, began January with $10,000 cash. Management fo that collections from credit customers will be $11,600 in January and $15,300 in February. The stor scheduled to receive $8,500 cash on a business note receivable in January. Projected cash payme include inventory purchases ($16,700 in January and $13,300 in February) and selling and adminis expenses ($2,900 each month). (Click the icon to view additional information about Lim Auto Parts.) Read the requirements. More info Lim Auto Parts' bank requires a $10,000 minimum balance in the store's checking account. At the end of any month when the account balance falls below $10,000, the bank automatically extends credit to the store in multiples of $1,000. Lim Auto Parts borrows as little as possible and pays back loans in quarterly installments of $2,000, plus 3% APR interest on the entire unpaid principal. The first payment occurs three months after the loan. Requirements 4 1. Prepare Lim Auto…
Tamarisk Garden Center has the following cash budget information available for the month of August: Beginning cash balance Cash receipts from sales and collections on account Collection of note receivable and interest Cash disbursements for operating expenses The company would have to $129,000 eTexthonk and Media 115,000 8,100 If the company has a policy of maintaining an end of the month cash balance of $120,000, determine the amount the company would have to borrow or the amount of excess cash it will have to invest in August. 96,400 SUPPORT

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS