Reference no: EM131110855
Grenoble Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July.
(1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale.
(2) The firm receives other income of $2,000 per month.
(3) The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively.
(4) Rent is $3,000 per month.
(5) Wages and salaries are 10% of the previous month's sales.
(6) Cash dividends of $3,000 will be paid in June.
(7) Payment of principal and interest of $4,000 is due in June.
(8) A cash purchase of equipment costing $6,000 is scheduled in July.
(9) Taxes of $6,000 are due in June.
|
Compare and contrast the statements developed
: Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2013. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2013. Compare and contrast the stat..
|
|
Discuss how knowledge of the timing and amounts involved
: Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $18,000. Use the analysis prepared in part a to predict Trotter's financing needs and investment oppo..
|
|
Check statements that will be affected immediately
: The following represent financial transactions that Johnsfield & Co. will be undertaking in the next planning period. For each transaction, check the statement or statements that will be affected immediately.
|
|
What is the cumulative cash surplus or deficit by the end
: Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2013. Are there individual months that incur a deficit? What is the cumulative cash surplus or deficit by the end of December2013?
|
|
Prepare and interpret a cash budget for the months of may
: he firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. The firm makes 20% of sales for cash, 60% are ..
|
|
Cash disbursement schedule for the months of april
: Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format of Table 4.9 (on page 130) and the following information in its preparation.
|
|
Explain the impact that depreciation
: Use the relevant data to determine the operating cash flow (see Equation 4.2) for the current year. Explain the impact that depreciation, as well as any other noncash charges, has on a firm's cash flows.
|
|
What amount should be reported ascash
: Kraft Enterprises owns the following assets at December 31, 2010. What amount should be reported ascash?
|
|
Moon hardware is planning to factor some of its receivable
: Explain to the controller of Moon Hardware what "recourse" is and how the recourse will be reflected in Moon's financial statements after the sale of the receivables.
|