Swee Rien Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of RM1,500,000. The company’s board of directors has set a maximum 4-year payback requirement and has set its cost of capital at 9.50 percent. The cash inflows associated with the two projects are shown in the following table.
Cash inflows (CFt)
Year |
Project A (RM) |
Project B (RM) |
1 |
450,000 |
750,000 |
2 |
450,000 |
600,000 |
3 |
550,000 |
300,000 |
4 |
400,000 |
350,000 |
5 |
450,000 |
250,000 |
6 |
450,000 |
300,000 |
a) Find the payback period for each project.
b) Calculate the NPV of each project at 9.50 percent.
c) Compute the Profitability Index.
d) Derive the IRR of each project.
e) Rank the projects by each of the techniques used. Make and
justify a recommendation.
In: Finance
Scenario Analysis
We are evaluating a project that costs $1,160,000, has a ten-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 44,000 units per year. Price per unit is $45, variable cost per unit is $20, and fixed costs are $645,000 per year. The tax rate is 35 percent, and we require a 20 percent return on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within ±10 percent. Calculate the best-case and worst-case NPV figures. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations and round your final answers to 2 decimal places. (e.g., 32.16))
NPV Best-case $
Worst-case $
In: Finance
Troy Industries purchased a new machine 4 year(s) ago for $82,000.
It is being depreciated under MACRS with a 5-year recovery period using the schedule.
Assume 40% ordinary and capital gains tax rates.
a. What is the book value of the machine?
b. Calculate the firm's tax liability if it sold the machine for each of the following
amounts: $98,400; $57,400; $13,940; and $9,800.
a. The remaining book value is
$ . (Round to the nearest dollar.)
Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes |
||||
Percentage by recovery year* |
||||
Recovery year |
3 years |
5 years |
7 years |
10 years |
1 |
33% |
20% |
14% |
10% |
2 |
45% |
32% |
25% |
18% |
3 |
15% |
19% |
18% |
14% |
4 |
7% |
12% |
12% |
12% |
5 |
12% |
9% |
9% |
|
6 |
5% |
9% |
8% |
|
7 |
9% |
7% |
||
8 |
4% |
6% |
||
9 |
6% |
|||
10 |
6% |
|||
11 |
4% |
|||
Totals |
100% |
100% |
100% |
100% |
In: Finance
At year-end 2016, total assets for Arrington Inc. were $1.8 million and accounts payable were $325,000. Sales, which in 2016 were $2.4 million, are expected to increase by 15% in 2017. Total assets and accounts payable are proportional to sales, and that relationship will be maintained; that is, they will grow at the same rate as sales. Arrington typically uses no current liabilities other than accounts payable. Common stock amounted to $445,000 in 2016, and retained earnings were $260,000. Arrington plans to sell new common stock in the amount of $65,000. The firm's profit margin on sales is 4%; 40% of earnings will be retained.
What were Arrington's total liabilities in 2016? Write out your
answer completely. For example, 25 million should be entered as
25,000,000. Round your answer to the nearest cent.
$
How much new long-term debt financing will be needed in 2017?
Write out your answer completely. For example, 25 million should be
entered as 25,000,000. Do not round your intermediate calculations.
Round your answer to the nearest cent. (Hint: AFN - New
stock = New long-term debt.)
$
In: Finance
No More Books Corporation has an agreement with Floyd Bank whereby the bank handles $6.8 million in collections per day and requires a $440,000 compensating balance. No More Books is contemplating canceling the agreement and dividing its eastern region so that two other banks will handle its business. Banks A and B will each handle $3.4 million of collections per day, and each requires a compensating balance of $290,000. No More Books’ financial management expects that collections will be accelerated by one day if the eastern region is divided. |
a. | What is the NPV of accepting the system? (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567.) | ||
b. |
What will be the annual net savings? Assume that the T-bill rate is 2.5 percent annually. (Enter your answer in dollars, not millions of dollars, e.g., 1,234,567.) |
||
|
In: Finance
Capital Budgeting – Example 1
General Farm Supply is considering the feasibility of expanding their line of fertilizers. They evaluate such projects by determining the net present value and internal rate of return.
General recently completed a feasibility study that indicated they would be able to sell as much fertilizer as they can produce. The study was performed by Fertilizer Consultants, Inc. at a cost of $100,000.
General has also determined facility needs that will accompany the expansion. Warehouse expansion will cost $500,000 and will be depreciated using the 5-year MACRS depreciation schedule. (.20, .32, .192, .1152, .1152, .0576). Equipment installation costs will total $50,000. General currently owns land next to their existing facility that can be used for the expansion. The land was purchased 10 years ago for $5,000. Current market value for the land is $20,000.
In order to finance the expansion, General plans to issue $500,000 in bonds. The bonds will have a 10% coupon rate and will mature in 10 years. They will have to pay $50,000 per year in interest on the bonds.
General uses a corporate-wide hurdle rate of 10.1% when evaluating capital projects. Their marginal tax rate is 35%.
General has determined that the expansion will allow them to sell 1,000,000 pounds of fertilizer per year at an estimated price of $0.30 per pound. Fixed costs per year are forecast at $40,000. Variable costs of $0.10 per pound are forecast.
General forecasts the following one-time changes in working capital in year 0:
Inventory will increase $20,000
Accounts receivable will increase $10,000
Accounts payable will increase $8,000
Any increase in NWC should be recaptured at the end of year 7.
Due to anticipated technological changes in the fertilizer industry, General is forecasting zero cash flow from this project beyond year 7.
General forecasts that the equipment that was purchased for this project can be sold for $40,000 at the end of year 7.
Help General’s CFO evaluate the project by completing the following on the Excel spreadsheet provided:
Find annual cash flows for years 0 through 7
Find the net present value
Find the internal rate of return
Should General do the project? Why or why not?
In: Finance
We are evaluating a project that costs $604,100, has a seven-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 90,000 units per year. Price per unit is $44, variable cost per unit is $31, and fixed costs are $710,000 per year. The tax rate is 23 percent, and we require a return of 12 percent on this project. |
a-1. |
Calculate the accounting break-even point. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) |
a-2. | What is the degree of operating leverage at the accounting break-even point? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) |
b-1. | Calculate the base-case cash flow and NPV. (Do not round intermediate calculations. Round your cash flow answer to the nearest whole number, e.g., 32. Round your NPV answer to 2 decimal places, e.g., 32.16.) |
b-2. | What is the sensitivity of NPV to changes in the quantity sold? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
c. | What is the sensitivity of OCF to changes in the variable cost figure? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. |
In: Finance
. Amortization Table. You wish to buy a $40,000 car. The bank can finance you with a 3-year loan at a 4 percent APR. If you make a $7,000 down payment on the purchase. What are the monthly payments on your loan? How much will you pay in interest each year?
In: Finance
ABC company issued bonds on January 1, 2006. The bonds had a coupon rate of 5.5%, with interest paid semiannually. The face value of the bonds is $1,000 and the bonds mature on January 1, 2021. What is the yield to maturity for these bonds on January 1, 2012 if the market price of the bond on that date is $950?
(i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem
In: Finance
ABC Golf Corporation Assignment:
ABC Golf Equipment Corporation has 500,000 shares outstanding and currently has no debt. The company has a marginal tax rate of 35% and the firm’s stock price is $27 per share. The firm’s unlevered beta is 1.5, the risk-free rate of return is 5%, and the expected market return is 10%.
The company is thinking of issuing bonds and simultaneously repurchasing a portion of its stock. Because the company is issuing bonds to repurchase the stock, there is no anticipated change to the stock price as a result of the stock buyback. The bonds can be issued with a 6% coupon, and under the new proposed structure the debt to capital ratio would be 7%. If the company’s debt to capital ratio exceeds 25%, the cost of debt would increase to a max rate of 8%. Company mandates require that the company’s debt to equity ratio remains at less than 3.0 at all times. The firm’s earnings are not expected to grow over time. All of its earnings will be paid out as dividends.
Probability |
EBIT ($) |
0.05 |
-$1 Million |
0.25 |
2.3 Million |
0.40 |
4 Million |
0.25 |
5.8 Million |
0.05 |
6.1 Million |
Use Excel for your calculations and answer the ten questions on the following pages. Your submission should consist of two files:
1) Submit a Word document clearly showing your solutions and how you achieved them
2) Also if possible please submit an Excel worksheet showing your spreadsheets that you used to calculate solutions.
Questions to answer:
1) Based on the given probabilities in the table above, what is the expected EBIT for ABC Golf Equipment Corporation?
2) If the market value equals the book value of the firm’s assets, what is the current market value of ABC Golf Equipment Corporation’s assets?
3) What is the current cost of equity to the firm?
4) Based on the current share price, what is the current dividend per share?
5) Based on the current share price, what is the current dividend yield?
6) If there is no change to the stock price as a result of the share repurchase, how much equity will shareholders own after the proposed capital restructuring?
7) After the proposed change in capital structure, how much debt will the company now carry?
8) Under these market conditions, what is the firm’s optimal debt to capital ratio for the firm?
9) What is the WACC at the optimal debt to capital ratio?
10) Under a new proposed tax cut, corporate tax rates would now be reduced to 21%. Explain how the new proposed tax plan affects the optimal capital structure. What would be the optimal capital structure under the new proposed tax plan?
In: Finance
Economic order quantity (EOQ).
Tinnendo, Inc. believes it will sell 4 million zen-zens, an electronic game, this coming year. Note that this figure is for annual sales. The inventory manager plans to order zen-zens 50 times over the next year. The carrying cost is $0.04 per zen-zen per year. The order cost is $513 per order. What are the annual carrying cost, the annual ordering cost, and the optimal order quantity for the zen-zens? Verify your answer by calculating the new total inventory cost.
What is the annual carrying cost for the zen-zens?
( ) $ (Round to the nearest dollar.)
In: Finance
An investment company intends to invest a given amount of money in three stocks.
The means and standard deviations of annual returns are as follows:
Stock | Mean | Standard Deviation | |
1 | 0.14 | 0.20 | |
2 | 0.11 | 0.25 | |
3 | 0.15 | 0.08 |
Stock Coorelation among annual returns | |
Stocks 1 and 2 | 0.5 |
Stocks 1 and 3 | 0.8 |
Stocks 2 and 3 | 0.1 |
Construct the efficient frontier for portfolios of these stocks. Please explain the involved steps in your modeling and construction.
In: Finance
Fortescue Ltd is offering bonds with a coupon rate of 8% p.a., paid semi-annually. The par value of each bond is $1,000 and has eight (8) years to maturity. The yield to maturity is 9%. What is the value of the bond?
In: Finance
Marvelous Mining Company (MMC) is negotiating for the purchase of a new piece of equipment for its current operations. MMC wants to know the maximum price that it should be willing to pay for the equipment. That is, how high must the price be that it should be willing to pay for the equipment to have an NPV of zero. You are given the following facts:
1. The new equipment would replace existing equipment that has a current market value of $35000.
2. The new equipment would not affect revenues, but before-tax operating costs would be reduced by $12500 per year for 5 years. These savings in costs would occur at year-end.
3. The old equipment is now five years old. It is expected to last another five years and to have no resale value at the end of those 5 years. It was purchased at $40000 and is being depreciated at a CCA rate of 30%.
4. The new equipment will also be depreciated at a CCA rate of 30%. MMC expects to be able to sell the equipment for $6000 at the end of five years. At that time, the firm plans to reinvest in new equipment in the same CCA pool.
5. MMC has profitable ongoing operations.
6. The appropriate discount rate is 14%.
7. The tax rate is 40%.
8. Assume net acquisition cost is positive.
In: Finance
In: Finance