Chat with us, powered by LiveChat CaseStudy1week1.xlsx - STUDENT SOLUTION USA

CaseStudy1week1.xlsx

Mini Case

11/20/18
Chapter 2 Mini Case
Situation
Jenny Cochran, a graduate of The University of Tennessee with 4 years of experience as an equities analyst, was recently brought in as assistant to the chairman of the board of Computron Industries, a manufacturer of computer components.During the previous year, Computron had doubled its plant capacity, opened new sales offices outside its home territory, and launched an expensive advertising campaign. Cochran was assigned to evaluate the impact of the changes. She began by gathering financial statements and other data.
Computron's Balance Sheets (Millions of Dollars)
2018 2019
Assets
Cash and equivalents $ 60 $ 50
Short-term investments 100 10
Accounts receivable 400 520
Inventories 620 820
Total current assets $ 1,180 $ 1,400
Gross fixed assets $ 3,900 $ 4,820
Less: Accumulated depreciation 1,000 1,320
Net fixed assets $ 2,900 $ 3,500
Total assets $ 4,080 $ 4,900
Liabilities and equity
Accounts payable $ 300 $ 400
Notes payable 50 250
Accruals 200 240
Total current liabilities $ 550 $ 890
Long-term bonds 800 1,100
Total liabilities $ 1,350 $ 1,990
Common stock 1,000 1,000
Retained earnings 1,730 1,910
Total equity $ 2,730 $ 2,910
Total liabilities and equity $ 4,080 $ 4,900
Computron's Income Statement (Millions of Dollars)
2018 2019
Net sales $ 5,500 $ 6,000
Cost of goods sold (Excluding depr. & amort.) 4,300 4,800
Depreciation and amortizationa 290 320
Other operating expenses 350 420
Total operating costs $ 4,940 $ 5,540
Earnings before interest and taxes (EBIT) $ 560 $ 460
Less interest 68 108
Pre-tax earnings $ 492 $ 352
Taxes (25%) 123 88
Net Income $ 369 $ 264
Notes:
a Computron has no amortization charges.
Other Data 2018 2019
Stock price $50.00 $30.00
Shares outstanding (millions) 100 100
Common dividends (millions) $90 $84
Tax rate 25% 25%
Weighted average cost of capital (WACC) 10.00% 10.00%
Computron's Statement of Cash Flows (Millions of Dollars)
Bart Kreps: The statement of cash flows provides information about cash inflows and outflows during an accounting period.
2019
Operating Activities
Net Income before preferred dividends $ 264
Noncash adjustments
Depreciation and amortization 320
Due to changes in working capital
Change in accounts receivable (120)
Change in inventories (200)
Change in accounts payable 100
Change in accruals 40
Net cash provided by operating activities $ 404
Investing activities
Cash used to acquire fixed assets $ (920)
Bart Kreps: Make sure to add back annual Depreciation to Net PP&E.
Bart Kreps: The statement of cash flows provides information about cash inflows and outflows during an accounting period. Change in short-term investments 90
Net cash provided by investing activities $ (830)
Financing Activities
Change in notes payable $ 200
Change in long-term debt 300
Payment of cash dividends (84)
Net cash provided by financing activities $ 416
Net change in cash and equivalents $ (10)
Cash and securities at beginning of the year 60
Cash and securities at end of the year $ 50
a. (1.) What effect did the expansion have on sales and net income? (2 pts)
a. (2.) What effect did the expansion have on the asset side of the balance sheet? (2 pts)
b. What do you conclude from the statement of cash flows? (2 pts)
c. What is free cash flow? Why is it important? What are the five uses of FCF? (2 pts)
d. What is Computron’s net operating profit after taxes (NOPAT)? What are operating current assets? What are operating current liabilities? How much net operating working capital and total net operating capital does Computron have? (7 pts)
Net Operating Profit After Taxes
NOPAT is the amount of profit Computron would generate if it had no debt and held no financial assets.
2019 NOPAT = EBIT x ( 1 – T )
= x
=
2018 NOPAT = EBIT x ( 1 – T )
= x
=
Net Operating Working Capital
Those current assets used in operations are called operating current assets, and the current liabilities that result from operations are called operating current liabilities. Net operating working capital is equal to operating current assets minus operating current liabilities.
2019 NOWC = Operating current assets − Operating current liabilities
= −
=
2018 NOWC = Operating current assets − Operating current liabilities
= −
=
Total Net Operating Capital (TNOC)
TNOC = NOWC + net operating long-term assets
2019 TNOC = NOWC + Fixed assets
= +
=
2018 TNOC = NOWC + Fixed assets
= +
=
e. What is Computron’s free cash flow (FCF)? What are Computron’s “net uses” of its FCF? (4pts)
Free Cash Flow
Computron's Free Cash Flow calculation is the cash flow actually availabe for distribution to investors after the company has made all necessary investments in fixed assets and working capital to sustain ongoing operations.
2019 FCF = NOPAT − Net Investment in Operating Capital
= −
=
Uses of FCF 2019
After-tax interest payment =
Reduction (increase) in debt =
Payment of dividends =
Repurchase (Issue) stock =
Purchase (Sale) of short-term investments =
Total uses of FCF =
f. Calculate Computron’s return on invested capital (ROIC). Computron has a 10% cost of capital (WACC). What caused the decline in the ROIC? Was it due to operating profitability or capital utilization? Do you think Computron’s growth added value? (6pts)
Return on Invested Capital
The Return on Invested Capital tells us the amount of NOPAT per dollar of operating capital.
2019 ROIC = NOPAT ÷ Operating Capital
=
=
2018 ROIC = NOPAT ÷ Operating Capital
=
=
Operating Profitability
The operating profitability (OP) ratio shows how many dollars of operating profit are generated by each dollar of sales.
2019 OP = NOPAT ÷ Sales
=
=
2018 OP = NOPAT ÷ Sales
=
=
Capital Utilization
The capital utilization (CR) ratio shows how many dollars of operating assets are needed to generated a dollar of sales.
2019 CR = Total Op. Cap. ÷ Sales
=
=
2018 CR = Total Op. Cap. ÷ Sales
=
=
Operating profitability declined and the capital utlization worsened, each contributing to the big decrease in ROIC.
g. What is Computron's EVA? The cost of capital was 10% in both years. (4pts)
Economic Value Added
Economic Value Added represents Computron's residual income that remains after the cost of all capital, including equity capital, has been deducted.
2019 EVA = NOPAT − Operating Capital x WACC
= − x
=
2018 EVA = NOPAT − Operating Capital x WACC
= − x
=
h. What happened to Computron's market value added (MVA)? (2pts)
Year-end common stock price $50.00 $30.00
Year-end shares outstanding (in millions) 100 100
Market Value Added
Assume that the market value of debt is equal to the book value of debt. In this case, Market Value Added (MVA) is the difference between the market value of Computron's stock and the amount of equity capital supplied by shareholders.
2019 MVA = Stock price x # of shares – Total common equity
= x –
=
2018
MVA = Stock price x # of shares – Total common equity
= x –
=
i. Assume that a corporation has $87 million of taxable income from operations. It also received interest income of $8 million and dividend income of $10 million. The federal tax rate is 21% and the dividend exclusion rate is 50%. What is the company's federal tax liability? (2pts)
Operating income = $87 million
Interest income received = $8 million
Dividend income received = $10 million
Federal tax rate = 21%
Dividend exclusion rate = 50%
Taxable dividends= million
Taxable income = million
Federal corporate tax liability = million
j. Assume that you are in the 25% marginal tax bracket and that you have $20,000 to invest. You have narrowed your investment choices down to municipal bonds yielding 7% or equally risky corporate bonds with a yield of 10%. Which one should you choose and why? At what marginal tax rate would you be indifferent? (4 pts)
Taxable vs. Tax Exempt bonds
Amount to invest $20,000
Corporate interest rate 10%
Municipal interest rate 7%
Tax Rate 25.0%
After-tax interest
Corporate = Pre-tax interest – tax on interest
=
Muni = Pre-tax interest
= There is no tax on the muni
Tax rate at which you would be indifferent
After-tax yield on muni versus corp bond
Muni Yield = Corp Yield *(1-Tax rate)
Solve for T
Tax rate = 1 – (Muni yield / Corp yield)
Tax Rate =

Get Your Paper Before the Deadline. Our Services are 100% private and Confidential

Useful Links That Will Help You Around

Link to new order   https://studentsolutionsusa.com/orders/stud/new

link to login page   https://studentsolutionsusa.com/orders/login

New user registration link   https://studentsolutionsusa.com/orders/register

Forgot Password https://studentsolutionsusa.com/orders/forgot/password

 

FREQUENTLY ASKED QUESTIONS

Question: How does this work?

Answer: Good Question. We are a group of a freelance board of students and professional essay writers. At our website, you may get help with any type of academic assignments: essay, coursework, term paper, business plan, case study, article review, research paper, presentation, and speech. Top writers can help with complex assignments such as dissertations, thesis papers, etc. All of them are professionals possessing excellent knowledge in their field of expertise, perfect writing skills, quality, and speed. When you place an order on our website, we assign it to the best writer.  Once the writer finishes the work, the paper is submitted to our quality assurance desk who go through it and ensure it is unique and plagiarism free and that the instructions were followed to the detail. After this step we upload the paper in your account, we also send a copy to the email that you used to register the account with. we can guarantee you that the paper will be 100% plagiarism free. Besides, our services are 100% private and confidential

Question: How do I place an Order after getting to the order page

Answer: There are three major steps in the ordering process

Step 1 ....................................................paper details In this step, you will fill in the instructions of your paper; you can upload any materials that you feel will make your assignment a success. Besides, you can also email us at [email protected] Remember to specify the correct academic level. Please note that sources mean the number of references.

Step 2...................................................... Price calculation Kindly specify the number of pages, type of spacing and the correct deadline. This step will give you the estimated cost minus discount -- you may add the extra features if you wish.

Step 3 ....................................................discount and payment Use the discount code HAPPY2018 to enjoy up to 30% discount of your total cost After this step, proceed to safe payment; you can checkout using your card or PayPal Please note we will send the complete paper to the email you will provide while registering. A copy will also be uploaded to your account

 

Question: How will I know when my paper is complete? or How will I get the complete Paper?

Answer: Once we are done with the paper, we will be uploaded to your account. A copy will also be sent to the email you registered with. We can guarantee you the following:- 1. Our service is private and confidential; we don't spam or share your contacts with anyone  2. The final paper will be plagiarism free. We will send a Turnitin Report to the email you registered with 3. At our company, willing to do free unlimited revisions until you are satisfied with your paper

Question:- Am a new client, How can I get the guarantee that the paper will be completed and sent to me before my deadline?

Answer: Thank you for expressing your concerns. We would love to have you as our loyal customer. We are certain if we do good work, you will come back for me. Besides, you will give us referrals to your friends and family. For that reason, we can’t fail to deliver your paper within your specified time frame. We will ensure we submit the paper on time so that you can have enough time to go through it, if you have problems with the paper delivered, you can request a free revision. You are entitled to as many revisions as you would wish until you get a paper that satisfies you

 

Useful Links That Will Help You Around

Link to new order   https://studentsolutionsusa.com/orders/stud/new

link to login page   https://studentsolutionsusa.com/orders/login

New user registration link   https://studentsolutionsusa.com/orders/register

Forgot Password https://studentsolutionsusa.com/orders/forgot/password

 

error: Content is protected !!