Problem 1. Jane McDonald, a financial analyst for Carroll Company, has prepared the following sales and cash disbursement estimates for the period February to June of the current year. Month Sales Cash disbursements February $500 $400 March 600 300 April 400 600 May 200 500 June 200 200 McDonald notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending balance in its cash account of $25. Balances above this amount would be invested in short-term government securities (marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable). The beginning cash balance at April 1 is $115. a. Prepare cash budgets for April, May, and June. b. How much financing, if any, at a maximum would Carroll Company require to meet its obligations during this 3-month period? c. A pro forma balance sheet dated at the end of June is to be prepared from the information presented. Give the size of each of the following: cash, notes payable, marketable securities, and accounts receivable.
Problem 1. Jane McDonald, a financial analyst for Carroll Company, has prepared the following sales and cash disbursement estimates for the period February to June of the current year. Month Sales Cash disbursements February $500 $400 March 600 300 April 400 600 May 200 500 June 200 200 McDonald notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a minimum ending balance in its cash account of $25. Balances above this amount would be invested in short-term government securities (marketable securities), whereas any deficits would be financed through short-term bank borrowing (notes payable). The beginning cash balance at April 1 is $115. a. Prepare cash budgets for April, May, and June. b. How much financing, if any, at a maximum would Carroll Company require to meet its obligations during this 3-month period? c. A pro forma balance sheet dated at the end of June is to be prepared from the information presented. Give the size of each of the following: cash, notes payable, marketable securities, and accounts receivable.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter21: Cash Budgeting (cashbud)
Section: Chapter Questions
Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...
Related questions
Question
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 now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning