Reference no: EM131373436
Question 1
The following are the selected entries for Lehman Hospital for December 31, 2015 and 2014. Create Lehman Hospital's Balance Sheet.
|
2015
|
2014
|
Bonds Payable
|
$64,000,000
|
$65,000,000
|
Current Assets
|
21,000,000
|
18,000,000
|
Current Liabilities
|
17,000,000
|
14,000,000
|
Property, Plant and Equipment
|
64,000,000
|
63,000,000
|
Net Assets (Equity)
|
4,000,000
|
2,000,000
|
Lehman Hospital
|
Balance Sheet
|
December 31, 2015
|
|
2015
|
2014
|
Assets
|
|
|
|
$
|
$
|
|
|
|
Total Assets
|
$
|
$
|
|
|
|
Liabilities & net assets (equity)
|
|
|
Liabilities
|
|
|
|
$
|
$
|
|
|
|
Total Liabilities
|
$
|
$
|
(Net assets) equity
|
|
|
Total Liabilities and net assets (equity)
|
$
|
$
|
Question 2
Using the data from your balance sheet and the following income statementanswer the following
Lehman Hospital |
Income Statement |
For Year Ended December 31, 2015 |
Revenues |
$96,000,000 |
Expenses |
94,000,000 |
Net Income |
$2,000,000 |
questions (5 points each).
Answer
(a) Compute the total profit margin ratio for 2015. Is this good if the industry average is 2.5
(b) Compute the return on assets ratio for 2015. Is this good if the industry average is 8.3%?
Note: To find total assets (in profit margin formula) to compare to the industry average, the total assets average must be calculated for both years, therefore (2015 assets+2014 assets)/2 = total assets.
(c) Compute the return on equity ratio for 2015. Is this good if the industry average is 5 percent?
Note: To find total equity (in return on equity formula) to compare to the industry average, the total equity average must be calculated for both years, therefore (2015 equity+2014 equity)/2 = total equity.
Question 3
Given the following data, complete the Cash Flow Analysis for Lehman Hospital:
Lehman Hospital is considering the purchase of a new MRI machine, which costs $3,000,000, with no salvage value and an expected life of five years. The MRI machine is expected to have fixed operating costs of $350,000 per year and variable operating costs of $10 per procedure. The equipment is expected to be used 20 times per day for 300 days a year, for each year of the life of the machine. The average billing price for one procedure is $100. All costs and revenues are expected to increase at a 5 percent inflation rate after the first year. The corporate cost of capital is 10%.
(a)
|
|
|
|
|
|
|
|
Year
|
|
0
|
1
|
2
|
3
|
4
|
5
|
Equipment Cost
|
|
|
|
|
|
|
Net Revenues
|
|
|
|
|
|
|
Fixed Operating Costs
|
|
|
|
|
|
|
Variable Operating Costs
|
|
|
|
|
|
|
Net Operating Income
|
|
|
|
|
|
|
Equipment Salvage Value
|
|
|
|
|
|
|
Net Cash Flow
|
|
|
|
|
|
|
|
|
NPV manual calculation.
|
|
|
Corporate Cost of Capital
|
|
|
|
|
|
|
NPV
|
|
|
|
|
|
|
IRR
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(b) What is the payback period for the project using the following timeline?
Year
|
0
|
1
|
2
|
3
|
4
|
5
|
Annual Cash Flows
|
|
|
|
|
|
|
Cumulative Cash Flows
|
|
|
|
|
|
|
Payback
|
?
|
Payback Calculation
|
|
|
|
Bonus Questions
(1) Using problem 12.3 (p. 385) of the text, create your own financial statement by changing the values for each section and solving.
(2) Recreate any problem from this course of your choosing. Please note the Chapter and formula that you are using to calculate your answer.
Garden and reduces my space on average
: Assume that my lawn is encroaching my garden and reduces my space on average by 8% each year. Approximately how many years before the garden space has been cut in half? Answer = 8.8 70/8=8.75 round up t
|
Conduct the test using given value
: A random sample of the percentage used space for companies is 38, 18, 91, 37, 55, 80, 71, 92, 68, 78, 40, 36, 50, 45, 22, 19, 62, 70, 82, 25. Conduct the test using α = 0.05.
|
Discuss how research in psych helps providers address cancer
: Discuss how research in psych helps providers address cancer and heart disease in clients. Is there really a connection? Show connections to the reading or outside research as that helps all of us to expand our understanding of this important issu..
|
How that reasoning supports the position you have taken
: This section of the Final Paper will explain and demonstrate what you believe to be the best way of reasoning about the question you have chosen, and showing how that reasoning supports the position you have taken on the question.
|
Compute the return on equity ratio for 2015
: HSA 304 Create your own financial statement by changing the values for each section and solving - Complete the Cash Flow Analysis for Lehman Hospital
|
Develop diversity training that fosters mutual respect
: Do you think corporations and government agencies should offer diversity training? If so, how can we develop diversity training that fosters mutual respect? Can you suggest practical ways to develop workplaces undivided by gender and race-ethnicit..
|
Conduct the test using given value
: A random sample of the percentage used space for companies is 38, 18, 91, 37, 55, 80, 71, 92, 68, 78, 40, 36, 50, 45, 22, 19, 62, 70, 82, 25. Conduct the test using α = 0.05.
|
What questions remain unanswered
: PSY/335:Each member of the team chooses an article from a journal in the university library (see below) and answers the 4 questions in the Proposal Worksheet document. Then everyone in the team reviews the other members' submissions of answers 1-4..
|
Which country has less expensive hotels
: Conduct a test for equality of average hotel room prices in these two countries against a two-tailed alternative. Which country has less expensive hotels?
|