Reference no: EM131068775
Introduction to Finance Assignment
1. Company A has the following incomplete balance sheet and income statement, and the company's tax rate is 35%.
Balance Sheet As of year End (Figures in millions of dollars)
Assets

2011

2012

Liabilities

2011

2012

Current Assets

100

150

Current Liabilities

80

80

Net Fixed Assets

820

900

LongTerm Debt

800

740

Income Statement, 2012 (Figures in millions of dollars)
Revenue 2280
Cost of Goods Sold 1060
Depreciation 360
Interest Expense 240
a. What does Company A earn before interest and taxes if Company A's expenses only include cost of goods sold, depreciation and interest expenses?
b. What is Company A's net income?
c. What is Company A's investment in fixed assets in 2012?
d. What is the operating cash flow of Company A in 2012?
e. What is the addition to net working capital in 2012?
f. What is the cash flow from assets?
g. What is the cash flow to creditors?
h. What is the cash flow to shareholders?
2. a. Fill in the table using the following information:
The Edwards School of Business has just bought new equipment at a total cost (including installation) of $160,000. The school expects them to last 4 years before they will need to be replaced and expects to sell them for $40,000 after the four years. The equipment is considered Class 10 or 30 percent for CCA purposes.
Year

Beginning UCC

CCA

Ending UCC

1




2




3




4




b. If the school sells them for $40,000 after the four years, will there be a terminal loss, a CCA recapture, or neither? If so, how much will the amount of loss or recapture be?
3.
ABC Company Financial Statements Balance Sheet (in thousands)

Assets

2012

Current assets


Cash

$ 300

Accounts Receivable

325

Inventory

450

Total

$1,075

Fixed Assets


Net plant and equipment's

$6,35

Total Assets

$7,425

Liabilities and Owners' Equity


Current liabilities


Accounts payable

$ 400

Notes Payable

1,750

Total

$2,150

Longterm debt

$2,350

Owners' equity


Common stock and paidin surplus

$1,250

Retained Earnings

1,675

Total

$2,925

Total liabilities and owners' equity

$7,425

Income Statement (in thousands)


Sales

$3,800

Cost of goods sold

2,430

Depreciation

340

Earnings before interest and taxes

$1,030

Interest paid

530

Taxable income

$ 500

Taxes (35%

175

Net income

$ 325

Dividends

$ 75

Addition to retained earnings

?

a. Based on the financial statements above, calculate the following list of financial ratios. (5 marks)
1.Current ratio
2.Cash ratio
3.Days' sales in inventory
4.Days' sales in receivables
5.Total debt ratio
6.Times interest earned ratio
7.Return on Assets
8.Return on Equity
9.Fixed asset turnover
10.Profit Margin
b. Construct the Du Pont identity for ABC Company.
c. ABC Company has 200,000 shares of common stock outstanding and the market price for a share of stock at the end of 2012 was $26.
i. What are the additions to retained earnings?
ii. What is the priceearnings ratio?
iii. What are the dividends per share?
iv. What is the markettobook ratio at the end of 2012?
4. Based on the following information for Swine Corp., classify each even as a source or use of cash, by how much and the total change in cash?
Decrease in inventory $400
Decrease in accounts payable 160
Increase in notes payable 580
Decrease in accounts receivable 210
5. The most recent financial statements for ABC Inc. are shown here:
Income Statement Balance Sheet
Sales $3,400 Current Assets $4,400 Current Liabilities $880
Costs Fixed Assets 5,700 Longterm debt 3,580
Taxable Income $600 Equity $5,640
Taxes (34%) 204 Total $10,100 Total $10,100
Net income $396
Assets, costs, and current liabilities are proportional to sales. Longterm debt and equity are not. ABC Inc. maintains a constant 40% dividend payout ratio. Like every other firm in its industry, next year's sales are projected to increase by exactly 20%. What is the external financing needed?
6. What is the future value of $25,000 received today if it is invested at 6.5% compounded annually for six years?
7. You are supposed to receive $2,000 five years from now. At an interest rate of 6%, what is that $2,000 worth today?
8. Granny puts $35,000 into a bank account earning 4%. You can't withdraw the money until the balance has doubled. How long will you have to leave the money in the account?
9. Your grandfather placed $2,000 in a trust fund for you. In 10 years the fund will be worth $5,000. What is the rate of return on the trust fund?
10. Suppose you are looking at the following possible cash flows (CF): Year 2 CF = $100; Year
3 CF =$200; Year 5 CF = $300; Year 6 CF=$400. The required discount rate is 5%
1) Draw the time line, mark out the time point and cash flows
2) What is the total value of the cash flows today? (keep two decimal points)
3) What is the total value of the cash flows at year 7? (keep two decimal points)