The Booth Company’s Sales

1. Additional Funds Needed
The Booth Company’s sales are forecasted to double from $1,000 in 2012 to $2,000 in 2013. Here is the December 31, 2012, balance sheet:
Cash $ 100 Accounts payable $ 50
Accounts receivable 200 Notes payable 150
Inventories 200 Accruals 50
Net fixed assets 500 Long-term debt 400
Common stock 100
Retained earnings 250
Total assets $1000 Total liabilities and equity $1000
Booth’s fixed assets were used to only 50% of capacity during 2012, but its current assets were at their proper levels in relation to sales. Spontaneous liabilities and all assets except fixed assets must increase at the same rate as sales, and fixed assets would also have to increase at the same rate if the current excess capacity did not exist. Booth’s after-tax profit margin is forecasted to be 7% and its payout ratio to be 70%. What is Booth’s additional funds needed (AFN) for the coming year? Round your answer to the nearest dollar.$

2. AFN equation
Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2013 to $9.2 million in 2014. Its assets totaled $5 million at the end of 2013. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2013, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 55%. What would be the additional funds needed? Do not round intermediate calculations. Round your answer to the nearest dollar.
$
Assume that the company’s year-end 2013 assets had been $4 million. Is the company’s “capital intensity” ratio the same or different?

I. The capital intensity ratio is measured as A0*/S0. Broussard’s capital intensity ratio is lower than that of the firm with $4 million year-end 2013 assets; therefore, Broussard is more capital intensive – it would require a smaller increase in total assets to support the increase in sales.
II. The capital intensity ratio is measured as A0*/S0. Broussard’s capital intensity ratio is higher than that of the firm with $4 million year-end 2013 assets; therefore, Broussard is less capital intensive – it would require a smaller increase in total assets to support the increase in sales.
III. The capital intensity ratio is measured as A0*/S0. Broussard’s capital intensity ratio is higher than that of the firm with $4 million year-end 2013 assets; therefore, Broussard is more capital intensive – it would require a larger increase in total assets to support the increase in sales.
IV. The capital intensity ratio is measured as A0*/S0. Broussard’s capital intensity ratio is lower than that of the firm with $4 million year-end 2013 assets; therefore, Broussard is more capital intensive – it would require a larger increase in total assets to support the increase in sales.

3.AFN Equation Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2013 to $9.2 million in 2014. Its assets totaled $4 million at the end of 2013. Baxter is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2013, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 4%. Assume that the company pays no dividends. Under these assumptions, what would be the additional funds needed for the coming year? Do not round intermediate calculations. Round your answer to the nearest dollar.
$
Why is this AFN different from the one when the company pays dividends?

I. Under this scenario the company would have a lower level of retained earnings which would reduce the amount of additional funds needed.
II. Under this scenario the company would have a lower level of retained earnings but this would have no effect on the amount of additional funds needed.
III. Under this scenario the company would have a higher level of retained earnings which would reduce the amount of additional funds needed.
IV. Under this scenario the company would have a higher level of retained earnings which would increase the amount of additional funds needed.
V. Under this scenario the company would have a higher level of retained earnings but this would have no effect on the amount of additional funds needed.
4.Sales Increase
Maggie’s Muffins, Inc., generated $4,000,000 in sales during 2013, and its year-end total assets were $2,400,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and $200,000 of accruals. Looking ahead to 2014, the company estimates that its assets must increase at the same rate as sales, its spontaneous liabilities will increase at the same rate as sales, its profit margin will be 4%, and its payout ratio will be 70%. How large a sales increase can the company achieve without having to raise funds externally; that is, what is its self-supporting growth rate? Do not round intermediate steps. Round your answers to the nearest whole.
Sales can increase by $ , that is by %.
5.Long-Term Financing Needed
At year-end 2013, Wallace Landscaping’s total assets were $1.8 million and its accounts payable were $415,000. Sales, which in 2013 were $2.6 million, are expected to increase by 30% in 2014. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to $470,000 in 2013, and retained earnings were $345,000. Wallace has arranged to sell $50,000 of new common stock in 2014 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2014. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its profit margin on sales is 4%, and 35% of earnings will be paid out as dividends.
1. What was Wallace’s total long-term debt in 2013? Round your answer to the nearest dollar.
$
What were Wallace’s total liabilities in 2013? Round your answer to the nearest dollar.
$
2. How much new long-term debt financing will be needed in 2014? (Hint: AFN – New stock = New long-term debt.) Round your answer to the nearest dollar.
$
6.Additional Funds Needed
The Booth Company’s sales are forecasted to double from $1,000 in 2012 to $2,000 in 2013. Here is the December 31, 2012, balance sheet:

Cash $ 100 Accounts payable $ 50
Accounts receivable 200 Notes payable 150
Inventories 200 Accruals 50
Net fixed assets 500 Long-term debt 400
Common stock 100
Retained earnings 250
Total assets $1000 Total liabilities and equity $1000

Booth’s fixed assets were used to only 50% of capacity during 2012, but its current assets were at their proper levels in relation to sales. Spontaneous liabilities and all assets except fixed assets must increase at the same rate as sales, and fixed assets would also have to increase at the same rate if the current excess capacity did not exist. Booth’s after-tax profit margin is forecasted to be 7% and its payout ratio to be 70%. What is Booth’s additional funds needed (AFN) for the coming year? Round your answer to the nearest dollar.

Review

Question 1 of 20! 5.0/ 5.0 Points! Mental health:! A. allows children to effectively cope with adversity. ! ! B. is not important until the primary years. !! C. does not affect physical health. ! ! D. teachers have little effect on a child’s mental health. ! !! Question 2 of 20! 0.0/ 5.0 Points! Whether a program receives meals through a contracted meal service, prepares food on site, or serves meals prepared in a home kitchen, it is important to implement guidelines established by which of the following?! A. National Association for the Education of Young Children ! ! B. Hazard and Analysis Critical Control Point system ! ! C. Child Nutrition Reauthorization Act ! ! D. U. S. Department of Agriculture ! !! Question 3 of 20! 5.0/ 5.0 Points! It is important for teachers to encourage playing actively and getting sufficient sleep because:! A. conditions such as obesity, heart disease, cancer, and mental health problems have their roots in early childhood. ! ! B. if children do not learn these skills in preschool they will not practice them later. ! ! C. most children come from homes that do not practice healthful living. ! ! D. as they age children will develop increased susceptibility to certain infectious diseases. ! !! Question 4 of 20! 0.0/ 5.0 Points! Accreditation through The National Association for the Education of Young Children includes:! A. quality assessment in 10 program standards. ! ! B. multiple endorsements for programs that serve children 0–18. !! C. one rigorous accreditation certification program. ! ! D. accreditation to meet local standards of quality. !!! Question 5 of 20! 0.0/ 5.0 Points! Which of the following foods requires more careful management than the others because it is considered a more potentially hazardous food?! A. Watermelon ! ! B. Bread ! ! C. Orange slices ! ! D. Lemon slices ! !! Question 6 of 20! 0.0/ 5.0 Points! Unpasteurized juice is MOST likely at risk for which of the following?! A. E. coli ! ! B. Botulism ! !

 

 

C. Spoilage ! ! D. Contaminants ! !! Question 7 of 20! 5.0/ 5.0 Points! A child who cannot concentrate, has low energy, poor self-esteem, and has a greater risk for diabetes, heart disease, and high blood pressure may not be getting enough of which of the following?! A. Sun ! ! B. Physical activity ! ! C. Breakfast !! D. Outside air ! !! Question 8 of 20! 5.0/ 5.0 Points! Protective factors in a child’s life include:! A. being uninsured and having inconsistent health care. ! ! B. a supportive, loving mother and consistently caring and responsible caregivers. ! ! C. biological determinants that impact children. ! ! D. aspects that suggest a child is high risk for disease. ! !! Question 9 of 20! 0.0/ 5.0 Points! Which of the following is included in proper care of an infant’s teeth?! A. Wiping the teeth and gums with a disposable tissue after each feeding. ! ! B. Providing milk after every feeding. ! ! C. Placing toothpaste on the teeth after each feeding. ! ! D. Encouraging an infant to suck on his/her pacifier after each feeding. ! !! Question 10 of 20! 0.0/ 5.0 Points! Which of the following foods is MOST likely to be contaminated with botulism?! A. Raw eggs !! B. Home-canned foods ! ! C. Sushi ! ! D. Potato salad at a picnic ! !! Question 11 of 20! 0.0/ 5.0 Points! Which ecological system does the following describe? The state passes a law that addresses health care for children.! A. Microsystems ! ! B. Macrosystems ! ! C. Exosystem ! ! D. Mesosystem ! !! Question 12 of 20! 5.0/ 5.0 Points! The greatest hazards to health are contaminants caused by:!

 

 

A. chemicals. ! ! B. microorganisms. ! ! C. physical hazards. ! ! D. insects. ! !! Question 13 of 20! 5.0/ 5.0 Points! When something hazardous to health is present in food or drink it is called:! A. contamination. ! ! B. pollution. ! ! C. impurities. ! ! D. infectivity. !!! Question 14 of 20! 5.0/ 5.0 Points! If ground beef is not cooked at a high enough temperature, which of the following should be the biggest concern?! A. Time and temperature factors ! ! B. Chemical hazards ! ! C. Physical hazards !! D. E. coli toxins ! !! Question 15 of 20! 0.0/ 5.0 Points! Learning the skills at a young age that promote wellness:! A. allows children to make their own healthy choices. ! ! B. positively affects children’s lifelong development. ! ! C. is difficult until the primary years. ! ! D. does not affect the possibility of developing obesity or diabetes. ! !! Question 16 of 20! 5.0/ 5.0 Points! Which of the following is a recommended practice for destroying the microorganisms causing E- Coli?! A. Cook foods to appropriate temperatures before serving. ! ! B. Wash fruits and vegetables thoroughly. ! ! C. Pay attention to food expiration dates. ! ! D. Serve only Grade A meat. ! !! Question 17 of 20! 5.0/ 5.0 Points! Which of the following is a chemical agent that can end up in food and pose a health risk?! A. Metal shavings ! ! B. Germs ! ! C. Pesticides ! ! D. Mold ! !! Question 18 of 20! 0.0/ 5.0 Points!

 

 

Which ecological system does the following describe? The teacher of a child with diabetes communicates with the parents about the child’s needs.! A. Microsystems ! ! B. Macrosystems ! ! C. Exosystem ! ! D. Mesosystem ! !! Question 19 of 20! 0.0/ 5.0 Points! Which of the following is the MOST effective way to decrease the incidence of foodborne illness?! A. Using a hair net ! ! B. Covering foods when they are not being consumed ! ! C. Hand washing ! ! D. Using appropriate food-service tools ! !! Question 20 of 20! 0.0/ 5.0 Points! Which of the following is MOST likely determined by lifestyle choices?! A. Health ! ! B. Wellness ! ! C. Acute conditions ! ! D. Congenital conditions ! !!! ! !

Exercise 4-12 Target Profit And Break-Even Analysis

Exercise 4-12 Target Profit and Break-Even Analysis; Margin of Safety; CM Ratio [LO1, LO3, LO5, LO6, LO7]
Exercise 4-12 Target Profit and Break-Even Analysis; Margin of Safety; CM Ratio [LO1, LO3, LO5, LO6, LO7]

Menlo Company distributes a single product. The company’s sales and expenses for last month follow:

Total Per Unit
Sales $1,092,000   $70
Variable expenses 764,400   49
Contribution margin 327,600   $21
Fixed expenses 264,600
Net operating income $63,000
________________________________________

Requirement 1:
What is the monthly break-even point in units sold and in sales dollars? (Omit the “$” sign in your response.)

Requirement 2:
Without resorting to computations, what is the total contribution margin at the break-even point? (Omit the “$” sign in your response.)
Requirement 3:
How many units would have to be sold each month to earn a target profit of $96,600? Use the formula method.

Units sold  units

Requirement 4:
Refer to the original data. Compute the company’s margin of safety in both dollar and percentage terms. (Round your percentage value to 2 decimal places. Omit the “$” and “%” signs in your response.)

Dollars Percentage
Margin of safety $
%

________________________________________

Requirement 5:
What is the company’s CM ratio? If sales increase by $91,000 and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase?(Omit the “$” and “%” signs in your response.)

CM ratio  %

Increased net operating income $

 

Problem 4-31 Changes in Fixed and Variable Costs; Target Profit and Break-Even Analysis [LO4, LO5, LO6]

Neptune Company produces toys and other items for use in beach and resort areas. A small, inflatable toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $2.9 per unit. Enough capacity exists in the company’s plant to produce 30,900 units of the toy each month. Variable costs to manufacture and sell one unit would be $1.84, and fixed costs associated with the toy would total $48,631 per month.

The company’s Marketing Department predicts that demand for the new toy will exceed the 30,900 units that the company is able to produce. Additional manufacturing space can be rented from another company at a fixed cost of $2,432 per month. Variable costs in the rented facility would total $2.03 per unit, due to somewhat less efficient operations than in the main plant.

Requirement 1:

(a)   Calculate the contribution margin per unit on anything over 30,900 units. (Round your answer to 2 decimal places. Omit the “$” sign in your response.)

Contribution margin $

(b)   Compute the total fixed costs to be covered if more than 30,900 units are produced. (Omit the “$” sign in your response)

Total fixed costs to be covered by remaining sales $

(c)   Compute the monthly break-even point for the new toy in units and in total sales dollars. (Round your answers to the nearest whole number. Omit the “$” sign in your response.)

Monthly break-even point in unit sales  units

Monthly break-even point in dollar sales $

________________________________________

Requirement 2:
How many units must be sold each month to make a monthly profit of $10,962?

Units to be sold  units

Requirement 3:
If the sales manager receives a bonus of 20 cents for each unit sold in excess of the break-even point, how many units must be sold each month to earn a return of 21% on the monthly investment in fixed costs? (Round your answer to the nearest whole number.)

Total units to be sold  units

 

Problem 6-15 Comprehensive Problem with Labor Fixed [LO1, LO2, LO3, LO4]
[The following information applies to the questions displayed below.]
Far North Telecom, Ltd., of Ontario, has organized a new division to manufacture and sell specialty cellular telephones. The division’s monthly costs are shown below:

Manufacturing costs:
Variable costs per unit:
Direct materials $88
Variable manufacturing overhead $3
Fixed manufacturing overhead costs (total) $220,400
Selling and administrative costs:
Variable 12% of sales
Fixed (total) $163,000
________________________________________

Far North Telecom regards all of its workers as full-time employees and the company has a long-standing no layoff policy. Furthermore, production is highly automated. Accordingly, the company includes its labor costs in its fixed manufacturing overhead. The cellular phones sell for $330 each. During September, the first month of operations, the following activity was recorded:

Units produced 3,800
Units sold 3,000
________________________________________

rev: 02-09-2011
references
Section Break Problem 6-15 Comprehensive Problem with Labor Fixed [LO1, LO2, LO3, LO4]

 

1.
value:
20.00 points

Problem 6-15 Requirement 1

Requirement 1:
(a) Compute the unit product cost under Absorption costing. (Omit the “$” sign in your response.)

Unit product cost $

(b) Compute the unit product cost under Variable costing. (Omit the “$” sign in your response.)

Unit product cost $

2.
value:
20.00 points

Problem 6-15 Requirement 2

Requirement 2:
Prepare an absorption costing income statement for September.(Input all amounts as positive values. Omit the “$” sign in your response.)

Requirement 3:
Prepare a contribution format income statement for September using variable costing. (Input all amounts as positive values except net operating loss which should be indicated by a minus sign. Omit the “$” sign in your response.)

Requirement 4:
Assume that the company must obtain additional financing in order to continue operations. As a member of top management, would you prefer to rely on the statement in (2) above or in (3) above when meeting with a group of prospective investors?

rev: 02-09-2011

Absorption costing statement

Variable costing statement
Requirement 5:
Reconcile the absorption costing and variable costing net operating incomes in requirement 2 and 3 above. (Negative amounts should be indicated by a minus sign. Omit the “$” sign in your response.)

$      : Fixed manufacturing overhead cost deferred

 

 

Financial Policy

Approved Logo 1 Sept 2013

 

 

 

 

 

BNFN 4304 – Financial Policy

Mr. Masood Aijazi

Case 28: University of Virginia Health System: The Long-Term Acute Care Hospital Project

Spring Semester 2017 – 2018

Authored By

Maryam Barifah 1420023

Nour Abdulaziz 1420149

Shrouq Al-Jaaidi               1420072

Balqees Mekhlafi 1420231

 

 

 

Submission Date

15/04/2018

 

 

Case Assignment

UNIVERSITY OF VIRGINIA HEALTH SYSTEM:

THE LONG-TERM ACUTE CARE HOSPITAL PROJECT

Pages 381-390

 

Idea of the case

This case puts students in the shoes of Larry Fitzgerald, the vice president for business development and finance at the University of Virginia Health System (UVa Health System). Students must decide, based on cash flow analysis and nonfinancial factors, whether or not to propose a long-term acute care hospital (LTAC) project to the board of directors of the U.Va. Health System. The LTAC is a very promising undertaking from the perspective of providing better care for patients, but the financial drivers of the project have yet to be assessed.

 

The primary objective in this case is to portray the major differences in project analysis for nonprofit organizations compared to for-profit companies and to highlight the unique issues relevant in a health care environment.

 

 

Questions

 

1. What are the nonfinancial drivers for adding an LTAC facility to the U.Va. Health System? What are potential reasons the board may not approve the project from a nonfinancial standpoint?

Hints: You can provide points from the case as to why the LTAC facility would be a good addition to the U.Va. Health System from the perspective of the hospital, the patient, and overall health care.

Students could suggest several reasons the board may not approve the project

2. What are the differences between nonprofit institutions and for-profit institutions? For example, how would a for-profit hospital approach the LTAC decision?

3. What is the average cost of capital of the for-profit hospitals provided in case Exhibit 3? Would this serve as a reasonable discount rate to analyze a set of for-profit LTAC facility cash flows? Should Fitzgerald use this number to discount the U.Va. LTAC facility’s cash flows?

Hints: Use a market risk premium (MRP) of 6% and the 10-year Treasury yield as the risk-free rate.

Use the data provided in Exhibit 4 page 390.

Determine the WACC in two cases: tax rate = 35% and tax rate = 0.

4. Using the information in the case and the memo from Karen Mulroney in case Exhibit 1, complete the cash flow projections in the spreadsheet provided. What do you get for the NPV and IRR of those cash flows?

5. What are the main drivers for NPV and IRR? Show the impact on NPV and IRR by changing a couple of these drivers to a “downside scenario” value.

Based on your financial analysis, should Fitzgerald propose the LTAC project in the board meeting.

 

 

Supporting Spreadsheet Data

 

The supporting Excel files are available for the convenience of students:

 

Q1. What are the nonfinancial drivers for adding an LTAC facility to the U.Va. Health System? What are potential reasons the board may not approve the project from a non-financial standpoint?

LTAC will benefit U.V.A in many areas such as; adding up to 25 beds per day for each transferred patient, boost money for patient care, work through matters that oppose many of the hospital systems, improve efficient patient turnover, addressing the bill insurance from both hospital stay and time spent in the LTAC. Moreover, it will be built within the U.Va On January 2007, the Centers of the Medicare and Medicaid services (CMS) halts the establishments of the facility. For them to build the facility they will need to have a loan of $15 million capital investment and the board want to acquire 5% profit margin.

Non-financial drivers for adding an LTAC:

-The LTAC hospitals are attractive financially as they increase revenues from patients who are taken care of by the system. Moreover, the hospital was paid insurance for patients staying regardless the time patients spent. This would allow the hospital to bill the insurance for both services of LTAC service and time spent in hospital. The addition of LTAC benefits the hospital in the reduction of expenses and capacity concerns.

– The hospital would be able to decrease the average expenses of a patient’s stay up to 50% from $3000 to $1500.

– adding an LTAC will increase capacity of beds in the rate of 25 beds per day due to the process of transferring the patients to the LTAC thus providing space for new admissions n the main hospital.

-LTAC patients are taken of more conscious way due to their circumstances; therefore they receive higher care and morale compared to a regular hospital. This allows a faster recovery period and reduced infection rate. Each patient has his own room that made them more comfortable at their stay. They became proverbial with their caregivers due to their long stay. This built a sense of comfort friendly environment. The personalized care made patients recover faster.

– This addition adds up to the objectives and goals of the hospital of providing highest quality health and continuum care. This is due to the higher quality care that would be offered compared to the service offered at a tradition al hospital.

Reasons for board disapproval:

cost of the project: the cost would be the $15 million loan. it is vital to evaluate the hospital’s financial state via its bond rating to cover their financial commitments. This is due to the inverse relation between the ratings and cost of debt, as the lower the rating the higher the cost of debt. When it comes to valuating the project, the board’s main objective is to maintain the rating of AA. Moreover, retaining this credit rating allowed the hospital to maintain a low borrowing cost and to compete effectually for debt dollars in future.

low utilization rate: it is expected for the LTAC facilities to have an increase in capacity to 26% in the upcoming year till the Medicare Certification is approved. Moreover, the usage of facility is essential for maintaining the hospital and for matching it with the costs of the project.

– Hospital’s reputation: in the case of the patient’s increased reside time for more than the 25 days, would concern and worry patients that the hospital may not extend their time. Therefore, the hospital’s reputation may be imperiled.

Gross Profit Margin– the board wants to achieve a 5% profit margin within the star up of the project, and this may not reach it and thus they may not be able to cover their costs.

 

Question 2: What are the differences between nonprofit institutions and for-profit institutions? For example, how would a for-profit hospital approach the LTAC decision?

A nonprofit institution is more advantageous than the for-profit institution because they do not respond to shareholders as its objectives are focust on stakeholders’ interests and not the goals of its owners.

Difference between Non-profits and For-profits institutions:

Non-profits:

· The institutional culture is service-driven.

· There is no tax burden; however they should cover the borrowing cost.

· Requires a low margin while managing to meet the objectives of providing clinical care. They need to maintain the bond rating at the investment rate.

· Funded by the government, private sector, or corporations that have a CSR policy.

· Non-profit hospitals’ main priority is the heath and not the profits. This improves the society overall.

· They are less likely to generate profits from operations.

· Aims towards the overall well-being of the society by supporting the poor and unprivileged.

For-profits:

· The institutional culture is business-driven.

· There is property and income taxes. They must cover tax expenses and the equity cost of capital.

· Requires a pre-tax profit margin of 15% for a capital investment.

· As any other business, expansion and growth is a strategic objective.

· Their main intention is generating profits, which harms the society indirectly.

· The main purpose is to add value and generate a return for shareholders. They need to meet the investors’ expectations.

· Aims towards the highest quality of services and products to customers in the market, especially for niche members.

For-profit hospital approach to the LTAC Decision

Since the For-profit institutions’ main purpose is to generate profits, increase shareholder value and to increase the quality, the LTAC is a great opportunity as they would add more beds, increase the revenue, and decrease the costs associated with treatments. Moreover, the hospital would be able to increase the capacity of patients in rolled into the hospital. The critical cases would be transferred to the LTAC facility as a critical patient takes more than 25 days to recover while a normal patient takes an average of 5 days to recover. Thus, for-profit hospitals should approach the LTAC facility as that would add overall value to their organization. Furthermore, the LTAC has beneficial financial drivers. The hospital could charge the insurance company for their services; and if the patient is to be transferred to the LTAC, then they could bill for the special treatment provided to the patient during his stay.

 

In order to know how much profits the LTAC must earn to be accepted, we must have a positive NPV that is greater than zero. That would cover all the expenses, as well as give a sufficient ROE. NPV is calculated based on cost of capital upon which both the cost of debt and equity reflect. Other financials that would support the board of directors’ decision would be the projected cash flows, net present value, internal rate of return and the payback period. Through using the WACC, it has been indicated that the NPV is positive, and so the nonprofit entity should rest assured that the investment is creating value. Finally, if the investment meets the for-profit required return, it should easily meet all the financial requirements of a non-profit.

 

Q3. What is the average cost of capital of the for-profit hospitals provided in case Exhibit 3? Would this serve as a reasonable discount rate to analyze a set of for-profit LTAC facility cash flows? Should Fitzgerald use this number to discount the U.V.A. LTAC facility’s cash flows?

Hints: Use a market risk premium (MRP) of 6% and the 10-year Treasury yield as the risk-free rate.

Use the data provided in Exhibit 4 page 390.

Determine the WACC in two cases: tax rate = 35% and tax rate = 0.

 

The weighted average cost of capital (WACC) is defined as the cost of the individual sources of capital. The make-up of capital is usually comprised of the equity that shareholders have decided to invest in the company, with each source being proportionally weighted individually. By calculating the WACC shareholders or lenders would will be able to appropriately estimate the return that would be earned if and when they decide to invest in the company. So, the WACC (Weighted Average Cost of Capital) can also be defined as the minimum rate of return that investors will expect to get from their investment. It is the lowest rate of return that a firm will have to earn in order to achieve a breakeven point.

 

The data that will be provided in the excel sheet in Exhibit 3 shows that the cost of capital, and cost of debt were calculated in order to get the WACC for the for-profit hospitals. By viewing WACC sheet in the attached excel one can see the summary of the WACC calculations for each for-profit healthcare company.

The steps that will be used to calculate the WACC are shown in the excel sheet, but they are also listed below:

Steps for WACC calculation as seen in the excel sheet:

· The formula used is:

Weighted Average Cost of Capital (WACC)= Wd x Rd x (1-T) + We x Re

Where: Wd= weight of debt Rd= cost of debt We= weight of equity

Re= cost of equity T= tax rate

· To calculate the WACC the first step that needs to be taken is for us to calculate the percentage of debt (Wd) in the capital structure, this is done by using this formula: Debt/ (Debt + Market Capitalization).

· The percentage of equity (We) should also be taken into consideration this is done by subtracting the percentage of debt calculated in step 1 from 1 (1-Wd or % debt).

· Calculating the cost of debt (Rd) comes next, where the corporate bond yields from Exhibit 4 (US Treasuries and Corporate Bond Yields) were used for the A, B, and BB ratings.

· The cost of equity (Re) is calculated by using the CAPM (Capital Asset Pricing Model) formula: Rf + Beta * Rm, using the risk-free rate (Rf) as the 10-year Treasury Yield and a market risk premium (MRP, Rm) of 6% these numbers were taken from the excel sheet and from the hints above.

· The last calculation that needs to happen to determine the WACC from the above-mentioned formula is to see the effects on it using two different tax rates, tax=35% and tax=0%.

What is noticeable in the attached excel for the for-profit healthcare companies, the higher the rating of the bond, the lower the WACC is and vice versa. The lowest achieved WACC in a tax = 35% category is by HCA Inc. (6.97%), it carried a bond rating of A, a yield of 5.45% and a beta of 0.60. The highest achieved WACC when using the same tax rate is by Manor Care Company (8.42%) which had a BB rating, a 6.79% yield and a 0.80 beta. When using a tax rate of 0% to calculate WACC it will show the same results were achieved, with HCA Inc. with the lowest WACC (7.51%) and the highest WACC with Manor Care (8.93%), this shows that the most important factors when calculating the WACC are cost of debt, beta and tax bracket.

Cost of debt, one of the three components, is considered to be the most important. This is due to the increase in the shareholder’s concern, since the investors have a belief that the greater the amount of debt a company has, the greater the risk of a default. This will result in a greater return on investment expectation from investors. Beta is also considered to be an important component as it will measure the covariance between the rate of return of a particular company and the systematic risk (overall market return). Lastly, tax bracket also contributes to the WACC as that means that the lower the tax the greater the WACC and vice versa.

 

The WACC that are calculated in the excel sheet would be able to serve as a reasonable discount rate to analyze the for-profit LTAC facility cash flows. In addition, this rate can be used by Fitzgerald to discount the University of Virginia Hospital LTAC facilities’ cash flows even though they are both different in nature as UVA being a non-profit hospital. The WACC that should be the most appropriate to use is the average of all the for-profit healthcare companies, so the assumption will be that UVA will operate like a for-profit. So, for the valuation and forecasts purposes, the average WACC for a tax rate of 0% is 8.21%; the reason for this specific tax rate is since UVA is a non-profit they will not pay any taxes. When comparing UVA to different healthcare service providers, HCA Inc. will be considered to be the most comparable company since they have an A bond rating and University of Virginia Hospital has an AA bond rating.

 

Q4. Using the information in the case and the memo from Karen Mulroney in case Exhibit 1, complete the cash flow projections in the spreadsheet provided. What do you get for the NPV and IRR of those cash flows?

To calculate the Net Present Value (NPV), we should calculate first the difference between the present value of cash inflows and cash outflows. The NPV is used to analyze the profitability of an investment or project.

The formula for NPV is:

The Ct in this case represents the net cash inflow, the Co represents the total initial investment costs, the r represents the discount rate, and the t represents the number of time periods. The NPV that is calculated gave a total of ($15,124.13), which is a positive number, what this number indicates is that their earnings exceed their costs, this means that their project is profitable.

In addition, the Internal Rate of Return (IRR) is the discount rate that will depend of the NPV calculations of all cash flows, this is used to measure the profitability of investments. The IRR that was found after calculation is (22.67%) and this will be used to rank the multiple projects of the firm.

· For the financial projections, the first step taken was to compute the number of patients each year for insurance payers. The total number of patients was then multiplied by the patient mix percentages. The following step was to multiply the number of patients by each insurance payer’s billing rate per patient. The last step in this process is to deduct the (1%) uncollectible billings from the revenues.

 

· Second, the total expenses were calculated which includes the salaries, wages and benefits, supplies, management fees, fixed and variable operating expenses, land leases and construction. For the salaries, wages, and benefits expenses were calculated by multiplying the full-time employees by the patient days per year. The supplies, drugs, food and management fees were calculated by multiplying the net revenue by the percentage of the net revenue.

· The second calculation to be done is, the total expenses were calculated which includes the salaries, wages, benefits, supplies, management fees, fixed and variable operating expenses land leases and construction. To calculate salaries, wages and benefits expenses this was done by multiplying the full-time employees by patient days per patient days per year. The supplies, drugs, food and management fees were calculated by multiplying the net revenue by the percentage of the net revenue. Operating expenses are an annual fixed charge of $1.2 million. Land lease is 200,000 and divided by 1000 then after the first year then will be an annual increase of 3%. Moreover, the cost of the construction of the building was depreciated by 30 years of the 15,000,000.

· Then the operating profit and operating margin was calculated. The operating profit was then calculated by deducting the expenses from the revenues. For the operating margin, the operating profit was divided by the total revenue.

· The next calculation there is a change in net working capital, this change was calculated by calculating the account receivables, inventories and account payable. The Net Working Capital = current assets – current liabilities which in this case is ((AR + Inventories) – AP).

· Free cash flows is measured by adding the operating profit with deprectiation, deducting the capital expenditure and the net working capital. Then to compute the NPV of the cash flows, the addition of the Net Working Capital Recovery and the Sale of Facility at book value is done.

· NPV is ($15,124.13) and IRR is (22.67%)

· All these steps for calculations are shown in the excel sheet.

 

Q5. What are the main drivers for NPV and IRR? Show the impact on NPV and IRR by changing a couple of these drivers to a “downside scenario” value?

For us to comprehend the main drivers for IRR and NPV we will have to examine the values that greatly affect the hospital’s cash flow. Most of the profits earned is from admitted patients, and the amount of capacity they use on patient days. So therefore one of the main drivers of the IRR and NPV is from utilization rate. If we considered the worst case scenario for the utilization rate in the second year is 45% , according to Mulroney’s memo exhibit. However, the growth rate that relates to the utilization rate