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:
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 |
|||||||||||
|
|||||||||||
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) |
||||||||||
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 $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. 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 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 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.
In: Finance
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. 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" with your cell phone? Why or why not?
In: Physics
In: Accounting
In: Operations Management
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 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).
|
In: Finance
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.
In: Finance
List five sources for finding prospective employers; give one advantage and one disadvantage of each source.
In: Operations Management