Please help with compiling a ration analysis report for the following elements.
1. For your third milestone, you will complete a draft of your ratio analysis report so that you can gain feedback and improve your work prior to the final submission in Module Eight. Note that you do not need feedback from Milestone Two to successfully complete this assignment. You should use the provided Final Project Part II template to structure your submission. Prompt: Specifically, the following critical elements must be addressed: Abstract: Summarize the story of profitability and liquidity for your company. In other words, highlight the most important aspects of your report, including your major conclusions. Computations: Identify and describe your computations from the Financial Analysis tab of your workbook. Be sure to format your key results in a table or graphical format, as appropriate. Explain why each cited figure was included in your report in terms of its importance for the organization. Comparison: Evaluate the financials of the company by comparing current ratios to both historical and industry-average ratios. Clearly identify all unexpected or aberrant figures. Conclusion: Draw informed conclusions based on your computations and comparisons in the previous paragraphs. Be sure to justify your claims with specific evidence and examples. II. III. IV. Rubric Guidelines for Submission: Your ratio analysis report must be 2-3 pages in length (plus a cover page and references) and written in APA format. Use double spacing, 12-point Times New Roman font, and one-inch margins. All references must be cited in APA format. As of December 31, 2017 Assets Current Assets: Cash Baking Supplies Merchandise Inventory (FIFO) Prepaid Rent Prepaid Insurance Office Supplies Accounts Receivable Total Current Assets 64,713.72 27,850.00 25,750.00 7,500.00 400.00 250.00 30.401.00 Liabilities and Owners' Equity Current Liabilities: 51,693.75 Accounts Payable 27,325.00 Wages Payable 22,800.00 Interest Payable 1,468.75 Total Current Liabilities 51,593.75 Long Term Liabilities: Notes Payable Loans Payable Total Long Term Liabilities: Total Liabilities: 31,000.00 10,000.00 21,000.00 156,864.72 31,000.00 82,593.75 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation 17,000.00 5,928.58 Common Stock Retained Earnings 30,000.00 63,642.39 11,071.42 Leasehold Improvements Accumulated Amortization Total Equity 93,642.39 10,000.00 4,000.00 6,000.00 Trademark 2,300.00 Total Assets: 176,236.14 Total Liabilities & Equity 176,236.14 2017 2.52 1 2 3 Quick Ratio 4 Gross Margin 5 Net Margin 6 Return on Equity 7 0.59 0.23 2016) 2.20 0.55 0.22 0.90 2015 Industry Standard 2.80 1.75 0.70 0.70 0.32 0.24 0.78 0.80 0.89 1. For your third milestone, you will complete a draft of your ratio analysis report so that you can gain feedback and improve your work prior to the final submission in Module Eight. Note that you do not need feedback from Milestone Two to successfully complete this assignment. You should use the provided Final Project Part II template to structure your submission. Prompt: Specifically, the following critical elements must be addressed: Abstract: Summarize the story of profitability and liquidity for your company. In other words, highlight the most important aspects of your report, including your major conclusions. Computations: Identify and describe your computations from the Financial Analysis tab of your workbook. Be sure to format your key results in a table or graphical format, as appropriate. Explain why each cited figure was included in your report in terms of its importance for the organization. Comparison: Evaluate the financials of the company by comparing current ratios to both historical and industry-average ratios. Clearly identify all unexpected or aberrant figures. Conclusion: Draw informed conclusions based on your computations and comparisons in the previous paragraphs. Be sure to justify your claims with specific evidence and examples. II. III. IV. Rubric Guidelines for Submission: Your ratio analysis report must be 2-3 pages in length (plus a cover page and references) and written in APA format. Use double spacing, 12-point Times New Roman font, and one-inch margins. All references must be cited in APA format. As of December 31, 2017 Assets Current Assets: Cash Baking Supplies Merchandise Inventory (FIFO) Prepaid Rent Prepaid Insurance Office Supplies Accounts Receivable Total Current Assets 64,713.72 27,850.00 25,750.00 7,500.00 400.00 250.00 30.401.00 Liabilities and Owners' Equity Current Liabilities: 51,693.75 Accounts Payable 27,325.00 Wages Payable 22,800.00 Interest Payable 1,468.75 Total Current Liabilities 51,593.75 Long Term Liabilities: Notes Payable Loans Payable Total Long Term Liabilities: Total Liabilities: 31,000.00 10,000.00 21,000.00 156,864.72 31,000.00 82,593.75 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation 17,000.00 5,928.58 Common Stock Retained Earnings 30,000.00 63,642.39 11,071.42 Leasehold Improvements Accumulated Amortization Total Equity 93,642.39 10,000.00 4,000.00 6,000.00 Trademark 2,300.00 Total Assets: 176,236.14 Total Liabilities & Equity 176,236.14 2017 2.52 1 2 3 Quick Ratio 4 Gross Margin 5 Net Margin 6 Return on Equity 7 0.59 0.23 2016) 2.20 0.55 0.22 0.90 2015 Industry Standard 2.80 1.75 0.70 0.70 0.32 0.24 0.78 0.80 0.89
