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 ATTACHMENT PREVIEW Download attachment 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

### 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