1. Find the costs (rate of return under current market conditions) of the individual capital components.
a. Long-term debt:
PV = -$874.78, FV = $1,000, PMT = $100, n = 15, i = need to solve for this first
Kd = i (1-T)
Kd = i% (1 – .40)
Kd = i% (.60)
Kd = 6.94%
b. Preferred stock:
Kp = Dp / (Pp – F)
Kp = Hint: D is *$100 par value times 9%
Kp = 10.35%
c. Retained earnings (avg. of CAPM and bond yield + risk premium approaches):
CAPM:15.76%
Kj = Rf + ß(Km – Rf)
Bond yield = 7.09% (calculated above) + 5% risk premium
= 16.56%
Average of two approaches: 15.76 + 16.56 / 2 = 16.16%
d. New common stock:
Kn = D1 / (P0 – F) + g
Kn = 17.40%
2. Compute the value of the long-term elements of the capital structure, and determine the target percentages for the optimal capital structure (based on current market value).
a. Long-term debt:
Market value = # bonds (bond price) = $140,000,000
b. Preferred stock:
Market value = # shares (share price) = $9,000,000
c. Common equity (retained earnings):
Market value = # shares (share price) = $52,486,800
Long-term debt
52,486,800
26.0497%
Preferred stock
9,000,000
4.4668%
Common equity
140,000,000
69.4835%
Total capital (check figure)
$201,486,800
100%
Determining the Marginal Cost of Capital:
Last year’s sales:
225,000,000
Net profit margin:
Net earnings:
Dividend payout ratio:
50%
New retained earnings in year 0:
*
*The firm also expects $10 million in retained earnings in year 1
Retained earnings breakpoint:
X = Retained earnings / % of retained earnings in the capital structure
X =
Weighted Average Cost of Capital for Financing up to $14 million:
Cost (aftertax)
Weights
Weighted Cost
Debt
Kd
69.4835
Preferred stock
Kp
4.4668
Retained earnings
Ke
26.0497
Weighted average cost of capital
Ka
Weighted Average Cost of Capital for Financing over $14 million:
Cost (aftertax)
Weights
Weighted Cost
Debt
Kd
Preferred stock
Kp
New common stock
Kn
Weighted average cost of capital
Ka
3. Compute the Year 0 investment for Project I.
$ (equipment) + $ (installation) + $ (AR/Inventory – Working capital) =
Year 0 Investment = $15,000,000 + $2,000,000 + $4,000,000
Year 0 Investment = $21,000,000
4. Compute the annual operating cash flows for years 1-6 of the project.
Annual depreciation expense:
Year
Depreciation Base
Percentage Depreciation
Annual Depreciation
1
$17,000,000*
.2
3,400,000
2
17,000,000
.32
5,400,000
3
17,000,000
.192
3,264,000
4
17,000,000
.115
1,955,000
5
17,000,000
.115
1,955,000
6
17,000,000
.058
986,000
Total Depreciation
17,000,000$
*MACRS is calculated with the purchase price as the depreciation base (Block et al., 2011).
Annual operating cash flows generated by the project:
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Rev
$5,000,000
$10,000,000
$14,000,000
$16,000,000
$12,000,000
$8,000,000
FC
1,000,000
1,000,000
1,000,000
1,000,000
1,000,000
1,000,000
VC*
1,500,000
3,000,000
4,200,000
4,800,000
3,600,000
2,400,000
Depr**
3,400,000
5,400,000
3,264,000
1,955,000
1,955,000
986,000
EBT
(900,000)
560,000
5,536,000
8,245,000
5,445,000
3,614,000
Taxes‡
224,000
2,214,4000
3,298,000
2,178,000
1,445,600
EAT
(900,000)
336,000
3,321,600
4,947,000
3,267,000
2,168,400
+Depr
3,400,000
5,400,000
3,264,000
1,955,000
1,955,000
986,000
CF
2,500,000
5,776,000
6,585,600
6,902,000
5,222,000
3,154,400
*Revenues multiplied by 30%
**Calculated above
‡With a 40% tax rate
5. Compute the additional non-operating cash flow at the end of year 6.
Purchase price of equipment: -17,000,000
Total depreciation to date: 17,000,000
Book value: $0.00
Sales price: $4,000,000
Gain on sale:
Tax expense (40%): -1,600,000
Cash inflow from sale: 2,400,000
Recovery of working capital:
Total terminal cash inflow: 6,400,000
*(Hodges, n.d.).
6. Compute the IRR and payback period for Project I.
Payback period:
Year
Cash Inflows
1
2,500,000
2
5,776,000
3
6,585,600
Total
14,861,600
Investment to be recovered: 21,000,000
Less: Amount recovered by the end of year 3: 14,861,600
Amount still needed: 6,138,400
Divided by: Cash flow in year 4: 6,902,000
Fraction of year 4 needed to recover balance: 3.89
Payback period: = 3.89
Internal rate of return:
Using a financial calculator as explained on page 327 of our text:
CFo
(21,000,000)
CFj-1
2,500,000
CFj-2
5,776,000
CFj-3
6,585,600
CFj-4
6,902,000
CFj-5
5,222.000
CFj-6*
9,554,400
IRR
15.82%
*Operating cash flow of $3,108,000 + Non-operating cash flow of $6,400,000
7. Determine your firm’s cost of capital (WACC plus an adjustment for the write up).
Long term debt 6.94%
Common stock 17.40%
Preferred stock 10.35%
6.94% x 26.0497% + 17.40% x 69.4835% + 10.35% x 4.4668% = 14.36%
8. Compute the NPV for Project I. Should management adopt this project based on your analysis? Explain. Would your answer be different if the project were determined to be of average risk? Explain.
Using a financial calculator as explained on page 325 of our text:
CFo
CFj-1
CFj-2
CFj-3
CFj-4
CFj-5
CFj-6*
i
NPV
CFo
CFj-1
CFj-2
CFj-3
CFj-4
CFj-5
CFj-6*
i
NPV
*Operating cash flow of $3,108,000 + Non-operating cash flow of $6,400,000
Project I
9. Indicate which of the other projects (A through E) should be accepted and why.
Assuming these projects are not mutually exclusive, the company should accept both Project A and Project B.
References
Block, B. B., Hirt, G. A., & Danielsen, B. R. (2011). Foundations of financial management (14th ed.). New York, NY: McGraw-Hill/Irwin.
Cengage Learning. (2010). Web extension 12B: The marginal cost of capital and the optimal capital budget. Retrieved from http://academic.cengage.com/resource_uploads/downloads/0324594690_163042.pdf
Hodges, C. W. (n.d.). Relevant capital budgeting cash flows are future. Retrieved from http://www.westga.edu/~chodges/pdf/capbudhint.pdf
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer Capital Budgeting project
1. Find the costs (rate of return under current market conditions) of the individual capital components.
a. Long-term debt:
PV = -$874.78, FV = $1,000, PMT = $100, n = 15, i = need to solve for this first
Kd = i (1-T)
Kd = i% (1 – .40)
Kd = i% (.60)
Kd = 6.94%
b. Preferred stock:
Kp = Dp / (Pp – F)
Kp = Hint: D is *$100 par value times 9%
Kp = 10.35%
c. Retained earnings (avg. of CAPM and bond yield + risk premium approaches):
CAPM:15.76%
Kj = Rf + ß(Km – Rf)
Bond yield = 7.09% (calculated above) + 5% risk premium
= 16.56%
Average of two approaches: 15.76 + 16.56 / 2 = 16.16%
d. New common stock:
Kn = D1 / (P0 – F) + g
Kn = 17.40%
2. Compute the value of the long-term elements of the capital structure, and determine the target percentages for the optimal capital structure (based on current market value).
a. Long-term debt:
Market value = # bonds (bond price) = $140,000,000
b. Preferred stock:
Market value = # shares (share price) = $9,000,000
c. Common equity (retained earnings):
Market value = # shares (share price) = $52,486,800
Long-term debt
52,486,800
26.0497%
Preferred stock
9,000,000
4.4668%
Common equity
140,000,000
69.4835%
Total capital (check figure)
$201,486,800
100%
Determining the Marginal Cost of Capital:
Last year’s sales:
225,000,000
Net profit margin:
Net earnings:
Dividend payout ratio:
50%
New retained earnings in year 0:
*
*The firm also expects $10 million in retained earnings in year 1
Retained earnings breakpoint:
X = Retained earnings / % of retained earnings in the capital structure
X =
Weighted Average Cost of Capital for Financing up to $14 million:
Cost (aftertax)
Weights
Weighted Cost
Debt
Kd
69.4835
Preferred stock
Kp
4.4668
Retained earnings
Ke
26.0497
Weighted average cost of capital
Ka
Weighted Average Cost of Capital for Financing over $14 million:
Cost (aftertax)
Weights
Weighted Cost
Debt
Kd
Preferred stock
Kp
New common stock
Kn
Weighted average cost of capital
Ka
3. Compute the Year 0 investment for Project I.
$ (equipment) + $ (installation) + $ (AR/Inventory – Working capital) =
Year 0 Investment = $15,000,000 + $2,000,000 + $4,000,000
Year 0 Investment = $21,000,000
4. Compute the annual operating cash flows for years 1-6 of the project.
Annual depreciation expense:
Year
Depreciation Base
Percentage Depreciation
Annual Depreciation
1
$17,000,000*
.2
3,400,000
2
17,000,000
.32
5,400,000
3
17,000,000
.192
3,264,000
4
17,000,000
.115
1,955,000
5
17,000,000
.115
1,955,000
6
17,000,000
.058
986,000
Total Depreciation
17,000,000$
*MACRS is calculated with the purchase price as the depreciation base (Block et al., 2011).
Annual operating cash flows generated by the project:
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Rev
$5,000,000
$10,000,000
$14,000,000
$16,000,000
$12,000,000
$8,000,000
FC
1,000,000
1,000,000
1,000,000
1,000,000
1,000,000
1,000,000
VC*
1,500,000
3,000,000
4,200,000
4,800,000
3,600,000
2,400,000
Depr**
3,400,000
5,400,000
3,264,000
1,955,000
1,955,000
986,000
EBT
(900,000)
560,000
5,536,000
8,245,000
5,445,000
3,614,000
Taxes‡
224,000
2,214,4000
3,298,000
2,178,000
1,445,600
EAT
(900,000)
336,000
3,321,600
4,947,000
3,267,000
2,168,400
+Depr
3,400,000
5,400,000
3,264,000
1,955,000
1,955,000
986,000
CF
2,500,000
5,776,000
6,585,600
6,902,000
5,222,000
3,154,400
*Revenues multiplied by 30%
**Calculated above
‡With a 40% tax rate
5. Compute the additional non-operating cash flow at the end of year 6.
Purchase price of equipment: -17,000,000
Total depreciation to date: 17,000,000
Book value: $0.00
Sales price: $4,000,000
Gain on sale:
Tax expense (40%): -1,600,000
Cash inflow from sale: 2,400,000
Recovery of working capital:
Total terminal cash inflow: 6,400,000
*(Hodges, n.d.).
6. Compute the IRR and payback period for Project I.
Payback period:
Year
Cash Inflows
1
2,500,000
2
5,776,000
3
6,585,600
Total
14,861,600
Investment to be recovered: 21,000,000
Less: Amount recovered by the end of year 3: 14,861,600
Amount still needed: 6,138,400
Divided by: Cash flow in year 4: 6,902,000
Fraction of year 4 needed to recover balance: 3.89
Payback period: = 3.89
Internal rate of return:
Using a financial calculator as explained on page 327 of our text:
CFo
(21,000,000)
CFj-1
2,500,000
CFj-2
5,776,000
CFj-3
6,585,600
CFj-4
6,902,000
CFj-5
5,222.000
CFj-6*
9,554,400
IRR
15.82%
*Operating cash flow of $3,108,000 + Non-operating cash flow of $6,400,000
7. Determine your firm’s cost of capital (WACC plus an adjustment for the write up).
Long term debt 6.94%
Common stock 17.40%
Preferred stock 10.35%
6.94% x 26.0497% + 17.40% x 69.4835% + 10.35% x 4.4668% = 14.36%
8. Compute the NPV for Project I. Should management adopt this project based on your analysis? Explain. Would your answer be different if the project were determined to be of average risk? Explain.
Using a financial calculator as explained on page 325 of our text:
CFo
CFj-1
CFj-2
CFj-3
CFj-4
CFj-5
CFj-6*
i
NPV
CFo
CFj-1
CFj-2
CFj-3
CFj-4
CFj-5
CFj-6*
i
NPV
*Operating cash flow of $3,108,000 + Non-operating cash flow of $6,400,000
Project I
9. Indicate which of the other projects (A through E) should be accepted and why.
Assuming these projects are not mutually exclusive, the company should accept both Project A and Project B.
References
Block, B. B., Hirt, G. A., & Danielsen, B. R. (2011). Foundations of financial management (14th ed.). New York, NY: McGraw-Hill/Irwin.
Cengage Learning. (2010). Web extension 12B: The marginal cost of capital and the optimal capital budget. Retrieved from http://academic.cengage.com/resource_uploads/downloads/0324594690_163042.pdf
Hodges, C. W. (n.d.). Relevant capital budgeting cash flows are future. Retrieved from http://www.westga.edu/~chodges/pdf/capbudhint.pdf
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer