need some help with this form please and thank you please use spread sheet attached

Information Given: Read the scenario below and answer the following 3 questions (be sure to scroll down). You will also need to complete the Budget on the "Income Statement & Budget" tab. Scenario: South Shore Medical Clinic is expanding its operations. As you will notice from Year 3 to Year 4, they have increased their revenue and encounted additional expenses. In addition, they have rented a new office at the end of the year so their rent expense is going to increase (they will now have two offices). In addition, they have added 2 additional staff members to payroll. Using the Income Statement, prepare a budget that takes these changes into account for the upcoming year. Questions: 1. Using the Balance Sheet, calculate the current ratio. Comment on whether or not the ratio shows financial strength. 2. Using the Income Statement, calculate the operating margin ratio for Year 4. How well does the company measure in terms of operating efficiency? 3. Explain your budget suggestions. Do you think Revenue will increase or decrease? Do you think Expenses will increase or decrease? Task #1: South Shore Medical Clinic is expanding its operations. As you will notice from Year 3 to Year 4, they have i encounted additional expenses. In addition, they have rented a new office at the end of the year so their rent expense is have two offices). In addition, they have added 2 additional staff members to payroll. Using the Income Statement belo these changes into account for the upcoming year. Suggest the budget amounts for Year 5 in the col South Shore Medical Clinic Income Statement For the year ending December 31, 20X4 ACTUAL Revenues: Service Fee Revenue Total Revenues Expenses: Advertising Expense Shipping Expense Salaries Expense Rent Expense Utilities Expense $ 160,000 $ $ $ $ $ 20,000 12,000 80,000 32,000 5,200 Total Expenses Income: Net Income Operating Margin: $ 10,800 BUDGET from Year 3 to Year 4, they have increased their revenue and f the year so their rent expense is going to increase (they will now Using the Income Statement below, prepare a budget that takes dget amounts for Year 5 in the column below. South Shore Medical Clinic Balance Sheet December 31, 20X4 ASSETS Current Assets Cash Accounts Receivable Supplies Inventory Total Current Assets $ $ $ $ $ 30,000 60,000 10,000 45,000 145,000 Non-current Assets Equipment Building Total Non-current Assets $ $ $ 193,000 200,000 393,000 TOTAL ASSETS $ 538,000 Current Ratio: al Clinic et 0X4 LIABILITIES & NET WORTH Current Liabilities Accounts Payable Current Portion - Long Term Debt Total Current Liabilities $ 32,200 $ 65,000 $ 97,200 Non-current Liabilities Long Term Debt, net of Current Portion Total Non-Current Liabilities $ 210,000 $ 210,000 NET WORTH Owner's Equity $ 230,800 TOTAL LIABILITIES & NET WORTH $ 538,000 South Shore Medical Clinic Trial Balance December 31, 20X4 Cash Accounts Receivable Supplies Inventory Equipment Building Accounts Payable Current Portion - Long Term Debt Long Term Debt, net of Current Portion Owner's Equity Service Fee Revenue Advertising Expense Shipping Expense Salaries Expense Rent Expense Utilities Expense Totals Debit Credit $ 30,000 60,000 10,000 45,000 193,000 200,000 $ 32,200 65,000 210,000 220,000 160,000 20,000 12,000 80,000 32,000 5,200 $ 687,200 $ 687,200