Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 8-11 (Static) Cash Budget Analysis [LO8-8] A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a

image text in transcribedimage text in transcribed Exercise 8-11 (Static) Cash Budget Analysis [LO8-8] A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Required: Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) 1 10 points eBook References \begin{tabular}{|c|c|c|c|c|c|} \hline & \begin{tabular}{c} Quarter 1 \\ (000 omitted) \end{tabular} & \begin{tabular}{c} Quarter 2 \\ (000 omitted) \end{tabular} & \begin{tabular}{c} Quarter 3 \\ (000 omitted) \end{tabular} & \begin{tabular}{c} Quarter 4 \\ (000 omitted) \end{tabular} & \begin{tabular}{l} Year (000 \\ omitted) \end{tabular} \\ \hline Cash balance, beginning & 6 & & & & \\ \hline Add collections from customers & & ? & 96 & & 323 \\ \hline Total cash available & 71 & & & & \\ \hline \multicolumn{6}{|l|}{ Less disbursements: } \\ \hline Purchase of inventory & 35 & 45 & & 35 & \\ \hline Selling and administrative expenses & & 30 & 30 & & 113 \\ \hline Equipment purchases & 8 & 8 & 10 & & 36 \\ \hline Dividends & 2 & 2 & 2 & 2 & \\ \hline Total disbursements & & 85 & & r & \\ \hline Excess (deficiency) of cash available over disbursements & (2) & & 11 & & \\ \hline \multicolumn{6}{|l|}{ Financing: } \\ \hline Borrowings & & 15 & & & \\ \hline Repayments (including interest) & & & & (17) & \\ \hline \multicolumn{6}{|l|}{ Total financing } \\ \hline \multicolumn{6}{|l|}{ Cash balance, ending } \\ \hline Interest will total $1,000 for the year. & & & & & \\ \hline \end{tabular}

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

My Adventures As An Auditor

Authors: Michael Quoter

1st Edition

1079508821, 978-1079508826

More Books

Students also viewed these Accounting questions

Question

How might social change occur?

Answered: 1 week ago