Question

In: Finance

Using the information below to answer question (a) to (e). The balance sheet and income statement...

Using the information below to answer question (a) to (e).

The balance sheet and income statement shown below are for Rebel Inc. Note that the firm has no amortization charges and it does not lease any assets. Its tax rate is 35%.

Balance Sheet (Millions of $)

2014

2013

Assets

Cash and securities

$2,500

$2,000

Accounts receivable

11,500

$11,000

Inventories

16,000

15,500

Total current assets

$30,000

$28,500

Net plant and equipment

$20,000

$19,500

Total assets

$50,000

$48,000

Liabilities and Equity

Accounts payable

$9,500

$10,000

Accruals

5,500

4,000

Notes payable

7,000

5,000

Total current liabilities

$22,000

$19,000

Long-term bonds

$15,000

$17,000

Total liabilities

$37,000

$36,000

Common stock

$2,000

$2,000

Retained earnings

11,000

10,000

Total common equity

$13,000

$12,000

Total liabilities and equity

$50,000

$48,000

Income Statement (Millions of $)

2014

Net sales

$87,500

Operating costs except depreciation

81,813

Depreciation

1,531

Earnings bef interest and taxes (EBIT)

$4,156

Less interest

1,375

Earnings before taxes (EBT)

$2,781

Taxes (35%)

973

Net income

$1,808

a. What is Rebel’s free cash flow for 2014? (Assum that there is no excess cash.) (7 points)

NOWC2013 = ???Answer million

NOWC2014 = ???Answer million

The change in NOWC = ???Answer million

FCF2014 = ???Answer million

b. What is the firm’s 2014 EVA? Assume that its after-tax cost of capital is 5%? (4 points)

Total invested capital2014= ???Answer million

EVA = ???Answer million

Solutions

Expert Solution


Related Solutions

Using the information given below, prepare an income statement, Statement of Retained Earnings and balance sheet...
Using the information given below, prepare an income statement, Statement of Retained Earnings and balance sheet for Hanson Storage from the adjusted trial balance. No additional investments in the company were made during the year. ( really need help with making an income statement, statement of retained earnings, and balance sheet. HANSON PRODUCTS COMPANY Adjusted Trial Balance December 31, 2018 Debit Credit Cash $    14,400 Accounts receivable 35,000 Allowance for doubtful accounts 800 Merchandise inventory 50,400 Office supplies 900 Prepaid...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below Calculate the Net Working Capital and the Net Operating Working Capital for both years Perform vertical analysis on both statements, for both years Perform Horizontal analysis on both statements for the most current year What was the Net Operating Profit After Taxes for both years? 2016 Accounts Receivable 400 Sales 5000 Accounts Payable 650 Inventory 1400 COGS 3000 Common Stock 1500 Cash 1600 Oper....
Using the information presented below, prepare an income statement and the balance sheet from the adjusted...
Using the information presented below, prepare an income statement and the balance sheet from the adjusted trial balance of McTangy Spices. McTangy Spices. Adjusted Trial Balance December 31 Cash %bodyamp;nbsp; 3,050 Accounts receivable 400 Prepaid insurance 830 Office supplies 80 Office equipment 4,200 Accumulated depreciation–office equipment $ 1,100 Buildings 98,000 Accumulated depreciation–buildings 28,000 Land 115,000 Wages Payable 880 Property taxes payable 1,400 Interest payable 2,200 Unearned rent 460 Notes payable 150,000 McTangy Spices, Capital Stock 40,340 McTangy Spices, Dividends 21,000...
PLEASE ANSWER E THROUGH Q. Hyrkas Corporation's most recent balance sheet and income statement appear below:...
PLEASE ANSWER E THROUGH Q. Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 215 $ 320 Accounts receivable, net 350 370 Inventory 320 290 Prepaid expenses 20 20 Total current assets 905 1,000 Plant and equipment, net 1,150 1,260 Total assets $ 2,055 $ 2,260 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 290...
Based on the information below create an income statement, balance sheet, and cash flow statement. On...
Based on the information below create an income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in legal fees,...
Create an income statement and balance sheet using the data below. Important: double the balance of...
Create an income statement and balance sheet using the data below. Important: double the balance of the Net Sales and make the necessary corrections to balance. Inputs Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120,000 Cash 7,000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, Plant, and Equipment 400,000 Interest Expense 15,000...
A Using the balance sheet and income statement below, calculate the quick ratio. B Using the...
A Using the balance sheet and income statement below, calculate the quick ratio. B Using the balance sheet and income statement below, calculate the current ratio. C Using the balance sheet and income statement below, calculate return on equity. D Using the balance sheet and income statement below, calculate days sales outstanding (also called average collection period). E Using the balance sheet and income statement below, calculate inventory turnover. F sing the balance sheet and income statement below, calculate the...
Use the starting balance sheet, income statement, and the list of changes to answer the question....
Use the starting balance sheet, income statement, and the list of changes to answer the question. Valley Technology Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 22,000 Liabilities 36,000 Other Assets 28,000 Equity 14,000 Total Assets 50,000 Total Liabilities & Equity 50,000 Valley Technology Income Statement January 1 to March 31, 2020 (amounts in thousands) Revenue 7,200 Expenses 3,600 Net Income 3,600 Between January 1 and March 31, 2020: 1. Cash decreases by $200,000 2. Liabilities decrease...
Use the starting balance sheet, income statement, and the list of changes to answer the question....
Use the starting balance sheet, income statement, and the list of changes to answer the question. Hopewell Corporation Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 29,000 Liabilities 24,000 Other Assets 37,000 Equity 42,000 Total Assets 66,000 Total Liabilities & Equity 66,000 Hopewell Corporation Income Statement January 1 to March 31, 2020 (amounts in thousands) Revenue 7,500 Expenses 2,200 Net Income 5,300 Between January 1 and March 31, 2020: 1. Cash decreases by $300,000 2. Liabilities increase...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT