FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
The accountant for Jean’s Dress Shop prepared the following
Required
-
Complete the cash budget by filling in the missing amounts.
-
Determine the amount of net
cash flows from operating activities Jean’s will report on the third quarter pro forma statement of cash flows. -
Determine the amount of net cash flows from financing activities Jean’s will report on the third quarter pro forma statement of cash flows.a.
Cash Budget July August September Section 1: Cash receipts Beginning cash balance $25,000 Add cash receipts 90,000 100,000 120,300 Total cash available 115,000 Section 2: Cash payments For inventory purchases 82,750 70,115 87,076 For S&A expenses 27,250 30,280 30,716 For interest expense 0 Total budgeted disbursements 110,000 Section 3: Financing activities Surplus (shortage) 5,000 Borrowing (repayments) 5,000 Ending cash balance $10,000 $0 $0 - b.
Net cash (operating activities) Net cash (financing activities)
- b.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 4 images
Knowledge Booster
Similar questions
- A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $57,000.arrow_forwardFoyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $6,300 is used to repay loans at month-end. The cash balance on October 1 is $6,300, and the company has an outstanding loan of $2,300. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $ 22,300 24,450 November $ 16,300 15,300 December $ 20,300 15,700 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) FOYERT CORPORATION es Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for Interest on loan Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash…arrow_forwardIguana, Incorporated, manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month's sales. Ending direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: \table[[March, 350], [April, 400], [May, 450], [June, 550], [July, 525], [August, 575]] Variable manufacturing overhead is incurred at a rate of $0.40 per unit produced. Annual fixed manufacturing overhead is estimated to be $10,800 ($900 per month) for expected production of 4,000 units for the year. Selling and administrative expenses are estimated at $950 per month plus $0.60 per unit sold. Iguana, Incorporated, had $11,900 cash on hand on April 1. Of its sales, 80 percent is in…arrow_forward
- Vargas Company is preparing a cash budget for April. The company has $27,000 cash at the beginning of April and anticipates $60,000 in cash receipts and $64,500 in cash disbursements during April. Vargas Company has an agreement with its bank to maintain a cash balance of at least $25,000. To maintain the $25,000 required balance, during April the company must: Borrow $2,500 from the owner. Borrow $5,000 from the owner. Borrow $7,500 from the owner. Borrow $4,500 from anyone other than the bank or the owner.arrow_forwardSpartan Industries has budgeted the following information for January Cash Receipts $ 43,400 Beginning Cash Balance $ 16,400 Cash Payments $ 61,400 Desired Ending Cash Balance $ 11,400 If there is not enough cash on hand to meet the desired ending balance, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,700 increments. Interest is paid monthly on the first day of the following month. The interest rate is 1 percent per month. The company had no debt before January 1 The shortage or surplus of cash before considering cash borrowed or interest payments in January would be a: Multiple Choice $1,600 shortage $9,800 shortage.arrow_forwardsarrow_forward
- Western Company is preparing a cash budget for June. The company has $10,100 cash at the beginning of June and anticipates $31,900 in cash receipts and $38,300 in cash disbursements during June. Western Company has an agreement with its bank to maintain a minimum cash balance of $10,000. As of May 31, the company owes $15,000 to the bank. To maintain the $10,000 required balance, during June the company must: Borrow $6,300. Borrow $10,000. Repay $6,300. Repay $3,700. Borrow $6,400.arrow_forwardKayak 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 $ 524,000 $ 465,300 February 412,500 353,800 March 475,000 526,000 Kayak requires a minimum cash balance of $40,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 $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March.arrow_forwardKayak 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. January February March Cash Receipts $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 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. Beginning cash balance Add: Cash receipts Total cash available KAYAK COMPANY Cash Budget January $ 30,000…arrow_forward
- The following information was taken from Trusted Care Company's cash budget for the month of April: Beginning cash balance Cash receipts Cash disbursements If the company has a policy of maintaining an end of the month minimum cash balance of $25,000, the amount the company would have to borrow is $10,000 $13,000 $11,000 $0 $27,000 62,000 75,000arrow_forwardThe Lowville Company has budgeted the following data for November: • Sales of $1,728,300, all in cash. • A cash balance on November 1 of $72,000. • Cash disbursements (other than interest) during November of $1,740,000. • A minimum cash balance of $90,000 at the end of each month. The company has 2% open line of credit for $100,000. All borrowing will take place at the beginning of the month. The November interest will be paid in cash when repayment is made. The excess (deficiency) of cash available over disbursements for November will be: A. $(11,700) B. $ (29,700) C. $60,300 D. $72,000 1. 2. The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is: A. $11,700 B. $18,000 C. $29,700 D. $30,000 The minimum cash balance the Lowville Company should have in order to make both repayment and interest payment in December should be closest to: A. $18,060 B. $29,800 C. $90,600 D. $119,800arrow_forwardThe company provides the following information regarding the cash budget for next year: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
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