Spring 1, 2013
Chapter 5. Ch 05 P24 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions will be accepted for credit.
Numeric answers in cells will not be accepted.
A 20-year, 8% semia
Personal Budget Project
Finance 510 Davenport University
Personal Budget project will require you to examine cash inflows and outflows as well as develop a
retirement plan for your household. Each sections provides clear direction. Please review grading r
Winter 1, 2013
Chapter 2. Ch 02 P14 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions will be accepted for credit.
Numeric answers in cells will not be accepted.
a. Cumberland Indus
Introduction
TheLeadershipTeamheadedbyMr.Sfoundedanewbiotechnologystartupin2009.The
biotechnologycompanywasstartedwithaninitialadvanceofUS$5Million.
The biotechnology startup was focused on developing existing molecules with a new
environment friendly tec
Running Head: Bond ratings- What are they and how are they used?
1
Bond ratings What are they and how are they used?
Timothy Keeler
Davenport University
Finance 510
Professor Rachael Hayes
January 31, 2017
Bond ratings What are they and how are they used?
Risk Profile Project
1
Risk Profile Project
Bradley Sheaffer
Davenport University
Risk Profile Project
2
Risk Profile Project
After completing the risk profile assessment my score was 25 which was an
average/moderate tolerance for risk. This sounds right
The assignment that was the most applicable to my workplace would be the weekly homework
assignments because it gave me a better understanding of how to use excel. My job currently consists of
a lot of data entry and some use of excel is required. Before
Figure 1
Loan Data
Auto Loan Original Principal
Trade-In
Down Payment
GM Discount
Principal
Years
Annual Interest Rate
Payments Per Year
Payment
Payment Number
$28,988
$1,500
$2,000
$2,500
$22,988
5
3.9%
12
$422.32
Payment
Principal
0
1
2
3
4
5
6
7
8
9
10
My biggest take away after completing the budget project is that I should be saving more
money every month than I currently am. I had been working off a budget I had created to help
pay off my credit card but this assignment has shown me that the budget I
How Do You Valuate a Companys Worth?
How Do You Valuate a Companys Worth?
Bradley C. Sheaffer
Davenport University
1
How Do You Valuate a Companys Worth?
2
Abstract
A companys value is important to any business owner. The value gives the owner an idea of
Are Retained Earnings Free?
1
Are Retained Earnings Free?
Bradley Sheaffer
Davenport University
Are Retained Earnings Free?
2
Abstract
Retained earnings are the sum of a companys profits, after dividend payments, since the
companys inception. They are als
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
A
B
Spring 1, 2013
C
D
E
F
G
H
I
J
K
L
M
N
O
Chapter 8. Ch 08 P08 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell refer
Spring 1, 2013
7/22/2012
Chapter 4. Ch 04 P35 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions will be accepted for credit.
Numeric answers in cells will not be accepted.
a. Find t
Spring 1, 2013
Chapter 6. Ch 06 P14 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions will be accepted for credit.
Numeric answers in cells will not be accepted.
a. Use the data giv
1.
2.
3.
4.
The amount of interest paid on the loan will be $4,786.65
By making an extra $2,000 payment, the loan will be paid off in 68 months instead of 72.
The amount of interest paid on the loan will be $2,368.57.
By lower the interest rate from 5% to
An effective oral presentation does not just happen it requires a lot of
research, planning, and work long before the speaker presents his/her
information to an audience. What verbal and non-verbal cues did you
find to be most effective? Think of a recent
1.) in a stock with a beta of 1.3. If these are the only two investments in her portfolio, what is
her portfolio's beta? Round your answer to two decimal places.
.8*30000/60000+1.3*30000/60000 = 1.05
2.) Assume that the risk-free rate is 3.5% and that the
1. Wilson Wonders's bonds have 12 years remaining to maturity. Interest is paid
annually, the bonds have a $1,000 par value, and the coupon interest rate is 10%. The
bonds sell at a price of $850. What is their yield to maturity? Round your answer to
two
1. Brushy Mountain Mining Company's ore reserves are being depleted, so its sales
are falling. Also, its pit is getting deeper each year, so its costs are rising. As a result,
the company's earnings and dividends are declining at the constant rate of 9% p
Spring 1, 2013
Chapter 2. Ch 02 P14 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions
Numeric answers in cells will not be accepted.
a. Cumberland Industries' most recent sales were
Spring 1, 2013
Chapter 6. Ch 06 P14 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions w
Numeric answers in cells will not be accepted.
a. Use the data given to calculate annual retu
Spring 1, 2013
Chapter 5. Ch 05 P24 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functio
Numeric answers in cells will not be accepted.
A 20-year, 8% semiannual coupon bond with a par va
Spring 1, 2013
Chapter 3. Ch 03 P15 Build a Model
Except for charts and answers that must be written, only Excel formulas that use cell references or functions
Numeric answers in cells will not be accepted.
Joshua & White Technologies: December 31 Balance
A.
P-value = 0.1379
Critical value = -2.326
B.
H0: p = 0.26
Ha: p 0.26
z = -0.9271
p = 0.3539
Fail to reject the null hypothesis
There is insufficient evidence to reject the claim that under the same
circumstances, 26% of the offspring peas will be yellow
bb, br, rr, rb
0
0.03
0.0009
a
0.9991
b
0.9409
c
0.16262705
a
773.9
b
16
c
B
B
4 over 20
B
a
63 over 64
1.26
b
0.73
D
D
Only 30 people are randomly selected from the group of 1
0.0313
0.9923
B
0.886
y selected from the group of 1236, which is less than 5%
Risk Profile Project
Finance 510 Davenport University
Objective: This assignment will give you an objective risk profile. You are to take the assessment
and then answer the questions below
1. Go to the following website and complete a risk profile questio
Amortization Project
Finance 510 Davenport University
Objective: The assignment will help you to understand how changes in loan terms and payments will
affect the total amount you pay.
1. Create an amortization table in Excel for a new car loan for 30,000
Capital Budget Assignment
1
Capital Budget Assignment
Bradley Sheaffer
Davenport University
Capital Budget Assignment
2
Abstract
A couple months my wife and I started looking into purchasing a new car for her. My wifes
previous car was 2007 model and was