Questions
3. Income statement The income statement, also known as the profit and loss (P&L) statement, provides...

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 Year 2, if Cute Camel has 10,000 shares of preferred stock issued and outstanding, then each preferred share should expect to receive   in annual dividends.
If Cute Camel has 500,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.
Cute Camel’s before interest, taxes, depreciation and amortization (EBITDA) value changed from   in Year 1 to   in Year 2.
It is   to say that Cute Camel’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. This is because   of the item reported in the income statement involve payments and receipts of cash.

In: Finance

KFA is considering investing in a new drone technology costing $12 million. It has a 5...

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

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

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

Describe the different types of indirect investments available to investors. Explain why this type of investment...

Describe the different types of indirect investments available to investors. Explain why this type of investment is a better alternative for some investors than buying securities directly.

In: Finance

A bank has issued a six-month, $2.0 million negotiable CD with a 0.50 percent quoted annual...

A bank has issued a six-month, $2.0 million negotiable CD with a 0.50 percent quoted annual interest rate (iCD, sp).

a. Calculate the bond equivalent yield and the EAR on the CD.
b. How much will the negotiable CD holder receive at maturity?
c. Immediately after the CD is issued, the secondary market price on the $2 million CD falls to $1,998,500. Calculate the new secondary market quoted yield, the bond equivalent yield, and the EAR on the $2.0 million face value CD.

Use 365 days in a year

In: Finance

You are bullish on Amazon’s stock (AMZN) which is currently selling for $1596.50. You have decided...

You are bullish on Amazon’s stock (AMZN) which is currently selling for $1596.50. You have decided to buy a 6-month call option with a strike price of $1,625. It costs $50.60 per share to buy the option. Assume the 6-month risk-free rate is 1% per annum with continuous compounding. a.Draw the profit and payoff function for the long call option at expiration? (Provide labels for the axes and label a point on the functions above, below and at the strike) b.Note each contract is for 100 call options. Calculate what the payoff and profit at expiration is if the spot price is _______.

i.$1,550

ii.$1,700

iii.$1,675.60

c.Draw the profit and payoff function for the short call option at expiration? (Provide labels for the axes and label a point on the functions above, below and at the strike)

In: Finance

Martin Enterprises needs someone to supply it with 133,000 cartons of machine screws per year to...

Martin Enterprises needs someone to supply it with 133,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $950,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. You estimate that, in five years, this equipment can be salvaged for $109,000. Your fixed production costs will be $525,000 per year, and your variable production costs should be $18.15 per carton. You also need an initial investment in net working capital of $106,000. If your tax rate is 23 percent and you require a return of 11 percent on your investment.

A. Assuming the price per carton is $27.60, what is the NPV of this project?

B. Assuming the price per carton is $27.60, find the quantity of cartons per year you can supply and still break even.

C. Assuming the price per carton is $27.60, find the highest level of fixed costs you could afford each year and still break even.

In: Finance

The current spot price of Amazon stock is $1,823 the current 1-year forward price is $1,944....

The current spot price of Amazon stock is $1,823 the current 1-year forward price is $1,944. The current 1-year risk free rate is 6.5% per annum with semiannual compounding. If there is a $20 transaction fee for the combination of all transactions made, paid today, can you make an arbitrage profit with 100 shares? If there is an arbitrage how much would you make? Otherwise prove that there is not an arbitrage.

In: Finance

Olsen Outfitters Inc. believes that its optimal capital structure consists of 70% common equity and 30%...

Olsen Outfitters Inc. believes that its optimal capital structure consists of 70% common equity and 30% debt, and its tax rate is 40%. Olsen must raise additional capital to fund its upcoming expansion. The firm will have $5 million of retained earnings with a cost of rs = 15%. New common stock in an amount up to $7 million would have a cost of re = 19%. Furthermore, Olsen can raise up to $3 million of debt at an interest rate of rd = 11% and an additional $3 million of debt at rd = 13%. The CFO estimates that a proposed expansion would require an investment of $7.8 million. What is the WACC for the last dollar raised to complete the expansion? Round your answer to two decimal places.

In: Finance

What exactly is the capital structure of an organization? Additionally, what do we mean by the...

What exactly is the capital structure of an organization? Additionally, what do we mean by the cost of capital? When considering capital projects, are there ways of measuring risks and costs associated?

In: Finance

2018 2017 Sales, ST Invest, Notes Pay, LT Debt factor increase 1.10 Sales $7,000 Operating costs...

 
2018 2017
Sales, ST Invest, Notes Pay, LT Debt factor increase 1.10 Sales $7,000
Operating costs as % of sales 77.50% Cash as % of sales 1.20%
Cash factor increase 1.15 Accts Rec as % of sales 11.00%
Accts. Rec factor increase 1.25 Inventory as % of sales 21.00%
Inventory factor increase 1.15 Net Plant & Equip as % of sales 28.00%
Net Plant & Equip factor increase 1.25 Accts Pay as % of sales 6.00%
Accts Pay factor increase 1.20 Accruals as % of Sales 6.00%
Accruals factor increase 1.15
Operating cost as % of sales 85.00%
Depreciation as % of Net Plant & Equip 10.00% Depreciation as % of Net Plant & Equip 10.00%
Interest rate 10.00% Interest rate 10.00%
Tax rate 40.00% Tax rate 40.00%
Payout rate 90.00% Payout rate 80.00%
Short-term investments as % of sales 0.50%
Notes payable as % of sales 2.00%
Long-term debt as % of sales 20.00%
Retained earnings multiple factor 1.50
Income Statements: 2018 2017
Sales $7,700.0 $7,000.0
Operating costs excluding depreciation 5,967.5 5,950.0
Depreciation and amortization 245.0 196.0
Earnings before interest and taxes $1,487.5 $854.0
Less interest 165.6 150.5
Pre-tax income $1,322.0 $703.5
Taxes 528.8 281.4
Net income available to common stockholders $793.2 $422.1
Common dividends $713.9 $337.7
Balance Sheets: 2018 2017
Assets
Cash $96.6 $84.0
Short-term investments 38.5 35.0
Accounts receivable 962.5 770.0
Inventories 1,690.5 1,470.0
Total current assets $2,788.1 $2,359.0
Net plant and equipment 2,450.0 1,960.0
Total assets $5,238.1 $4,319.0
Liabilities and Equity
Accounts payable $504.0 $420.0
Accruals 483.0 420.0
Notes payable 154.0 140.0
Total current liabilities $1,141.0 $980.0
Long-term debt 1,540.0 1,400.0
Total liabilities $2,681.0 $2,380.0
Common stock 2,351.2 1,812.4
Retained earnings 205.9 126.6
Total common equity $2,557.1 $1,939.0
Total liabilities and equity $5,238.1 $4,319.0
  1. What is the net operating profit after taxes (NOPAT) for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to one decimal place.

    $   million

  2. What are the amounts of net operating working capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.

    2018 $   million

    2017 $   million

  3. What are the amounts of total net operating capital for both years? Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.

    2018 $   million

    2017 $   million

  4. What is the free cash flow for 2018? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answer to one decimal place.

    $   million

  5. What is the ROIC for 2018? Round your answer to one decimal places.

    %

  6. How much of the FCF did Rhodes use for each of the following purposes: after-tax interest, net debt repayments, dividends, net stock repurchases, and net purchases of short-term investments? (Hint: Remember that a net use can be negative.) Enter your answers in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Do not round intermediate calculations. Round your answers to one decimal place.

    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

You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where...

You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during the year but paid $800,000 in dividends to common shareholders. Throughout the year, the firm purchased $5.4 million of machinery that was needed for a new project. You have just spoken to the firm's accountants and learned that annual depreciation expense for the year is $440,000; however, the purchase price for the machinery represents additions to property, plant, and equipment before depreciation. Finally, you have determined that the only financing done by the firm was to issue long-term debt of $1 million at a 6% interest rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet What was the firm's end-of-year cash balance? Recreate the firm's cash flow statement to arrive at your answer. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar, if necessary. $

In: Finance

Using the historical financial statement information provided for KAJ Manufacturing, calculate the 20X4 to 20X5 percentage...

Using the historical financial statement information provided for KAJ Manufacturing, calculate the 20X4 to 20X5 percentage changes for these income statement items:
AMOUNTS in MILLIONS
Fiscal Year Ended
December 31,20X5 December 31, 20X4
Sales $31,037 $25,333
Net Income $1,792

$1,398

a. Sales
b. Net Income

In: Finance

What is the connection between the value of shares and dividends? How are they both different?

What is the connection between the value of shares and dividends? How are they both different?

In: Finance