Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period? Prepare an Initial Balance Sheet dated the end of June from the information provided. Determine the value of the following: cash, notes payable, negotiable securities, and accounts receivable.
Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period? Prepare an Initial Balance Sheet dated the end of June from the information provided. Determine the value of the following: cash, notes payable, negotiable 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
100%
- Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year.
Month |
Sales |
Cash Disbursements |
February |
500 |
400 |
March |
600 |
300 |
April |
400 |
600 |
May |
200 |
500 |
June |
200 |
200 |
MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115.
- Prepare
cash budgets for April, May, and June. - How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period?
- Prepare an Initial Balance Sheet dated the end of June from the information provided. Determine the value of the following: cash, notes payable, negotiable securities, and accounts receivable.
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 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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
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
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College