Question

In: Finance

After-tax Interest Rates Used in Discounted Cash Flow Analysis and NPV Apply these concepts to the...

After-tax Interest Rates Used in Discounted Cash Flow Analysis and NPV

Apply these concepts to the analysis of investment project (e.g. factory, apartment building, equipment purchase, renovation, etc.)

The Excel Corp. has $1 million in corporate debt outstanding with a after-tax cost of 5%, and a maturity of two years. The only way it can finance a $500,000 investment is to refinance with $1.5 million of debt with a similar maturity, costing 8% after-tax. The investment would pay $55,000 in year 1 and $550,000 in year 2 (the investment has an IRR of .11). Assume that the current cost of equity is 12%, and that after refinancing, the firm will be 50% leveraged. Debt costs and cash flows are on an after-tax basis. Should the investment be accepted?

Solutions

Expert Solution

Let us find the WACC after the refinancing
Given After Tax cost of Debt =8%
Ungeared cost of Equity =kug=12%
D/E ratio =50:50 =1
So Geared Cost of Equity =kg=kug+(1-T)*(kug-kd)*D/E
kg=12%+4%=16%
So Cost of Equity after refinancing =16%
so WACC after refinancing=50%*16%+50%*8%=12%
We need to find the NPV of The Investment using the
WACC as the discount rate.

.

Year Cash flow PV factor @12%=1/1.12^n PV of Cash flow
0 $           (500,000)                            1.00 $     (500,000)
1 $               55,000 0.8929 $         49,110
2 $            550,000 0.7972 $      438,460
Total=NPV= $       (12,431)
As the NPV of the investment is negative, the investment should not be accepted.

Related Solutions

The Discounted Cash Flow methodology. The difference between interest rates and different compounding methods. The concepts...
The Discounted Cash Flow methodology. The difference between interest rates and different compounding methods. The concepts of present value and future value as well as discounting. How to determine a firm's cash flow in the context of required rates of return and compensation for risk.Please give us one example from your research, work, or personal life of an application of the above concepts.
What is an opportunity cost rate? How is this rate used in discounted cash flow analysis,...
What is an opportunity cost rate? How is this rate used in discounted cash flow analysis, and where is it shown on a time line? Is the opportunity rate a single number that is used to evaluate all potential investments?
Create a Free Cash Flow and Discounted Cash Flow Statement. The tax rate and discount rate...
Create a Free Cash Flow and Discounted Cash Flow Statement. The tax rate and discount rate are not given, so the percentage below is an assumption. If there are better assumptions, then feel free to use that with a description as to why it is better. The EBIT is from the company that is trying to bought; their stand alone basis projected income statement and balance sheet. Show all calculations.   Would you say the merger is a good idea? 2015...
Calculate the After-Tax Cash Flow, NPV (at minimum ROR=20%) and ROR for the following investment with...
Calculate the After-Tax Cash Flow, NPV (at minimum ROR=20%) and ROR for the following investment with 6 years life time: -The investor is a Non-integrated petroleum company -Total producible oil in the reserve is estimated to be 2,400,000 barrel -Production rate will be 400,000 barrel of oil per year from year 1 to year 6 -Mineral rights acquisition cost for property would be $1,600,000 at time zero -Intangible drilling cost (IDC) is expected to be $7,000,000 at time zero -Tangible...
a) What is the Before Tax Cash Flow? b) What is the After Tax Cash Flow?...
a) What is the Before Tax Cash Flow? b) What is the After Tax Cash Flow? Given: Annual Debt Service                            $20,876             Vacancy & Collection Loss 5%             Depreciation                                       11,000             PGI                                                      46,200             Interest                                               1,700             Operating Expenses                            18,400             Marginal Tax Rate                              28%                         All numbers are annual If possible, please use a financial calculator and show me how to solve as I need to learn this concept for this class.
Discounted Cash Flow Analysis. If the appropriate discount rate for the following cash flows is 7.3%,...
Discounted Cash Flow Analysis. If the appropriate discount rate for the following cash flows is 7.3%, what is the present value of the cash flows? Please show me how to do this problem using a Texas Instruments BAII Plus Business calculator. Year     Cash Flow 1              $1,200 2              1,100 3               800 4               600
Compute the cash flow, tax flow, and after tax flow for the following real estate investment...
Compute the cash flow, tax flow, and after tax flow for the following real estate investment property: -Gross rents are expected to be $36,000 per year -Expected vacancy allowance is 5% of gross rents -Property management fees are 8% of rents collected -Total estimated operating expenses per year $7,200 -Payment of mortgage per year: Interest 12,000 Principal 3,000 Total 15,000 -Depreciation allowance for the year is $14,350 -The owner's earned income is $100,000 and his marginal tax bracket is 30%...
Which of the following is not commonly used in discounted cash flow valuation to calculate the...
Which of the following is not commonly used in discounted cash flow valuation to calculate the value of the firm? a. Dividends. b. Free Cash Flow to the Firm. c. Free Cash Flow to Equity. d. Share Buy Backs Which of het following adjustments would you make after calculating the value of the firm to get to the value of equity? a. Subtract the value of debt. b. Subtract capital expenditures on new projects. c. Subtract the expected liabilities from...
Consider the following project’s after-tax cash flow and the expected annual inflation rates during the project...
Consider the following project’s after-tax cash flow and the expected annual inflation rates during the project period. Convert the cash flows in actual dollars into equivalent constant dollars with the base year 0. (complete the table for constant dollars cash flow) If the annual real interest rate is 15%, what is the present worth of the cash flow? Is this project acceptable? Final answer section (b): actual cash flow year amount 0 - $295,000 1 $ 95,000 2 $ 45,000...
Fill in the ‘boxed’ values in the after tax cash flow below. EOY B4TCF Interest Principal...
Fill in the ‘boxed’ values in the after tax cash flow below. EOY B4TCF Interest Principal Deprec Taxable Inc. Taxes ATCF 0 -125,000 -50,000 -75,000 1 10,000 5,000 10,774 -2,850 -2,924 2 22,500 -6,423 -2,441 6,667 3 30,000 2,738 13,036 9,262 3,520 4 40,000 1434 14,340 14,400 24,166 15,043 5 80,000 11,525 68,475 26,021 53,980
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT