I have attached a word document with three case study questions. I have already completed all of the schedules which I have attached as well. Schedule A-F. Schedule F is the cash budget (hopefully done right). I need to answer the three questions on the word document attached. If cash budget is correct, it shouldn't be too difficult to answer these. I am just having trouble analyzing the data and answering the questions and the why. Work has to be showed for the last two, but like I said, I think the hard part is done? Mine cells are linked.

Schedule A: Sales Budget Credit Sales Cash Sales Total Sales April $56,000.00 $14,000.00 $70,000.00 May $68,000.00 $17,000.00 $85,000.00 June $72,000.00 $18,000.00 $90,000.00 Total $196,000.00 $49,000.00 $245,000.00 Schedule B: Expected Cash Collections March sales April sales May sales June sales Total cash collections April May June $48,000.00 $14,000.00 $56,000.00 $17,000.00 $68,000.00 $18,000.00 $62,000.00 $73,000.00 $86,000.00 Total $48,000.00 $70,000.00 $85,000.00 $18,000.00 $221,000.00 Schedule C: Purchases Budget for Merchandise Inventory Budgeted cost of goods sold Add: desired ending merchandise inventory (30%) Total needs Less: beginning merchandise inventory Required purchases April $42,000.00 $15,300.00 $57,300.00 $12,600.00 $44,700.00 May $51,000.00 $16,200.00 $67,200.00 $15,300.00 $51,900.00 June $54,000.00 $9,000.00 $63,000.00 $16,200.00 $46,800.00 Total $147,000.00 $40,500.00 $187,500.00 $44,100.00 $143,400.00 Schedule D: Expected Cash Disbursements for Inventory Purchases April $18,300.00 $22,350.00 $0.00 $0.00 $40,650.00 For March Inventory For April For May For June Total cash disbursements for purchases June A/P = $23,400.00 May $0.00 $22,350.00 $25,950.00 $0.00 $48,300.00 June $0.00 $0.00 $25,950.00 $23,400.00 $49,350.00 Total $18,300.00 $44,700.00 $51,900.00 $23,400.00 $138,300.00 Schedule E: Operating Expenses and disbursements for expenses Cash expenses: Salaries Maintenance Utilities Insurance Advertising Other expenses Total cash expenses Non cash expenses: Depreciation Total operating expenses April May June $8,500.00 $425.00 $700.00 $0.00 $3,000.00 $7,000.00 $19,625.00 $8,500.00 $425.00 $700.00 $0.00 $3,000.00 $8,500.00 $21,125.00 $8,500.00 $425.00 $700.00 $2,625.00 $3,000.00 $9,000.00 $24,250.00 $2,000.00 $2,000.00 $2,000.00 $21,625.00 $23,125.00 $26,250.00 Total $25,500.00 $1,275.00 $2,100.00 $2,625.00 $9,000.00 $24,500.00 $65,000.00 $6,000.00 $71,000.00 Schedule F: Cash Budget Beginning balance Collections Total cash available April May June Total $9,000.00 $8,000.00 $8,000.00 $9,000.00 $62,000.00 $73,000.00 $86,000.00 $221,000.00 $71,000.00 $81,000.00 $94,000.00 $230,000.00 Cash disbursements: $40,650.00 Inventory purchases $19,625.00 Operating expenses $19,750.00 Equipment purchases $0.00 Dividends paid $80,025.00 Total disbursements Excess (deficiency) of cash available over disburseme -$9,025.00 $8,000.00 Minimum balance $17,025.00 Loan balance $0.00 Loan repayment $0.00 Interest expense $8,000.00 Ending cash balance $48,300.00 $21,125.00 $0.00 $0.00 $69,425.00 $11,575.00 $8,000.00 $13,620.25 $3,404.75 $170.25 $8,000.00 $49,350.00 $138,300.00 $24,250.00 $65,000.00 $0.00 $19,750.00 $4,000.00 $4,000.00 $77,600.00 $227,050.00 $16,400.00 $2,950.00 $8,000.00 $5,356.45 $5,356.45 $8,263.80 $11,668.55 $136.20 $306.45 $8,000.00 $8,000.00 Case 2 - Master Budgeting - MBA 6100 - Pat Carlozzi Wolf's Gear Zone is a retail establishment that sells hiking and kayaking gear. The owner, Timothy Wolf, has enlisted you to prepare a budget for the next quarter, which is his busiest time of year. His primary concern is his cash position. He anticipates having to finance inventory purchases in anticipation of an upswing in demand. Based on the information provided in the attached document: A. Please prepare a cash budget for April-June 2017 with supporting schedules in Excel. (See format outlined) (25 Points) B. Based on your schedules, write a short report to the owner that answers the following questions she has posed. This should be in Microsoft Word memo format. Grammar, spelling, format, tone will be graded as well as content. (25 Points) 1. Does the cash budget based on the given parameters provide the firm with the liquidity it needs in meeting operations for the quarter (and why)? 2. The owner wants to know what the impact would be of increasing the minimum monthly cash balance from $8000 to $9,000. Provide a short but detailed response to Mr. Wolf on the impact of this change. (Of course, he will expect to see the numerical values that support the response.) 3. Mr. Wolf has been working with the same bank for 10 years. He is accustomed to paying higher-thanmarket interest. You believe he could move to another bank and reduce his interest rate to 8%. Explain what would be the impact on a) the budget as proposed, and b) and his request for a higher minimum cash balance? Required Schedules - in Excel