c. Prepare a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing funds in case of a cash shortfall (less than $10,500). (Negative amounts should be indicated by a minus sign. Assume the June beginning loan balance and beginning marketable security balance is $0.) Archer Electronics Cash Budget June July August September
c. Prepare a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing funds in case of a cash shortfall (less than $10,500). (Negative amounts should be indicated by a minus sign. Assume the June beginning loan balance and beginning marketable security balance is $0.) Archer Electronics Cash Budget June July August September
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please do not give solution in image format thanku
![c. Prepare a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash
balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing
funds in case of a cash shortfall (less than $10,500). (Negative amounts should be indicated by a minus sign. Assume the June
beginning loan balance and beginning marketable security balance is $0.)
Archer Electronics
Cash Budget
Total cash receipts
Total cash payments
Net cash flow
Beginning cash balance.
Cumulative cash balance
Borrow
Repay loan
Sell marketable securities
Buy marketable securities
Ending cash balance
Cumulative loan balance
Cumulative marketable
securities
June
$0
$0
$0
July
$0
$0
$0
August
$0
$0
$0
September
$0
$0
$0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6817b732-d772-4533-b1b2-837d0a85b1f1%2F01dbc41c-d254-45f2-a8df-66719ed05868%2Fq9sufh_processed.jpeg&w=3840&q=75)
Transcribed Image Text:c. Prepare a complete monthly cash budget with borrowing and repayments for June through September. The maximum desired cash
balance is $50,500. Excess cash (above $50,500) is used to buy marketable securities. Marketable securities are sold before borrowing
funds in case of a cash shortfall (less than $10,500). (Negative amounts should be indicated by a minus sign. Assume the June
beginning loan balance and beginning marketable security balance is $0.)
Archer Electronics
Cash Budget
Total cash receipts
Total cash payments
Net cash flow
Beginning cash balance.
Cumulative cash balance
Borrow
Repay loan
Sell marketable securities
Buy marketable securities
Ending cash balance
Cumulative loan balance
Cumulative marketable
securities
June
$0
$0
$0
July
$0
$0
$0
August
$0
$0
$0
September
$0
$0
$0
![Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for
June through September:
April (actual)
May (actual)
June (forecast)
July (forecast)
August (forecast)
September (forecast)
Archer
Electronics
Cash
Payments.
Schedule
Sales
Credit sales
ash sales
One month
after sale
Two months
after sale
Total cash
receipts
Archer Electronics
The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month
after the sale and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase
and 80 percent two months after.
Cash Payments
Schedule
Labor expense equals 15 percent of the current month's sales. Overhead expense equals $12,500 per month. Interest payments of
$32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due
in June and September. There is a scheduled capital outlay of $350,000 in September.
Archer Electronics' ending cash balance in May is $22,500. The minimum desired cash balance is $10,500.
Materials.
purchases
a. Prepare a schedule of monthly cash receipts for June through September.
Materials: One
month after
purchase
Sales
$370,000 $155,000
Materials: Two
months after
purchase
Labor expense
350,000
April
325,000
Overhead expense
Interest payments
Dividend payments
Tax payments
Capital outlay
Total payments
325,000
340,000
380,000
Purchases
145,000
145,000
May
April
205,000
225,000
b. Prepare a schedule of monthly cash payments for June through September.
220,000
June
May
$0
June
July
$0
$0
August September
July
$0
$0
$0
August September
$0
$0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6817b732-d772-4533-b1b2-837d0a85b1f1%2F01dbc41c-d254-45f2-a8df-66719ed05868%2Fw6036rk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for
June through September:
April (actual)
May (actual)
June (forecast)
July (forecast)
August (forecast)
September (forecast)
Archer
Electronics
Cash
Payments.
Schedule
Sales
Credit sales
ash sales
One month
after sale
Two months
after sale
Total cash
receipts
Archer Electronics
The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month
after the sale and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase
and 80 percent two months after.
Cash Payments
Schedule
Labor expense equals 15 percent of the current month's sales. Overhead expense equals $12,500 per month. Interest payments of
$32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due
in June and September. There is a scheduled capital outlay of $350,000 in September.
Archer Electronics' ending cash balance in May is $22,500. The minimum desired cash balance is $10,500.
Materials.
purchases
a. Prepare a schedule of monthly cash receipts for June through September.
Materials: One
month after
purchase
Sales
$370,000 $155,000
Materials: Two
months after
purchase
Labor expense
350,000
April
325,000
Overhead expense
Interest payments
Dividend payments
Tax payments
Capital outlay
Total payments
325,000
340,000
380,000
Purchases
145,000
145,000
May
April
205,000
225,000
b. Prepare a schedule of monthly cash payments for June through September.
220,000
June
May
$0
June
July
$0
$0
August September
July
$0
$0
$0
August September
$0
$0
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education