Complete the following 5-year calculations:

• Net sales, operating expenses, operating income, and net income of Jiranna Healthcare.
• Total profit margin, asset turnover, return on assets, and return on net worth.
• Current ratio, day's cash on hand, and working capital.
• Debt ratio and times interest earned ratio.
• Complete a DuPont analysis for each of the five most recent years.

Next, reflect on what each of the resulting data mean in terms of the:

• Significance of the trend results.
• Company's profitability.
• Company's liquidity.
• Company's long-term solvency.
• Company's individual DuPont characteristics (e.g., total margin, total asset turnover & equity multiplier) and trends across the analysis period.

Finally, think about whether you would recommend purchasing Jiranna Healthcare and the rationale for your recommendation.

Transcribed Image Text:

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

Answer rating: 100% (QA)

Based on the provided cash flows for Jiranna Healthcare in 2021 in thousands we can calculate the net present value NPV internal rate of return IRR modified internal rate of return MIRR payback period ... View the full answer