Calculate the duration of a 3 year from maturity bond that has a 5.00% annual pay coupon rate and a 2.50% yield. (Use 4 decimal point precision.)
In: Finance
Individual A just turned 30 years old, have just received your MBA, and have accepted your first job. He must decide how much money to put into its retirement plan. The plan works as follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until he retires on his sixty-fifth birthday. After that point, individual A can make withdrawals as he sees fit.
Individual A decides that he will plan to live to 100 and work until hi turns 65. He estimates that to live comfortably in retirement, he'll need $100,000 per year starting at the end of the first year of retirement and ending on his one-hundredth birthday.
Individual A will contribute the same amount to the plan at the end of every year that you work.
(a) How much does Individual A need to contribute each year to fund his retirement? The situation above is not very realistic because most retirement plans do not allow you to specify a fixed amount to contribute every year. Instead, you are required to specify a fixed percentage of your salary that you want to contribute. Assume that your starting salary is $75,000 per year and it will grow 2% per year until you retire.
(b) Assuming everything else stays the same as in the previous question, what percentage of his income does he need to contribute to the plan every year to fund the same retirement income?
In: Finance
JPJ Corp has sales of $1.29 million, accounts receivable of $46,000, total assets of $5.17million(of which $3.19 million are fixed assets), inventory of $155,000, and cost of goods sold of $596,000. What are JPJ’s accounts receivable days? Fixed asset turnover? Total asset turnover? Inventory turnover?
In: Finance
What differentiates an ordinary investment from a security
In: Finance
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