1.1: Calculate and interpret net sales, operating expenses, operating income, and net income data to determine the significance of the trend result.

1.2: Calculate and interpret profit margin, asset turnover, return on assets, and return on net worth data to assess a company's profitability

1.3: Calculate and interpret the current ratio, day's cash on hand, and working capital data to evaluate a company's liquidity

1.4: Calculate the debt ratio and times interest earned ratio to evaluate a company's long-term solvency.

1.5: Conduct a DuPont analysis to determine the organization's DuPont characteristics and trends across an analysis period.

1.6: Make recommendations for management decisions based on the evaluation of financial information.

CARDIOLOGY ENDOCRINOLOYGY FAMILY MED BGYN $ 5,478.81 645 $ 3,533,832 677 $5,807.54 $ 3,931,704 197 $1,144,085 $ 5,478.81 217 $ 1,188,902 228 $5,807.54 $ 1,324,119 112 $ 650,444 $ 5,476.81 1,105 $ 6,051,875 1,161 $5,802.92 $ 6,737,188 636 $ 3,690,656 $ 5,478.81 208 $ 1,139,592 219 $5,794.28 $1,268,947 116 $ 672,136 ENT 0 MENTAL HEALTH $5,475.81 $498.78 690 $ 3,778,309 724 $5,804.36 $ 4,202,356 421 $ 2,443,635 1,287 $641,930 1,351 $528.71 $ 714,283 736 $389,128 1 NEWBORN $ 5,478.81 698 $ 3,824,209 733 $5,807.54 $ 4,256,926 433 $ 2,514,664 2 OB 3 ORTHO 4 PEDIATRICS 5 PODIATRY 6 Total Expenses $ 5,478.81 1,430 $ 7,834,698 1,501 $5,807.54 $8,717,115 868 $ 5,040,943 $ 5,478.81 601 $ 3,292,765 631 $5,807.54 $ 3,664,557 274 $ 1,591,266 $ 5,477.81 124 $679,248 130 $5,806.48 $ 754,842 72 $418,066 $ 5,478.81 2,050 $ 11,231,561 2,152 $55,281 9,055 $43,196,921 9,507 $5,807.54 $58,582 $ 12,497,823 800 $48,069,860 4,665 $ 4,646,031 $23,201,056 7 8 0 Outpatient Outpatient Product Line Unit Price (FY20) 1 CARDIOLOGY 2 ENDOCRINOLOYGY Actual Units (FY20) Total OP Revenue (FY20) Jiranna Healthcare Revenues Worksheet, Mid-Year Review Unit Forecasted Unit Price For (FY21) Projected OP Revenue For Actual Actual OP Revenue (Budget FY21) FY21 (FY21 YTD) (FY21 YTD) $ 6,118.73 645 $ 3,946,580.85 677 $6,118.73 $ 4,142,380 197 $ 1,205,390 $ 6,103.65 217 $ 1,324,492.05 228 $6,103.65 $ 1,391,632 112 $ 683,609 3 FAMILY MED $ 6,021.65 1,105 $ 6,653,923.25 1,161 $6,019.06 $ 6,988,125 636 $ 3,828,120 4 GYN $ 6,013.65 208 $1,250,839.20 219 $5,999.92 $ 1,313,983 116 $ 695,991 5 ENT $ 6,010.65 690 $ 4,147,348.50 724 $6,010.65 $ 4,351,711 421 $ 2,530,484 6 MENTAL HEALTH $ 502.99 1,287 $ 647,348.13 1,351 $502.99 $ 679,539 736 $ 370,200 7 NEWBORN $ 7,014.71 698 $ 4,896,267.58 733 $7,014.71 $ 5,141,782 433 $ 3,037,369 8 OB 9 ORTHO O PEDIATRICS 1 PODIATRY 2 Total Revenue $ 5,713.65 1,430 $ 8,170,519.50 1,501 $5,713.65 $ 8,576,189 868 $ 4,959,448 $ 6,084.18 $ 6,001.65 $ 6,018.14 $61,604 601 124 $ 744,204.60 2,050 $ 12,337,187.00 $ 3,656,592.18 631 $6,084.18 $ 3,839,118 274 130 $6,001.65 $ 780,215 72 $1,667,066 $432,119 2,152 9,055 $47,775,303 9,507 $6,018.14 $61,587 $ 12,951,037 $50,155,711 800 $ 4,814,512 4,665 $24,224,308 3. 4 5 6 Product Line MDC DescrOPtion 7 CARDIOLOGY 8 ENDOCRINOLOYGY 9 FAMILY MED 0 GYN 1 ENT Diseases and Disorders of the Circulatory System (Hypertension, Heart Disease, etc.) Diseases and Disorders of the Endocrin System (Diabetes Type 1 & 2, Thyroid Disorders, etc) Family Primary Care and Disease Preventative Services Diseases and Disorders of Women's Reproductive Health Diseases and Disorders of the Ear, Nose, Mouth, and Throat MENTAL HEALTUL