Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following Cash Flow Budget to answer questions 1 6. You do not need to show your work for Questions 1-6. Enter your answer

Use the following Cash Flow Budget to answer questions 1 6. You do not need to show your work for Questions 1-6. Enter your answer as a whole number. ex. 1000

Cash Flow Budget Assumptions:

Beginning balance is $20,000

Cost of goods sold is 75% of sales

Building rent is $3,000 a month

Accounts payable turnover ratio is 12

Accounts receivable ratio is 6

Inventory turnover ratio is 6

A quarter of sales are paid in cash

Minimum cash balance is never less than $6,000

Cash Flow Budget
April May June
Projected sales $12,000 $15,000 $18,000
Purchases Question 1 $15,000 $12,750
Pay Accounts Payable $11,250 $13,500 Question 2
Pay Overhead $3,000 $3,000 $3,000
Total Cash Outflow $14,250 $16,500 $18,000
Projected Sales $12,000 $15,000 $18,000
Cash Sales $3,000 Question 3 $4,500
Collect Accounts Receivable $6,000 $7,500 Question 4
Total Cash Inflow $9,000 $11,250 $13,500
Beginning Cash Balance $20,000 $14,750 $9,500
Total Cash Inflow $9,000 $11,250 $13,500
Total Cash Available $29,000 $26,000 $23,000
Total Cash Outflow $14,250 $16,500 $18,000
Net Cash Balance $14,750 Question 5 $5,000
Borrow/Repay $ - $ - Question 6
Ending Cash Balance $14,750 $9,500 $6,000
Cumulative Borrowing $ - $ - $1,000

Using the table in question 1, calculate the net cash balance for May.

Using the table in question 1, calculate the amount needed to be borrowed/repaid in June. If funds need to be borrowed enter as a positive number. If funds are repaid enter as a negative number.

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

Students also viewed these Accounting questions