DISCUSSION QUESTION 1-1
MF620: Financial Statement Development and Analysis
Lesson 1: Sizing-up a Business
Upon completion of the Required Readings, write a thorough, well-planned narrative answer to the following discussion question. Rely on your Required Readings and the Lecture and Research Update for specific information to answer the discussion question, but turn to your original thoughts when asked to apply, evaluate, analyze, or synthesize the information. Your Discussion Question response should be both grammatically and mechanically correct, and formatted in the same fashion as the question itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your responses and document in a bibliography using APA style.
Discussion Question 1 (50 points)
Respond to the following:
1. Explain how the cash flow cycle works.
2. Describe how financial management is related to accounting.
3. How do sole proprietorships, general partnerships, limited liability companies, S corporations, and C corporations differ?
4. Suppose three optometrists wished to form a business that was expected to last until the oldest one was about to retire. The three had known each other since college and were close friends who trusted one another. What type of firm might be appropriate? Why?
DISCUSSION QUESTION 1-2
MF620: Financial Statement Development and Analysis
Lesson 1: Sizing-up a Business
Upon completion of the Required Readings, write a thorough, well-planned narrative answer to the following discussion question. Rely on your Required Readings and the Lecture and Research Update for specific information to answer the discussion question, but turn to your original thoughts when asked to apply, evaluate, analyze, or synthesize the information. Your Discussion Question response should be both grammatically and mechanically correct, and formatted in the same fashion as the question itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your responses and document in a bibliography using APA style.
Discussion Question 2 (50 points)
Respond to the following:
1. Describe the four stages of the business cycle.
2. Describe the two hypotheses that explain the shape of the yield curve.
3. Describe the three shapes of the yield curve that tend to be associated with different business cycle stages.
4. Compare the typical profitability of a stage 2 firm versus a stage 3 firm.
5. Develop a list of factors that would result in a firm having high supply risk and high demand risk.
ACTIVITY 2
MF620 Financial Statement Development and Analysis
Lesson 2: Financial Performance
Activity 2: Financial Performance (4 pages, 100 points)
Part A Bigco's balance sheet one year ago indicated retained earnings of $450 million. This year, Bigco's net income was $35 million. It paid its preferred shareholders a dividend of $5 million and paid its common shareholders a regular dividend of $6 million, along with a special one-time dividend of $10 million. What should be the retained earnings amount on this year's balance sheet?
Part B Wholesale Lumber, Ltd. is a firm that distributes lumber to building supply and home improvement retail stores. The firm's cost of sales for the most recent year was $45 million, its beginning inventory was $16 million, and its ending inventory was $18 million. Estimate Wholesale Lumber's purchases of lumber materials for the year.
Part C Star Inc. has year 1 revenues of $80 million, net income of $9 million, assets of $65 million, and equity of $40 million, as well as year 2 revenues of $87 million, net income of $22 million, assets of $70 million, and equity of $50 million. Calculate Star's return on equity (ROE) for each year based on the DuPont method and compare it with a direct ROE measure. Next, explain why the firm's ROE changed between year 1 and year 2.
DISCUSSION QUESTION 3-1
MF620: Financial Statement Development and Analysis
Lesson 3: Assessing Future Financial Needs
Upon completion of the Required Readings, write a thorough, well-planned narrative answer to the following discussion question. Rely on your Required Readings and the Lecture and Research Update for specific information to answer the discussion question, but turn to your original thoughts when asked to apply, evaluate, analyze, or synthesize the information. Your Discussion Question response should be both grammatically and mechanically correct, and formatted in the same fashion as the question itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your responses and document in a bibliography using APA style.
Discussion Question 1 (50 points)
Calculate the following:
1. Calculate the present value (PV) of a cash inflow of $500 in one year and a cash inflow of $1,000 in five years, assuming a discount rate of 15 percent.
2. Calculate the present value (PV) of an annuity stream of five annual cash flows of $1,200, with the first cash flow received in one year, assuming a discount rate of 10 percent.
3. What is the present value of a perpetual stream of annual cash flows, with the first cash flow of $100 to be received in one year and with all subsequent cash flows growing at a rate of 3 percent, assuming a discount rate of 8 percent?
4. Consider two bonds, Bond C and Bond D, both with a yield to maturity of 10 percent and with 5 years to maturity. These are standard bonds with semiannual coupon payments. Bond C has a coupon rate of 10 percent (with semiannual coupon payments); Bond D does not pay any coupons (i.e., it a zero-coupon bond). What is the price of each bond?
5. What is the fair value today of a common share with expected annual dividends of $1.00, $1.05, and $1.10 in each of the next three years and an expected share price of $20 in three years, assuming a required return of 9 percent?
DISCUSSION QUESTION 3-2
MF620: Financial Statement Development and Analysis
Lesson 3: Assessing Future Financial Needs
Upon completion of the Required Readings, write a thorough, well-planned narrative answer to the following discussion question. Rely on your Required Readings and the Lecture and Research Update for specific information to answer the discussion question, but turn to your original thoughts when asked to apply, evaluate, analyze, or synthesize the information. Your Discussion Question response should be both grammatically and mechanically correct, and formatted in the same fashion as the question itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your responses and document in a bibliography using APA style.
Discussion Question 2 (50 points)
Calculate the following:
1. What is the payback period of a project with average annual cash outflows of $8,000, average annual cash inflows of $10,000, and an initial investment of $13,000?
2. What is the net present value of a simple one-period project with an initial investment of $12,000 and an expected net cash flow in one year of $15,000, assuming a discount rate of 8 percent?
3. What is the net present value of a project with a $40,000 initial investment and expected net cash flows of $15,000, $20,000, and $25,000 in each of the next three years, assuming an appropriate discount rate of 10 percent?
a. What is the internal rate of return for the project?
b. What is the profitability index for the project?
c. What is the payback period for the project?
d. What is the modified internal rate of return for the project if the finance rate is 10 percent and the reinvestment rate is 13 percent?
ACTIVITY 4
MF620 Financial Statement Development and Analysis
Lesson 4: Long Term Financing
Activity 4: Long Term Financing (4 pages, 100 points)
Choose a publicly traded company on which to focus, modeled on the Walmart analysis in chapter 14.
Part A Project an income statement for next year for the firm based on your assessment of revenue growth, key projected financial ratios, and any other key assumptions, making sure to justify any assumptions.
1. What is your projection for net income and how does it compare with the previous year?
2. Based on your assessment of anticipated dividends, what is your projection for a change in retained earnings?
Part B Project a balance sheet for next year for the firm based on your assessment of the change in retained earnings, key projected financial ratios, and any other key assumptions, making sure to justify any assumptions. Use external borrowing as your balancing "plug." What is your assessment of the firm's financial needs?
Part C Based on your projection of financial needs, what recommendation would you make to the firm—for example, how to meet increased financing needs or what to do with excess financial capacity?
DISCUSSION QUESTION 5-1
MF620: Financial Statement Development and Analysis
Lesson 5: Financing and Capital Structure
Upon completion of the Required Readings, write a thorough, well-planned narrative answer to the following discussion question. Rely on your Required Readings and the Lecture and Research Update for specific information to answer the discussion question, but turn to your original thoughts when asked to apply, evaluate, analyze, or synthesize the information. Your Discussion Question response should be both grammatically and mechanically correct, and formatted in the same fashion as the question itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your responses and document in a bibliography using APA style.
Discussion Question 1 (50 points)
Respond to the following:
1. Explain why a hotel company might have a higher proportion of debt in its capital structure relative to a drug company.
2. According to Modigliani and Miller (M&M), in a world of perfect capital markets, what will be the expected equity return (or cost of equity) for a firm that has a cost of capital of 10 percent, a cost of debt of 6 percent, debt valued at $1.2 million, and equity valued at $1.0 million?
3. Suppose a firm has $10 million in debt that it expects to hold in perpetuity. If the interest rate is 7 percent and the corporate tax rate is 35 percent, what is the value of the interest tax shield?
4. What is the value of an all-equity firm that: has a dividend payout ratio of 100 percent, is expected to generate net income each year (forever) of $1 million, and has a required equity return (also the ROE) of 16 percent?
DISCUSSION QUESTION 5-2
MF620: Financial Statement Development and Analysis
Lesson 5: Financing and Capital Structure
Upon completion of the Required Readings, write a thorough, well-planned narrative answer to the following discussion question. Rely on your Required Readings and the Lecture and Research Update for specific information to answer the discussion question, but turn to your original thoughts when asked to apply, evaluate, analyze, or synthesize the information. Your Discussion Question response should be both grammatically and mechanically correct, and formatted in the same fashion as the question itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your responses and document in a bibliography using APA style.
Discussion Question 2 (50 points)
Respond to the following:
1. Assume that a firm's earnings per share (EPS) are expected to be $2.00 next year and that analysts have determined that an appropriate forward-looking multiple is 15 times the projected earnings. What should the stock price be?
2. Suppose that the firm in question #1 plans to increase the proportion of debt as part of its capital structure. The projected EPS would then be $2.50. In a world with no financial distress, determine what the stock price should be and explain why in the real world the stock price would be less than that amount.
3. Calculate an EBIT breakeven between a debt firm (DF) and an all-equity firm (EF) based on the following information: DF interest = $40,000; DF number common shares = 6,000; EF number of common shares = 10,000; and tax rate = 35 percent. Check your answer by calculating the EPS for both DF and EF at the breakeven EBIT.
4. Calculate the cash flow coverage ratio based on the following information: EBIT = $540,000; depreciation and amortization = $65,000; interest payments = $180,000; principal repayment = $75,000; and tax rate = 35 percent.
5. Suppose a firm has an EBIT of $5 million, interest expenses of $2 million, depreciation expenses of $1 million, and a tax rate of 35 percent. Its bank agrees to lend up to 4 times its EBITDA. How much debt can the firm borrow from the bank?
6. Suppose an all-equity firm has a beta estimated to be 1.2. If the firm changes its capital structure such that its debt-to-equity ratio is now 0.4, what should be the revised beta estimate if it also faces a tax rate of 35 percent?
ACTIVITY 6
MF620 Financial Statement Development and Analysis
Lesson 6: Creating Value
Activity 6: Creating Value (4 pages 100 points)
Part A Estimate the free cash flows to the firm for Free Cash Inc. for each of the next three years.
Part B Free Cash Inc.'s cost of capital is estimated to be 9 percent. Free cash flows beyond year 3 are estimated to grow at an annual rate of 4 percent. Using this information and that provided in Part A, apply the growing perpetuity formula to estimate the terminal value of Free Cash Inc. as of year 3.
Part C Free Cash Inc.'s current value of existing debt is $58,996. Using this information and that provided in Parts A and B, estimate the value of the equity of Free Cash Inc. by applying the free cash flow to the firm method.
Part D Estimate Free Cash Inc.'s year 3 terminal value by applying an EV/EBITDA multiple of 8.5 times to year 3 EBITDA.
STAND-ALONE PROJECT
MF620 Financial Statement Development and Analysis
Stand-Alone Project: Target Corporation
Instructions: Target Corporation describes itself as "an upscale discounter that provides high-quality, on-trend merchandise at attractive prices in clean, spacious and guest-friendly stores." Target has over 350,000 employees and operates over 1,700 stores in the United States. The firm recently opened stores in Canada, and—like Walmart (see chapter 14 in your text)—it has an online business component. Target also offers branded proprietary credit and debit cards.
Part A Target Corporation: ROIC
For the fiscal year ending January 31, 2012, Target's EBIT was $5,322, * and its tax rate was 34.3 percent. Its short-term borrowings were $3,786, and its long-term debt was $13,697. In addition, the firm's book value of equity was $15,821.
1. Estimate Target's return on invested capital or ROIC.
2. Compare it with Walmart's. Are you surprised at the difference?
* All amounts related to Target are in millions of dollars, unless otherwise noted.
Part B Target Corporation: ROE
For the fiscal year ending January 31, 2012 (2011), Target had total revenues of (in millions) $69,865 ($67,390) and net earnings of $2,929 ($2,920). Its total assets were $46,630 ($43,705) and its equity was $15,821 ($15,487).
1. Estimate Target's return on equity (ROE) for each of these two years, using the DuPont decomposition to indicate the profit margin, the asset turnover, and the firm's financial leverage.
2. Why has the ROE changed?
3. How would you compare the ROE drivers for Walmart and Target?
Part C Target Corporation: Cost of Capital
According to its annual report, as of January 31, 2012, Target's borrowing costs averaged 4.6 percent, and its tax rate was 34.27 percent. A research report estimated Target's cost of capital at 10.5 percent. The firm had interest-bearing debt of $17,483. Moreover, Target's stock was trading at $50.81 per share, and there were 679.1 million shares outstanding. Now, let's assume Target's amount of debt is also a market value estimate of the debt. Let's also assume the current debt and equity values are at Target's optimal capital structure.
1. Based on market value estimates, what is Target's cost of capital?
2. How does it compare to Walmart's, and what explains the difference?
Part D Target Corporation: EVA
Earlier, you were provided with the information necessary to estimate Target's operating profit (EBIT) after-tax, also known as NOPAT; invested capital (the book value of equity plus interest-bearing debt); cost of capital; and market value of equity. Based on this information,
1. Estimate Target's EVA for the year that ended on January 31, 2012.
2. Was Target adding value?
3. Did Target have a positive market value added or MVA?
4. How did Target's EVA and MVA compare with Walmart's EVA and MVA?
Part E Target Corporation: EV/EBITDA Analysis
Let's suppose you forecast Target's EBIT for the year ending January 31, 2013, to be $5,352, and you forecast Target's depreciation and amortization to be $2,361. A research analyst determines that an appropriate forward-looking EV/EBITDA multiple for Target is 6.9 times. Based on this information,
1. Estimate Target's enterprise value, or EV.
2. Next, incorporating the value of Target's debt, estimate the firm's value of equity.
3. Finally, based on 679.1 million shares outstanding, estimate the intrinsic value per share and compare it with Target's stock price on January 31, 2012, of $50.81.
4. Based on this analysis, is Target's stock overvalued or undervalued?
No comments:
Post a Comment