Excel_1_Spring_2012

Excel_1_Spring_2012 - ENTER YOUR NAME HERE =>

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
e3c593ca57dccbab8572b3babf95c6c67205173f.xls ENTER YOUR NAME HERE => 3-8 Cash Budget - Basic BUT MODIFIED FOR EXCEL ASSIGNMENT This is Grenoble again (see Problem 3-8, pg. 126, in textbook), but one year later. It buys and sells on the same credit terms as last year. You will do the cash receipts, disbursements, and budget in Excel and report on the cash manager's actions. Turn in printout and cell formulas. Use cell formulas to add up (SUM) the cash receipts and disbursements and calculate net cash flow, ending cash, future months' beginning cash, and required total financing or excess cash balance. Yellow shading indicates that you need to enter a number or formula. Grenoble Enterprises had sales of $40,000 in March and $45,000 in April. Forecast sales for May, June and July are $55,000, $70,000, and $85,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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online