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
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 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 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 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 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% 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 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 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 |
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
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
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
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
What is the ROIC for 2018? Round your answer to one decimal places.
%
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 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 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?
In: Finance