From the below Excel, please analyze the: - Cost of Equity - Cost of Debt - Cost
Fantastic news! We've Found the answer you've been seeking!
Question:
From the below Excel, please analyze the:
- Cost of Equity
- Cost of Debt
- Cost of Capital
Transcribed Image Text:
40 41 Current beta- 1.47 42 Current Debt= $679,106 43 Tax rate= 24.45% 44 Enterprise value = $686,635 15 46 |D/(D+E) 47 D/E Current Equity Current EBITDA= $9,059 $1,228 Current Rating A- Current Depreciation= $426 Current Interest rate (Company)= 5.95% Current T.Bond rate= 3.79% Adjusted EBITDA = $1,228 WORKSHEET FOR ESTIMATING RATINGS/INTEREST RATES 0.00% 10.00% 20.00% 30.00% 40.00% 0.00% 11.11% 25.00% 42.86% 48 S Debt SO $68,816 $137,633 $206,449 49 Beta 0.03 0.03 0.03 0.04 66.67% $275,266 0.04 50.00% 100.00% 150.00% $344,082 $412,899 60.00% 70.00% 80.00% 90.00% 233.33% 400.00% 900.00% $481,715 $550,532 $619,348 0.05 0.06 0.09 0.13 0.26 50 Cost of Equity 3.93% 3.94% 3.96% 3.98% 4.02% 4.06% 4.13% 4.24% 4.47% 5.15% 51 % Drop in EBITDA 0.00% -40.00% -50.00% -50.00% -50.00% -50.00% -50.00% -50.00% -50.00% -50.00% 52 EBITDA $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 53 Depreciation $426 $426 $426 $426 $426 $426 $426 $426 $426 $426 54 EBIT $802 $802 $802 $802 $802 $802 $802 $802 $802 $802 55 Interest SO $3,475 $34,477 56 Taxable Income $802 ($2,673) 57 Tax $196 $106 ($33,675) $106 58 Net Income $606 59 (+)Deprec'n $426 $426 50 Funds from Op. $1,032 ($2,353) ($2,779) ($33,781) $426 ($33,355) $66,332 $88,443 $132,664 ($65,530) ($87,641) ($109,751) ($131,862) $106 $106 $106 $106 ($65,636) ($87,747) ($109,858) ($131,968) $426 $426 $426 $426 ($65,210) ($87,321) ($109,432) ($131,542) $110,554 $154,775 $176,886 $198,997 ($153,973) $106 ($154,079) $426 ($153,653) ($176,084) ($198,194) $106 $106 ($176,190) ($198,300) $426 $426 ($175,764) ($197,874) 51 52 Pre-tax Int. cov 00 0.23 0.02 0.01 0.01 0.01 0.01 0.01 0.00 0.00 63 Funds/Debt 00 -0.03 -0.24 -0.32 -0.32 -0.32 -0.32 -0.32 -0.32 -0.32 64 Likely Rating Aaa/AAA C2/C D2/D D2/D D2/D D2/D D2/D D2/D D2/D D2/D 55 Pre-tax cost of debt 5.05% 25.05% 32.13% 32.13% 32.13% 32.13% 32.13% 32.13% 32.13% 32.13% 66 Tax rate for debt (deduction constraint) 24.45% 2.59% 0.26% 0.14% 0.10% 0.08% 0.07% 0.06% 0.05% 0.05% 67 Tax rate for debt tax benefits (Interest limits 24.45% 5.64% 0.57% 0.30% 0.22% 0.18% 0.15% 0.13% 0.11% 0.10% 58 Tax rate to use in after-tax cost of debt 24.45% 2.59% 0.26% 0.14% 0.10% 0.08% 0.07% 0.06% 0.05% 0.05% 69 COST OF CAPITAL CALCULATIONS 70 D/(D+E) 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 90.00% 71 D/E 72 S Debt 73 Cost of equity 0.00% 11.11% 25.00% 42.86% 66.67% 100.00% 150.00% 233.33% 400.00% 900.00% SO $68,816 $137,633 $206,449 $275,266 $344,082 $412,899 $481,715 $550,532 $619,348 3.93% 3.94% 3.96% 3.98% 4.02% 4.06% 4.13% 4.24% 4.47% 5.15% 74 Cost of debt 3.82% 24.40% 32.05% 32.09% 32.10% 32.10% 32.11% 32.11% 32.11% 32.12% 75 Cost of Capital 3.93% 5.99% 9.58% 12.41% 15.25% 18.08% 20.92% 23.75% 26.58% 29.42% 76 1 0 0 0 0 0 0 0 0 0 7 Value (perpetual growth) $4,033,203 $249,706 $94,784 $63,599 $47,869 $38,378 $32,027 $27,480 $24,064 $21,403 78 40 41 Current beta- 1.47 42 Current Debt= $679,106 43 Tax rate= 24.45% 44 Enterprise value = $686,635 15 46 |D/(D+E) 47 D/E Current Equity Current EBITDA= $9,059 $1,228 Current Rating A- Current Depreciation= $426 Current Interest rate (Company)= 5.95% Current T.Bond rate= 3.79% Adjusted EBITDA = $1,228 WORKSHEET FOR ESTIMATING RATINGS/INTEREST RATES 0.00% 10.00% 20.00% 30.00% 40.00% 0.00% 11.11% 25.00% 42.86% 48 S Debt SO $68,816 $137,633 $206,449 49 Beta 0.03 0.03 0.03 0.04 66.67% $275,266 0.04 50.00% 100.00% 150.00% $344,082 $412,899 60.00% 70.00% 80.00% 90.00% 233.33% 400.00% 900.00% $481,715 $550,532 $619,348 0.05 0.06 0.09 0.13 0.26 50 Cost of Equity 3.93% 3.94% 3.96% 3.98% 4.02% 4.06% 4.13% 4.24% 4.47% 5.15% 51 % Drop in EBITDA 0.00% -40.00% -50.00% -50.00% -50.00% -50.00% -50.00% -50.00% -50.00% -50.00% 52 EBITDA $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 $1,228 53 Depreciation $426 $426 $426 $426 $426 $426 $426 $426 $426 $426 54 EBIT $802 $802 $802 $802 $802 $802 $802 $802 $802 $802 55 Interest SO $3,475 $34,477 56 Taxable Income $802 ($2,673) 57 Tax $196 $106 ($33,675) $106 58 Net Income $606 59 (+)Deprec'n $426 $426 50 Funds from Op. $1,032 ($2,353) ($2,779) ($33,781) $426 ($33,355) $66,332 $88,443 $132,664 ($65,530) ($87,641) ($109,751) ($131,862) $106 $106 $106 $106 ($65,636) ($87,747) ($109,858) ($131,968) $426 $426 $426 $426 ($65,210) ($87,321) ($109,432) ($131,542) $110,554 $154,775 $176,886 $198,997 ($153,973) $106 ($154,079) $426 ($153,653) ($176,084) ($198,194) $106 $106 ($176,190) ($198,300) $426 $426 ($175,764) ($197,874) 51 52 Pre-tax Int. cov 00 0.23 0.02 0.01 0.01 0.01 0.01 0.01 0.00 0.00 63 Funds/Debt 00 -0.03 -0.24 -0.32 -0.32 -0.32 -0.32 -0.32 -0.32 -0.32 64 Likely Rating Aaa/AAA C2/C D2/D D2/D D2/D D2/D D2/D D2/D D2/D D2/D 55 Pre-tax cost of debt 5.05% 25.05% 32.13% 32.13% 32.13% 32.13% 32.13% 32.13% 32.13% 32.13% 66 Tax rate for debt (deduction constraint) 24.45% 2.59% 0.26% 0.14% 0.10% 0.08% 0.07% 0.06% 0.05% 0.05% 67 Tax rate for debt tax benefits (Interest limits 24.45% 5.64% 0.57% 0.30% 0.22% 0.18% 0.15% 0.13% 0.11% 0.10% 58 Tax rate to use in after-tax cost of debt 24.45% 2.59% 0.26% 0.14% 0.10% 0.08% 0.07% 0.06% 0.05% 0.05% 69 COST OF CAPITAL CALCULATIONS 70 D/(D+E) 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 90.00% 71 D/E 72 S Debt 73 Cost of equity 0.00% 11.11% 25.00% 42.86% 66.67% 100.00% 150.00% 233.33% 400.00% 900.00% SO $68,816 $137,633 $206,449 $275,266 $344,082 $412,899 $481,715 $550,532 $619,348 3.93% 3.94% 3.96% 3.98% 4.02% 4.06% 4.13% 4.24% 4.47% 5.15% 74 Cost of debt 3.82% 24.40% 32.05% 32.09% 32.10% 32.10% 32.11% 32.11% 32.11% 32.12% 75 Cost of Capital 3.93% 5.99% 9.58% 12.41% 15.25% 18.08% 20.92% 23.75% 26.58% 29.42% 76 1 0 0 0 0 0 0 0 0 0 7 Value (perpetual growth) $4,033,203 $249,706 $94,784 $63,599 $47,869 $38,378 $32,027 $27,480 $24,064 $21,403 78
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The ordinary share capital of PP Ltd (a trading company) is owned 32% by QQ Ltd, 35% by RR Ltd and 23% by SS Ltd. The remaining 10% is owned by various individuals, none of whom own more than 1%. All...
-
You are considering investing in the following securities and have developed the probability distributions for their returns over the next year. a. Calculate the expected return and standard...
-
Compare and contrast the EU approach to SME policy with that in the UK.
-
John and Jennifer Margeson entered into a contract to sell a weight-loss franchise business called Inches-A-Weigh to Theresa Artis. The parties memorialized their agreement in an Asset Purchase...
-
Periodic versus Perpetual Entries Chippewas Company sells one product. Presented below is information for January for Chippewas Company. Jan. 1 Inventory 100 units at $6 each 4 Sale 80 units at $8...
-
8. A straight section of railroad track crosses two highways 400 m and 600 m from an intersection. Find the dimensions of the largest rectangular lot that can be laid out in the triangle formed by...
-
Extend Example 20.3 to calculate CVA when default can happen in the middle of each month. Assume that the default probability during the first year is 0.001667 per month and the default probability...
-
Mohammed owns 6 Cars for rent, the following are the details of rent revenue and costs during the year al hawl: 1. Monthly rent for 3 cars S.R 9000 2. Monthly rent for 2 cars S.R 5000 3. One of the...
-
What is HTML and what is its role in web development? Question 1 2 1 2 options: A high - level programming language interpreted by a browser. The standard markup language used for creating web pages...
-
The size of any arrays is determined using The member variable called size O The method length() O The member variable called length The method size() returns the number of cells
-
Positional parameters are a . . special variables inside the script b . . special variables for setting arguments in the command line c . . special patterns and symbols from command line d . . group...
-
21) Dijkstra's Algorithm is used to solve ..... problems. a) Shortest path from any node to any other node on the graph. (All pair shortest path) b) Shortest path from a given sounrce node to any...
-
How have recent developments in information technology made the operations of businesses more effective? By reducing the need for business processes By automating tasks that were previously manual By...
-
(1) Land and buildings were revalued by the directors on 31 December 20x0 based on an independent valuation performed by I. Countit (a member of the Australian Institute of Valuers) on 12 December,...
-
Huntingdon Capital Corp. is a competitor of Plazacorp and First Capital Realty. Huntingdon reported the following selected information (in millions):...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1 and 2. On September 1, Irene opened a retail store that specializes in sports car...
-
Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...
-
Jan has two jobs during 2012. One employer withheld and paid FICA taxes on $66,600 of Jan's salary, and the other employer withheld and paid FICA taxes on $44,400 in salary paid to Jan. Calculate the...
-
An engineering organisational system is composed of major groups such as management, research and development, preliminary design, experiments, product design and drafting, fabrication and...
-
The student-teacher learning activity is inherently a feedback exercise intended to reduce the system error to a minimum. The desired output is the knowledge being studied, and the student is the...
-
Give two examples of feedback control systems in which a human acts as a controller.
Study smarter with the SolutionInn App