. The Finance officer of Your Natural Romance Co asked for a CASH BUDGET given the following data: November $370,000 164,000 92,000 December $400,000 210,000 102,000 240,000 October Sales $320,000 132,000 Operating Costs Selling and Administrative Expenses 80,000 Capital Expenses Among the sales figures, only 90% are treated as receivables, with the other value as down payment. Six tenths of the receivables are collected in the following month and the rest a month further. Semiannual depreciation costs $144,000. Of the remaining operating costs, 80% will be paid in the month they are incurred and the rest, a month after. Current assets as of October 1 include cash of $84,000, marketable securities of $50,000 and accounts receivable of $396,000 ($300,000 from September sales and $96,000 from August Sales). Sales on account in August and September were $240,000 and $300,000 respectively. Current liabilities as of October 1 include $26,000 of accounts payable in September for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax of $48,000 will be made in November. The quarterly dividend is expected to be declared in November and paid in December. Management wishes to maintain a minimum cash balance of $80,000. Construct a cash budget for the three months mentioned. Put the corresponding notes as may be applicable (Note A, Note B, etc)
. The Finance officer of Your Natural Romance Co asked for a CASH BUDGET given the following data: November $370,000 164,000 92,000 December $400,000 210,000 102,000 240,000 October Sales $320,000 132,000 Operating Costs Selling and Administrative Expenses 80,000 Capital Expenses Among the sales figures, only 90% are treated as receivables, with the other value as down payment. Six tenths of the receivables are collected in the following month and the rest a month further. Semiannual depreciation costs $144,000. Of the remaining operating costs, 80% will be paid in the month they are incurred and the rest, a month after. Current assets as of October 1 include cash of $84,000, marketable securities of $50,000 and accounts receivable of $396,000 ($300,000 from September sales and $96,000 from August Sales). Sales on account in August and September were $240,000 and $300,000 respectively. Current liabilities as of October 1 include $26,000 of accounts payable in September for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax of $48,000 will be made in November. The quarterly dividend is expected to be declared in November and paid in December. Management wishes to maintain a minimum cash balance of $80,000. Construct a cash budget for the three months mentioned. Put the corresponding notes as may be applicable (Note A, Note B, etc)
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 5PA: Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash...
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.
Step by step
Solved in 3 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
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
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning