A two-year coupon bond with a 5% coupon rate is valued at $916.79 and another two-year coupon bond with a 10% coupon rate is valued at $1,007.13. Given this information, what will be the value of a two-year bond with an 8% coupon rate? The par values of all three bonds are $1,000.
| A. |
$1,076.95 |
|
| B. |
$1,039.63 |
|
| C. |
$970.99 |
|
| D. |
$1,004.36 |
|
| E. |
$937.89 |
In: Finance
|
Walmart Income Statement For the year ended January 31, 2018 |
Walmart Income Statement For the year ended January 31, 2017 |
||||
|
Details |
2018 |
Details |
2017 |
||
|
$ |
$ |
||||
|
Total Revenue |
$500,343,000 |
Total Revenue |
$485,873,000 |
||
|
Cost of Revenue |
$373,396,000 |
Cost of Revenue |
$361,256,000 |
||
|
Gross Profit |
$126,947,000 |
Gross Profit |
$124,617,000 |
||
|
Sales, General and Admin. |
$106,510,000 |
Sales, General and Admin. |
$101,853,000 |
||
|
Operating Income |
$20,437,000 |
Operating Income |
$22,764,000 |
||
|
Add’l income/expense items |
($2,984,000) |
Add’l income/expense items |
$100,000 |
||
|
Earnings Before Interest and Tax |
$17,453,000 |
Earnings Before Interest and Tax |
$22,864,000 |
||
|
Interest Expense |
$2,330,000 |
Interest Expense |
$2,367,000 |
||
|
Earnings Before Tax |
$15,123,000 |
Earnings Before Tax |
$20,497,000 |
||
|
Income Tax |
$4,600,000 |
Income Tax |
$6,204,000 |
||
|
Minority Interest |
($661,000) |
Minority Interest |
($650,000) |
||
|
Net Income-Cont. Operations |
$9,862,000 |
Net Income-Cont. Operations |
$13,643,000 |
||
|
Net Income- |
$9,862,000 |
Net Income- |
$13,643,000 |
||
|
Net Income-Applicable to Common Shareholders |
$9,862,000 |
Net Income-Applicable to Common Shareholders |
$13,643,000 |
|
Target Income Statement For the year ended February 23, 2018 |
Target Income Statement For the year ended January 28, 2017 |
||||
|
Details |
2018 |
Details |
2017 |
||
|
$ |
$ |
||||
|
Total Revenue |
$71,879,000 |
Total Revenue |
$69,495,000 |
||
|
Cost of Revenue |
$51,125,000 |
Cost of Revenue |
$49,145,000 |
||
|
Gross Profit |
$20,754,000 |
Gross Profit |
$20,350,000 |
||
|
Sales, General and Admin. |
$14,248,000 |
Sales, General and Admin. |
$13,356,000 |
||
|
Other Operating Items |
$2,194,000 |
Other Operating Items |
$2,025,000 |
||
|
Operating Income |
$4,312,000 |
Operating Income |
$4,969,000 |
||
|
Add’l income/expense items |
0 |
Add’l income/expense items |
0 |
||
|
Earnings Before Interest and Tax |
$4,312,000 |
Earnings Before Interest and Tax |
$4,969,000 |
||
|
Interest Expense |
$666,000 |
Interest Expense |
$1,004,000 |
||
|
Earnings Before Tax |
$3,646,000 |
Earnings Before Tax |
$3,965,000 |
||
|
Income Tax |
$718,000 |
Income Tax |
$1,296,000 |
||
|
Minority Interest |
0 |
Minority Interest |
0 |
||
|
Net Income-Cont. Operations |
$2,928,000 |
Net Income-Cont. Operations |
$2,669,000 |
||
|
Net Income |
$2,934,000 |
Net Income |
$2,737,000 |
||
|
Net Income-Applicable to Common Shareholders |
$2,934,000 |
Net Income- |
$2,737,000 |
|
Target Balance Sheet For the year ended February 3, 2018 |
Target Balance Sheet For the year ended January 28, 2017 |
Target Balance Sheet For the year ended January 30, 2016 |
||||
|
Details |
2018 |
Details |
2017 |
Details |
2016 |
|
|
$ |
$ |
$ |
||||
|
Cash and Cash Equivalents |
$2,643,000 |
Cash and Cash Equivalents |
$2,512,000 |
Cash and Cash Equivalents |
$4,046,000 |
|
|
Short-Term Investments |
0 |
Short-Term Investments |
0 |
Short-Term Investments |
0 |
|
|
Net Receivables |
0 |
Net Receivables |
0 |
Net Receivables |
0 |
|
|
Inventory |
$8,657,000 |
Inventory |
$8,309,000 |
Inventory |
$8,601,000 |
|
|
Other Current Assets |
$1,264,000 |
Other Current Assets |
$1,169,000 |
Other Current Assets |
$1,483,000 |
|
|
Total Current Assets |
$12,564,000 |
Total Current Assets |
$11,990,000 |
Total Current Assets |
$14,130,000 |
|
|
Long-Term Investments |
0 |
Long-Term Investments |
0 |
Long-Term Investments |
0 |
|
|
Fixed Assets |
$25,018,000 |
Fixed Assets |
$24,658,000 |
Fixed Assets |
$25,217,000 |
|
|
Goodwill |
0 |
Goodwill |
0 |
Goodwill |
0 |
|
|
Intangible Assets |
0 |
Intangible Assets |
0 |
Intangible Assets |
0 |
|
|
Other Assets |
$1,417,000 |
Other Assets |
$783,000 |
Other Assets |
$915,000 |
|
|
Deferred Asset Charges |
0 |
Deferred Asset Charges |
0 |
Deferred Asset Charges |
0 |
|
|
Total Assets |
$38,999,000 |
Total Assets |
$37,431,000 |
Total Assets |
$40,262,000 |
|
|
Current Liabilities |
Current Liabilities |
Current Liabilities |
||||
|
Accounts Payable |
$12,931,000 |
Accounts Payable |
$10,989,000 |
Accounts Payable |
$11,654,000 |
|
|
Short-Term Debt / Current Portion of Long-Term Debt |
$270,000 |
Short-Term Debt / Current Portion of Long-Term Debt |
$1,718,000 |
Short-Term Debt / Current Portion of Long-Term Debt |
$815,000 |
|
|
Other Current Liabilities |
0 |
Other Current Liabilities |
0 |
Other Current Liabilities |
$153,000 |
|
|
Total Current Liabilities |
$13,201,000 |
Total Current Liabilities |
$12,707,000 |
Total Current Liabilities |
$12,622,000 |
|
|
Long-Term Debt |
$11,317,000 |
Long-Term Debt |
$11,031,000 |
Long-Term Debt |
$11,945,000 |
|
|
Other Liabilities |
$2,059,000 |
Other Liabilities |
$1,879,000 |
Other liabilities |
$1,915,000 |
|
|
Deferred Liability Charges |
$713,000 |
Deferred Liability Charges |
$861,000 |
Deferred Liability Charges |
$823,000 |
|
|
Minority Interest |
0 |
Minority Interest |
0 |
Minority Interest |
0 |
|
|
Total Liabilities |
$27,290,000 |
Total Liabilities |
$26,478,000 |
Total Liabilities |
$27,305,000 |
|
|
Stock Holders’ Equity |
Stock Holders’ Equity |
Stock Holders’ Equity |
||||
|
Common Stocks |
$45,000 |
Common Stocks |
$46,000 |
Common Stocks |
$50,000 |
|
|
Capital Surplus |
$5,858,000 |
Capital Surplus |
$5,661,000 |
Capital Surplus |
$5,348,000 |
|
|
Retained Earnings |
$6,553,000 |
Retained Earnings |
$5,884,000 |
Retained Earnings |
$8,188,000 |
|
|
Other Equity |
($747,000) |
Other Equity |
($638,000) |
Other Equity |
($629,000) |
|
|
Total Equity |
$11,709,000 |
Total Equity |
$10,953,000 |
Total Equity |
$12,957,000 |
|
|
Total Liabilities & Equity |
$38,999,000 |
Total Liabilities & Equity |
$37,431,000 |
Total Liabilities & Equity |
$40,262,000 |
1. Restructuring activities: Have the companies restructured operations in the last three years?
a) Determine the amount of the expense on the income statement?
b) Are other close competitors also restructuring during this time period?
c) Find the restructuring liability on the balance sheet, does the liability seem reasonable over time?
d) Are there significant reversals of prior accruals? This might indicate shifting.
In: Accounting
|
Walmart Income Statement For the year ended January 31, 2018 |
Walmart Income Statement For the year ended January 31, 2017 |
||||
|
Details |
2018 |
Details |
2017 |
||
|
$ |
$ |
||||
|
Total Revenue |
$500,343,000 |
Total Revenue |
$485,873,000 |
||
|
Cost of Revenue |
$373,396,000 |
Cost of Revenue |
$361,256,000 |
||
|
Gross Profit |
$126,947,000 |
Gross Profit |
$124,617,000 |
||
|
Sales, General and Admin. |
$106,510,000 |
Sales, General and Admin. |
$101,853,000 |
||
|
Operating Income |
$20,437,000 |
Operating Income |
$22,764,000 |
||
|
Add’l income/expense items |
($2,984,000) |
Add’l income/expense items |
$100,000 |
||
|
Earnings Before Interest and Tax |
$17,453,000 |
Earnings Before Interest and Tax |
$22,864,000 |
||
|
Interest Expense |
$2,330,000 |
Interest Expense |
$2,367,000 |
||
|
Earnings Before Tax |
$15,123,000 |
Earnings Before Tax |
$20,497,000 |
||
|
Income Tax |
$4,600,000 |
Income Tax |
$6,204,000 |
||
|
Minority Interest |
($661,000) |
Minority Interest |
($650,000) |
||
|
Net Income-Cont. Operations |
$9,862,000 |
Net Income-Cont. Operations |
$13,643,000 |
||
|
Net Income- |
$9,862,000 |
Net Income- |
$13,643,000 |
||
|
Net Income-Applicable to Common Shareholders |
$9,862,000 |
Net Income-Applicable to Common Shareholders |
$13,643,000 |
|
Target Income Statement For the year ended February 23, 2018 |
Target Income Statement For the year ended January 28, 2017 |
||||
|
Details |
2018 |
Details |
2017 |
||
|
$ |
$ |
||||
|
Total Revenue |
$71,879,000 |
Total Revenue |
$69,495,000 |
||
|
Cost of Revenue |
$51,125,000 |
Cost of Revenue |
$49,145,000 |
||
|
Gross Profit |
$20,754,000 |
Gross Profit |
$20,350,000 |
||
|
Sales, General and Admin. |
$14,248,000 |
Sales, General and Admin. |
$13,356,000 |
||
|
Other Operating Items |
$2,194,000 |
Other Operating Items |
$2,025,000 |
||
|
Operating Income |
$4,312,000 |
Operating Income |
$4,969,000 |
||
|
Add’l income/expense items |
0 |
Add’l income/expense items |
0 |
||
|
Earnings Before Interest and Tax |
$4,312,000 |
Earnings Before Interest and Tax |
$4,969,000 |
||
|
Interest Expense |
$666,000 |
Interest Expense |
$1,004,000 |
||
|
Earnings Before Tax |
$3,646,000 |
Earnings Before Tax |
$3,965,000 |
||
|
Income Tax |
$718,000 |
Income Tax |
$1,296,000 |
||
|
Minority Interest |
0 |
Minority Interest |
0 |
||
|
Net Income-Cont. Operations |
$2,928,000 |
Net Income-Cont. Operations |
$2,669,000 |
||
|
Net Income |
$2,934,000 |
Net Income |
$2,737,000 |
||
|
Net Income-Applicable to Common Shareholders |
$2,934,000 |
Net Income- |
$2,737,000 |
1. Revenue recognition: On the income statement we must assess it on a quantitative and qualitive basis.
a) Use horizontal analysis to identify any time trends.
b) Compare the horizontal analysis of the two companies, what are the differences if any?
c) Consider the current economic environment and the companies’ competitive landscape. Given that they operate in the same industry, do they have similar revenues?
In: Accounting
1) a year ago you purchased a $1000 face value bond for $989. A year later you sold the bond for $981 after receiving a coupon payment for $53. What was your rate of capital gain?
2) A banker must earn at least a 4.8% return after expected inflation on short term loans. The inflation rate for the past 6 months has averaged 5.1%. The expected inflation rate for the next twelve months is 7.8%. Nominal interest rates for short term loans were 8.2% last month. What is the minimum nominal interest rate that he should charge for a one year loan?
3) A $5000 face value bond maturing in 4 years has a coupon rate of 4.1 percent. What is the coupon payment?
4) A $1080 face value bond is selling in the market place for $926. It matures in 3 years. If keep to maturity, what is the bond's yield to maturity?
In: Finance
|
Revenue |
YR 2020 |
YR 2021 |
YR 2022 |
|
|
ABC Ltd |
2138935.4 |
2117546.05 |
1905791.44 |
|
|
XYZ Ltd |
2595389.4 |
2465619.93 |
1232809.97 |
|
|
Expense |
YR 2020 |
YR 2021 |
YR 2022 |
|
|
ABC Ltd |
42821.1 |
29974.77 |
20982.339 |
|
|
XYZ Ltd |
2116066.4 |
1481246.48 |
1036872.54 |
|
|
Dividend |
YR 2020 |
YR 2021 |
YR 2022 |
|
|
ABC Ltd |
397200 |
297900 |
223425 |
|
|
XYZ Ltd |
296243.64 |
293281.204 |
290348.392 |
In: Finance
Lockheed Corporation reported EBITDA of $4,000 million in the year just ended (year 0), prior to interest expenses of $1,000 million and depreciation charges of $600 million. Capital expenditures in the year just ended amounted to $1,000 million, and working capital was 8% of revenues (which was $20,000 million). The tax rate for the firm was 40%.
The firm had debt outstanding of $18.00 billion (in book value terms), trading at a market value of $20.0 billion and yield a pre-tax interest rate of 8%.
There were 100 million shares outstanding, trading at $250 per share, and the most recent beta was 1.20. The Treasury bond rate was 3%, and the market risk premium was 6.5%.
The firm expected revenues, earnings (EBITDA) and depreciation to grow at 10% a year from the current year (year 0) to year 3, after which the growth rate was expected to drop to 3% a year forever.
Capital expenditures will also grow at 10% a year from year 0 to year 3, but capital spending will be 120% of depreciation in the steady state period. The company also planned to lower its debt/equity ratio to 60% for the steady state which will result in the pretax interest rate dropping to 6%. As a result of the lowering of the firm’s debt/equity ratio, the beta of the firm is also expected to decline.
|
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
|
|
Growth Rate |
|||||
|
EBITDA |
|||||
|
Depreciation |
|||||
|
EBIT |
|||||
|
Taxes |
|||||
|
EBIT(1-T) |
|||||
|
Capital Expenditures |
|||||
|
Revenues |
|||||
|
Working Capital Required |
|||||
|
Change in Working Capital |
|||||
|
Free Cash Flow to Firm |
WACC Before Year 3 =
Cost of Equity After Year 3 =
WACC After Year 3 =
In: Finance
You plan to retire in year 20
Your retirement will last 25 years starting in year 21
You want to have $50,000 each year of your retirement.
How much would you have to invest each year, starting in one year,
for 15 years , to exactly pay for your retirement ,if your
investments earn 6.00% APR (compounded annually)?
In: Finance
The following transactions pertain to Year 1, the first-year operations of Rooney Company. All inventory was started and completed during Year 1. Assume that all transactions are cash transactions.
Acquired $4,600 cash by issuing common stock.
Paid $680 for materials used to produce inventory.
Paid $1,800 to production workers.
Paid $848 rental fee for production equipment.
Paid $100 to administrative employees.
Paid $117 rental fee for administrative office equipment.
Produced 320 units of inventory of which 220 units were sold at a price of $13 each.
Required
Prepare an income statement and a balance sheet in accordance with GAAP.
In: Accounting
An investment offers €10,000 per year for 15 years, with the first payment occurring one year from now. If the required return is 10 per cent,
a) What is the value of the investment?
b) What would the value be if the payments occurred for 50 years?
c) For ever?
In: Finance
Lockheed Corporation reported EBITDA of $4,000 million in the year just ended (year 0), prior to interest expenses of $1,000 million and depreciation charges of $600 million. Capital expenditures in the year just ended amounted to $1,000 million, and working capital was 8% of revenues (which was $20,000 million). The tax rate for the firm was 40%.
The firm had debt outstanding of $18.00 billion (in book value terms), trading at a market value of $20.0 billion and yield a pre-tax interest rate of 8%.
There were 100 million shares outstanding, trading at $250 per share, and the most recent beta was 1.20. The Treasury bond rate was 3%, and the market risk premium was 6.5%.
The firm expected revenues, earnings (EBITDA) and depreciation to grow at 10% a year from the current year (year 0) to year 3, after which the growth rate was expected to drop to 3% a year forever.
Capital expenditures will also grow at 10% a year from year 0 to year 3, but capital spending will be 120% of depreciation in the steady state period. The company also planned to lower its debt/equity ratio to 60% for the steady state which will result in the pretax interest rate dropping to 6%. As a result of the lowering of the firm’s debt/equity ratio, the beta of the firm is also expected to decline.
|
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
|
|
Growth Rate |
|||||
|
EBITDA |
|||||
|
Depreciation |
|||||
|
EBIT |
|||||
|
Taxes |
|||||
|
EBIT(1-T) |
|||||
|
Capital Expenditures |
|||||
|
Revenues |
|||||
|
Working Capital Required |
|||||
|
Change in Working Capital |
|||||
|
Free Cash Flow to Firm |
Cost of Equity Before Year 3 =
WACC Before Year 3 =
Cost of Equity After Year 3 =
WACC After Year 3 =
|
Year |
1 |
2 |
3 |
|
Free Cash Flow to Firm |
Lockheed has $800 million in cash, and it also owns 10% of the stock of ABC Corporation. ABC Corporation has 100 million shares outstanding, and its shares are trading at $50/share. Estimate the Intrinsic Value of Equity and estimate the current share price of Lockheed.
In: Finance