Answered step by step
Verified Expert Solution
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
6642349bbca4e_984460.pdf
180 KBs PDF File
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