Question

In: Finance

Calculate the following based on 2018 numbers using the attached financial statements for XYZ Corp. Assume...

Calculate the following based on 2018 numbers using the attached financial statements for XYZ Corp. Assume the only variable cost is the cost of goods sold.

  1. Survival revenues (EBITDA breakeven – includes interest).
  2. B.NOPAT Breakeven

c) Interpret these values and indicate what you would expect to happen to them if a large addition is made to fixed assets.

Financial Statements for XYZ Corp.

Balance Sheet for Period Ending December 31.

Assets

2017

2018

Cash and Marketable Securities

40

15

Accounts Receivable

160

80

Inventories

250

370

Total Current Assets

450

465

Gross Plant and Equipment

675

855

less: Accumulated Depreciation

250

300

Net Plant and Equipment

425

555

Total Assets

875

1020

Liabilities and Equity

Accounts Payable

15

30

Short-term Bank Loans

35

40

Accrued Liabilities

55

60

Total Current Liabilities

105

130

Long-Term Debt

265

360

Common Stock

180

180

Retained Earnings

325

350

Total Equity

505

530

Total Liabilities and Equity

875

1020

Income Statement for the Period Ending December 31.

2018

Sales

1500

Cost of Goods Sold

1272

Gross Profit Margin

228

Administrative Expense

40

Marketing Expense

30

Research and Development

20

Depreciation

50

Earnings before Interest and Taxes

88

Interest Expense

39

Income before Taxes

49

Income Taxes @ 40%

20

Net Income

29

Solutions

Expert Solution


Related Solutions

Prepare the 2018 cash flow statement for XYZ Corp. Assume no dividends were paid. Financial Statements...
Prepare the 2018 cash flow statement for XYZ Corp. Assume no dividends were paid. Financial Statements for XYZ Corp. Balance Sheet for Period Ending December 31. Assets 2017 2018 Cash and Marketable Securities 40 15 Accounts Receivable 160 80 Inventories 250 370 Total Current Assets 450 465 Gross Plant and Equipment 675 855 less: Accumulated Depreciation 250 300 Net Plant and Equipment 425 555 Total Assets 875 1020 Liabilities and Equity Accounts Payable 15 30 Short-term Bank Loans 35 40...
Using the attached financial statements please calculate for 2017 and 2016: Days in Accounts receivable, Days...
Using the attached financial statements please calculate for 2017 and 2016: Days in Accounts receivable, Days Cash on hand, equity financing percentage, cash flow to debt percentage, times interest earned, fixed asset turnover ratio, current asset turnover ratio, average age of facilities. Please show all work and calculations Balance Sheet Assets 2017 2016 Current Assets Cash and Cash equivalents $82,815 $59,696 Assets limited as to use, current portion 5,327 5,088 Accounts Receivable Patients, less allowance for doubtful accounts ($25,302 in...
Based on the following information for XYZ Corporation, answer the each question (calculate for year 2018)....
Based on the following information for XYZ Corporation, answer the each question (calculate for year 2018). Assume that price per share is $15.25 and number of shares is 350. 2017 2018 Income Statement Sales 3,850 Cost of goods sold 2,150 Expenses 200 Depreciation 875 EBIT Interest 250 Taxable Income Taxes ? Net Income Dividends 225 Balance Sheet Current assets 2,000 2,350 Net fixed assets 6,700 7,000 Total Assets (TA) ? ? Current liabilities 950 1,200 Long-term debt 2,800 3,100 Total...
XYZ Corporation published the following information in its financial statements for its 2018 annual report:  ...
XYZ Corporation published the following information in its financial statements for its 2018 annual report:       Income Statement Items:     Sales                                         $76,000   - Cost of goods sold   49,000   Gross profit     27,000 - Cash Operating expenses $9,000   - Depreciation   2,000          Total Operating Expenses     11,000 EBIT     16,000...
Using the Starbucks financial statements provided on Blackboard, calculate and interpret the operating cycle. Assume 20%...
Using the Starbucks financial statements provided on Blackboard, calculate and interpret the operating cycle. Assume 20% of all sales are credit sales. STARBUCKS CORP 10-K Income Statement in millions of dollars, except for per share figures Fiscal Year Ended 10/1/2017 10/2/2016 9/27/2015 9/28/2014 Net revenues: Company-operated stores $17,650.7 $16,844.1 $15,197.3 $12,977.9 Licensed stores 2,355.0 2,154.2 1,861.9 1,588.6 CPG, foodservice and other 2,381.1 2,317.6 2,103.5 1,881.3 Total net revenues $22,386.8 $21,315.9 $19,162.7 $16,447.8 Cost of sales including occupancy costs 9,038.2 8,511.1...
Suppose that the 2017 actual and 2018 projected financial statements for Cramner Corp. are initially as...
Suppose that the 2017 actual and 2018 projected financial statements for Cramner Corp. are initially as shown in the following tables. In these tables, sales are projected to rise 35 percent in the coming year, and the components of the income statement and balance sheet that are expected to increase at the same 35 percent rate as sales are indicated with an italics font. Assuming that Cramner Corp. wants to cover the AFN with 45 percent equity, 25 percent long-term...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018   Current assets   Current liabilities       Cash $ 34,485 $ 37,928       Accounts payable $ 36,712 $ 42,632       Accounts receivable 17,851 27,856       Notes payable 19,108 16,275       Inventory 3,640 42,672       Other 19,954 24,714         Total $ 55,976 $ 108,456         Total $ 75,774 $ 83,621   Long-term debt $ 115,500 $ 174,101   Owners’ equity       Common stock and paid-in surplus $...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018   Current assets   Current liabilities       Cash $ 24,246 $ 26,100       Accounts payable $ 25,184 $ 29,100       Accounts receivable 14,448 17,200       Notes payable 20,000 12,800       Inventory 27,992 29,100       Other 13,571 18,100         Total $ 66,686 $ 72,400         Total $ 58,755 $ 60,000   Long-term debt $ 89,000 $ 103,648   Owners’ equity       Common stock and paid-in surplus $...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018   Current assets   Current liabilities       Cash $ 24,226 $ 25,900       Accounts payable $ 24,984 $ 28,900       Accounts receivable 14,248 17,000       Notes payable 17,000 12,600       Inventory 27,802 28,900       Other 13,371 17,500         Total $ 66,276 $ 71,800         Total $ 55,355 $ 59,000   Long-term debt $ 124,000 $ 127,662   Owners’ equity       Common stock and paid-in surplus $...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018...
Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets Assets Liabilities and Owners’ Equity 2017 2018 2017 2018   Current assets   Current liabilities       Cash $ 35,985 $ 39,308       Accounts payable $ 39,562 $ 43,382       Accounts receivable 18,601 29,206       Notes payable 20,608 17,400       Inventory 4,090 43,272       Other 21,304 25,914         Total $ 58,676 $ 111,786         Total $ 81,474 $ 86,696   Long-term debt $ 123,000 $ 189,270   Owners’ equity       Common stock and paid-in surplus $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT