Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The monthly cash budgets for the first quarter of 2016 are shown below ($000 omitted) for XYZ Company. A minimum cash balance of $40,000 is

The monthly cash budgets for the first quarter of 2016 are shown below ($000 omitted) for XYZ Company. A minimum cash balance of $40,000 is required. A line of credit has been established with ABC's bank at a 7.5% interest rate. Calculate the missing amounts:

January February March Q1 Total
Cash balance, beginning $ 52 $ ? $ ? $ 52
Add collections from customers ? 214 ? ?
Total cash available 188 ? 312 674
Less disbursements:
Purchase of inventory ? 120 96 ?
Operating expenses 60 ? ? ?
Capital additions 68 16 ? 88
Payment of dividends ? 18
Total disbursements ? 214 166 608
Excess (deficiency) of cash available over disbursements (40 ) ? 146 ?
Borrowings ? ?
Repayments (including interest) ? ?
Cash balance, ending $ ? $ 40 $ ? $ 65

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

Contemporary Auditing University Of Southern Indiano

Authors: Michael C. Knapp

7th Edition

0324658052, 978-0324658057

More Books

Students also viewed these Accounting questions

Question

Conduct an effective performance feedback session. page 360

Answered: 1 week ago