BUSN 379 Week 4 Case Study II
Week 4 Case Study II
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 4
1.) What are the monthly payments for a 30-year traditional mortgage? What are the
payments for a 20-year traditional mortgage?
BUSN 379 Week
BUSN 379 Week 6 Homework
Week 6 Assignment
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 6
BUSN 379 Week 6 Homework
3. Calculating Cost of Equity. Stock in CDB Industries has a beta of .90. The market risk
premium is 7 percent, and T-bills
BUSN 379 Week 5 Homework
Week 5 Assignment
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 5
Chapter 11
BUSN 379 Week 5 Homework
4. Portfolio Expected Return. You have $10,000 to invest in a stock portfolio. Your choices are
Stock X with an e
BUSN 379 Week 4 Homework
Week 4 Assignment
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 4
BUSN 379 Week 4 Homework
Calculating Payback. Global Toys Inc., imposes a payback cutoff of three years for its
international investment projects. If
BUSN 379 Week 3 Homework
Week 3 Assignment
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 3
Chapter 6
BUSN 379 Week 3 Homework
16) Both Bond Bill and Bond Ted have 7 percent coupons, make semiannual payments, and are
priced at par value. Bon
BUSN 379 Week 7 Homework
Week 7 Assignment
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 7
BUSN 379 Week 7 Homework
6) Calculating Net Float. Each business day, on average, a company writes checks
totaling $19,500 to pay its suppliers. The
BUSN 379 Week 2 Homework
Week 2 Assignment
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 2
Chapter 4
BUSN 379 Week 2 Homework
8) Calculating Rates of Return. In 2011, an 1880-O Morgan silver dollar sold for $13,113. What
was the rate of ret
BUSN 379 Week 6 Case Study III
Week 6 Case Study III
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 6
1.
Construct a spreadsheet to calculate the payback period, internal rate of return, modified
internal rate of return, and net present valu
BUSN 379 Week 2 Case
Week 2 Case
DeVry University
Professor Farrell
Author Note
BUSN 379 Week 2
1. An income statement for 2013 and 2014.
BUSN 379 Week 2 Case
2. A balance sheet for 2013 and 2014.
2013
2014
24,524
26,056
17,378
22,542
Accounts receivable
Case #2 - Ratios and Financial Planning at S&S Air
Sales
COGS
Other expenses
Depreciation
PBIT
Interest
PBT
Taxes (40%)
NPAT
R 128,700,000
R 90,700,000
R 15,380,000
R
4,200,000
R 18,420,000
R
2,315,000
R 16,105,000
R
6,442,000
R
9,663,000
Dividends
Add to
Jamie Bryant
BUSN 379
Professor Heath
Memo:
Boeing is probably not a good aspirant company. Even though both companies manufacture airplanes,
S&S Air manufactures small airplanes, while Boeing manufactures large, commercial aircraft. These are
two differe
Chapter 11
4.
Here, we are given the expected return of the portfolio and the expected return of each asset in the
portfolio, and are asked to find the weight of each asset. We can use the equation for the expected
return of a portfolio to solve this prob
3.
We have the information available to calculate the cost of equity, using the CAPM and the dividend
growth model. Using the CAPM, we find:
RE = .035 + .90(.07) = .0980, or 9.80%
And using the dividend growth model, the cost of equity is
RE = [$1.80(1.05
17.6. Net Float (10/10)
a. First scenario
1. The disbursement float.
Disbursement float = 4($19,500)
Disbursement float = $78,000
2. The collection float.
Collection float = 2($37,200)
Collection float = $74,400
3. The net float is the disbursement float
Case II is due at the end of this week. For this assignment, prepare a memo in Word, which answers
the questions in the Chapter 5 case, S & S Air's Mortgage, on page 165 of the textbook. Use Excel
to do any financial calculations. You will be graded on co
Case II is due at the end of this week. For this assignment, prepare a memo in Word, which answers
the questions in the Chapter 5 case, S & S Air's Mortgage, on page 165 of the textbook. Use Excel
to do any financial calculations. You will be graded on co
6-16)
assuming bond price is $1000.00
Current:
7% / 2
Bond Bill = 1,000 / (1+.0356) = $813.50
Bond Ted = 1,000 / (1+.03540) = $252.57
Increase by 2% / 2:
Bond Bill = 1,000 / (1+.0456) = $767.90
Bond Ted = 1,000 / (1+.04540) = $171.93
Decrease by 2% / 2
Bo
Please complete the following exercises from Chapters 12 and 13 of your textbook and post them in
the Dropbox.
Chapter 12: 3, 5, 6, and 15
Chapter 13: 1
12:3
$45.00
12:5
5.79%
12:6
Pretax cost of debt = 2.82%
Aftertax cost of debt = 2.09%
12:15
13:1
a.
No
Week 1: Chapter 2 Questions
Kevin Singh
Professor Luxe Isaac
BUSN - 379
DeVry University
Chapter 2
Questions: 8, 14, & 19
8. Calculating OCF. Hammett, Inc., has sales of $34,630, costs of $10,340, depreciation expense
of $2,520, and interest expense of $1
Week 2: Home Work
Kevin Singh
Professor Luxe Isaac
BUSN - 379
DeVry University
Week 3 Homework
Chapter 6: 16
Chapter 7: 11 & 12
Chapter 6: 16
Interest Rate Risk. Both Bond Bill and Bond Ted have 7 percent coupons, make semiannual
payments, and are priced
Calculating Cost of Equity (=Next Year's Dividends/stock price + dividends increase)
Beta
0.9
Market Risk Premium
7%
T-bills
3.50%
Dividend
$1.80 Per share, 5% increase annually, indefinitely
If Stock sales for $47 per share what is your best estimate of
Chapter 11
Problems 4, 7, 10
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel
Report #3-104
November 5, 2015
123 Abc Street
Anywhere, Anystate 12345
(111)222-3333
TO: Mark Tads, Owner, Sunset Boards
FROM:
SUBJECT: Financial Statements
INTRODUCTION
This report consists of the financial statements for Sunset Boards for the 2013 and 2
Chapter 4: 8, 17, 18
Chapter 5: 1, 4, 12
8. Calculating Rates of Return.
In 2011 an 1880-O Morgan silver dollar sold for $13,113. What was the rate of return on
this investment.
r= (FV/PV)^1/t-1
r=(13,113/1)^1/131-1
r= .0751 or 7.51%
17. Calculating Prese
Chapter 8
Problems 5, 6, 11, 15, 28
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed i
Chapter 17
Question 6
Input Area:
Value of checks
Clearing time
Received payment
Clearing time
New clearing time
$
$
19,500
4
37,200
2
1
a. Disbursement float
Collection float
Net float
$
$
$
78,000
(74,400)
3,600
b. Disbursement float
Collection float
Ne
123 Abc Street
Anywhere, USA 12345
(111)222-3333
Report #3-105
November 20, 2015
TO: Mark Sexton and Todd Story, Owners, S&S Air, Inc.
FROM:
SUBJECT: Mortgage Recommendations
INTRODUCTION
This report consists of the evaluation of different mortgages. It w