Erin McCoy
Problem 1 -
Using the excess cash flow to produce a dividend payout has both positive and negative ramifications. For instance, immediately
after the dividend payout, the price per share will be decreased. As a result, the companies cash balanc
Current Assets
Fixed Assets
Total Assets
$
$
$
8,200
22,500
30,700
Current Liability
Long Term Debt
Total Liability
$
$
$
6,400
12,500
18,900
We know that,
Assets = Liability + Equity
So, Equity =
$
11,800
Net Working Capital = Current Assets - Current Li
Problem 1.Dividends and Taxes: Midland, Incorporated
has declared a $6.50 per share dividend and the stock is
about to go ex-dividend. Calculate the ex-dividend price
based on the following data:
Capital gains are not
taxed.
There is a 12 percent tax
rate
1 Net Dividend =
$
5.72
$
70.28
$
365000
72
Ex-Dividend Price = Current Price - Ex-Diviend
2 Total Shares
Current Price per Share
BC has a five-forthree stock split?
No. of Shares
Price per share
608333.33333
$
43.20
Price per share
$
63.36
Price per shar
FINANCIAL ANALYSIS
1
MICROSOFT CORPORATION
MBA 6016
Finance and Value Creation
Address:
Telephone:
Email:
Instructor: Prof. Michael Blagg
Date: 11 December 2014
FINANCIAL ANALYSIS
2
EXECUTIVE SUMMARY
The Microsoft Corporation was established in 1975 with
U0a21 Financial Statements
1. Building a Balance Sheet: Jones, Incorporated
What is the value of the company's stockholders equity and net working capital?
Net Fixed Assets
Current Assets
Current Liabilities
Long-Term Debt
$22,500
$8,200
$6,400
$12,500
To
Risk Return Analysis
MBA FP6016
Assessment 6
Capella University
March, 2016
rn Analysis
Calculating Returns: A stock with an initial price of $55 per share paid a dividend of $1.75 per share throughout the
year, with an ending price of $59. Calculate the
Calculating Returns: A stock with an initial price of $55 per share paid a dividend of
$1.75 per share throughout the year, with an ending price of $59. Calculate the
percentage total return of the stock.
Per Share
Dividend
Ending Price
Total Return of St
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
$14,900
$1,600
CHAPTER 2: PROBLEM 2
Sales
Costs
Depreciation Expense
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
$14,900
$1,600
CHAPTER 2: PROBLEM 2
Sales
Costs
Depreciation Expense
Financial Statements
MBA FP6016
Assessment 3
Capella University
March, 2016
Problem 1
Calculate the future value of $3,500, compounded annually for each of the following:
10 years at 7 percent
N
I
PV
PMT
10
7%
$3,500
FV
$6,885.03
FV
$4,491.99
FV
$4,075.48
Financial Statements
MBA FP6016
Assessment 2
Capella University
March, 2016
Jones, Incorporated
December 31,xxxx
Balance Sheet
ASSET
Current Assets
LIABILITIES
$8,200 Current Liabilities
$6,400
Net fixed assets
$22,500 Long -term Debt
$12,500
Total assets
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
#NAME?
#NAME?
CHAPTER 2: PROBLEM 2
Sales
Costs
Depreciation Expense
FINANCIAL ANALYSIS: TEMPLATE
NAME:
Cindy Cloutier
EXECUTIVE SUMMARY:
Google
Cindy Cloutier
Introduction
Google Corporation is very popular and used daily, by most of society. The founders of Google are
Larry Page and Sergey Brin, who met at Stanford Unive
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
#NAME?
#NAME?
CHAPTER 2: PROBLEM 2
Sales
Costs
Depreciation Expense
Dividends and Stocks
MBA FP6016
Assessment 7
Capella University
March, 2016
and Stocks
Dividends and Taxes: Midland, Incorporated has declared a $6.50 per share dividend and the stock is about to go e
Capital gains are not taxed.
There is a 12 percent tax
Megaware Case Study
MBA FP6016
Assessment 8
Capella University
March, 2016
e Case Study
John thinks that the firm should use the excess cash flow to pay a special one-time dividend to the investors. How
When a dividend is paid the reduction of that value
UNIT 4: TEXTBOOK PROBLEMS
CHAPTER 10: PROBLEM 1
Beginning Stock Price
Ending Stock Price
Dividend
$73
$82
$1.20
Percentage Total Return =
13.97%
CHAPTER 10: PROBLEM 12
Stock Return the past 5 years
Holding Period Return for the Stock =
-18.35%
14.72%
28.4
UNIT 3: TEXTBOOK PROBLEMS
CHAPTER 7: PROBLEM 1b
Discount Rate
Year 0
Year 1
Year 2
Year 3
NPV =
Project A
15%
($14,500)
$8,500
$6,800
$2,800
($125.87)
Project B
15%
($9,800)
$4,700
$4,200
$4,100
$158.58 (Note: You will choose the project
Project B should
UNIT 2: TEXTBOOK PROBLEMS
CHAPTER 4: PROBLEM 2 (a through c)
Present Value
Interest Rate
Number of Years
Future Value =
A.
3,200
6%
10
$5,731
B.
3,200
8%
10
$6,909
C.
3,200
6%
20
$10,263
A.
15,451
7%
12
$6,860
B.
51,557
9%
8
$25,875
C.
886,073
14%
19
$73,
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
$14,900
$1,600
Total assets = 33500
Total Liabilities = 18600
33500-
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
$14,900
$1,600
CHAPTER 2: PROBLEM 2
Sales
Costs
Depreciation Expense
UNIT 1: TEXTBOOK PROBLEMS
CHAPTER 2: PROBLEM 1
Current Assets
Net Fixed Assets
Current Liabilities
Long-Term Debt
$7,300
$26,200
$5,700
$12,900
Shareholder Equity =
Net Working Capital =
$14,900
$1,600
CHAPTER 2: PROBLEM 2
Sales
Costs
Depreciation Expense