Need 1 and 2 all parts done in an excel spreadsheet

Problems supo vioinsy of mom or ghibbrealsa wil to d om gniwollots 1. Lakewood Laser SkinCare's ending cash balance as of January 31, 2018 (the end of its fiscal year 2017) was $15,000. Its expected cash collections and payments for the next six months are given in the following table. um 000.252 to sonsled fast chode to1 Isunms oop ex Month Collections Payments February $37,125 $43,650 March 41,175 46,800 W YBM babno mil out . April 51,075 48,600 May 65,475 54,675 ovai ati Juo anidolside anne June 73, 125 60,075 womod of aviensgxo am July 81,000 61,200 952 ord sau of a. Calculate the firm's expected ending cash balance for each month. bongg smil vni all 10 30b. Assuming that the firm must maintain an ending cash balance of at bisq ed blow 19 least $12,000, how much must they borrow during each month? w editorsb bic. If the firm must pay 5% annual interest on its short-term borrowing, what are your ending cash balances for each month? zonnever bed. What are the ending cash balances if the firm uses any cash in excess older of the minimum to pay off its short-term borrowing in each month? 2. Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have 000.\\S& gathered the following information. 108.08 Month Sales Other Payments June 2017 $279,500 $130,000 July mi 20 230,750 121,875 e stir asile andmom August 196,625 113,750 lonneasog Isonsla September 151,125 020 821 81,250 October 123,500 73,000 November 131,625Budget April and May sales were $186,875 and $219,375, respectively. The firm collects 15% of its sales during the month, 75% the following month, and 10% two months after the sale. Each month it purchases inventory equal to 55% of the next month's expected sales. The company pays for 40% of its inventory purchases in the same month and 60% in the following month. However, the firm's suppliers give it a 2% discount if it pays during the same month as the purchase. A minimum cash balance of $25,000 must be maintained each month, and the firm pays 4% annually for short-term borrowing from its bank. Yuands a. Create a cash budget for June to October 2017. The cash budget 10should account for short-term borrowing and payback of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance. b. Bob Loblaw, the president, is considering stretching out its inventory payments. He believes that it may be less expensive to borrow from suppliers than from the bank. He has asked you to use the Scenario Manager to see what the total interest cost for this time period would be if the company paid for 0%, 10%, 30%, or 40% of its inventory purchases in the same month. The remainder would be paid in the following month. Create a scenario summary and describe whether the results support Bob's beliefs