if answer can be done in excell that would be great

rooter. Print cash budget d. Undo the what-if analysis 000. Print the resulting worksheet in Value view wil and date printed in the lower left footer and the file name analysis performed in pl be mine what sales wou balance of $50,000. Print growth would be needed to produce lI rght footer. Print cash budget and assumptions. Chapter 6 Case Problem 2: WINE DEPOT The Wi ing their tion is to borrow $300,000 lating several alternative means of financ ual acquisition of $70,000 in equipment. O from a local bank for 5 years at 11 perce them to produce Year 4). Sales of e One op Year 4 ucea 4year cash budget broken down by year (Year I through 650,000 are expected in year 1, with sales increasing each y 10 percent. Sales in the previous year were $600,000. Pur- an expected cost of sales of 30 percent and a required end- rcent of next year's sales. Purchases in the previous year and beginning inventory was $32,000. Annual expenses include ing expense of $10,000, marketing expense of $6,000, depreciation of $8.000, interest expense of $35,000., salaries expense of $250,000, s expense of $7,500, and utilities expense of penses except depreciation are paid in the year in which they were $200,000, adv vertisin wages $10,000. All ex expense of $65,000, supplie are incurred and are expected to increase 5 percent each year. Collections in the year of sale are expected to be 92 percent, with the remaining 8 percent col- in the next year. Payments in the year of purchase are expected to be lected ning 7 percent paid in the next year Procesd ed in year 1 and $75.0 of facilities wil with the remaining 7 percent 3 percent, Proceeds from expected equipment ss cach year. Pr h year. 510.000. Annual payments of S81,171 onthae amount to SIO the begihe ch6-05 file to start your work, create a Tul inger) based on gcash receipts, operating cash payment, cash from each year are expectes sh balance in year I was $20,0oo. loan also bepin in yu y he assumptions just provided. Use Excel's cash budget (as you d chapter) based on hgroup operating cash receipts, h from (to) investing activities, and cash from to cing activities. Save your file as ch6-0S gme). Define names as appropriate. Print the newly completed worksheet in Value view name w aand date printed in the lower left footer and the file name in the right footer. Collapse rows to level 2; then print the worksheet in Valtue view. with name and date printed in the lower left footer and the file name your the lower right footer. Print cash budget only, no assumptions Collapse rows to level 2, and then use what-if analysis to calcalae end-of-year cash if the sales growth each year were 4 percent. Prin the resulting worksheet in Value view, with your name and date c. inted in the lower left footer and the file name in the lower right pri footer. Print cash budget only, no assumptions. Undo the what-if analysis performed in part d. Collapse rows to level 2, and then use goal seek to determine what annual sales growth would be needed to produce an ending cash balance of $100,000 n year 4. 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 d. hapter 6 Case Problem 3: ans of financing OD SHOP 93 percent, with the remaining 7 percent paid in the next year. Proceeds from the $300,000 loan are expected in year 1 and $75,000 of facilities will be purchased each year. Proceeds from expected equipment sales each year are expected to amount to $10,000. Annual payments of $81,171 on the loan also begin in year l. The beginning cash balance in year 1 was $20,000. Using the ch6-05 file to start your work, create a cash budget (as you did in the chapter) based on the assumptions just provided. Use Excel's grouping fea- ture to group operating cash receipts, operating cash payment, cash from (to) operating activities, cash from (to) investing activities, and cash from (to) financing activities. Save your file as ch6-05_student name (replacing student name with your name). Define names as appropriate. Print the newly completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Collapse rows to level 2; then print the 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 only, no assumptions. a. b. c. Collapse rows to level 2, and then use what-if analysis to calculate end-of-year cash if the sales growth each year were 4 percent. 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 only, no assumptions. ae wiu yul nae). eine names as appropriate. piacing student Print the newly completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Collapse rows to level 2; then print the 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 only, no assumptions. a. b. c. Collapse rows to level 2, and then use what-if analysis to calculate end-of-year cash if the sales growth each year were 4 percent. Print the resulting worksheet in Value view, with your name and date footer. Print cash budget only, no assumptions. Undo the what-if analysis performed in part d. Collapse rows to level 2, and then use goal seek to determine what annual sales growth d. ould be needed to produce an ending cash balance of $100,000 in year 4. Print the resulting worksheet in Value view, with your name and date printed in the lower left right footer. Print cash budget and assumptions. footer and the file name in the lower Chapter 6 Case Problem 3