In December 2019, Bob Prescott, the controller for the Blue Ridge Mill, was considering the addition of new on-site long-wood woodyard. The addition would have two primary benefits: to eliminate the need to purchase short-wood from an outside supplier and create the opportunity to sell short-wood on the open market as a new market for Worldwide Paper Company (WPC). The new woodyard would allow the Blue Ridge Mill not only to reduce its operating costs but also to increase its revenues. The proposed woodyard will utilise new technology that allows tree-length logs, called long-wood, to be processed directly, whereas the current process required short-wood, which had to be purchased from the Shenandoah Mill. This nearby mill, owned by a competitor, has excess capacity that allows it to produce more short-wood than it needs for its own pulp production. The excess is sold to several different mills, including the Blue Ridge Mill. Thus, adding the new long-wood equipment would mean that Prescott would no longer need to use the Shenandoah Mill as a short-wood supplier and that the Blue Ridge Mill would instead compete with the Shenandoah Mill by selling on the short-wood market. The question for Prescott was whether these expected benefits were enough to justify the $18m capital outlay plus the incremental investment in working capital over the six-year life of the investment. Construction would start within a few months, and the investment outlay would be spent over two calendar years: $16m in 2020 and the remaining $2m in 2021. When the woodyard begins operating in 2021, it would significantly reduce the operating costs of the mill. These operating savings would come mostly from the difference in the cost of producing short-wood on-site versus buying it on the open market and were estimated to be $2m for 2021 and $3.5m per year thereafter. Prescott also planned on taking advantage of the excess production capacity afforded by the new facility by selling short-wood on the open market as soon as possible. For 2021, he expected to show revenues of approximately $14m, as the facility came on-line and began to break into the new market. He expected shortwood sales to reach $20m in 2022 and continue at the $20m level through 2026. Prescott estimated that the cost of goods sold (before including depreciation expense) would be 75%. In addition to the capital outlay of $18m, the increased revenues would necessitate higher levels of inventories and accounts receivable. Therefore the amount of working capital investment each year would equal 15% of incremental sales for the year. At the end of the life of the equipment, in 2026, all the net working capital on the books would be recoverable at cost fully. Taxes would be paid at a 30% rate, and the equipment depreciation is to be calculated on a straight-line basis over the six-year life to zero balance. However, the new equipment is estimated to have a salvage value (scrap value) of $3m at the end of its life. WPC’s accountants have told Prescott that depreciation charges could not begin until 2021, when all the $18m had been spent and the equipment is in service. WPC has a company policy to use 15% as the hurdle rate for such investment opportunities. The hurdle rate is based on the study of the company’s cost of capital conducted 5 years ago. Page 7 of 7
a. Prepare cash flow statement/s and compute the NPV and IRR of the proposed project. Comment on the feasibility of the project.
b. Outline reasons why Prescott may be uneasy using the 15% hurdle rate for a discount rate.
c. Perform a sensitivity analysis on NPV of the project on the following scenarios: (i) Sales increases/decreases by 10%. (ii) Cost of capital increases/decreases by 10%. Comment on the feasibility of the project under each scenario.
d. The global paper and pulp industry, one of the world largest industries, has been growing slowly, at a rate much less than expected over the last 20 years. The price chart below shows that the Products Industry Index on average grew at around 2.5% per year over the last 20 years, while lumber futures contract prices have negative growth. Some analysts believe that the industry needs more structural change to counter disruption of technology and tackle social impacts due to climate change. Identify and analyse three qualitative risk factors (i.e. factors which are unquantifiable at present) faced by the industry. How would Bob Prescott consider these factors in evaluating the feasibility of the new on-site longwood woodyard?
In: Finance
You are planning on buying $100,000 face value of Australian Commonwealth Government Bonds. The bonds mature on 15 February 2022 and have a coupon rate of 4.75%. If your purchase will settle on 27 April 2012, and the quoted yield for the bond is 3.92%, what is the cash price of the bonds to the nearest dollar?
In: Finance
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
| 2016 | 2015 | ||
| Sales | $7,700.0 | $7,000.0 | |
| Operating costs excluding depreciation | 6,160.0 | 5,950.0 | |
| Depreciation and amortization | 177.0 | 154.0 | |
| Earnings before interest and taxes | $1,363.0 | $896.0 | |
| Less Interest | 166.0 | 151.0 | |
| Pre-tax income | $1,197.0 | $745.0 | |
| Taxes (40%) | 478.8 | 298.0 | |
| Net income available to common stockholders | $718.2 | $447.0 | |
| Common dividends | $646.0 | $358.0 |
Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)
| 2016 | 2015 | ||
| Assets | |||
| Cash | $89.0 | $77.0 | |
| Short-term investments | 39.0 | 35.0 | |
| Accounts receivable | 966.0 | 840.0 | |
| Inventories | 1,663.0 | 1,330.0 | |
| Total current assets | $2,757.0 | $2,282.0 | |
| Net plant and equipment | 1,771.0 | 1,540.0 | |
| Total assets | $4,528.0 | $3,822.0 | |
| Liabilities and Equity | |||
| Accounts payable | $564.0 | $490.0 | |
| Accruals | 756.0 | 630.0 | |
| Notes payable | 154.0 | 140.0 | |
| Total current liabilities | $1,474.0 | $1,260.0 | |
| Long-term debt | 1,540.0 | 1,400.0 | |
| Total liabilities | $3,014.0 | $2,660.0 | |
| Common stock | 1,307.8 | 1,028.0 | |
| Retained earnings | 206.2 | 134.0 | |
| Total common equity | $1,514.0 | $1,162.0 | |
| Total liabilities and equity | $4,528.0 | $3,822.0 | |
Using Rhodes Corporation's financial statements (shown above), answer the following questions.
| After-tax interest payment | $ million |
| Reduction (increase) in debt | $ million |
| Payment of dividends | $ million |
| Repurchase (Issue) stock | $ million |
| Purchase (Sale) of short-term investments | $ million |
In: Finance
Your company has been approached to bid on a contract to sell 5,100 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $4.7 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $104,000 to be returned at the end of the project, and the equipment can be sold for $284,000 at the end of production. Fixed costs are $649,000 per year, and variable costs are $164 per unit. In addition to the contract, you feel your company can sell 10,400, 11,300, 13,400, and 10,700 additional units to companies in other countries over the next four years, respectively, at a price of $355. This price is fixed. The tax rate is 40 percent, and the required return is 10 percent. Additionally, the president of the company will undertake the project only if it has an NPV of $100,000. What bid price should you set for the contract? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
In: Finance
|
Year |
Large – Company Stocks |
US Treasury Bill |
|
1 |
3.67% |
4.69% |
|
2 |
14.32 |
3.55 |
|
3 |
19.11 |
4.14 |
|
4 |
-14.57 |
5.89 |
|
5 |
-32.06 |
5.16 |
|
6 |
37.35 |
5.33 |
| a. |
Calculate the arithmetic average returns for large-company stocks and T-bills over this period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) |
|
Large Company Stocks |
4.64% |
|
T-Bills |
4.79% |
| b. |
Calculate the standard deviation of the returns for large-company stocks and T-bills over this period. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) |
|
Large Company Stocks |
_____ % |
|
T-Bills |
_____ % |
| c-1 |
Calculate the observed risk premium in each year for the large-company stocks versus the T-bills. What was the arithmetic average risk premium over this period? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
| c-2 |
Calculate the observed risk premium in each year for the large-company stocks versus the T-bills. What was the standard deviation of the risk premium over this period? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
|
Average risk premium |
_____ % |
|
Standard deviation |
_____ % |
In: Finance
Given a 3 percent interest rate, compute the year 6 future value of deposits made in years 1, 2, 3, and 4 of $1,700, $1,900, $1,900, and $2,200, respectively.
In: Finance
3.
Quantitative Problem: Rosnan Industries' 2013 and 2012 balance sheets and income statements are shown below.
| Balance Sheets: | |||
| 2013 | 2012 | ||
| Cash and equivalents | $100 | $85 | |
| Accounts receivable | 275 | 200 | |
| Inventories | 375 | 250 | |
| Total current assets | $750 | $635 | |
| Net plant and equipment | 2,000 | 1,490 | |
| Total assets | $2,750 | $2,125 | |
| Accounts payable | $150 | $85 | |
| Accruals | 75 | 50 | |
| Notes payable | 150 | 75 | |
| Total current liabilities | $375 | $210 | |
| Long-term debt | 450 | 290 | |
| Common stock | 1,225 | 1,225 | |
| Retained earnings | 700 | 400 | |
| Total liabilities and equity | $2,750 | $2,125 | |
| Income Statements: | |||
| 2013 | 2012 | ||
| Sales | $2,000 | $1,500 | |
| Operating costs excluding depreciation | 1,250 | 1,000 | |
| EBITDA | $750 | $500 | |
| Depreciation and amortization | 100 | 75 | |
| EBIT | $650 | $425 | |
| Interest | 62 | 45 | |
| EBT | $588 | $380 | |
| Taxes (40%) | 235 | 152 | |
| Net income | $353 | $228 | |
| Dividends paid | $53 | $48 | |
| Addition to retained earnings | $300 | $180 | |
| Shares outstanding | 160 | 160 | |
| Price | $ 27.78 | $ 25.28 | |
| WACC | 9.00 % | ||
Using the financial statements above, what is Rosnan's 2013 market value added (MVA)? Round your answer to the nearest dollar. Do not round intermediate calculations.
Using the financial statements given earlier, what is Rosnan's 2013 economic value added (EVA)? Round your answer to the nearest cent. Do not round intermediate calculations.
In: Finance
You are given the following set of data:
| Year | NYSE | Stock X |
|
1 |
-26.5% | -14% |
| 2 | 37.2 | 23.0 |
| 3 | 23.8 | 17.5 |
| 4 | -7.2 | 2.0 |
| 5 | 6.6 | 8.1 |
| 6 | 20.5 | 19.4 |
| 7 | 30.6 | 18.2 |
a. Determine Stock X beta coefficient
b. determine the arithmetic average rates of return for stock X and NYSE over the period given. Calculate the standard deviations of returns for both X and NYSE
c. assume the situation during years 1 to 7 is expected to prevail in the future. Also assume stock X is in equilibrium that is, its plots on the SML. What is the risk-free rate?
In: Finance
You win the lottery! Your choices are
a) If the interest rate is 0.1% compounded annually, which would you prefer?
b) If the interest rate is 4% compounded annually, which would you prefer?
c) At what annual interest rate would you be indifferent between the two?
use equation to solve!
In: Finance
2. Income statement
The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders.
The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were incurred, not necessarily when cash was received or paid. Investors and analysts use the information given in the income statement and other financial statements and reports to evaluate the company’s financial performance and condition.
Consider the following scenario:
Cold Goose Metal Works Inc.’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year.
| 1. | Cold Goose is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). |
| 2. | The company’s operating costs (excluding depreciation and amortization) remain at 75% of net sales, and its depreciation and amortization expenses remain constant from year to year. |
| 3. | The company’s tax rate remains constant at 25% of its pre-tax income or earnings before taxes (EBT). |
| 4. | In Year 2, Cold Goose expects to pay $300,000 and $1,172,601 of preferred and common stock dividends, respectively. |
Complete the Year 2 income statement data for Cold Goose, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar.
|
Cold Goose Metal Works Inc. |
||
|---|---|---|
|
Income Statement for Year Ending December 31 |
||
| Year 1 | Year 2 (Forecasted) | |
| Net sales | $15,000,000 | |
| Less: Operating costs, except depreciation and amortization | 11,250,000 | |
| Less: Depreciation and amortization expenses | 600,000 | 600,000 |
| Operating income (or EBIT) | $3,150,000 | |
| Less: Interest expense | 315,000 | |
| Pre-tax income (or EBT) | 2,835,000 | |
| Less: Taxes (25%) | 708,750 | |
| Earnings after taxes | $2,126,250 | |
| Less: Preferred stock dividends | 300,000 | |
| Earnings available to common shareholders | 1,826,250 | |
| Less: Common stock dividends | 956,813 | |
| Contribution to retained earnings | $869,437 | $1,133,180 |
Given the results of the previous income statement calculations, complete the following statements:
| • | In Year 2, if Cold Goose has 25,000 shares of preferred stock issued and outstanding, then each preferred share should expect to receive in annual dividends. |
| • | If Cold Goose has 200,000 shares of common stock issued and outstanding, then the firm’s earnings per share (EPS) is expected to change from in Year 1 to in Year 2. |
| • | Cold Goose’s earnings before interest, taxes, depreciation and amortization (EBITDA) value changed from in Year 1 to in Year 2. |
| • | It is to say that Cold Goose’s net inflows and outflows of cash at the end of Years 1 and 2 are equal to the company’s annual contribution to retained earnings, $869,437 and $1,133,180, respectively. This is because of the items reported in the income statement involve payments and receipts of cash. |
In: Finance
Financial information for Powell Panther Corporation is shown below:
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
| 2019 | 2018 | |||
| Sales | $ | 1,320.0 | $ | 1,100.0 |
| Operating costs excluding depreciation and amortization | 990.0 | 935.0 | ||
| EBITDA | $ | 330.0 | $ | 165.0 |
| Depreciation and amortization | 36.0 | 33.0 | ||
| Earnings before interest and taxes (EBIT) | $ | 294.0 | $ | 132.0 |
| Interest | 29.0 | 24.2 | ||
| Earnings before taxes (EBT) | $ | 265.0 | $ | 107.8 |
| Taxes (25%) | 106.0 | 43.1 | ||
| Net income | $ | 159.0 | $ | 64.7 |
| Common dividends | $ | 143.1 | $ | 51.8 |
Powell Panther Corporation: Balance Sheets as of December 31 (Millions of Dollars)
| 2019 | 2018 | |||
| Assets | ||||
| Cash and equivalents | $ | 15.0 | $ | 13.0 |
| Accounts receivable | 190.0 | 165.0 | ||
| Inventories | 277.0 | 231.0 | ||
| Total current assets | $ | 482.0 | $ | 409.0 |
| Net plant and equipment | 363.0 | 330.0 | ||
| Total assets | $ | 845.0 | $ | 739.0 |
| Liabilities and Equity | ||||
| Accounts payable | $ | 138.0 | $ | 110.0 |
| Accruals | 83.0 | 66.0 | ||
| Notes payable | 26.4 | 22.0 | ||
| Total current liabilities | $ | 247.4 | $ | 198.0 |
| Long-term bonds | 264.0 | 220.0 | ||
| Total liabilities | $ | 511.4 | $ | 418.0 |
| Common stock | 298.3 | 301.6 | ||
| Retained earnings | 35.3 | 19.4 | ||
| Common equity | $ | 333.6 | $ | 321.0 |
| Total liabilities and equity | $ | 845.0 | $ | 739.0 |
Write out your answers completely. For example, 25 million should be entered as 25,000,000. Round your answers to the nearest dollar, if necessary. Negative values, if any, should be indicated by a minus sign.
What was net operating working capital for 2018 and 2019? Assume the firm has no excess cash.
2018: $
2019: $
What was the 2019 free cash flow?
$
How would you explain the large increase in 2019 dividends?
-Select-IIIIIIIVVItem 4
In: Finance
3. Income statement
The income statement, also known as the profit and loss (P&L) statement, provides a snapshot of the financial performance of a company during a specified period of time. It reports a firm’s gross income, expenses, net income, and the income that is available for distribution to its preferred and common shareholders.
The income statement is prepared using the generally accepted accounting principles (GAAP) that match the firm’s revenues and expenses to the period in which they were incurred, not necessarily when cash was received or paid. Investors and analysts use the information given in the income statement and other financial statements and reports to evaluate the company’s financial performance and condition.
Consider the following scenario:
Cute Camel Woodcraft Company’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year.
| 1. | Cute Camel is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). |
| 2. | The company’s operating costs (excluding depreciation and amortization) remain at 65% of net sales, and its depreciation and amortization expenses remain constant from year to year. |
| 3. | The company’s tax rate remains constant at 40% of its pre-tax income or earnings before taxes (EBT). |
| 4. | In Year 2, Cute Camel expects to pay $100,000 and $1,419,075 of preferred and common stock dividends, respectively. |
Complete the Year 2 income statement data for Cute Camel, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar.
|
Cute Camel Woodcraft Company Income Statement |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
For Year Ending December 31 |
||||||||||
| Year 1 | Year 2 (Forecasted) | |||||||||
| Net sales | $20,000,000 | |||||||||
| Less: Operating costs, except depreciation and amortization | 13,000,000 | |||||||||
| Less: Depreciation and amortization expenses | 800,000 | |||||||||
| Operating income (or EBIT) | $6,200,000 | |||||||||
| Less: Interest expense | 620,000 | |||||||||
| Pre-tax income (or EBT) | 5,580,000 | |||||||||
| Less: Taxes (40%) | 2,232,000 | |||||||||
| Earnings after taxes | $3,348,000 | |||||||||
| Less: Preferred stock dividends | 100,000 | |||||||||
| Earnings available to common shareholders | 3,248,000 | |||||||||
| Less: Common stock dividends | 1,171,800 | |||||||||
| Contribution to retained earnings | $2,076,200 |
Given the results of the previous income statement calculations, complete the following statements:
|
||||||||
In: Finance
KFA is considering investing in a new drone technology costing $12 million. It has a 5 year life (no salvage value) and will save KFA $3.5 million/year in pre-tax operating costs. It will need an up-front working capital investment of $300,000. KFA's cost of capital is 8.0% and its tax rate is 21.0%. Their current technology has a $5 million book value but a $1 million salvage value. What are the NPV and IRR of the decision to replace the old technology?
| Output: | Year | |||||
| Start | 1 | 2 | 3 | 4 | 5 | |
| Cost | ||||||
| Operating: | ||||||
| Cost savings | ||||||
| Book loss: sale of old tech | ||||||
| Total operating | ||||||
| After-tax operating | ||||||
| Working capital | ||||||
| Cash flow | ||||||
| NPV | ||||||
| IRR | ||||||
In: Finance
KFA has issued a 100-year coupon bond with par of $1,000, and a 6.50% annual coupon paid semi-annually. Calculate its price for each of the following three YTM scenarios: 4.0%, 6.0%, and 8.0%.
| Input: | Output: | |
| Par ($) | 1,000.00 | |
| Years to maturity | 100 | |
| Annual coupon rate | 6.50% | |
| Coupons per year | 2 | Price |
| Yield to maturity | 4.0% | |
| Yield to maturity | 6.0% | |
| Yield to maturity | 8.0% |
KFA is evaluating a project with the following cash flows in the first 4 years: $4,000, $5,000, $6,000, and $7,000. Use an 8.0% discount rate to calculate the project's net present values (NPV) for three potential initial investments: $11,000 (scenario 1), $13,000 (scenario 2), and $15,000 (scenario 3). Assume no residual value.
| Input: | Output: | Scenario | ||||
| Cash Inflows: | 1 | 2 | 3 | |||
| Year 1 | 4,000.00 | Start | ||||
| Year 2 | 5,000.00 | Year 1 | ||||
| Year 3 | 6,000.00 | Year 2 | ||||
| Year 4 | 7,000.00 | Year 3 | ||||
| Discount rate | 8.0% | Year 4 | ||||
| Initial cost: | ||||||
| Scenario 1 | 11,000.00 | NPV | ||||
| Scenario 2 | 13,000.00 | |||||
| Scenario 3 | 15,000.00 | |||||
In: Finance
Suppose you inherited a building from your great aunt which you now own outright (e.g., you have complete ownership without any outstanding debt). If this building is 200,000 SF, rents for $12 per square foot per year, is expected to be on average 5% vacant, and costs $5 per occupied SF per year to operate, what is the expected Before-Tax Cash Flow for the building?
answer
$1,330,000
Now, you decide to complete some renovations on the building described in question 2. If the renovation costs $2,510,006, which you can finance with a 15-year FRM mortgage with payments due annually offered at 10% annual interest, how much more would you need to charge in rent for the Before-Tax Cash Flow to remain the same as it did in question 2?
Group of answer choices
~$1.74 /sf/year more
~$2.24 /sf/year more
~$3.03 /sf/year more
~$2.09/sf/year more
In: Finance