Month April (Actual) May (Actual) une (Forecasted) uly (Forecasted) August (Forecasted) 390,000 September (Forecasted) 420,000 ● ● ● ● ● . Sales 410,000 400,000 380,000 360,000 Purchases 220,000 210,000 200,000 250,000 300,000 200,000 The company makes 10 percent of its sales for cash and 90 percent on credit. Of the credit sales: O 20% are collected in the month after the sale O 78% are collected two months after O 2% of sales are never collected and are written of as bad debts Variable Labour expense equals 10% of the current month's sales Fixed Labour expense is equal to $10,000 per month Overhead expenses of $8,000 per month should be expected Fixed debt payments of $40,000 are due in June and again in September Cash dividend of $20,000 is scheduled to be paid in June Tax installments of $35,000 are due in June and September There is a schedule capital outlay of $300,000 in September Depreciation is $20,000 per month Ending cash balance a in May is $20,000 Minimum desired balance at the end of any month is $50,000 Excess balances above $50,000 are invested in money market securities for 30 days and generate a return of 2.1% per annum. If the ending balance is below $15,000, money is borrowed from the company's line of credit at 12% per annum.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 4P
icon
Related questions
icon
Concept explainers
Question
(cash budget from excel)
Preparing a Cash Budget
Smith's Avionics actual sales and purchases for April and May are show here, along with forecasted sales
and purchases for June through September.
Month
Sales
April (Actual)
410,000
May (Actual)
400,000
June (Forecasted)
380,000
July (Forecasted)
360,000
August (Forecasted)
390,000
September (Forecasted) 420,000
The company makes 10 percent of its sales for cash and 90 percent on credit. Of the credit sales:
O
20% are collected in the month after the sale
78% are collected two months after
O 2% of sales are never collected and are written of as bad debts
Variable Labour expense equals 10% of the current month's sales
Fixed Labour expense is equal to $10,000 per month
● Overhead expenses of $8,000 per month should be expected
Fixed debt payments of $40,000 are due in June and again in September
Cash dividend of $20,000 is scheduled to be paid in June
Tax installments of $35,000 are due in June and September
There is a schedule capital outlay of $300,000 in September
Depreciation is $20,000 per month
Ending cash balance a in May is $20,000
Minimum desired balance at the end of any month is $50,000
●
●
●
●
●
●
●
●
.
●
●
Purchases
220,000
210,000
200,000
250,000
300,000
200,000
Excess balances above $50,000 are invested in money market securities for 30 days and
generate a return of 2.1% per annum.
If the ending balance is below $15,000, money is borrowed from the company's line of credit at
12% per annum.
Transcribed Image Text:(cash budget from excel) Preparing a Cash Budget Smith's Avionics actual sales and purchases for April and May are show here, along with forecasted sales and purchases for June through September. Month Sales April (Actual) 410,000 May (Actual) 400,000 June (Forecasted) 380,000 July (Forecasted) 360,000 August (Forecasted) 390,000 September (Forecasted) 420,000 The company makes 10 percent of its sales for cash and 90 percent on credit. Of the credit sales: O 20% are collected in the month after the sale 78% are collected two months after O 2% of sales are never collected and are written of as bad debts Variable Labour expense equals 10% of the current month's sales Fixed Labour expense is equal to $10,000 per month ● Overhead expenses of $8,000 per month should be expected Fixed debt payments of $40,000 are due in June and again in September Cash dividend of $20,000 is scheduled to be paid in June Tax installments of $35,000 are due in June and September There is a schedule capital outlay of $300,000 in September Depreciation is $20,000 per month Ending cash balance a in May is $20,000 Minimum desired balance at the end of any month is $50,000 ● ● ● ● ● ● ● ● . ● ● Purchases 220,000 210,000 200,000 250,000 300,000 200,000 Excess balances above $50,000 are invested in money market securities for 30 days and generate a return of 2.1% per annum. If the ending balance is below $15,000, money is borrowed from the company's line of credit at 12% per annum.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

How the interest on investment comes for these three months ?

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Completing the Accounting Cycle
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,