Questions
A two-year coupon bond with a 5% coupon rate is valued at $916.79 and another two-year...

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

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

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

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

Interpret the tables trend for revenue, expense & dividend year by year comparing both company? Revenue...

  1. Interpret the tables trend for revenue, expense & dividend year by year comparing both company?

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

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.

  1. Estimate the free cash flow to the firm.

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

  1. Compute the beta of the firm after Year 3.

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

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

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.

  1. Acquired $4,600 cash by issuing common stock.

  2. Paid $680 for materials used to produce inventory.

  3. Paid $1,800 to production workers.

  4. Paid $848 rental fee for production equipment.

  5. Paid $100 to administrative employees.

  6. Paid $117 rental fee for administrative office equipment.

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

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

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.

  1. Estimate the free cash flow to the firm. (40pts)

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

  1. Compute the beta of the firm after Year 3. (4pts)
  1. Determine the Cost of Equity and WACC for the Period from Year 0 to Year 3, and the Cost of Equity and WACC after Year 3. (16pts)

Cost of Equity Before Year 3 =

WACC Before Year 3 =

Cost of Equity After Year 3 =

WACC After Year 3 =

  1. Estimate the Terminal Value of the Firm in Year 3. (3pts)
  1. List the free cash flows to the firm (FCFF). FCFF in Year 3 should include the terminal value. (3pts)

Year

1

2

3

Free Cash Flow to Firm

  1. Estimate the Enterprise Value of Lockheed (value of the firm).    (4pts)

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