Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Case study on capital structure with solution

22/10/2021 Client: muhammad11 Deadline: 2 Day

Healthcare Finance.

CASE17
CASE 19 Instructor Version Copyright 2014 Health Administration Press
11/26/14
RN TEMPS, INC.
Capital Structure Analysis
This case illustrates the capital structure decision for a firm that begins with zero debt
financing.
The spreadsheet consists of two separate models:
1) Debt amount and ROE (Rows 35-43) uses income statements to examine the
effects of financial leverage on ROE. This model uses a single (constant)
interest rate input for all capital structure scenarios.
2) Debt amount and Stock Price / CCC (Rows 45-56) examines the effects of debt financing
on firm value, cost of capital, and stock price, assuming zero growth (perpetual cash flows.)
The model consists of a complete base case analysis--no changes need to be made
to the existing MODEL-GENERATED DATA section. However, all values in the INPUT DATA
section of the student version have been replaced with zeros. Thus, students must determine
the appropriate input values and enter them into the model. These cells are colored red.
When this is done, any error cells will be corrected and the base case solution will appear.
Note that the model does not contain any risk analyses, so students will have to create
their own if required by the case. Furthermore, students must create their own graphics
(charts) as needed to present their results.
The instructor version of the model contains a sheet (Figure 1) that plots both stock price
and cost of capital versus the dollar amount of debt financing. It also contains sheets that
contain the inputs and outputs for the increased and decreased business risk scenarios.
INPUT DATA: KEY OUTPUT:
Tax rate 40.0%
Debt Amount and ROE Input: Debt Amount and ROE Analysis:
Market value $12,000,000 Expected
Cost of debt 10.0% ROE SD of ROE
All Equity 15.0% 1.8%
Probability EBIT 25% Debt 18.0% 2.4%
0.25 $2,500,000 50% Debt 24.0% 3.5%
0.5 $3,000,000 75% Debt 42.0% 7.1%
0.25 $3,500,000
Debt Amount and Stock Price / CCC Input: Debt Amount and Stock Price / CCC Analysis:
EBIT $3,000,000
No. of shares 10,000,000
Debt Amount Cost of Debt Cost of Equity Debt Amount Stock Price CCC
$0 0.0% 15.0% $0 $1.200 15.0%
2,500,000 10.0% 15.5% 2,500,000 $1.315 13.7%
5,000,000 11.0% 16.5% 5,000,000 $1.391 12.9%
7,500,000 13.0% 18.0% 7,500,000 $1.425 12.6%
10,000,000 16.0% 20.0% 10,000,000 $1.420 12.7%
12,500,000 20.0% 25.0% 12,500,000 $1.370 13.1%
MODEL-GENERATED DATA:
Debt and ROE Analysis:
All Equity 25% Debt
Probability 0.25 0.50 0.25 0.25 0.50 0.25
EBIT $2,500,000 $3,000,000 $3,500,000 $2,500,000 $3,000,000 $3,500,000
Interest 0 0 0 300,000 300,000 300,000
EBT $2,500,000 $3,000,000 $3,500,000 $2,200,000 $2,700,000 $3,200,000
Taxes 1,000,000 1,200,000 1,400,000 880,000 1,080,000 1,280,000
Net Income $1,500,000 $1,800,000 $2,100,000 $1,320,000 $1,620,000 $1,920,000
ROE 12.5% 15.0% 17.5% 14.7% 18.0% 21.3%
TIE Ratio n.a. n.a. n.a. 8.33 10.00 11.67
E(ROE) 15.0% 18.0%
Std dev of ROE 1.8% 2.4%
Coefficient of variation 0.12 0.13
50% Debt 75% Debt
Probability 0.25 0.50 0.25 0.25 0.50 0.25
EBIT $2,500,000 $3,000,000 $3,500,000 $2,500,000 $3,000,000 $3,500,000
Interest 600,000 600,000 600,000 900,000 900,000 900,000
EBT $1,900,000 $2,400,000 $2,900,000 $1,600,000 $2,100,000 $2,600,000
Taxes 760,000 960,000 1,160,000 640,000 840,000 1,040,000
Net Income $1,140,000 $1,440,000 $1,740,000 $960,000 $1,260,000 $1,560,000
ROE 19.0% 24.0% 29.0% 32.0% 42.0% 52.0%
TIE Ratio 4.17 5.00 5.83 2.78 3.33 3.89
E(ROE) 24.0% 42.0%
Std dev of ROE 3.5% 7.1%
Coefficient of variation 0.15 0.17
Debt Amount and Stock Price / CCC Analysis:
Market Value Market Value Total Stock Number of Earnings per
of Debt of Equity Value Debt Ratio Price CCC Shares Share (EPS)
$0 $12,000,000 $12,000,000 0.0% $1.200 15.0% 10,000,000 $0.18
2,500,000 10,645,161 13,145,161 19.0% 1.315 13.7% 8,098,160 $0.20
5,000,000 8,909,091 13,909,091 35.9% 1.391 12.9% 6,405,229 $0.23
7,500,000 6,750,000 14,250,000 52.6% 1.425 12.6% 4,736,842 $0.26
10,000,000 4,200,000 14,200,000 70.4% 1.420 12.7% 2,957,746 $0.28
12,500,000 1,200,000 13,700,000 91.2% 1.370 13.1% 875,912 $0.34
Optimal Debt Level = $7,500,000
END
Figure1
STOCK PRICE AND COST OF CAPITAL

1.2 1.3145161290322582 1.3909090909090909 1.425 1.42 1.37 0.15 0.13693251533742332 0.12941176470588234 0.12631578947368421 0.12676056338028169 0.13138686131386862
Amount of Debt ($)

Increased Business Risk
CASE 17 Instructor Version (Increased Business Risk) Copyright 2014
By FACHE
RN TEMP SERVICES, INC.
Capital Structure Decisions
This sheet contains the increased business risk scenario valuation.
INPUT DATA: KEY OUTPUT:
Debt Amount and ROE Input: Debt Amount and ROE Analysis:
Total value $12,000,000 Debt Amount Stock Price CCC
Cost of debt 12.0% $0 $1.13 16.0%
EBIT $3,000,000 2,500,000 1.21 14.9%
Tax rate 40.0% 5,000,000 1.24 14.5%
No. of shares 10,000,000 7,500,000 1.24 14.5%
10,000,000 1.23 14.6%
12,500,000 1.23 14.7%
Debt Amount and Stock Price / CCC Input:
Debt Amount Cost of Debt
$0 0.0%
2,500,000 11.0%
5,000,000 13.0%
7,500,000 16.0%
10,000,000 20.0%
12,500,000 25.0%
Debt Amount Cost of Equity
$0 16.0%
2,500,000 17.0%
5,000,000 19.0%
7,500,000 22.0%
10,000,000 26.0%
12,500,000 31.0%
MODEL-GENERATED DATA:
Debt Amount and Stock Price / CCC Analysis:
Market Value Market Value Total Stock Number of Earnings per
of Debt of Equity Value Debt Ratio Price CCC Shares Share (EPS)
$0 $11,250,000 $11,250,000 0.0% $1.125 16.0% 10,000,000 $0.18
2,500,000 9,617,647 12,117,647 20.6% 1.212 14.9% 7,936,893 0.21
5,000,000 7,421,053 12,421,053 40.3% 1.242 14.5% 5,974,576 0.24
7,500,000 4,909,091 12,409,091 60.4% 1.241 14.5% 3,956,044 0.27
10,000,000 2,307,692 12,307,692 81.3% 1.231 14.6% 1,875,000 0.32
12,500,000 (241,935) 12,258,065 102.0% 1.226 14.7% (197,368) 0.38
Optimal Debt Level: $5,000,000
END
Decreased Business Risk
CASE 17 Instructor Version (Decreased Business Risk) Copyright 2014
By FACHE
RN TEMPS SERVICES, INC.
Capital Structure Decisions
This sheet contains the decreased business risk scenario valuation.
INPUT DATA: KEY OUTPUT:
Debt Amount and ROE Input: Debt Amount and ROE Analysis:
Total value $12,000,000 Debt Amount Stock Price CCC
Cost of debt 12.0% $0 $1.29 14.0%
EBIT $3,000,000 2,500,000 1.41 12.7%
Tax rate 40.0% 5,000,000 1.51 11.9%
No. of shares 10,000,000 7,500,000 1.58 11.4%
10,000,000 1.60 11.3%
12,500,000 1.57 11.5%
Debt Amount and Stock Price / CCC Analysis:
Debt Amount Cost of Debt
$0 0.0%
2,500,000 9.0%
5,000,000 9.5%
7,500,000 10.5%
10,000,000 12.5%
12,500,000 15.5%
Debt Amount Cost of Equity
$0 14.0%
2,500,000 14.3%
5,000,000 15.0%
7,500,000 16.0%
10,000,000 17.5%
12,500,000 20.0%
MODEL-GENERATED DATA:
Debt Amount and Stock Price / CCC Analysis:
Market Value Market Value Total Stock Number of Earnings per
of Debt of Equity Value Debt Ratio Price CCC Shares Share (EPS)
$0 $12,857,143 $12,857,143 0.0% $1.286 14.0% 10,000,000 $0.18
2,500,000 11,643,357 14,143,357 17.7% 1.414 12.7% 8,232,386 0.20
5,000,000 10,100,000 15,100,000 33.1% 1.510 11.9% 6,688,742 0.23
7,500,000 8,296,875 15,796,875 47.5% 1.580 11.4% 5,252,226 0.25
10,000,000 6,000,000 16,000,000 62.5% 1.600 11.3% 3,750,000 0.28
12,500,000 3,187,500 15,687,500 79.7% 1.569 11.5% 2,031,873 0.31
Optimal Debt Level: $10,000,000

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Premium Solutions
Top Class Engineers
Financial Assignments
Assignment Hut
Phd Writer
Top Grade Tutor
Writer Writer Name Offer Chat
Premium Solutions

ONLINE

Premium Solutions

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$39 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$15 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$41 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$22 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$44 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$22 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Reading and Essay - Examiner newspaper death notices launceston - Assignment 3: Sarbanes-Oxley Act (SOX) and ERP Solution - Stage 1 pdhpe units of work - Concept analysis in regards to substance abuse - Ideal gas law lab answer key - Week - National Patient Safety Goals 250 words with references. Only bids that can complete in 3 hours. - Lds self reliance invitation - Borgwarner it services europe gmbh - Alternate form reliability definition - Intrapersonal communication in nursing - Charges and electric potential mastering physics - Fore research and management aum - Dyson market oriented mission statement - Mylabsplus angelina - Bacha meaning in arabic - Marriott corporation the cost of capital solution xls - Hyattsville volunteer fire department - Discussion - Which is better controlled access or contention explain - Cpt reflection 09/29 - Plant cell rap lyrics - The wave study guide answers - Ted bundy case study - The case for short words - Course name: Information Governance - Mensa entry level iq - Bathroom floor slope to drain in australia - Harmonic analysis in matlab - Organization Economics - Paul durcan father's day - Excel chapter 4 grader project homework - What is the theme of the story the boarded window - Spelling connections grade 8 unit 1 answers - Linear regression project ideas - Discussion #3 - Fayol classical management theory - Sum of products canonical form - Sentinel event definition medical - Which property is 6 0 - AP Macroeconomics - What are the effects of muscle stretching on injury incidence? - Compare summer and winter - Https lc ugrad1 gcu edu - Writing assignment - Computer ethics exam questions and answers - An american childhood questions - The drinking water needs of an office - Competency based recruitment and selection ppt - Mr clean mother's day ad - Target milk and honey soap - Discussion - Independent project 4 5 excel 2016 - Cloud computing - Three input components of the congruence model - Week 3 - Gateshead gov uk building development planning applications - Marketing as strategy nirmalya kumar pdf - 21 39 melbourne street north adelaide south australia - The __________ on packages were intended to improve inventory control for businesses. - Loose stock dyeing machine - Safe harbor provisions under hipaa - Body's chemical system crossword clue - Bsbmgt502 task 1 answers - Components of a unit of competency - 2x 10 3x2 10x 2x3 3x2 - Need responses to two discussion question 150 words min with reference if needed - Michael kors target audience - Homework 5 - Swinburne online semester dates - Dr. vasant lad secrets of the pulse pdf - Wish you well questions and answers - Mobil oil australia v wellcome international - Radioactive dating game lab answer key - Planting caladium bulbs upside down - PAD 520 Learning Activity: Monitoring Observed Policy Outcomes - Discussion - A christmas carol sparknotes - Gm 5.7 lg sgi 638 - In our courts when it's a white man - Research Paper - Case study on corporate social responsibility with questions - Love Problem Solution In mumbai +917657874622 - Lablink covance - Paper on pediatrics class - Taking the lead lln - Carlsberg organizational structure - Experiment 4 paper chromatography answers - Explain the technical technique for forecasting exchange rates - Johnny depp life's too short bloopers - Probation and Parole 1 discussion - Bus wiring - Snap fitness equipment for sale - Australian police rugby union - Ecstasy of fumbling meaning - Case Analysis - What is the basic economic problem - Nursing reserach - Buried in treasures support group - 1st the worst rhyme