Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on 2017 sales, Rosario Resources Management has forecasted the following monthly growth in sales and monthly cash collection measures for 2018: a. 12-month cash

Based on 2017 sales, Rosario Resources Management has forecasted the following monthly growth in sales and monthly cash collection measures for 2018:

a.  12-month cash flow budget in Excel using the following assumption:

  • 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:  short summary to evaluate management's decision

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Based on the provided information it seems that Rosario Resources Management has forecasted signific... 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_2

Step: 3

blur-text-image_3

Document Format ( 2 attachments)

PDF file Icon
6642349bbca4e_984460.pdf

180 KBs PDF File

Word file Icon
6642349bbca4e_984460.docx

120 KBs Word File

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 Accounting Tools for business decision making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th Edition

978-1119191674, 047053477X, 111919167X, 978-0470534779

More Books

Students also viewed these Accounting questions

Question

4. In Prob. 1, find the dimension of S S.

Answered: 1 week ago

Question

7. Prove Theorem 5.2.5.

Answered: 1 week ago