Questions
Instructions: For this assignment, you will create a cash flow statement for Happy Healing Hospital for...

Instructions:

For this assignment, you will create a cash flow statement for Happy Healing Hospital for 2016.

The information for 2016 has been collected from various sources within the healthcare organization and is listed in the info below.  It is not nice and neat. The entries are not lined up very well and may be a little out of order for your report but the information that you need to create this statement is all listed. It is up to you to create the statement and make it presentable.

You will find the information for 2015 has already been entered in the spreadsheet as an example to go by.

To complete this assignment, please do the following:

  • add a column next to 2015 and label it 2016 for side-by- side comparison.
  • enter the information below in the appropriate cell.
  • create formulas to total each section as was done for 2015.
  • Happy Healing Hospital - Cash Flow Statement

    Reported Values

    Operating Activities

    2015 2016
    Cash received from patients and third party payors $19,915,566
    Cash paid to employees for salaries and benefits ($11,081,726)
    Cash paid to vendors for goods and services ($7,166,776)
    Other operating receipts, net $671,212
    Net cash from operating activities $2,338,276

    Capital and related financing activities

    Acquisition and construction of capital assets ($477,992)
    Proceeds from sale of capital assets $3,980
    Interest paid on long-term debt ($42,184)
    Payments on line of credit -
    Proceeds on long-term debt -
    Principal payments on long-term debt ($391,003)
    Net cash from capital and related financing activities ($907,199)

    Investing activities

    Investment and other nonoperating income $108,045
    Net cash from investing activities $108,045
    Net change in cash and cash equivalents $1,728,113
    Cash and cash equivalents, beginning of year $2,379,906
    Cash and cash equivalents, end of year $4,324,109

    Reconciliation of cash and cash equivalents to the balance sheets

    Cash and cash equivalents
    In current assets $5,166,428
    In noncurrent cash and investments $809,491
    Total cash and cash equivalents $5,975,919

    Reconciliation of operating loss to net cash from operating activities

    Operating income $861,828

    Adjustments to reconcile operating income to net cash from operating activities:

    Depreciation and amortization $1,883,051
    (Gain) loss on disposal of capital assets ($525)
    Provision for bad debt $1,281,107
    Changes in assets and liabilities
    Patient accounts receivable ($2,044,870)
    Estimated third-party settlements $1,199,971
    Supplies and other current assets $90,264
    Other assets ($7,698)
    Accounts payable and accrued expenses $2,077,036
    Other current liabilities $57,535
    Accrued salaries and related liabilities ($2,405,197)
    Other long-term liabilities ($25,000)

    Net cash flows from operating activities

    $2,967,502

2016

Operating income

$180,798

Acquisition and construction of capital assets

($401,572)

Proceeds from sale of capital assets

-   

Interest paid on long-term debt

($48,036)

Payments on line of credit

($150,000)

Proceeds on long-term debt

$125,000

Principal payments on long-term debt

($352,225)

Cash and cash equivalents

In current assets

$1,739,826

In noncurrent cash and investments

$640,080

Total cash and cash equivalents

$2,379,906

Depreciation and amortization

$1,243,393

(Gain) loss on disposal of capital assets

$246,456

Provision for bad debt

$1,402,017

Changes in assets and liabilities

Patient accounts receivable

($717,771)

Estimated third-party settlements

$300,318

Supplies and other current assets

($221,648)

Other assets

$7,760

Accounts payable and accrued expenses

($364,752)

Other current liabilities

$77,440

Accrued salaries and related liabilities

$186,109

Other long-term liabilities

($35,000)

Investment and other nonoperating income

($103,893)

Net cash from investing activities

($103,893)

Net change in cash and cash equivalents

$1,374,394

Cash and cash equivalents, beginning of year

$1,005,512

Cash received from patients and third party payors $20,363,530




Cash paid to employees for salaries and benefits

($11,349,910)

Cash paid to vendors for goods and services

($7,724,464)

Other operating receipts, net

$1,015,964

In: Finance

Charlotte's Crochet Shoppe has 14,000 shares of common stock outstanding at a price per share of...

Charlotte's Crochet Shoppe has 14,000 shares of common stock outstanding at a price per share of $74 and a rate of return of 11.57 percent. The company also has 270 bonds outstanding, with a par value of $2,000 per bond. The pretax cost of debt is 6.11 percent and the bonds sell for 96.9 percent of par. What is the firm's WACC if the tax rate is 39 percent?

In: Finance

A $1,000 par value bond has coupon rate of 5% and the coupon is paid semi-annually....

A $1,000 par value bond has coupon rate of 5% and the coupon is paid semi-annually. The bond matures in 20 years and has a required rate of return of 10%. Compute the current price of this bond?

In: Finance

Problem 7-11 Balance Sheet Analysis Complete the balance sheet and sales information in the table that...

Problem 7-11
Balance Sheet Analysis

Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data:

Total assets turnover: 1.3
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 20%
Total liabilities-to-assets ratio: 45%
Quick ratio: 1.05
Days sales outstanding (based on 365-day year): 39.5 days
Inventory turnover ratio: 7.0

Round your answers to the nearest whole dollar.

Partial Income Statement
Information
Sales $ _____
Cost of goods sold $ ______

Balance Sheet

Cash $ _______ Accounts payable $ ______
Accounts receivable $ ______ Long-term debt $  50,000
Inventories $ _______ Common stock $ ______
Fixed assets $ _____ Retained earnings $  100,000
Total assets $  400,000 Total liabilities and equity $ _______

Answer all the blanks ____ and plz show steps

In: Finance

“The aim of industrial psychology is primarily not to obtain greater production or output but to...

“The aim of industrial psychology is primarily not to obtain greater production or output but to give the worker greater ease at his work”. - Justify this statement.

In: Psychology

i want to know about the financial summary/stock purchase recommendation of the texas instrument inc.

i want to know about the financial summary/stock purchase recommendation of the texas instrument inc.

In: Finance

Assume that stock market returns have the market index as a common factor, and that all...

Assume that stock market returns have the market index as a common factor, and that all stocks in the economy have a beta of 1.2 on the market index. Firm-specific returns all have a standard deviation of 25%.

Suppose that an analyst studies 20 stocks and finds that one-half of them have an alpha of +1.6%, and the other half have an alpha of −1.6%. Suppose the analyst invests $1.0 million in an equally weighted portfolio of the positive alpha stocks, and shorts $1 million of an equally weighted portfolio of the negative alpha stocks.

a. What is the expected profit (in dollars) and standard deviation of the analyst’s profit? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)

b. How does your answer change if the analyst examines 50 stocks instead of 20 stocks? 100 stocks? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)

In: Finance

President Trump began his Presidency in January 2017. He had to make many new administrative appointments....

President Trump began his Presidency in January 2017. He had to make many new administrative appointments. Searching the internet review media reports of his major appointments, focusing on the particular characteristics and backgrounds of the appointees. What qualities was the president looking for?include media reports from diverse sources. Meaning, not all Fox News, not all MSNBC/CNN, not all The Drudge Report, etc.

In: Psychology

Based on what you heard in this podcast, do you think you are "frying your brain"...

  1. Based on what you heard in this podcast, do you think you are "frying your brain" with your cell phone? Why or why not?

In: Physics

TCJA changed the depreciation rules for new farm machinery and equipment. The change includes:

TCJA changed the depreciation rules for new farm machinery and equipment. The change includes:

In: Accounting

What is the difference between a requirements philosophy and a replenishment philosophy of inventory management? Why...

  • What is the difference between a requirements philosophy and a replenishment philosophy of inventory management? Why is this difference important?
  • Compare and contrast the management of finished goods inventory in a manufacturing firm with that in a retail or wholesale firm.

In: Operations Management

Jack is the only shareholder of XYZ Corporation. At year-end, XYZ had $200 of current year...

Jack is the only shareholder of XYZ Corporation. At year-end, XYZ had $200 of current year earnings and profits and $600 of accumulated earnings and profits. If XYZ distributes cash of $200 to Jack, what is Jack’s tax liability on the dividend, if any? Assume Jack has a basis of $10 in XYZ shares. How does this result change if XYZ only has $50 of current earnings and profits and $100 of accumulated earnings and profits?

Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make effective use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.

In: Accounting

A store has 5 years remaining on its lease in a mall. Rent is $2,100 per...

A store has 5 years remaining on its lease in a mall. Rent is $2,100 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to sell the property in a year and wants rent at that time to be high so that the property will appear more valuable. Therefore, the store has been offered a "great deal" (owner's words) on a new 5-year lease. The new lease calls for no rent for 9 months, then payments of $2,500 per month for the next 51 months. The lease cannot be broken, and the store's WACC is 12% (or 1% per month).

  1. Should the new lease be accepted? (Hint: Be sure to use 1% per month.)

    -Select-YesNoItem 1

  2. If the store owner decided to bargain with the mall's owner over the new lease payment, what new lease payment would make the store owner indifferent between the new and old leases? (Hint: Find FV of the old lease's original cost at t = 9; then treat this as the PV of a 51-period annuity whose payments represent the rent during months 10 to 60.) Do not round intermediate calculations. Round your answer to the nearest cent.

    $  

  3. The store owner is not sure of the 12% WACC—it could be higher or lower. At what nominal WACC would the store owner be indifferent between the two leases? (Hint: Calculate the differences between the two payment streams; then find its IRR.) Do not round intermediate calculations. Round your answer to two decimal places.

      %

In: Finance

Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to...

Working Capital Cash Flow Cycle

Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,700,000 (all on credit), and its net profit margin was 4%. Its inventory turnover was 7.5 times during the year, and its DSO was 44 days. Its annual cost of goods sold was $1,500,000. The firm had fixed assets totaling $430,000. Strickler's payables deferral period is 50 days. Assume 365 days in year for your calculations. Do not round intermediate calculations.

  1. Calculate Strickler's cash conversion cycle. Round your answer to two decimal places.
         days
  2. Assuming Strickler holds negligible amounts of cash and marketable securities, calculate its total assets turnover. Round your answer to two decimal places.
         x
    Calculate its ROA. Round your answer to two decimal places.
         %
  3. Suppose Strickler's managers believe the annual inventory turnover can be raised to 11 times without affecting sale or profit margins. What would Strickler's cash conversion cycle have been if the inventory turnover had been 11 for the year? Round your answer to two decimal places.
         days
    What would Strickler's total assets turnover have been if the inventory turnover had been 11 for the year? Round your answer to two decimal places.
          x
    What would Strickler's ROA have been if the inventory turnover had been 11 for the year? Round your answer to two decimal places.
         %

In: Finance

List five sources for finding prospective employers; give one advantage and one disadvantage of each source.

List five sources for finding prospective employers; give one advantage and one disadvantage of each source.

In: Operations Management