Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART II: Management's Cash flow Assumptions - 15% Based on 2017 sales, Rosario Resources Management has forecasted the following monthly growth in sales and monthly

image text in transcribed
PART II: Management's Cash flow Assumptions - 15% Based on 2017 sales, Rosario Resources Management has forecasted the following monthly growth in sales and monthly cash collection measures for 2018: Create a 12-month cash flow budget in Excel using the following assumptions: a. Annual 2017 sales of $4,500,000 per month with forecasted monthly growth of 2% 35% of each month's sales for cash; 30% collected the following month; 20% collected 2 months later; 10% collected 3 months later; and 5% never collected Initial cash balance of $300,000 Assuming an initial cash balance of $300,000, management has concluded that they will achieve an ending cash balance of $41,000,000. REQUIRED: Write a short summary to evaluate management's decision. (Your answer should be within 20 words.)

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

Organizational Change

Authors: Barbara Senior, Stephen Swailes

5th Edition

1292063831, 9781292063836

More Books

Students also viewed these Accounting questions

Question

In the EOQ model, how do we determine the optimum order quantity?

Answered: 1 week ago