Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sheffield, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Sheffield desires to maintain a $ 15.000

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Sheffield, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Sheffield desires to maintain a $ 15.000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $ 1.000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter () October November December Quz Beginning cash balance $ 15,000 $ Collections from sales 51.000 Total cash available 67.500 95,500 120,000 Less disbursements Materials purchases 10,000 14,000 5.000 6,000 8,000 20,000 24,000 22,000 Direct labor Manufacturing overhead Selling & administrative expenses 27,000 25.000 Equipment purchase 5,000 Dividends 65,500 Total disbursements 30.500 Excess (deficiency) of cash Minimum cash balance 15,000 15,000 15.000 - 13,000 9,000 Cash available (needed) Financing Borrowings Repayments - 130 Interest - 13,130 Total financing $ 17,370 $ $ 15,000 Ending cash balance Quarter $ 16,500 234,130 37,500 19,000 15.000 5,000 5,000 13,000 13,000 - 130 - 130

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

QuickBooks Online For Beginners

Authors: Steven Carlson

2023rd Edition

B0BQY4RP4S, 979-8369780794

More Books

Students also viewed these Accounting questions