Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started