Part 1, using the Week 5 Final Project Template Word document,
Calculate the cur
Part 1, using the Week 5 Final Project Template Word document,
Calculate the current ratio and debt ratio for 2017, 2018, and 2019 (Table 1).
Calculate the days sales outstanding, days in inventory, days in payables, and cash conversion cycle in 2017, 2018, and 2019 (Table 2).
Calculate the sources and uses of funds related to the purchase of additional sewing equipment (Table 3.).
Prepare the pro forma income statement for 2020 for Ashley Palmer Clothing based on the stated assumptions (Table 4).
Prepare the pro forma balance sheet for 2020 for Ashley Palmer Clothing (Table 5).
Use the percentage of sales method.
Calculate the current ratio and debt ratio for 2020, based on your Table 5 pro forma balance sheet (Table 6).
Calculate the days sales outstanding, days in inventory, days in payables, and cash conversion cycle for 2020, based on your Table 4 pro forma income statement and your Table 5 pro forma balance sheet (Table 7)
Part 2, in the paper,
Compare the projected financial ratios in 2020 to the ratios in 2019.
Be sure to discuss trends in the current ratio, debt ratio, days sales outstanding, days in inventory, and days in payables.
Compare Ashley Palmer’s projected cash conversion cycle in 2020 to 2019’s cycle.
Explain bank loan covenants, who they protect, and the consequences for a business that does not meet bank loan covenants.
Consider including scholarly, peer-reviewed, or credible sources to support your explanation.
Determine if Ashley Palmer Clothing is projected to meet the covenants of the bank loan of a current ratio of 1.5 or higher and a debt ratio of 55% or lower in 2020, based on the analysis in your template.
Justify the decision to expand the business and purchase the new sewing equipment as described in the case.
Discuss an alternate form of funding for Ashley Palmer Clothing in place of the two bank loans. Consider the pros and cons of using credit cards, asking friends or family members to invest, or using crowdfunding.
Consider including scholarly, peer-reviewed, or credible sources to support your discussion.
Create a Code of Ethics for the Ashley Palmer Clothing business; be sure to address the five fundamental principles of purpose, pride, patience, persistence, and perspective.