Financial Statement Analysis: Average Payment Period Ratio

THIS ASSIGNMENT IS TO BE DONE ON AN EXCEL SPREADSHEET

In this assignment, you will compare year-over-year payment trends using the average payment period ratio, which is calculated as follows:

Average Payment Period Ratio = Current Liabilities / ([Total Operating Expenses – Depreciation and Amortization Expenses] / 365)

The average payment period measures how long it takes, on average, for a business to pay back its creditors or, in essence, to pay its bills.

Review the following scenario:

You are the department head for the finance department for Anytown Hospital, a not-for-profit community hospital in an urban community. The hospital administrator reviewed the most recent average payment period report (for fiscal year 2012 [FY2012]) and noted a variance between the FY2011 and FY2012 reports. The hospital administrator is not well versed in financial reports.

As the chief finance officer (CFO) and financial expert, you are tasked to explain the variance to the Administrator. You must answer whether the variance is positive or negative as compared with the industry benchmark of 45 days. What are the risks if the trend is negative between FY2011 and FY2012? What are the benefits if the trend is positive from FY2011 to FY2012? You will present your findings in a PowerPoint presentation to the Hospital Administrator and other hospital department heads.

Based on your analysis of the scenario, complete the following tasks: 

Part 1: Average Payment Period Ratio Report Development

For this assignment, you will develop and analyze financial statements. Part 1 of the assignment includes describing what an average payment period is and how it is calculated. Use the years and the dollar amounts provided in the table below: 

Operating Expenses

Depreciation and Amortization

Difference

Days per Year

Average Cash Expense per Day

15,255,263.00

553,219.00

365

12,589,823.00

665,393.00

365

Year

Current Liabilities

Average Cash Expense Per Day

Average Payment Period Days

2011

2,550,263.00

2012

4,553,681.00

Using an Excel spreadsheet (or any other tool for performing calculations), determine the average payment period for FY2011 and FY2012. Use the following steps:
•Use the provided dollar amount of total operating expenses and depreciation and amortization. 
•Subtract depreciation and amortization from the operating expenses and divide by 365 days to compute the average cash expense per day.
•Identify the dollar amounts for current liabilities on the balance sheet.
•Divide the current liabilities by the average cash per day.
•Determine if the trend is positive or negative for the average payment period days.
•Determine if the 2011 and 2012 average payment period days are above or below the industry benchmark.

——————-

p(1)

Place your order now to enjoy great discounts on this or a similar topic.

People choose us because we provide:

Essays written from scratch, 100% original,

Delivery within deadlines,

Competitive prices and excellent quality,

24/7 customer support,

Priority on their privacy,

Unlimited free revisions upon request, and

Plagiarism free work,

 

Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: