Can someone help me solve it so i can check my answers

5 Prepare a balance sheet as of the 30 th of September You must show your calculations. I need to see the formulas if I click on a number or a note next to it This is the information you were able to gather to help in your calculations 1 You expect to make sales in the amount of 260000 during the month of September 26% of these sales will be made in cash, all the rest will fall into accounts receivable 50% of the credit sales are collected within the same month, and the rest is usually collected during the next mon 2 All the inventory purchases made by ABC company are always made on account 35% of those purchases/accounts payable are paid within the same month 65% of those purchases/accounts payable are paid within the next month 0% of those purchases/accounts payable are paid within the third month It is estimated that the ABC company will need to purchase 200000 USD worth of inventory 3 ABC company anticipates that it will finish September with a 40000 USD inventory balance in its store 4 You exnert to incur the following (all in rashl exnenses in September 5 Company wants to buy some new shelves and displays in September. It will cost 9000 USD 6 The company believes it will need a some money for purchasing new furniture in the fall Therefore it decided to borrow 18000 USD from a credit union for 9 months in the middle of September 7 The company does not anticipate to pay dividends in the near future