- = = Merge & Center $ Clipboard Font Alignment TextBox2 fo A B C D E F 1 2 3 Service Revenue 4 Total 2015 Revenue 5 2016 2017 2015 718,591.55 718,591.55 $ 6 7 2015 8 Payroll 2016 2017 9 10 Payroll Tax Liability Preparation Serivce $439,91F00 $ 32,993.55 $ 1,292.00 Accountant $6,000.00 Attorney $3,000.00 Consulting $ 1,440.00 MD Licensing/Credentialing $ 2,100.00 Office Supplies Medical Devices Medical Supplies $ 1,200.00 $ 92,400.00 $ 18,000.00 11 12 Professional Fees 13 14 15 16 17 Supplies 18 19 20 21 Rent 22 23 24 Utilities 25 26 27 28 29 30 Subscriptions 31 32 33 34 Total Expenses: 35 Savannah Pooler $ 58,200.00 $ 21,600.00 Telephone MD Cell Phones Electricity H20 Internet Services $ 10,548.00 $ 2,400.00 $ 3,600.00 $ 2,400.00 $ 3,000.00 EMR IT Maintenance Plan $ 12,600.00 $ 5,904.00 Outlined in this spreadsheet is a short form of 2015 expenses. Listed below are some changes that are expected over the next two fiscal years. Insert the Calculations where appropriate for the following: 1.) All utility costs are expected to increase by 2% in 2016 and 0.5% for 2017. 2.) Payroll is expected to jump in 2017 by $120,000 with the addition of a nurse practitioner and medical assistant. With the hiring of this additional staff, Tax Liability will also increase. The tax liability for the new staff will be 7.5% of the $120,000. (There are no projected changes for 2016.) 3.) For all supplies there needs to be a decrease in spending. The owners are requesting a 10% reduction in supply cost over the next two years. For there to be a gradual reduction, there are requesting costs be reduced 5% in both 2016 and 2017. 5.) There are no additional expected changes over the next two years. 1.) Is the amount of revenue in 2015 enough to cover the expenses for 2016? What about 2017? 2.) What would the revenue need to be in order for this medical practice to have a 10% profit in 2016? 3.) What would the revenue need to be in order for this medical practice to have a 20% profit in 2017