Question

In: Finance

Case Study: John & Jon (J&J) Financial Statement Preparation & Analysis You are recently hired as...

Case Study: John & Jon (J&J) Financial Statement Preparation & Analysis

You are recently hired as a senior financial analyst for John & Jon (J&J) and you are in charge of preparing the financial statements and presenting an annual analysis on the board meeting.

Overview of John & Jon’s Balance Sheet

The assets of John & Jon (J&J) in 2017 has both current assets and net plant and equipment. It has total assets of $ 7.5 million and net plan and equipment equals $5 million. J&J only finances with $2.5 million long-term debt, $500,000 notes payable and total common equity of $3.5 million. The firm does have $400,000 accounts payable and $600,000 accruals on its balance sheet. Now assume the firm’s current assets consist entirely of cash and cash equivalence, account receivables and inventories. If it has 1.5 million cash and cash equivalents and $400,000 account receivables.

John & Jon’s Income Statement in 2017 (dollars are in millions)

Sales     $15

Operating costs excluding depreciation and amortization              $5

EBITDA $10

Depreciation & Amortization      $0.6

EBIT      $9.4

Interest $0.4

EBT       $9

Taxes (40%)      $3.6

Net Income $5.4

Cash Dividends $2.0

19. What is the ratio of total debt to total capital? (1%)

20. What is the ratio of return on common equity? (1%)

21. Assume between 2016 and 2017, net operating working capital has increased by $500,000, calculate John & Jon’s free cash flow. (Hint: use this formula. FCF = [EBIT (1-T) +Depreciation & Amortization] – [Capital Expenditures + Change on Net Operating Working Capital]) (5%)

22. Now after you present your analysis on the meeting, the CEO would like to see higher sales and a forecasted net income of $10.8 million. Assume that operating costs (excluding depreciation and amortization) are still one-third of sales and that depreciation and amortization and interest expenses will increase by 10%. The tax rate which is 40%, will remain the same. What level of sales would generate $10.8 million in net income? (5%)

Solutions

Expert Solution

liabilities $ in million
equity 3.5
long term debt 2.5 19. total debt to capital ratio = (2.5/(3.5+2.5))
notes payable 0.5 (debt / debt + 'equity') 0.4166666667
acount payable 0.4
accruals 0.6 20. return on equity 1.5428571429
TOTAL 7.5 (net income/ shareholders equity)
Assets
Plant & equipment 5 21. FCF=
Cash & cash eq 1.5 FCF = [EBIT (1-T) +Depreciation & Amortization] – [Capital Expenditures + Change on Net Operating Working Capital])
account receivable 0.4 (debt / debt + 'equity')
inventories 0.6 (((9.4*(1-0.4))+0.6-((0.5))))
TOTAL 7.5 5.74
particulars $ in million $ in million
Sales 15 28.65 < Answer 22.
operating cost (1/3 ON SALES) 5 9.55 1/3rd
EBITDA 10 19.1 2/3rd
DA 0.6 0.66 110.00%
EBIT 9.4 18.44
Interest 0.4 0.44 110.00%
EBT 9 18 (10.8/0.6)
Taxes @40% 3.6 7.2
net income 5.4 10.8 60.00%
dividend 2

Related Solutions

Case Study on Managing an Investment Portfolio As a recently hired CFA financial analyst for Horizon...
Case Study on Managing an Investment Portfolio As a recently hired CFA financial analyst for Horizon Investments you have been asked to make portfolio recommendation and setup an investment policy statement for three clients of the firm. 1) John Lambert has recently received his MBA and currently works for Oracle. He is 26 and recently married. He and hid wife have saved nearly $100,000 for a down payment on a home. He contributes 10% of his salary to a 401K...
Case study: Financing policies AAA, Inc, a manufacturer, hired you as a financial analysist. You verified...
Case study: Financing policies AAA, Inc, a manufacturer, hired you as a financial analysist. You verified AAA financial documents and you encountered the following information. To: Julian Jones, CEO From: A. Banks, Controller Date: February 1, 20X4 Subject: Financing options Hi Ms. Jones, Following our previous correspondence about the financing options for our new project. My team has determined several possible levels of working capital that involve fundamental decisions regarding our firm’s liquidity and the maturity composition of dent portfolio....
Case study: Financing policies AAA, Inc, a manufacturer, hired you as a financial analysist. You verified...
Case study: Financing policies AAA, Inc, a manufacturer, hired you as a financial analysist. You verified AAA financial documents and you encountered the following information. To: Julian Jones, CEO From: A. Banks, Controller Date: February 1, 20X4 Subject: Financing options Hi Ms. Jones, Following our previous correspondence about the financing options for our new project. My team has determined several possible levels of working capital that involve fundamental decisions regarding our firm’s liquidity and the maturity composition of dent portfolio....
Case study: Financing policies AAA, Inc, a manufacturer, hired you as a financial analysist. You verified...
Case study: Financing policies AAA, Inc, a manufacturer, hired you as a financial analysist. You verified AAA financial documents and you encountered the following information. To: Julian Jones, CEO From: A. Banks, Controller Date: February 1, 20X4 Subject: Financing options Hi Ms. Jones, Following our previous correspondence about the financing options for our new project. My team has determined several possible levels of working capital that involve fundamental decisions regarding our firm’s liquidity and the maturity composition of dent portfolio....
Case: You have recently been hired as an OR nurse at Community Hospital. Recently divorced and...
Case: You have recently been hired as an OR nurse at Community Hospital. Recently divorced and the mother of two very small children, you were thrilled and relieved to get a job with these hours at the only hospital in this small mid-western city. However, on your second day, you are confronted with an unusual situation. A 35-year-old woman is scheduled to undergo the surgical removal of a benign uterine tumor. While preparing for surgery, you discover that the two...
ABC Company Case Analysis You have been hired by ABC Co. to assess their current financial...
ABC Company Case Analysis You have been hired by ABC Co. to assess their current financial situation and offer suggestions for potential expansion. ABC has been in business for 6 years and has grown from a sole proprietor to its current status. The business is in a growing industry and sells accessories for technology items. Sales have been steadily growing and this is something that Jane, the owner, is very happy about. Jane’s area of expertise is marketing and operations...
Case Study The President of LFC Inc, Jo Rogers, a friend of your family, recently hired...
Case Study The President of LFC Inc, Jo Rogers, a friend of your family, recently hired you as a trainee executive assistant. Your duties include assisting with strategy, budgeting, and year-end accounts. On 1st Dec 2020 at the end of the financial year, Jo calls by your office. S/he greets you with a warm friendly smile and says s/he is pleased with your work so far and can see how you can play an important part in its future expansion....
Case Study N. Got, P.Eng., has been hired recently as the chief engineer, as well as...
Case Study N. Got, P.Eng., has been hired recently as the chief engineer, as well as his assistant, James Lo, C.E.T., by a gold mine near a remote town in Northern Ontario. The mining company is the main employer in the region. Immediately upon starting the new job, N. Got spent some time reviewing the mining company’s operational procedures. No Got discovered that, for several years, tailing ponds at the mine have been releasing toxic and corrosive substances into the...
Mini Case – Cash budget and Short-term financial planning Middleton Manufacturing You have recently been hired...
Mini Case – Cash budget and Short-term financial planning Middleton Manufacturing You have recently been hired by Middleton Manufacturing to work in the newly established treasury department. Middleton Manufacturing is a small company with disorganized systems and the finance area needs work. The company currently has a beginning cash balance of $100,000 and plans to buy new machinery during the fourth quarter for $500,000, paying cash. The company maintains a minimum cash balance of $100,000 and invests any excess cash...
1)D01 Financial Statement Analysis Discuss you approach to a sound and meaningful financial statement analysis. Be...
1)D01 Financial Statement Analysis Discuss you approach to a sound and meaningful financial statement analysis. Be detailed and specific as to what you would do and what data you would represent. answer must be 500 words. 2) D02 Stock Valuation What are some of the key elements of valuing common stocks? What are the most critical and why?answer must be 500 words. 3)Long term Investment and Asset Growth What are the key considerations used by the CFO in determining how...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT