Please show all wqorkings/formulas when using excel

Sithabiso's Wraps is an allorganic restaurant located near State University. It is managed by Eunice Ndlovu, and Eunice is preparing her firstquarter cash budget for this year. It is important to her because of the variation in volume and cash available caused by the return of the university students. Eunice has budgeted her revenues, cost of sales, and operating expenses based on her forecasts for January, February, and March. From her hospitality management classes, Eunice recalls that her ending cash balance for one month is the beginning cash balance of the next month, and she has compiled the following information and assumptions about her operation. Percent of revenue expected to be collected in the month it was generated (current month) 80% Percent of revenue expected to be collected in the month after it was generated based on AR aging 20% Accounts receivable to be collected in January from December AR $30,000 Percent of cost of sales to be paid in the month they were incurred (current month) 60% Percent of cost of sales to be paid one month after they were incurred (as AP) 40% Amount to be paid in January from AP for cost of sales incurred in December $17,000 Percent of operating expenses to be paid in the month they were incurred (current month) 70% Percent of operating expenses to be paid one month after they were incurred (from AP) 30% Amount to be paid in January (from AP) for operating expenses incurred in December $21,000 Percent of nonoperating expenses to be paid in the month they were incurred (current month) 100% Monthly rent expense $4,000 First of each quarter insurance premium $6,000 Beginning cash balance on January 1 $5,000 Ending cash balance for one month is beginning cash balance of the next month Minimum required cash balance (for emergencies) $5,000 Shortterm loan denominations $5,000 Shortterm loan interest rate 10%

Help Eunice complete her cash budget and then answer the questions that follow.

Sithabiso's Wraps Cash Budget for the First Quarter of This Year

GIVEN DATA January February March Revenues $60,000 $132,000 $76,000 Cost of Sales $21,000 $46,200 $33,600 Operating Expenses $28,000 $36,000 $32,000 NonOperating Expenses Rent Expense $4,000 $4,000 $4,000 Insurance Premiums $6,000 Current Month Second Month Schedule of Receipts (AR) 80% 20% AR from December (Received in January) $30,000 Schedule of Payments (AP) Cost of Sales 60% 40% Operating Expenses 70% 30% NonOperating Expenses 100% Cost of Sales from December (Paid in January) Operating Expenses from December (Paid in January) CASH BUDGET January February March Receipts Food Revenues Current Month 80% Second Month Disbursements Cost of Sales Current Month Second Month Operating Expenses Current Month Second Month NonOperating Expenses 100% Beginning Cash Balance Cash Receipts Subtotal Cash Disbursements Subtotal ShortTerm Loans Ending Cash Balance Will Eunice have to borrow any shortterm loans to cover cash shortfalls in the first quarter of the year? If so, how much money will she have to borrow, and what do you think may have caused this? If Eunice has to borrow a shortterm loan to cover cash shortfalls in the first quarter of the year, will she be able to pay it back in a timely manner? If so, when? By the end of the quarter, will Eunice have a surplus or deficit of cash? If she has a surplus, what should she do with the extra money? Overall, how do you think Eunice is doing at planning her cash receipts and cash disbursements in order to keep enough cash on hand to pay her bills?