Question: Hello , I am required to complete a financial analysis of a company / organization of my choice . I have chosen the Jubilee Association

Hello , I am required to complete a financial analysis of a company/organization of my choice . I have chosen the Jubilee Association of Maryland or any other organization (Government/Non -Profit),I preferred an organization in Maryland . I am asked to carefully the organization and answer the following question Introduction of the organization you chose(Jubilee Association of Maryland ) to include its location, primary market served, competitors, and the products / services provided. The main part of the submission should be dedicated to the selection and preliminary calculations (show the math in the Presenters notes) of two (2) ratios from each of the primary ratio categories (e.g.,liquidity, profitability, operating efficiency, and capital structure).1. Liquidity ratio (chose 2 from Current Ratio, Quick ratio, Operating cash flow and ,Working Capital Ratio )2. Profitability Ratio (choose 2 from Gross Profit Margin, Operating Profit Margin ,Net Profit Margin ,Return on Assets (ROA),3. Operational Efficiency Ratio (Choose 2 from: Asset Turnover Ratio, Inventory Turnover Ratio, Accounts Receivable Turnover ,Accounts Payable Turnover )4. Capital Structure Ratios (Choose 2 from: Debt-to-Equity Ratio, Debt Ratio, Interest Coverage Ratio, Equity Ratio, Financial Leverage Ratio) We were asked to carefully consider the selected ratios within each category above and ensure all of the data necessary to fully complete the analysis for the final project is available for your target organization(Jubilee Association of Maryland ). We are required to complete five/six-year trend(2019-2024) analysis including the most recent year of available information/data is expected for each ratio selected. We are required to show the data, interpret each of the ratios selected, and provide your perspectives on the financial strengths and weaknesses of the organization The benchmarking and key financial performance indicator analysis for the chosen organization should be conducted in detail Locate and reference the source data for the financial statements you plan to use However, I have tried few organizations, but not all of the data are available, or probably I dont know other sources to get them. I completed 2023 for Jubilee Association of Maryland and I have attached the sample. I only need help with data for 2022,2021,2020,2019/2024 similar to 2023(attached).8 sub ratios for each year. Below is a sample of what I have completed(2023):Fiscal Year 20231.Liquidity Ratios 1.1 Current Ratio Current Ratio = Current Assets / Current Liabilities Total assets=$26.5m Total Liabilities $ 2.46m : Current Ratio = Current Assets / Current Liabilities Current Ratio = $26.5/$2.46=10.771.2 Quick Ratio The quick ratio assesses an organization's capacity to meet short-term obligations without relying on inventory sales. It is calculated as: QuickRatio=CurrentAssetsInventory/Current Liabilities: QuickRatio=9,764,00002,459,0003.97 Data Interpretation: Liquidity Ratios (2023) For Fiscal Year 2023, the current ratio of 10.77 indicates a strong ability to cover short-term liabilities with current assets, while the quick ratio of 3.97 reinforces the organization's strong position, demonstrating it can meet short-term obligations without relying on inventory sales. 2.0Profitability Ratios (2023)2.1 Net Profit Margin This ratio measures the portion of revenue converted into net profit. Net Profit Margin = Net Income / Total Revenue Net Income=4,110,079 Total Revenue =25,867,716 Net Profit Margin=4,110,079/25,867,716x100 Net Profit Margin=15.89%2.2. Return on Assets (ROA) Formula: ROA = Net Income / Total AssetsX100 Net Income: $4,110,079 Total Assets: $26,508,223 ROA=$4,110,079/26,508,223 ROA=(TotalAssets/NetIncome)100 ROA=$4,110,079/26,508,223X10015.51%.3. Operational Efficiency Ratios 3.1 Operating Margin Operating margin reflects the proportion of revenue remaining after covering operating expenses. It is calculated using the formula: Operating Margin:(Net Income / Revenue)X100 Revenue: $29,977,795 Net Income: $4,110,079 Operating Margin: 13.71%3.2 Asset Turnover Ratio Net Sales (Total Revenue): $29,977,795 Total Assets: $26,508,223 AssetTurnoverRatio=29,977,795/26,508,2231.13 Asset Turnover Ratio =1.134. Capital Structure Ratios 4.1 Debt Ratio The debt ratio indicates the proportion of an organization's assets financed by liabilities. It is calculated as: DebtRatio= TotalLiabilities Total Assets Total Liabilities: $2,459,176 Total Assets: $26,508,223 DebtRatio=$2,459,176 $26,508,223 Debt ratio=0.092X100=9.28% One more is needed for this ratio from this list( Debt-to-Equity Ratio, Interest Coverage What specific information do you want? I have provided all the details including sample

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!