Bus302: principles of Financial Management
Chapter 1: Productivity
1. Chatham Lumber makes wooden boxes in which to ship powertools. Eight employees work a total of 32
hours per day making 1800 boxes.
a. Compute the labor productivity?
1800/32 = 56.25 boxes per hour
b. After redesigning the proces
Ch. 01 HW
Ch. 02 HW
Textbook Ex. 1
Value of Stockholders Equity?
Total Assets = Total Liabilities plus Equity or Total Assets
Less Total liabilities
How much is net working capital?
Notes: You must first activiate "=YIELD" and "=PRICE" bond functions in Excel , or your output may turn out to be "e
A.This is for Excel 2003 only:
1) Go "Tools"=>"Add-Ins" and have the top two "Analysis Toolpack" boxes checked;
2) Put =PRICE and =YIELD i
Chapter 07 HW: Part A, End-of-chapter "Questions & Problems"
Question 3 - Staind, Inc., has 7.5 percent coupon bonds on the market that have
10 years left to maturity. The bonds make annual payments. If the YTM on these
bonds is 8.75 percent, what is the
Chapter 06, HW Part B, Off-Textbook-Exercise 1 (Home mortgage problem):
You are applying for a 30-year, fixed-rate (APR 6.50%) mortgage loan for a house that sells for
$80,000 today. The mortgage bank will ask you for 20% initial down payment of the house
Chapters 5 & 6 Power Point Examples using Excel formulas
Click on the asnwer amount to see what to put in the Excel function.
When you change any of those PV, FV, inputs, your answers will be updated.
Example 1 - compute future value (FV):
Chapter 05 Assignments
When you change any of those PV, FV, inputs, your answers will be automatically updated.
PS: In business calculator or Excel function, all cash inflows must be put as positive, all cash outflows mus
Inflows include money receipts, i