Questions
(Related to Checkpoint 13.2 and Checkpoint​ 13.3) ​ (Comprehensive risk​ analysis) Blinkeria is considering introducing a...

(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

A retail shopping center is purchased for $2.1 million. During the next five yearsthe property appreciates...

A retail shopping center is purchased for $2.1 million. During the next five yearsthe property appreciates at 2 percent per year. At the time of purchase, the property is financed with a 70 percent loan-to-value ratio for 25 years at 6 percent (annual) with monthly amortization. At the end of year 5, the property is sold with 4 percent selling expenses. What is the before-tax equity reversion?
A. 804,192
B. 826,937
C.860,182
D.870,581
E.903,825

In: Finance

Forecasted Statements and Ratios Upton Computers makes bulk purchases of small computers, stocks them in conveniently...

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.

  1. If sales are projected to increase by $70 million, or 31.11%, during 2017, use the AFN equation to determine Upton's projected external capital requirements. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places.
    $ million
  2. Using the AFN equation, determine Upton's self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? Round your answer to two decimal places.
    %
  3. Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2017. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt).
    Assume Upton's profit margin and dividend payout ratio will be the same in 2017 as they were in 2016. What is the amount of the line of credit reported on the 2017 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credit is taken out on last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2017 addition to retained earnings for the balance sheet without actually constructing a full income statement.) Round your answers to the nearest cent.
    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...

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...

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 ?

How are financial institutions profitable from risk management ?

In: Finance

Broussard Skateboard sales are expected to increase by 15% from $7.6 million in 2016 to $8.74...

Broussard Skateboard sales are expected to increase by 15% from $7.6 million in 2016 to $8.74 million in 2017. Its assets totaled $5 million at the end of 2016. Broussard is already at full capacity so its assets must grow at the same rate as projected sales. At the end of 2016 current liabilities were $1.4 million consisting of $450000 of accounts payable $500000 of notes payable and $450000 of accruals. The after tax profit margin is forecasted to be 6%. Assume that the company pays no dividends. What would be the additional funds needed for the coming year?

In: Finance

A. What is the value today of a money machine that will pay $1,385.00 per year...

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...

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.

  1. What was net operating working capital for 2018 and 2019? Assume the firm has no excess cash.

    2018:  $   

    2019:  $   

  2. What was the 2019 free cash flow?

    $   

  3. How would you explain the large increase in 2019 dividends?

    1. The large increase in net income from 2018 to 2019 explains the large increase in 2019 dividends.
    2. The large increase in EBIT from 2018 to 2019 explains the large increase in 2019 dividends.
    3. The large increase in sales from 2018 to 2019 explains the large increase in 2019 dividends.
    4. The large increase in retained earnings from 2018 to 2019 explains the large increase in 2019 dividends.
    5. The large increase in free cash flow from 2018 to 2019 explains 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...

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...

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...

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...

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
  1. 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: $ ?

  2. What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places.

    Project A: ? %

    Project B: ? %

  3. 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: ? %

  4. 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.

  5. Discount Rate NPV Project A NPV Project B
    0% $ ? $ ?
    5 ? ?
    10 ? ?
    12 ? ?
    15 ? ?
    18.1 ? ?
    24.18 ? ?
  6. Calculate the crossover rate where the two projects' NPVs are equal. Do not round intermediate calculations. Round your answer to two decimal places.

    ? %

  7. 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...

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.

  1. Calculate the project's NPV. Negative value, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest cent.
    $   

    Calculate the project's IRR. Do not round intermediate calculations. Round your answer to two decimal places.
      %

    Calculate the project's MIRR. Do not round intermediate calculations. Round your answer to two decimal places.
      %

    Calculate the project's payback. Do not round intermediate calculations. Round your answer to two decimal places.
      years

  2. Assume management is unsure about the $90,000 cost savings-this figure could deviate by as much as plus or minus 20%. What would the NPV be under each of these situations? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent.
    20% savings increase: $   
    20% savings decrease: $   

In: Finance

Glitter Inc. uses one-quarter common stock and three-quarters debt to finance their operations. The after-tax cost...

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