can someone break this problem down for me so I can understand it. i keep getti g stuck in the caculations. please answer all questions or provide example.

Beadle Consulting Services, a firm started sevwral years apo, by Mr. Beadle to offer consulting services for baseball stadium layout and maintenance. The batance sheet prepared by the firm's bookkeeper at the end of 2022 is shoan below Beadle borrowed money from the bank on a $30,000,95,5 year note on September 1,2022 One of the provisions of the loan is that yearend debtito-equity ratio (ratio of fotal liabilities to total shareholders' equity) shall not exoeed 10. What is the ratio, given this balance sheet? Beadle is worried that the firm may be in violation of the loan agreament and asks for your help in reviewing the situation. Beadle thinks his inexperienced bookkeeper may have missed some items at yearend. After discussions with Mr. Beadle and the bookketper, you see the following: 1. On May 1, 2022: the firm paid a 54,500 insurance premium for two years of coverage. 2. Depreciation on the equipment should be takenat 10% of cost each year [How many years in the asset's life?]. The bookkeeper mistakenly took 15% for 2022 [How many of estimated life did he assume here?] 3. Interest on bank loan is due each year en the date the note was made. 4. The firm was working on a consulfing engagement in December, completing the first stage of designing a layout for a new stadium for the Savannah Bananas baseball team. The $8,000 fee has not been bilied yet 5. On December 1, 2022, the fim had recelved an $11,300 advance payment from Sieen Corp for consulting services for a stadium upgrade. By yearond, Beadle had earned onequarter of the advance, based on milestones achieved during December. 6. Supplies costing $4,600 were on hend on December 31. The bookkeeper had made the count, but had only recorded it on s piece of paper put in a file. QUESTIONS ON NEXT PAGE QUESTION 1 continued A. Prepare labelied calculations 8 entries to update the balance sheet. Don't forget to answer the THREE bolded questionsll! B. Prepare the updated balance sheet IN GOOD FORM C. What is the correct debt-to-equity ratio? is Besdle in defaul? D. Why would the bank have wanted to include the debt-to-equity provision in the loan agreement