Question
Former Corporation sells office supplies to government agencies. At the beginning of the current quarter, the company reports the following selected account balances: Cash $
Former Corporation sells office supplies to government agencies. At the beginning of the current quarter, the company reports the following selected account balances: |
Cash | $ | 10,000 |
Accounts receivable | 210,000 | |
Current payables | 88,000 | |
|
Formers management has made the following budget estimates regarding operations for the current quarter: |
Sales (estimated) | $ | 500,000 |
Total costs and expenses (estimated) | 400,000 | |
Debt service payment (estimated) | 145,000 | |
Tax liability payment (estimated) | 45,000 | |
|
Of Formers total costs and expenses, $20,000 is quarterly depreciation expense, and $20,000 represents the expiration of prepayments. The remaining $360,000 is to be financed with current payables. The companys ending prepayments balance is expected to be the same as its beginning prepayments balance. Its ending current payables balance is expected to be $22,000 more than its beginning balance. |
All of Formers sales are on account. Approximately 65 percent of its sales are collected in the quarter in which they are made. The remaining 35 percent are collected in the following quarter. Because all of the companys sales are made to government agencies, it experiences virtually no uncollectible accounts. |
Formers minimum cash balance requirement is $10,000. Should the balance fall below this amount, management negotiates a short-term loan with a local bank. The companys debt ratio (liabilities assets) is currently 80 percent. |
Instructions |
a. | Compute Formers budgeted cash receipts for the quarter. |
b. | Compute Formers payments of current payables budgeted for the quarter. |
c. | Compute Formers cash prepayments budgeted for the quarter. |
d. | Prepare Formers cash budget for the quarter. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started