(Related to Checkpoint 13.2 and Checkpoint 13.3) (Comprehensive risk analysis) Blinkeria is considering introducing a new line of hand scanners that can be used to copy material and then download it into a personal computer. These scanners are expected to sell for an average price of $95 each, and the company analysts performing the analysis expect that the firm can sell 105,000 units per year at this price for a period of five years, after which time they expect demand for the product to end as a result of new technology. In addition, variable costs are expected to be $18 per unit and fixed costs, not including depreciation, are forecast to be $1,100,000 per year. To manufacture this product, Blinkeria will need to buy a computerized production machine for $9.1 million that has no residual or salvage value, and will have an expected life of five years. In addition, the firm expects it will have to invest an additional $304,000 in working capital to support the new business. Other pertinent information concerning the business venture is provided here:
Initial cost of the machine $9,100,000
Expected life 5 years
Salvage value of the machine $0
Working capital requirement $304,000
Depreciation method straight line
Depreciation expense $1,820,000 per year
Cash fixed costs—excluding depreciation $1,100,000 per
year
Variable costs per unit $18
Required rate of return or cost of capital 9.1%
Tax rate 34%
a. Calculate the project's NPV.
b. Determine the sensitivity of the project's NPV to a(n) 8 percent decrease in the number of units sold.
c. Determine the sensitivity of the project's NPV to a(n) 8 percent decrease in the price per unit.
d. Determine the sensitivity of the project's NPV to a(n) 8 percent increase in the variable cost per unit.
e. Determine the sensitivity of the project's NPV to a(n) 8 percent increase in the annual fixed operating costs.
f. Use scenario analysis to evaluate the project's NPV under worst- and best-case scenarios for the project's value drivers. The values for the expected or base-case along with the worst- and best-case scenarios are listed here:
Expected or Base Case Worst
Case Best Case
Unit sales 105,000 72,450
137,550
Price per unit $95 $83.60
$112.10
Variable cost per unit $(18)
$(19.80) $(16.56)
Cash fixed costs per year $(1,100,000)
$(1,298,000) $(1,001,000)
Depreciation expense $(1,820,000)
$(1,820,000) $(1,820,000)
In: Finance
In: Finance
Forecasted Statements and Ratios
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Upton's balance sheet as of December 31, 2016, is shown here (millions of dollars):
Cash | $ 3.5 | Accounts payable | $ 9.0 | |
Receivables | 26.0 | Notes payable | 18.0 | |
Inventories | 58.0 | Line of credit | 0 | |
Total current assets | $ 87.5 | Accruals | 8.5 | |
Net fixed assets | 35.0 | Total current liabilities | $ 35.5 | |
Mortgage loan | 6.0 | |||
Common stock | 15.0 | |||
Retained earnings | 66.0 | |||
Total assets | $122.5 | Total liabilities and equity | $122.5 |
Sales for 2016 were $225 million and net income for the year was $6.75 million, so the firm's profit margin was 3.0%. Upton paid dividends of $2.7 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2017. Do not round intermediate calculations.
Upton Computers Pro Forma Balance Sheet December 31, 2017 (Millions of Dollars) |
||
Cash | $ | |
Receivables | $ | |
Inventories | $ | |
Total current assets | $ | |
Net fixed assets | $ | |
Total assets | $ | |
Accounts payable | $ | |
Notes payable | $ | |
Line of credit | $ | |
Accruals | $ | |
Total current liabilities | $ | |
Mortgage loan | $ | |
Common stock | $ | |
Retained earnings | $ | |
Total liabilities and equity | $ |
In: Finance
Below are the most recent balance sheets for Country Kettles, Inc. Excluding accumulated depreciation, determine whether each item is a source or a use of cash, and the amount (Input all amounts as positive values): |
COUNTRY KETTLES, INC. Balance Sheet December 31, 2011 |
||||||
2010 | 2011 | |||||
Assets | ||||||
Cash | $ | 32,400 | $ | 31,690 | ||
Accounts receivable | 71,900 | 75,280 | ||||
Inventories | 62,800 | 65,375 | ||||
Property, plant, and equipment | 167,000 | 179,800 | ||||
Less: Accumulated depreciation | 47,520 | 51,900 | ||||
Total assets | $ | 286,580 | $ | 300,245 | ||
Liabilities and Equity | ||||||
Accounts payable | $ | 46,900 | $ | 49,190 | ||
Accrued expenses | 8,280 | 7,220 | ||||
Long-term debt | 27,600 | 31,000 | ||||
Common stock | 36,000 | 42,000 | ||||
Accumulated retained earnings | $ | 167,800 | $ | 170,835 | ||
Total liabilities and equity | $ | 286,580 | $ | 300,245 | ||
Item | Source/Use | Amount | ||
Cash | (Click to select)UseSource | $ | ||
Accounts receivable | (Click to select)UseSource | $ | ||
Inventories | (Click to select)SourceUse | $ | ||
Property, plant, and equipment | (Click to select)UseSource | $ | ||
Accounts payable | (Click to select)SourceUse | $ | ||
Accrued expenses | (Click to select)UseSource | $ | ||
Long-term debt | (Click to select)SourceUse | $ | ||
Common stock | (Click to select)SourceUse | $ | ||
Accumulated retained earnings | (Click to select)SourceUse | $ | ||
In: Finance
A stock is currently priced at $49.00. The risk free rate is 5.9% per annum with continuous compounding. In 8 months, its price will be $57.33 with probability 0.46 or $42.63 with probability 0.54.
Using the binomial tree model, compute the present value of your expected profit if you buy a 8 month European call with strike price $53.00. Recall that profit can be negative.
In: Finance
How are financial institutions profitable from risk management ?
In: Finance
In: Finance
A. What is the value today of a money machine that will pay $1,385.00 per year for 13.00 years? Assume the first payment is made 5.00 years from today and the interest rate is 6.00%.
B. What is the value today of a money machine that will pay $3,787.00 every six months for 29.00 years? Assume the first payment is made 4.00 years from today and the interest rate is 12.00%.
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 | $ | 2,970.0 | $ | 2,700.0 |
Operating costs excluding depreciation and amortization | 2,525.0 | 2,295.0 | ||
EBITDA | $ | 445.0 | $ | 405.0 |
Depreciation and amortization | 81.0 | 70.0 | ||
Earnings before interest and taxes (EBIT) | $ | 364.0 | $ | 335.0 |
Interest | 65.3 | 59.4 | ||
Earnings before taxes (EBT) | $ | 298.7 | $ | 275.6 |
Taxes (25%) | 119.5 | 110.2 | ||
Net income | $ | 179.2 | $ | 165.4 |
Common dividends | $ | 161.3 | $ | 132.3 |
Powell Panther Corporation: Balance Sheets as of December 31 (Millions of Dollars)
2019 | 2018 | |||
Assets | ||||
Cash and equivalents | $ | 35.0 | $ | 30.0 |
Accounts receivable | 386.0 | 297.0 | ||
Inventories | 535.0 | 486.0 | ||
Total current assets | $ | 956.0 | $ | 813.0 |
Net plant and equipment | 807.0 | 702.0 | ||
Total assets | $ | 1,763.0 | $ | 1,515.0 |
Liabilities and Equity | ||||
Accounts payable | $ | 238.0 | $ | 216.0 |
Accruals | 304.0 | 243.0 | ||
Notes payable | 59.4 | 54.0 | ||
Total current liabilities | $ | 601.4 | $ | 513.0 |
Long-term bonds | 594.0 | 540.0 | ||
Total liabilities | $ | 1,195.4 | $ | 1,053.0 |
Common stock | 500.0 | 412.3 | ||
Retained earnings | 67.6 | 49.7 | ||
Common equity | $ | 567.6 | $ | 462.0 |
Total liabilities and equity | $ | 1,763.0 | $ | 1,515.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
question 7 chapter 3
In: Finance
Describe the purposes of the antitrust laws. What are the major anti-trust statutes / Acts and their stated objectives. What penalties, if any, are available to address violations of the major antitrust laws. Explain fully.
In: Finance
Pizza di Joey operates several food trucks that provide hot food and beverages in the Washington DC area. The company has annual sales of $625,400. Cost of goods sold average 32 percent of sales and the profit margin is 4.5 percent. The average accounts receivable balance is $34,700. Assume 365 days per year. [Please show your work on an Excel sheet]
a. On average, how long does it take the company to collect payment for its services?
b. What is the change in the Payables deferral period if the payables turnover has gone from an average of 10.50 times to 11.45 times per year?
c. What is the length of the company's cash conversion cycle after the change in the Payables deferral period if the inventory turnover is 22.20 times?
In: Finance
Edmonds Industries is forecasting the following income statement:
Sales | $5,000,000 |
Operating costs excluding depreciation & amortization | 2,750,000 |
EBITDA | $2,250,000 |
Depreciation and amortization | 500,000 |
EBIT | $1,750,000 |
Interest | 300,000 |
EBT | $1,450,000 |
Taxes (25%) | 362,500 |
Net income | $1,087,500 |
The CEO would like to see higher sales and a forecasted net income of $1,970,000. Assume that operating costs (excluding depreciation and amortization) are 55% of sales and that depreciation and amortization and interest expenses will increase by 10%. The tax rate, which is 25%, will remain the same. (Note that while the tax rate remains constant, the taxes paid will change.) What level of sales would generate $1,970,000 in net income? Round your answer to the nearest dollar, if necessary.
$ _____
chapter 3 question 9
In: Finance
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows:
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Project A | -$300 | -$387 | -$193 | -$100 | $600 | $600 | $850 | -$180 |
Project B | -$400 | $133 | $133 | $133 | $133 | $133 | $133 | $0 |
What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent.
Project A: $ ?
Project B: $ ?
What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places.
Project A: ? %
Project B: ? %
What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations. Round your answers to two decimal places.
Project A: ? %
Project B: ? %
Construct NPV profiles for Projects A and B. If an amount is zero, enter 0. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent.
Discount Rate | NPV Project A | NPV Project B |
0% | $ ? | $ ? |
5 | ? | ? |
10 | ? | ? |
12 | ? | ? |
15 | ? | ? |
18.1 | ? | ? |
24.18 | ? | ? |
Calculate the crossover rate where the two projects' NPVs are equal. Do not round intermediate calculations. Round your answer to two decimal places.
? %
What is each project's MIRR at a WACC of 18%? Do not round intermediate calculations. Round your answers to two decimal places.
Project A: ? %
Project B: ? %
In: Finance
Holmes Manufacturing is considering a new machine that costs $275,000 and would reduce pretax manufacturing costs by $90,000 annually. The new machine will be fully depreciated at the time of purchase. Management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. Net operating working capital would increase by $25,000 initially, but it would be recovered at the end of the project's 5-year life. Holmes's marginal tax rate is 25%, and an 11% WACC is appropriate for the project.
In: Finance
Glitter Inc. uses one-quarter common stock and three-quarters
debt to finance their operations. The after-tax cost of debt is 7
percent and the cost of equity is 13 percent.
The management of Glitter Inc. is considering an expansion project
that costs $1.2 million. The project will produce a cash inflow of
$45,000 in the first year and 150,000 in each of the following 10
years (i.e., $150,000 in years 2 through 11.. What is the WACC and
should Glitter Inc. invest in this project?
a. 10 percent, no because the NPV is negative
b. 10 percent, yes because the NPV is positive
c. 8.5 percent, no because the NPV is negative
d. 8.5 percent, yes because the NPV is positive
HOW CAN I SOLVE IT BY HAND STEP BY STEP PLEASE
DO NOT USE EXCEL
In: Finance