Question

It is all one question Case Study: John & Jon (J&J) Financial Statement Preparation & Analysis...

It is all one question

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

Use the above information to answer the following questions. When you answer your question, make sure include the calculation steps or formula.

Prepare the balance sheet and present to the board of directors (5%)

Total Assets

Liabilities & Shareholder’s Equity


2. What is the amount of total liabilities and equity that appears on the firm’s balance? (1%)

3. What is the amount of current assets (1%)

4. What is the balance of current liabilities? (1%)

5. What is the amount of company’s inventory? (1%)

6. What is the amount of total liabilities? (1%)

7. What is the amount of total debt? (1%)

8. What is the amount of total capital? (1%)

9. What is the amount of net working capital? (1%)

10. What is the amount of net operating working capital? (1%)

11. If by the end of 2017, the retained earnings of John and Jon is $2.5 million, what is the amount of paid-in capital? (1%)

12. If John & Jon decides to purchase $500,000 market securities by using its cash, how does this action would affect its current asset position? (2%)

13. As the Income of Statement shows in 2017 John & Jon actually gave out $2 million cash dividends, what is the amount of retained earnings? (1%)

14. What is the amount of operating income? (1%)

15. What are the operating margin and the profit margin? (1%)

16. What is the average length of time that John & Jon must wait after making a sale before it receives cash? (1%)

17.What is the ratio we generally use to estimate a firm’s ability to meet its annual interest payments? And calculate that ratio for John and Jon (1%)

18. What are the fixed assets turnover ratio and the total asset turnover ratio? (1%)

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%)

Homework Answers

Answer #1

2) Total liabilities is the summation of short term debt as well as long term debt. In this case, total debt is the summation of Long term debts, notes payable and accruals payable which is equal to $3.4 million and total common equity is $3.5 million. Hence total of Total liabilities and Equity is $3.4+$3.5 which is $6.9 million.

3) Current asset is the summation of cash and cash equivalents, inventory and accounts receivable.

In this case, total asset is $7.5 million out of which $5 million is fixed asset hence the remaining that is $2.5 million is the amount of current assets.

4) Current Liabilities is the summation of notes payable as well as accounts payable

=$500,000+$400,000= $900,000 which is $0.9 million.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
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...
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...
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...
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...
FREE CASH FLOW Arlington Corporation’s financial statements (dollars and shares are in millions) are provided here....
FREE CASH FLOW Arlington Corporation’s financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2018                     2017 Assets Cash and equivalents                      $ 15,000               $ 14,000 Accounts receivable                        35,000                   30,000 Inventories                                         33,320                   27,000 Total current assets                        $ 83,320               $ 71,000 Net plant and equipment             48,000                  46,000 Total assets                                        $131,320             $ 117,000 Liabilities and Equity Accounts payable                             $ 10,100               $ 9,000 Accruals                                              ...
Question 8. (Calculating financial ratios) Use the balance sheet and income statement for the J. P....
Question 8. (Calculating financial ratios) Use the balance sheet and income statement for the J. P. Robard Mfg. Company to calculate the following ratios: (Show all work.) Current ratio (Round to two decimal places.) _________ Times interest earned (Round to two decimal places) ________ times Inventory turnover (Round to two decimal places.) __________ times Total asset turnover (Round to two decimal places.) __________ Operating profit margin (Round to one decimal places.) ___________% Operating return on assets (Round to one decimal...
Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance...
Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Nike Inc. for the year ended May 31, 2016, and a forecasted income statement and balance sheet for 2017. Nike Inc. Income Statement For Year Ended May 31 $ millions 2016 actual 2017 Est. Revenues $ 32,376 $ 34,319 Cost of sales 17,405 18,464 Gross profit 14,971 15,855 Demand creation expense 3,278 3,466 Operating overhead expense 7,191 7,619 Total selling and administrative...
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here....
FREE CASH FLOW Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2016 2015 Assets Cash and equivalents $  14,000 $  11,000 Accounts receivable 25,000 20,000 Inventories 21,520 19,000   Total current assets $ 60,520 $ 50,000 Net plant and equipment 51,000 49,000 Total assets $111,520 $99,000 Liabilities and Equity Accounts payable $ 10,600 $  9,500 Accruals 7,000 5,000 Notes payable 6,900 5,300   Total current liabilities $ 24,500 $ 19,800 Long-term bonds 10,000 10,000...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All...
The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All amounts in SAR unless otherwise indicated, all sales are on credit and no hard keys.) Balance Sheet: ABC Corporation Balance Sheet Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common stock (par & paid in capital) Retained earnings Total common...