I am having a really hard time completing this so if someone can help me that would be great. also if this can be completed in excel so i know how the problem was done that would be great to thanks. i will give a rating at the end

ett forner and ter 6 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boin special equipment. One alternative is to borrow $2000 of $200,000 in equi ue is contemplating several means of financing thet r 10 years at 12 percent per annum. The bank has asked 0.000 froma cash budget broken down by quarters. Sales of $40.000 uce a 1-year first quarter, with each quarter thereafter increasing 2 percen. er thereafter i are based on an expected cost of sales of 55 percent and a inventory of 70 percent of next quarter's cost of sales. Beginning inver- s11.000. Sales for the first quarter next year are expected to be tory was $11 $50,000. Sales ious year's third quarter were $30,000. Expenses include ady roll expense of $8,000 the quarter during which they are incurred. Collections in the qua in the previous year's fourth quarter were $28,000. Sales in the advertising pay- supplies expense of $500, and utilities expense of $600 expense of $900, depreciation expense of s800, interest expense of $1.00, uarter throughout the year. All expenses except depreciation are paid in rter of sale are expected to be 80 percent, collections in the first quarter following a sale 15 percent, and in the second quarter 5 percent. Payments in the quarter of pur chase are expected to be 85 percent, payments in the first quarter followinga purchase 10 percent, and payments in the second quarter to be 5 percent. Pur- chases in the previous year's fourth quarter were $20,000. Purchases in the pre- expected in the second quarter and $200,000 of equipment will be parchased n rd quarter. The beginning cash balance in the first quarter was $15,00. were $17,000. Proceeds from the $200,000 loan are ous year's third quarter the third quarter. Quarterly payments of $4,200 on the loan also begin in the el for Aervunring ch-04 file to start your work, create a cash budget (as you did in revious paragraph, Using is based on the assumptions listed in the ) that grouping feature to group operating cash rece ipts, oe Parag the cel's group from. h from (to) operating activities, cash (to) inv ment. pay cing activities and also to group theourctiviti lacing student name and cash from oether. Save your file as ch6-04 student name (replaci names as appropriate. completed worksheet in Value view, with your name). Define Print the newly a. and date printed in the lower left footer and the file name inur nae right footer. b. Collapse rows to level 2 and columns to level 1, and then print the printed in the worksheet in Value view with your name and date and the file name in the lower right footer. Print lower left footer budget only, no assumptions. to level 3 and columns to level 2, and then use what what-if calculate end-of-year cash if the sales growth each quarter Expand rows e. were 4 percent and payroll expense were $18,000 per quarter. Print in Value view, with your name and date nted in the lower left footer and the file name in the lower right the resulting worksheet footer. Print cash budget only, no assumptions d. Undo the what-if analysis performed in part c. Use goal seek to deter- mine what sales growth would be needed to produce an ending cash balance of $50,000. Print the resulting worksheet in Value view with your name and date printed in the lower left footer and the file name in the lower right footer. Print cash budget and assumptions