Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

My professor asked us to calculate the 2015 financial ratios after creating the income statement and balance sheet. PLEASE HELP Exhibit 1 Blackhawk Urology Rlaclharvl

image text in transcribedimage text in transcribedimage text in transcribed

My professor asked us to calculate the 2015 financial ratios after creating the income statement and balance sheet.

PLEASE HELP

Exhibit 1 Blackhawk Urology Rlaclharvl Finnnainl Ctatemante and Ratioe Physician salary 750 4Y0 43 *Net worth is defined as (last year's net worth) + (gross profit) - (physician salary). Cash shortfalls are assumed to affect physician salary such that (total assets) =( accounts payable )+( net worth). **Receivable days represents the average number of days it takes to collect practice receivables. Source: Created by case writer. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ Income Statement } \\ \hline \multicolumn{7}{|l|}{ Blackhawk Urology } \\ \hline & & 2012 & & 2013 & & 2014 \\ \hline Total Revenue & $ & 1,910 & $ & 1,952 & $ & 2,085 \\ \hline \multicolumn{7}{|l|}{ Expenses } \\ \hline Office Expenses & $ & 198 & $ & 205 & $ & 221 \\ \hline Medical Supplies & $ & 105 & $ & 113 & $ & 135 \\ \hline Cancer Meds & $ & 285 & $ & 313 & $ & 350 \\ \hline Rent and Utilities & $ & 112 & $ & 115 & $ & 117 \\ \hline Staff Salary & $ & 350 & $ & 359 & $ & 420 \\ \hline Physician Malpractice & $ & 54 & $ & 52 & $ & 65 \\ \hline Total Expenses & $ & 1,104 & $ & 1,157 & $ & 1,308 \\ \hline Profit & $ & 806 & $ & 795 & $ & 777 \\ \hline data is in thousands & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ Balance Sheet } \\ \hline \multicolumn{7}{|l|}{ Blackhawk Urology } \\ \hline & & 2012 & & 2013 & & 2014 \\ \hline \multicolumn{7}{|l|}{ Assets } \\ \hline Cash On Hand & $ & 145 & $ & 175 & $ & 84 \\ \hline Receivables & $ & 556 & $ & 708 & $ & 840 \\ \hline Other Current Assets & $ & 55 & $ & 58 & $ & 64 \\ \hline Equipment & $ & 1,650 & $ & 1,680 & $ & 1,860 \\ \hline Total Assets & $ & 2,406 & $ & 2,621 & $ & 2,848 \\ \hline \multicolumn{7}{|c|}{ Liabilities and Net Worth } \\ \hline Accounts Payable & $ & 215 & $ & 125 & $ & 70 \\ \hline Net Worth & $ & 2,191 & $ & 2,496 & $ & 2,778 \\ \hline Total & $ & 2,406 & $ & 2,621 & $ & 2,848 \\ \hline \end{tabular} Exhibit 1 Blackhawk Urology Rlaclharvl Finnnainl Ctatemante and Ratioe Physician salary 750 4Y0 43 *Net worth is defined as (last year's net worth) + (gross profit) - (physician salary). Cash shortfalls are assumed to affect physician salary such that (total assets) =( accounts payable )+( net worth). **Receivable days represents the average number of days it takes to collect practice receivables. Source: Created by case writer. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ Income Statement } \\ \hline \multicolumn{7}{|l|}{ Blackhawk Urology } \\ \hline & & 2012 & & 2013 & & 2014 \\ \hline Total Revenue & $ & 1,910 & $ & 1,952 & $ & 2,085 \\ \hline \multicolumn{7}{|l|}{ Expenses } \\ \hline Office Expenses & $ & 198 & $ & 205 & $ & 221 \\ \hline Medical Supplies & $ & 105 & $ & 113 & $ & 135 \\ \hline Cancer Meds & $ & 285 & $ & 313 & $ & 350 \\ \hline Rent and Utilities & $ & 112 & $ & 115 & $ & 117 \\ \hline Staff Salary & $ & 350 & $ & 359 & $ & 420 \\ \hline Physician Malpractice & $ & 54 & $ & 52 & $ & 65 \\ \hline Total Expenses & $ & 1,104 & $ & 1,157 & $ & 1,308 \\ \hline Profit & $ & 806 & $ & 795 & $ & 777 \\ \hline data is in thousands & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ Balance Sheet } \\ \hline \multicolumn{7}{|l|}{ Blackhawk Urology } \\ \hline & & 2012 & & 2013 & & 2014 \\ \hline \multicolumn{7}{|l|}{ Assets } \\ \hline Cash On Hand & $ & 145 & $ & 175 & $ & 84 \\ \hline Receivables & $ & 556 & $ & 708 & $ & 840 \\ \hline Other Current Assets & $ & 55 & $ & 58 & $ & 64 \\ \hline Equipment & $ & 1,650 & $ & 1,680 & $ & 1,860 \\ \hline Total Assets & $ & 2,406 & $ & 2,621 & $ & 2,848 \\ \hline \multicolumn{7}{|c|}{ Liabilities and Net Worth } \\ \hline Accounts Payable & $ & 215 & $ & 125 & $ & 70 \\ \hline Net Worth & $ & 2,191 & $ & 2,496 & $ & 2,778 \\ \hline Total & $ & 2,406 & $ & 2,621 & $ & 2,848 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISE Analysis For Financial Management

Authors: Robert C. Higgins Professor, Jennifer Koski

13th International Edition

1265042632, 9781265042639

More Books

Students also viewed these Finance questions

Question

How flying airoplane?

Answered: 1 week ago

Question

List at least three disadvantages to using a consultant.

Answered: 1 week ago

Question

How are arbitrators credentialed?

Answered: 1 week ago