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 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 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 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?
|
In: Finance
|
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., 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 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:
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.
In: Finance
. 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 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
In: Finance
|
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 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 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 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 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