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
|
Long-Term 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
|
|
Long-term debt
|
$2,350
|
|
Owners' equity
|
|
|
Common stock and paid-in 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 price-earnings ratio?
iii. What are the dividends per share?
iv. What is the market-to-book 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 Long-term 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. Long-term 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)