Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I get the next Q1 with these information prior Q4 Q1 Q2 Q3 Q4 NEXT Q1 Sales $75,000 $77,000 $75,500 $78,000 $75,000 A/R

image text in transcribed

How do I get the next Q1 with these information

image text in transcribed
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

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

Financial Management For Public Health And Not For Profit Organizations

Authors: Steven A. Finkler

2nd Edition

0131471988, 978-0131471986

More Books

Students also viewed these Finance questions