Develop a cash flow budget using the following

Develop a cash flow budget using the
following information:
a. inventory turnover ratio = 12 e.
Sales half cash, half credit
b. cost of goods is 50% of sales. f. minimum cash balance =$100,000
c. accounts payable turnover ratio = 12. g.
Sept projected sales =$700,000
d. accounts receivable ratio = 12. h. Oct projected sales =$800,000
i. May Projected sales = $200,000
SITUATION
I

Item

June

July

Aug

Projected Sales

160,000

192,000

320,000

Purchases

Pay Acc’t Payable

Pay Overhead

45,000

45,000

45,000

Total Cash Outflow

Projected Sales

160,000

192,000

320,000

Cash Sales

Collect Acc’t Rec

30,000

Total Cash Inflow

Begin Cash Bal.

200,000

Cash Inflow

Total Cash Avail.

Cash Outflow

Net Cash

Needed Borrowings/Repayments

Ending Cash Balance

Cumulative
Borrowings

Develop
a cash flow budget using the following information:
a. inventory turnover ratio = 6 e. Sales half cash, half credit
b. cost of goods is 75% of sales. f. minimum cash balance =$100,000
c. accounts payable turnover ratio = 6. g.
Sept projected sales =$700,000
d. accounts receivable ratio = 6. h. Oct projected sales =$800,000
i. May projected sales = $200,000
SITUATION
II

Item

June

July

Aug

Projected Sales

160,000

192,000

320,000

Purchases

Pay Acc’t Payable

112,000

Pay Overhead

45,000

45,000

45,000

Total Cash Outflow

Projected Sales

160,000

192,000

320,000

Cash Sales

Collect Acc’t Rec

30,000

Total Cash Inflow

Begin Cash Bal.

200,000

Cash Inflow

Total Cash Avail.

Cash Outflow

Net Cash

Needed
Borrowings/Repayments

Ending Cash Balance

Cumulative
Borrowings

 

CLICK HERE TO ORDER A SIMILAR PAPER

We pride ourselves in writing quality essays

CLICK HERE TO CONTACT US

Lets Start Working

Plagiarism Free

We use anti-plagiarism software to ensure you get high-quality, unique papers. Besides, our writers have a zero plagiarism mentality

On Time Delivery

Your essay will be delivered strictly within the deadline.  If you have an urgent order, we can do it!

Money Back Guarantee

We offer warranty service, including free revisions, and a right to request a refund incase your expectations are not met!

THE BEST PAPER WRITER HELPER

Our Advantage

  • Say “NO” to plagiarism – FREE plagiarism report as an addition to your paper
  • The lowest prices that fit excellent quality
  • Authorship – you are the one who possesses the paper. We DO NOT re-sale or re-use any of them.

OUR PAPER WRITER HELPER GOODIES

Our Freebies

  • Free Cover Page
  • Free Revisions
  • Free Reference Page
  • Free 24/7 support

Pin It on Pinterest

Share This