College Pal
Connecting to a pal for your paper
  • Home
  • Place Order
  • My Account
    • Register
    • Login
  • Confidentiality Policy
  • Samples
  • How It Works
  • Guarantees

Sms or Whatsapp only : US:+12403895520

 

email: [email protected]
December 19, 2022

This is a case study to help you understand the financial statements and learn how to work with financial data in excel. You will use the following scenario: Jenny Cochran, a graduate of

Uncategorized

This is a case study to help you understand the financial statements and learn how to work with financial data in excel. You will use the following scenario:

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.

Instructions

Download and complete this Excel worksheet Download Download and complete this Excel worksheetfor the case study and submit as an .xlsx or .xls file.

Please use Excel functions to show your answers so that your instructor can see your calculation details for full credit. 

  • attachment

    CaseStudy1week1.xlsx

Mini Case

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

This case study requires you to do some research (company selection, information collection, calculation, etc.). The mini lecture in Chapter 9 provides guidance on this assignment.casestu Using the Internet, research and select three current epidemiological studies regarding risk factors that are associated with any health problem. You can also use the following websites t

Related Posts

Uncategorized

Unit 2: Common Assessment/Project Part A Start Assignment

Uncategorized

Person-Centered and Experiential Therapy

Uncategorized

Read the Instructions for the Population Health Assessment & Prevention ?Download Instructions for the Population Health Assessment & Prevention

Why Choose Us

Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices

At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that?

Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals.

We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science.

Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles.

They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers.

They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases.

Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count.

Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top.

From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications.

Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work.

How Our Website Works

Get an Essay from Us

College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients.

Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE.

Step 1
To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Deadline range from 6 hours to 30 days.

Step 2
Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Pricing and Discounts
Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.

Recent Posts

  • Write a 2-4 page paper on leading your team through change by? Step 1: Choose a topic from the following list: Technology/Software Updates. Or
  • Which learning theories and principles do you think are most useful to the advanced practice nurse (APN) in providing high quality health care to c
  • Free White Switch Hub Turned on Stock PhotoWeek 5 Assignment: Build a substance-based PowerPoint presentation
  • Use this discussion to introduce yourself. Consider adding to your introduction using the following questions: What sort of experience have you
  • To become proficient in statistical reasoning, you need to be able to interpret data from surveys. This includes preparing frequency tables and gra
College Pal

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

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