Question

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

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

17) The ratio which is used is used as Interest Coverage ratio. Higher Interest coverage ratio indiocates a better ability of firm to pay its debt.

Interest coverage ratio= EBIT/ Interest

= 9.4/0.4

=23.5

The company has a healthy interest coverage ratio of 23.5 times which means the company can easily pay off its interest.

18) Fixed asset turnover ratio= Net Sales/ Fixed Asset

= 15/5

=3 times

Total asset turnover ratio= Net sales/ Total Assets

=15/7.5

=2 times

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...
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 $...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for...
Ivanhoe Corporation recently filed the following financial statements with the SEC. Ivanhoe Corporation Income Statement for the Fiscal Year Ended July 31, 2017 Net sales $58,589 Cost of products sold 41,674 Gross profit $16,915 Selling, general, and administrative expenses 7,466 Depreciation 848 Operating income (loss) $8,601 Interest expense 519 Earnings (loss) before income taxes $8,082 Income taxes 2,829 Net earnings (loss) $5,253 Ivanhoe Corporation Balance Sheet as of July 31, 2017 Assets Liabilities and Stockholders’ Equity Cash and marketable securities...
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                                              ...
Basic Financial Ratios The accounting staff of CCB Enterprises has completed the financial statements for the...
Basic Financial Ratios The accounting staff of CCB Enterprises has completed the financial statements for the 2017 calendar year. The statement of income for the current year and the comparative statements of financial position for 2017 and 2016 follow. CCB Enterprises Statement of Income For the Year Ended December 31, 2017 (thousands omitted) Revenue:      Net sales $800,000      Other 60,000          Total revenue $860,000 Expenses:      Cost of goods sold $540,000      Research and development 25,000      Selling and administrative 155,000      Interest 20,000          Total expenses...
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...
Analysis of Operating Assets At December 31, 2017, XYZ Inc. has the following amounts on its...
Analysis of Operating Assets At December 31, 2017, XYZ Inc. has the following amounts on its financial statements: Property, plant, and equipment $15,000 Accumulated depreciation 6,000 Total assets at January 1, 2017 30,000 Total assets at December 31, 2017 40,000 Net sales 60,000 Depreciation expense 1,000 Calculate the following: Average life of the assets: years Average age of the assets: years Asset turnover ratio (round to 2 decimal places): times