You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1 2 3 4 5. 6. 7 Additional information concerning Sage Hill Inc is as follows Gross profit is 24% of sales Actual and budgeted sales data March (actual April (budgeted) April 43.620 $12.280 $47,100 72,700 562.460 23.120 37,100 123,400 22,910 152,900 Sales are both cash and credit. Cash collections expected in April are March $18.840 (40% of 547,100) 160% of $72,700 12.320 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte Purchases March Purchases April $22.910 28.910 $51.820 Cash operating costs are anticipated to be $12.110 for the month of April. Equipment costing $2.530 will be purchased for cash in April The company wishes to maintain a minimum cash balance of $12.240 An open line of credit is available at the bank All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 13% per year, and interest expense is accrued at the end of the month and paid in the following month Prepare a cash budget for the month of April. Determine how much cash Sage Hill Inc. must borrow.or can repay in April ( not le Payment of April Cash Purchases Add V B Collections from Customers Total Available Cash Less V B Cash Receipts Payment of March Purchases Payment of April Cash Purchases Cash Operating Costs Cash Disbursements Equipment Purchase Total Disbursements Financing Add Excess (Deficiency) of Available Cash Over Disbursements Y Lass V Borrowings Repayments SAGE HILL INC. Cash Budget For the Month Ending April 30, 2027 V Ending Cash Balance V

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet.
Cash
Accounts receivable
Inventory
Property, plant, and equipment, net of depreciation
Accounts payable
Common stock
Retained earnings
1
2
3.
5.
6.
7.
Additional information concerning Sage Hill Inc. is as follows.
Gross profit is 24% of sales.
Actual and budgeted sales data:
March (actual)
April (budgeted)
March
April
$18.840
$47.100
$62460
$12,280
72.700
23.120
37,100
123,400
22,910
Sales are both cash and credit, Cash collections expected in April are:
152.900
12.320
(40% of $47.100)
(60% of $72,700)
Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte
Purchases March
Purchases April
$22,910
28,910
$51820
Cash operating costs are anticipated to be $12,110 for the month of April.
Equipment costing $2,530 will be purchased for cash in April.
The company wishes to maintain a minimum cash balance of $12,240. An open line of credit is available at the bank. All
borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate
is 13% per year, and interest expense is accrued at the end of the month and paid in the following month
Prepare a cash budget for the month of April. Determine how much cash Sage Hill Inc. must borrow, or can repay. in April (Do not leave
0006
€
€
Payment of April Cash Purchases
Add
Collections from Customers
Less
<
Total Available Cash
*
V
Payment of March Purchases
Cash Receipts
Payment of April Cash Purchases
Cash Operating Costs
Equipment Purchase
Add
Cash Disbursements
Total Disbursements
Financing
Less
Excess (Deficiency) of Available Cash Over Disbursements
<
<
Borrowings
Repayments
SAGE HILL INC.
Cash Budget
For the Month Ending April 30, 2027
Ending Cash Balance
>
>
>
$
$
E
Transcribed Image Text:You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1 2 3. 5. 6. 7. Additional information concerning Sage Hill Inc. is as follows. Gross profit is 24% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April $18.840 $47.100 $62460 $12,280 72.700 23.120 37,100 123,400 22,910 Sales are both cash and credit, Cash collections expected in April are: 152.900 12.320 (40% of $47.100) (60% of $72,700) Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte Purchases March Purchases April $22,910 28,910 $51820 Cash operating costs are anticipated to be $12,110 for the month of April. Equipment costing $2,530 will be purchased for cash in April. The company wishes to maintain a minimum cash balance of $12,240. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 13% per year, and interest expense is accrued at the end of the month and paid in the following month Prepare a cash budget for the month of April. Determine how much cash Sage Hill Inc. must borrow, or can repay. in April (Do not leave 0006 € € Payment of April Cash Purchases Add Collections from Customers Less < Total Available Cash * V Payment of March Purchases Cash Receipts Payment of April Cash Purchases Cash Operating Costs Equipment Purchase Add Cash Disbursements Total Disbursements Financing Less Excess (Deficiency) of Available Cash Over Disbursements < < Borrowings Repayments SAGE HILL INC. Cash Budget For the Month Ending April 30, 2027 Ending Cash Balance > > > $ $ E
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Financial Statements
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
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