SEATECH INC. Cash Budget For the Months of April, May, and June 2019 April May June Beginning cash balance Cash Receipts: 11,200 60,800 From cash sales made in current month From credit sales made in: 44,800 54,400 February 35,840 March April Мay Total cash available 01,840 54,400 60,800 Cash Disbursements: For cost of goods sold/operating expenses incurred in: March 18,080 April May June For payment of note payable and interest For.capital.eXPenditucea 13.70

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Hopefully these pictures are sufficient. I am unsure of how to solve this problem, please help. 

**Transcription for Educational Website:**

The image contains a detailed explanation and a table related to the cash budget for SeaTech Inc. for the months of April, May, and June 2019.

The text explains that SeaTech Inc. aims to maintain a minimum cash balance of $10,000 at the beginning of each month. To ensure this availability, the company has secured a $50,000 line of credit from a local bank at an interest rate of 10%. Borrowing transactions occur at the end of months when the cash balance might fall below the $10,000 minimum. Repayments, including principal and interest, are due at the end of the earliest month when sufficient funds are available, using a 360-day year for calculations.

**Table: SeaTech Inc. Cash Budget**

- **Beginning Cash Balance:**
  - April: $11,200
  - May: [Blank]
  - June: [Blank]

- **Cash Receipts:**
  - From cash sales made in the current month:
    - April: [Blank]
    - May: [Blank]
    - June: [Blank]
  - From credit sales made in:
    - February: [Blank for April, May, June]
    - March: [Blank for April, May, June]
    - April: [Blank for April, May, June]
    - May: [Blank for April, May, June]

- **Total Cash Available:**
  - April: $11,200
  - May: $0
  - June: $0

- **Cash Disbursements:**
  - For cost of goods sold/operating expenses incurred in:
    - March: [Blank for April]
    - April: [Blank for April]
    - May: [Blank for April]
    - June: [Blank for April]
  - For payment of note payable and interest: [Blank for April, May, June]
  - For capital expenditures: [Blank for April, May, June]
  - For payment of income taxes: [Blank for April, May, June]
  - For payment of dividends: [Blank for April, May, June]

- **Total Disbursements:**
  - April: $0
  - May: $0
  - June: $0

- **Excess (Deficiency) of Cash Available Over Disbursements:**
  - April:
Transcribed Image Text:**Transcription for Educational Website:** The image contains a detailed explanation and a table related to the cash budget for SeaTech Inc. for the months of April, May, and June 2019. The text explains that SeaTech Inc. aims to maintain a minimum cash balance of $10,000 at the beginning of each month. To ensure this availability, the company has secured a $50,000 line of credit from a local bank at an interest rate of 10%. Borrowing transactions occur at the end of months when the cash balance might fall below the $10,000 minimum. Repayments, including principal and interest, are due at the end of the earliest month when sufficient funds are available, using a 360-day year for calculations. **Table: SeaTech Inc. Cash Budget** - **Beginning Cash Balance:** - April: $11,200 - May: [Blank] - June: [Blank] - **Cash Receipts:** - From cash sales made in the current month: - April: [Blank] - May: [Blank] - June: [Blank] - From credit sales made in: - February: [Blank for April, May, June] - March: [Blank for April, May, June] - April: [Blank for April, May, June] - May: [Blank for April, May, June] - **Total Cash Available:** - April: $11,200 - May: $0 - June: $0 - **Cash Disbursements:** - For cost of goods sold/operating expenses incurred in: - March: [Blank for April] - April: [Blank for April] - May: [Blank for April] - June: [Blank for April] - For payment of note payable and interest: [Blank for April, May, June] - For capital expenditures: [Blank for April, May, June] - For payment of income taxes: [Blank for April, May, June] - For payment of dividends: [Blank for April, May, June] - **Total Disbursements:** - April: $0 - May: $0 - June: $0 - **Excess (Deficiency) of Cash Available Over Disbursements:** - April:
**Sales and Financial Projections for SEATECH INC.**

### Income Statement Overview
This section provides a summary of the projected income statements for SEATECH INC. for the months of April, May, and June 2019.

#### Sales and Costs
- **Sales**: Projected sales increase from $112,000 in April to $152,000 in June.
- **Cost of Goods Sold (COGS)**: Estimated at $76,280 in April, increasing to $100,680 in June.
- **Gross Profit**: Rises from $35,720 in April to $51,320 in June.
- **Operating Expenses**: Consistently at $18,120 each month.

#### Operating Income
- **April**: $17,600
- **May**: $24,800
- **June**: $29,600

### Assumptions and Notes
1. **Product and Period Costs**
   - Product costs include direct materials, labor, and manufacturing overhead.
   - Period costs comprise selling, general, and administrative expenses.

2. **Revenue Collection**
   - 40% of sales are via cash transactions.
   - Collection of remaining sales: 65% in the first month following the sale, 35% in the second month.

3. **Other Financial Considerations**
   - Depreciation, insurance, and property taxes are included in operating expenses.
   - Insurance is paid annually in January, property taxes in August.
   - Remaining operating expenses are paid in the month incurred (90%).

4. **Current Assets and Liabilities**
   - As of April 1, 2019, cash at $1,200 and receivables at $119,840.
   - Current liabilities: Accounts payable for product costs ($14,400), accrued liabilities ($3,680), and a $38,000 note payable on April 17, 2019.

5. **Estimated Payments**
   - Income tax: $36,000 in May.
   - Quarterly dividend: $12,800 declared in May, paid in June.
   - Capital expenditures: $13,760 in April.

### Cash Budget
A detailed monthly cash budget is provided for April, May, and June 2019, using a 360-day year for calculations.

#### Example of Cash Budget for April
- **Beginning Cash Balance**: $1,200
- **Cash Receipts**:
Transcribed Image Text:**Sales and Financial Projections for SEATECH INC.** ### Income Statement Overview This section provides a summary of the projected income statements for SEATECH INC. for the months of April, May, and June 2019. #### Sales and Costs - **Sales**: Projected sales increase from $112,000 in April to $152,000 in June. - **Cost of Goods Sold (COGS)**: Estimated at $76,280 in April, increasing to $100,680 in June. - **Gross Profit**: Rises from $35,720 in April to $51,320 in June. - **Operating Expenses**: Consistently at $18,120 each month. #### Operating Income - **April**: $17,600 - **May**: $24,800 - **June**: $29,600 ### Assumptions and Notes 1. **Product and Period Costs** - Product costs include direct materials, labor, and manufacturing overhead. - Period costs comprise selling, general, and administrative expenses. 2. **Revenue Collection** - 40% of sales are via cash transactions. - Collection of remaining sales: 65% in the first month following the sale, 35% in the second month. 3. **Other Financial Considerations** - Depreciation, insurance, and property taxes are included in operating expenses. - Insurance is paid annually in January, property taxes in August. - Remaining operating expenses are paid in the month incurred (90%). 4. **Current Assets and Liabilities** - As of April 1, 2019, cash at $1,200 and receivables at $119,840. - Current liabilities: Accounts payable for product costs ($14,400), accrued liabilities ($3,680), and a $38,000 note payable on April 17, 2019. 5. **Estimated Payments** - Income tax: $36,000 in May. - Quarterly dividend: $12,800 declared in May, paid in June. - Capital expenditures: $13,760 in April. ### Cash Budget A detailed monthly cash budget is provided for April, May, and June 2019, using a 360-day year for calculations. #### Example of Cash Budget for April - **Beginning Cash Balance**: $1,200 - **Cash Receipts**:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Database design
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education