Please help using excel so that I can see how it was done thanks

looter. Print cash budget d . Undo the what - if analysis performed in pall mine what sales growth would be needed to produce balance of $50. 000 . Print the resulting worksheet in Value VIEW } Your name and date printed in the lower left footer and the file name In the lower right footer . Print cash budget and assumptions . Chapter 6 Case Problem 2 . WINE DEPOT the Wine Depot is contemplating several alternative means of financing their annual acquisition of $70.000 in equipment . One option is to borrow $300. 00 0 from a local bank for 5 years at 1 1 percent per annum . The bank has asked them to produce a 4-year cash budget broken down by year Year I through Year 4 ). Sales of $650. 000 are expected in year I, with sales increasing each year thereafter by 10 percent . Sales in the previous year were $600, 000 . Pur` chases are based on an expected cost of sales of 30 percent and a required end_ Ing inventory of 10 percent of next year's sales . Purchases in the previous year were $200, 000 , and beginning inventory was $32, 000. Annual expenses include advertising expense of $10,000 , marketing expense of $6,000, depreciation expense of $8, 000 , interest expense of $35, 000, salaries expense of $250, 000. wages expense of $65, 000 , supplies expense of $7. 500, and utilities expense of $10, 000. All expenses except depreciation are paid in the year in which they 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- lected in the next year . Payments in the year of purchase are expected to belooter. Print cash budget d . Undo the what - if analysis performed in pall mine what sales growth would be needed to produce balance of $50. 000 . Print the resulting worksheet in Value VIEW } Your name and date printed in the lower left footer and the file name In the lower right footer . Print cash budget and assumptions . Chapter 6 Case Problem 2 . WINE DEPOT the Wine Depot is contemplating several alternative means of financing their annual acquisition of $70.000 in equipment . One option is to borrow $300. 00 0 from a local bank for 5 years at 1 1 percent per annum . The bank has asked them to produce a 4-year cash budget broken down by year Year I through Year 4 ). Sales of $650. 000 are expected in year I, with sales increasing each year thereafter by 10 percent . Sales in the previous year were $600, 000 . Pur` chases are based on an expected cost of sales of 30 percent and a required end_ Ing inventory of 10 percent of next year's sales . Purchases in the previous year were $200, 000 , and beginning inventory was $32, 000. Annual expenses include advertising expense of $10,000 , marketing expense of $6,000, depreciation expense of $8, 000 , interest expense of $35, 000, salaries expense of $250, 000. wages expense of $65, 000 , supplies expense of $7. 500, and utilities expense of $10, 000. All expenses except depreciation are paid in the year in which they 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- lected in the next year . Payments in the year of purchase are expected to be