prior Q4 Q1 Q2 Q3 Q4 NEXT Q1 Sales $75,000 $77,000 $75,500 $78,000 $75,000 A/R 80.0% $60,000 $61,600 $60,400 $62,400 $60,000 SO AR collected in...
View the step-by-step solution to:

Question

How do I get the next Q1 with these information

Group Assign Cash</h1><p class='abPRemoveTitle'> Budget.png

Group Assign Cash Budget.png

prior Q4
Q1
Q2
Q3
Q4
NEXT Q1
Sales
$75,000
$77,000
$75,500
$78,000
$75,000
A/R
80.0%
$60,000
$61,600
$60,400
$62,400
$60,000
SO
AR collected in fullnext period
Inv
82%
$61,500
$63,140
$61,910
$63,960
$61,500
SO
Cash for inv
55%
-$33,825
-$34,727
-$34,051
-$35,178
-$33,825
SO
A/P
45.0%
$27,675
$28,413
$27,860
$28,782
$27,675
SO
cash sales
20.0%
$15,000
$15,400
$15,100
$15,600
$15,000
SO
cash from A/R
$60,000
$61,600
$60,400
$62,400
$60,000
Cash paid for Inv
55%
-$34,727
-$34,051
-$35,178
-$33,825
SO
Cash to pay A/P
-$27,675
-$28,413
-$27,860
-$28,782
-$27,675
Other expenses
$0
SO
SO
SO
SO
Net change in cash
$12,998
$14,237
$12,963
$14,793
$32,325
Starting cash
SO
$12,998
$27,235
$40,197
$54,990
Ending cash
$12,998
$27,235
$40,197
$54,990
$87,315
8 Cash
$235
$503
$590
-$112
9
A/R
$61,600
$60,400
$62,400
$60,000
Inve
$63,140
$61,910
$63,960
$61,500
Current assets
$124,975
$121,807
$126,950
$121,388
Current Liabilities
$28,413
$27,860
$28,782
$27,675
NWC
$96,562
$93,947
$98,168
$93,713

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes