Questions
Use the following tables to complete the critical thinking assignment. Best Buy Co., Inc. Income Statement...

Use the following tables to complete the critical thinking assignment.

Best Buy Co., Inc.

Income Statement

2/3/2018 1/28/2017 1/30/2016 1/31/2015
Revenue
Total Revenue 42,151,000 39,403,000 39,528,000 40,339,000
Cost of Revenue 32,275,000 29,963,000 30,334,000 31,292,000
Gross Profit 9,876,000 9,440,000 9,194,000 9,047,000
Operating Expenses
Selling General and Administrative 7,911,000 7,493,000 7,612,000 7,550,000
Operating Income or Loss 1,965,000 1,947,000 1,582,000 1,497,000
Income from Continuing Operations
Add Total Other Income/Expenses Net -148,000 -131,000 -272,000 -110,000
Interest Expense 75,000 72,000 80,000 90,000
Income Before Tax 1,742,000 1,744,000 1,230,000 1,297,000
Income Tax Expense 818,000 609,000 503,000 141,000
Add Discontinued Operations 1,000 21,000 90,000 -13,000
Net Income 925,000 1,156,000 817,000 1,143,000

Best Buy Co., Inc.

Balance Sheet

2/3/2018 1/28/2017 1/30/2016 1/31/2015
Current Assets
Cash And Cash Equivalents 1,101,000 2,240,000 1,976,000 2,432,000
Short Term Investments 2,196,000 1,848,000 1,384,000 1,539,000
Net Receivables 1,049,000 1,347,000 1,162,000 1,280,000
Inventory 5,209,000 4,864,000 5,051,000 5,174,000
Other Current Assets 274,000 217,000 313,000 1,047,000
Total Current Assets 9,829,000 10,516,000 9,886,000 11,472,000
Long Term Investments 0 13,000 27,000 3,000
Property Plant and Equipment 2,421,000 2,293,000 2,346,000 2,295,000
Goodwill 425,000 425,000 425,000 425,000
Intangible Assets 18,000 18,000 18,000 57,000
Other Assets 356,000 591,000 817,000 993,000
Deferred Long Term Asset Charges 159,000 317,000 510,000 574,000
Total Assets 13,049,000 13,856,000 13,519,000 15,245,000
Current Liabilities
Accounts Payable 4,873,000 4,984,000 4,450,000 5,030,000
Short/Current Long Term Debt 499,000 0 350,000 0
Other Current Liabilities 1,043,000 944,000 975,000 1,609,000
Total Current Liabilities 7,817,000 7,122,000 6,925,000 7,777,000
Long Term Debt 648,000 1,158,000 1,168,000 1,492,000
Other Liabilities 805,000 704,000 877,000 901,000
Total Liabilities 9,437,000 9,147,000 9,141,000 10,250,000
Stockholders' Equity
Total Stockholder Equity 3,612,000 4,709,000 4,378,000 4,995,000

Choose one of the following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission.

Option #1: Ratio Analysis and Interpretation

Using the attached financial statements for Best Buy Co., Inc. complete the financial statement analysis and ratio analysis by answering the questions below.

a. Calculate average collection period, total asset turnover, inventory turnover, and days in inventory.

b. Assess the activity of the firm, using your calculations in part a, over the four year period.

c. Calculate the gross profit margin, operating margin, and net profit margin.

d. Assess the profitability of the firm, using your calculations in part c, over the four year period.

In: Finance

A mail-order firm processes 6,000 checks per month. Of these, 70 percent are for $50 and...

A mail-order firm processes 6,000 checks per month. Of these, 70 percent are for $50 and 30 percent are for $82. The $50 checks are delayed three days on average; the $82 checks are delayed four days on average. Assume 30 days per month.

a-1. What is the average daily collection float? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

a-2. How do you interpret your answer?

b-1. What is the weighted average delay? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

b-2. Calculate the average daily float. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

c. How much should the firm be willing to pay to eliminate the float? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

d. If the interest rate is 6 percent per year, calculate the daily cost of the float. (Use 365 days a year. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

e. How much should the firm be willing to pay to reduce the weighted average float by 2 days? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

In: Finance

A 20-year maturity $1,000 par value 9% coupon bond paying coupons annually is callable in five...

A 20-year maturity $1,000 par value 9% coupon bond paying coupons annually is callable in five years at a call price of $1,050. The bond currently sells at a yield to maturity of 8%. What is the yield to call?

please show full steps of the work. thank you!!!

In: Finance

A7X Corp. just paid a dividend of $1.45 per share. The dividends are expected to grow...

A7X Corp. just paid a dividend of $1.45 per share. The dividends are expected to grow at 30 percent for the next 8 years and then level off to a growth rate of 8 percent indefinitely.

If the required return is 12 percent, what is the price of the stock today?

  • $156.07

  • $128.98

  • $149.95

  • $153.01

  • $2.05

In: Finance

Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...

Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $6.318 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $491,400. The project requires an initial investment in net working capital of $702,000. The project is estimated to generate $5,616,000 in annual sales, with costs of $2,246,400. The tax rate is 34 percent and the required return on the project is 15 percent.

  

Required:
(a) What is the project's year 0 net cash flow?
(Click to select)  -7,020,000  -6,669,000  -6,318,000  -7,722,000  -7,371,000

  

(b) What is the project's year 1 net cash flow?
(Click to select)  3,086,975  2,645,978  2,939,976  2,792,977  3,233,974

  

(c) What is the project's year 2 net cash flow?
(Click to select)  2,645,978  2,939,976  3,086,975  2,792,977  3,233,974

  

(d) What is the project's year 3 net cash flow?
(Click to select)  4,164,615  3,767,985  4,362,930  3,966,300  3,569,670

  

(e) What is the NPV?
(Click to select)  2,758,049  385,824  367,452  -1,309,807  394,627

In: Finance

Define the most important capital budgeting techniques. name at least two (2) capital budgeting techniques (e.g.,...

Define the most important capital budgeting techniques. name at least two (2) capital budgeting techniques (e.g., NPV, IRR, Payback Period, etc.) that you used to arrive investment decision.

In: Finance

WACC Estimation The following table gives the balance sheet for Travellers Inn Inc. (TII), a company...

WACC Estimation

The following table gives the balance sheet for Travellers Inn Inc. (TII), a company that was formed by merging a number of regional motel chains.

Travellers Inn: (Millions of Dollars)
Cash $10 Accounts payable $10
Accounts receivable 20 Accruals 10
Inventories 20 Short-term debt 5
    Current assets $50     Current liabilities $25
Net fixed assets 50 Long-term debt 30
Preferred stock 5
Common equity
    Common stock $10
    Retained earnings 30
        Total common equity $40
Total assets $100 Total liabilities and equity $100

The following facts also apply to TII:

  1. Short-term debt consists of bank loans that currently cost 9%, with interest payable quarterly. These loans are used to finance receivables and inventories on a seasonal basis, so bank loans are zero in the off-season.
  2. The long-term debt consists of 20-year, semiannual payment mortgage bonds with a coupon rate of 9%. Currently, these bonds provide a yield to investors of rd = 12%. If new bonds were sold, they would have a 12% yield to maturity.
  3. TII's perpetual preferred stock has a $100 par value, pays a quarterly dividend of $2.50, and has a yield to investors of 9%. New perpetual preferred stock would have to provide the same yield to investors, and the company would incur a 5% flotation cost to sell it.
  4. The company has 4 million shares of common stock outstanding. P0 = $20, but the stock has recently traded in price the range from $17 to $23. D0 = $1 and EPS0 = $2. ROE based on average equity was 24% in the most recent year, but management expects to increase this return on equity to 32%; however, security analysts and investors generally are not aware of management's optimism in this regard.
  5. Betas, as reported by security analysts, range from 1.3 to 1.7; the T-bond rate is 9%; and RPM is estimated by various brokerage houses to be in the range from 4.5% to 5.5%. Some brokerage house analysts reports forecasted dividend growth rates in the range of 10% to 15% over the foreseeable future.
  6. TII's financial vice president recently polled some pension fund investment managers who hold TII's securities regarding what minimum rate of return on TII's common would make them willing to buy the common rather than TII bonds, given that the bonds yielded 12%. The responses suggested a risk premium over TII bonds of 4 to 6 percentage points.
  7. TII is in the 30% federal-plus-state tax bracket.
  8. TII's principal investment banker predicts a decline in interest rates, with rd falling to 10% and the T-bond rate to 7%, although the bank acknowledges that an increase in the expected inflation rate could lead to an increase rather than a decrease in interest rates.

Assume that you were recently hired by TII as a financial analyst and that your boss, the treasurer, has asked you to estimate the company's WACC under the assumption that no new equity will be issued. Your cost of capital should be appropriate for use in evaluating projects that are in the same risk class as the assets TII now operates.

  1. What are the market value weights for long-term debt, preferred stock, and common stock in Travellers' capital structure? Do not round intermediate calculations. Round your answers to two decimal places.

In: Finance

. You are given the following information for Watson Power Co. Assume the company’s tax rate...

. You are given the following information for Watson Power Co. Assume the company’s tax rate is 40 percent. Debt: 8,000 6.2 percent coupon bonds outstanding, $1,000 par value, 10 years to maturity, selling for 110 percent of par; the bonds make semiannual payments. Common stock: 300,000 shares outstanding, selling for $50 per share; the beta is 1.08. Preferred stock: 12,000 shares of 7 percent preferred stock outstanding, currently selling for $70 per share. Market: 8 percent market risk premium and 4.2 percent risk-free rate. What is the company's WACC? Please do this step by step. Thank you!

In: Finance

Assume that you are nearing graduation and that you have applied for a job with a...

Assume that you are nearing graduation and that you have applied for a job with a local bank. As part of the bank’s evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions: Questions: (1) What is the future value of an initial $100 after three years if it is invested in an account paying 10% annual interest? (2) What is the present value of $100 to be received in three years if the appropriate interest rate is 10% per year? What is the difference between an ordinary annuity and an annuity due? What type of annuity is shown in the following cash flow time line? How would you change it to the other type of annuity? (1) What is the future value of a 3-year ordinary annuity of $100 if the appropriate interest rate is 10%? (2) What is the present value of the annuity? (3) What would the future and present values be if the annuity were an annuity due? (1) Define the stated, or quoted, or simple, rate, (rSIMPLE), annual percentage rate (APR), the periodic rate (rPER), and the effective annual rate (rEAR). (2) What is the effective annual rate for a simple rate of 10%, compounded semiannually? Compounded quarterly? Compounded daily? (1) Construct an amortization schedule for a $1,000 loan that has a 10%annual interest rate that is repaid in three equal installments.  

In: Finance

Please Show your work. 13. If you want to accumulate $250 after 30 years and your...

Please Show your work.
13. If you want to accumulate $250 after 30 years and your bank pays 2%, how much will you have to deposit monthly?

14. If you borrow $250 for 25 years at 6%, what will be your monthly payment?

15. If you can earn 15%, how long will it take for an investment today of $700 to grow to $5000?

16. If you save $100 monthly and your bank promises 15%, how many months will it take to accumulate $25,000?

In: Finance

The Boring Corporation is considering a 3-year project with an initial cost of $1,020,000. The project...

The Boring Corporation is considering a 3-year project with an initial cost of $1,020,000. The project will not directly produce any sales but will reduce operating costs by $640,000 a year. The equipment is depreciated straight-line to a zero book value over the life of the project. At the end of the project the equipment will be sold for an estimated $156,000. The tax rate is 34 percent. The project will require $28,000 in extra inventory for spare parts and accessories. Should this project be implemented if The Boring Corporation requires a rate of return of 16 percent? Why or why not?

Multiple Choice

  • yes; The NPV is $314,960.00

  • yes; The NPV is $370,509.74

  • no; The NPV is $272,189.10

  • yes; The NPV is $244,189.10

  • yes; The NPV is $97,042.85

Next Visit question map

Question8of10Total8 of 10

Prev

In: Finance

Paperless Exams Distributor is considering a four-year project to improve its exam production efficiency. Buying a...

Paperless Exams Distributor is considering a four-year project to improve its exam production efficiency. Buying a new exam question generator would cost $385,000. It is expected to result in $145,000 in cost savings, per year, before taxes. This piece of equipment would follow the MACRS five-year class depreciation method. Its salvage value at the end of the project is estimated at $45,000. The exam question generator also requires an immediate investment in spare parts inventory of $20,000. It will require additional $3,100 in inventory in each succeeding year of the project. The company's tax rate is 22 percent. The appropriate discount rate is 9 percent. Refer to Table 10.7.

Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
Should the company buy and install the equipment?
  • No

  • Yes

Next Visit question map

Question7of10Total7 of 10

Prev

In: Finance

1. You have a stock portfolio that consists of the following positions (price and beta as...

1. You have a stock portfolio that consists of the following positions (price and beta as of 12:34 PM on 10/21/2019):
Shares Price Beta
Amazon 25 1782.52 1.63
Apple 90 240.38 1.10
Tesla 85 253.26 0.32
Costco 75 301.62 0.93
Disney 50 130.32 0.72
(a) What is the portfolio beta? [Hint: You will need to compute the weights for each stock.]
(b) If the market return is expected to be 2.5% and the risk-free rate is 1%,
then what is the required rate of return on the portfolio?

In: Finance

Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset...

Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $1.836 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $142,800. The project requires an initial investment in net working capital of $204,000. The project is estimated to generate $1,632,000 in annual sales, with costs of $652,800. The tax rate is 32 percent and the required return on the project is 9 percent.

  

Required:
(a) What is the project's year 0 net cash flow?
(Click to select)  -1,938,000  -2,142,000  -1,836,000  -2,040,000  -2,244,000

  

(b) What is the project's year 1 net cash flow?
(Click to select)  775,526  818,611  861,696  904,781  947,866

  

(c) What is the project's year 2 net cash flow?
(Click to select)  947,866  818,611  775,526  904,781  861,696

  

(d) What is the project's year 3 net cash flow?
(Click to select)  1,220,940  1,162,800  1,104,660  1,279,080  1,046,520

  

(e) What is the NPV?
(Click to select)  -389,027  392,400  345,206  817,848  373,714

In: Finance

Which one of the following is a correct statement concerning the excess return? The lower the...

Which one of the following is a correct statement concerning the excess return?

  • The lower the average rate of return, the greater the excess return.

  • The lower the volatility of returns, the greater the expected excess return.

  • The excess return is not affected by the volatility of returns.

  • The excess return is not correlated to the average rate of return.

  • The greater the volatility of returns, the greater the expected excess return.

In: Finance