Reference no: EM13865831
A. Create a 12 month cash budget in Excel using the following assumptions:
• Initial sales of $5,000,000 with forecasted monthly growth of 1%.
• 40% of each months sales for cash; 30% for the following month ; 20% collected 2 months later; 8% collected 3 months later, and 2% never collected.
• Initial cash balance of 350,000.
B. Add a spinner to your spreadsheet that will enable you to easily change the forecasted monthly sales growth to range from .5% to 1.5% in increments of .1%.
C. Add a scroll bar to your spreadsheet that will let you modify the amount of the initial sales to vary from $4,000,000 to $6,000,000 in increments of $100,000.
D. Design appropriate data entry and processing controls to ensure the spreadsheet accuracy.
|
Calculate the average days to collect receivables
: Rounded to one decimal place, compute the turnover ratios for accounts receivable and inventory. By dividing 365 by your ratios from requirement 1, calculate the average days to collect receivables and the average days to sell inventory. Interpret wh..
|
|
Provide additional information from the accounting records
: Additional information from the accounting records
|
|
What is meant by the term hedging?
: What is meant by the term hedging?
|
|
Benefit or damage minuteclinic overall profitability
: Read the case study titled "MinuteClinic,". Predict whether or not embracing the Continuity of Care Record (CCR) standard will either benefit or damage MinuteClinic's overall profitability
|
|
Design appropriate data entry to ensure spreadsheet accuracy
: Design appropriate data entry and processing controls to ensure the spreadsheet accuracy. Create a 12 month cash budget in Excel using the Initial sales of $5,000,000 with forecasted monthly growth of 1%.
|
|
Explain what each ratio means for cintas
: Assuming that all sales are on credit, compute the current ratio (two decimal places), inventory turnover ratio (one decimal place), and accounts receivable turnover ratio (one decimal place) for 2013. Explain what each ratio means for Cintas.
|
|
Illustrate impact on the firm total and marginal cost
: In a graph with square feet of housing on the horizontal axis and ‘all other consumption' on the vertical axis, illustrate all of the bundles in this family's choice set - How much does it cost the government to provide a public housing unit to th..
|
|
Determine the apparent power
: The following loads are connected in parallel to a common 230/60o V, 50Hz, single-phase supply.
|
|
Who will talk to in order to set sales assumption forecast
: Describe who else you will talk to in order to set the sales assumption forecast. How will you document this? How is the sales budget used to build the other budgets?
|