Chapter 6
Problems 1-37 (odd problems)
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 installe
Chapter 11
Problems 1-37 (odd problems)
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 install
FIN610
Group Assignment - #1
Bethesda Mining
Data
Contract qty
Production:
1st year
2d year
500,000
3d year
4th year
Price per ton
Spot market price per ton
Variable cost per ton
Fixed cost
NWC (of sales)
tax
$
$
$
$
620,000
680,000
730,000
590,000
82.00
Internal Rate of Return (IRR)
Internal rate of Return (IRR) is an interest rate at which the Net Present Value (NPV) of
all cash flows from a project equal zero, and evaluates the attractiveness of the project
or investment. In order to accept the project
1.
The financial ratio measured as net income divided by total assets is known as the firms:
a. profit margin.
b. return on assets.
c. return on equity.
d. asset turnover.
e. earnings before interest and taxes.
2.
The three parts of the Du Pont identity c
PROBLEM 2-6
Given
TCM Petroleum
Sales
Cost of Goods Sold
Gross Profit
Selling, General, & Administrative Expense
Operating Income Before Deprec.
Depreciation, Depletion, & Amortization
Operating Profit (NOI)
Interest Expense
Non-Operating Income/Expense
S
Question 1
Under which of the following discounting methods will the present value of an investment be the highest,
assuming the same annual interest rate?
Yearly
Monthly
Continuous
Quarterly
Question 2
Future value: Larry James is planning to invest $25,
Score:30/30Points100%
Question 1 (of 3)
1.
Award: 10 out of 10.00 points
Show correct answer
Problem 8-26 Components of Bond Returns
-2-2
http:/ /ezto.mhedu
Bond P is a premium bond with a 9 percent coupon. Bond D is a 5 percent coupon bond currently sell
Score:30/30Points100%
Question 1 (of 3)
1.
Award: 10 out of 10.00 points
Show correct answer
Problem 6-18 Cash Flow Valuation
-2-2
http:/ /ezto.mhedu
Phillips Industries runs a small manufacturing operation. For this fiscal year, it expects real net cash
Chapter 9
Problems 1-35 (odd problems)
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 installe
Chapter 8
Problems 1-31 (odd problems)
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 installe
Chapter 7
Problems 1-29 (odd problems)
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 installe
Chapter 8
Problems 1-31 (odd problems)
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 installe
Chapter 9
Problems 1-35 (odd problems)
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 installe
Chapter 11
Problems 1-37 (odd problems)
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 install
$VVLJQPHQW3ULQW9LHZ
Score:
37.50/40
Points
93.75
%
KWWSH]WRPKHGXFDWLRQFRPKPBILQDQFHWS["WRGR SULQWYLHZ
1.
$VVLJQPHQW3ULQW9LHZ
Award: 10 out of 10.00 points
Problem 4-28 Annuity Present Values
:KDW LV WKH SUHVHQW YDOXH RI DQ DQQXLW\ RI SHU \HDU ZLWK WKH IL
Chapter 7
Bunyan Lumber, LLC
Input area:
Total acreage
Years since original planting
1P pond value
2P pond value
3P pond value
Cash flow/acre from thinning
Years from today for harvest
to begin
20
25
30
35
Defect rate
Tractor cost (MBF)
Road (MBF)
Sale pr
Board of Directors and Ethics Codes in Different
Corporate Governance Systems
By:
FIN 610
Apr 3, 2016
Turnitin.com similarity score: 26%
Board of Directors and Ethics Codes in Different Corporate
Governance Systems
Abstract
Corporate Governance (CG) is a
Score:20/20Points100%
Question 1 (of 2)
1.
Award: 10 out of 10.00 points
Show correct answer
Problem 7-16 Sensitivity Analysis
-2-2
http:/ /ezto.mhedu
McGilla Golf is evaluating a new golf club. The clubs will sell for $875 per set and have a variable cos