Question: Data about 2018 income statement (from Jan. 18, 201 to Dec. 31, 2018) and balance sheet (as of Jan. 1, 2019) of XYZ company is

Data about 2018 income statement (from Jan. 18, 201 to Dec. 31, 2018) and balance sheet (as of Jan. 1, 2019) of XYZ company is provided in the following. Also known that XYZ company started on Jan. 1, 2016, with a total cost of $100 Million in the fixed assets ( land, buildings and equipment), among which $20 Million is buildings and $30 Million is equipment. XYZ company depreciates the buildings on a 50-year straight-line schedule and the equipment on a 10-year straight-line schedule with no salvage value at the end of the service life. On Jan. 1, 2016, XYZ company borrowed a long-term debt of $100 Million which is repaid over a 10-year period with equal annual repayment of the loan principal. The annual interest rate of the loan is 10%. Assumed COGS = 40% sales, and SG&A (excluding depreciation) = 5% sales in the income statement below.

Answer the blank cell in below.Data about 2018 income statement (from Jan. 18, 201 to Dec. 31,

Income Statement (2018) Sales COGS Contribution Margin ($) Contribution Margin (%) SG&A Operation Income Other Income (Interest Charge) Net Income Balance Sheet (Jan. 1, 2019) Assets Current Assets Cash Receivables Short Term Investment Inventory Prepaid Expenses Fixed Assets Land, Building, Equip, @Cost Less Acc Depreciation Long Term Investment Goodwill Total Assets $60,000,000 $80,000 $4,000,000 $0 $1,000,000 $800,000 $0 $0 Liabilities Current Liabilities Short Term Credit Line Acccounts Payable Accrued Expense Taxes Payable Current Portion of Long Term Debt Long Term Debt Repayable Grants Long Term Debt Shareholders Equity Capital Shares Retaines Earnings Total Liability and Equity $1,000,000 $500,000 $500,000 $0 $15,000,000 $5,000,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!