Click here for=> Check
Figures & Complete Solutions for Chap. 9 Homework
(DOC)
Check figures & Complete solutions for ch 9 HW - PDF file
Note: Chapter 9 check figures
also serve as the Chap. 9 complete solutions.
COMPLETE SOLUTIONS FOR FINANCE HOMEWORK (POSTED
2 days AFTER DUE
DATES):
**All of these are on the
R: shared faculty-student drive, which you can access on
campus.
* Excel Assignment 1: Right click the following link, then Save Target As (to floppy or desktop) to get -> Excel 1 Cash Budget worksheet. Also, once completed, go to Print, Print Area, and Set Print Area after highlighting the entire worksheet (including your answer to question part (b)). Then you can print out your answers. Once you have that printed, get to cell formulas by simultaneously holding down the CTRL key and ~ (right below ESC key on top left of keyboard). Make sure to highlight the formulas part of your worksheet, then print that out. Turn in both your numbers and your cell formulas printouts on Fri. 10/5 at the beginning of class.
(See below for how to get cell formulas to print.)
I recommend that you do the work "by hand" with a calculator to know that your numbers are right. Also, once completed, go to Print, Print Area, and Set Print Area after highlighting the entire worksheet (including your answer to question part (b)). Then you can print out your answers. Once you have that printed, get to cell formulas by simultaneously holding down the CTRL key and ~ (right below ESC key on top left of keyboard). Make sure to highlight the formulas part of your worksheet, then print that out. Turn in both your numbers and your cell formulas printouts.
- Assignment worksheet printouts (2 of them - -one of the number values, the other one for formulas) due 10/5 at beginning of class period. Print out values (numbers), then print out cell formulas (use CTRL ~, with the tilde character just above the ESC key), and turn in both printouts.
- Get helpful cash budget handout here => Cash Budgeting Guidelines Handout
* Excel Assignment #2 due at beginning of final exam. Don't forget cell formulas, too.
*Download Excel Assignment #2 below (right-click, Save Target As, select hard drive or network space),
due at beginning of final exam.
Print out cell formulas (use CTRL ~, with the tilde character
just above the ESC key) numbers, and turn in both.
Right-Click (Save Target As) here to download: -> Excel Worksheet for Excel #2
Ignore any reference to Problem 9-10. In the part (c), if you put X or Y, you are saying
that the company should invest in that project. See page 361 of your text on how to do IRR in Excel.
For guidelines, click above for handout to guide you on the Excel project, which is due at the final exam, Friday, April 25, 10 a.m..
(5) EXAMS: See Course Schedule/Game Plan (link at top of this page).
The first exam is over Chapters 1-3, and three of the four assigned ethics boxes in this unit, with exam in class on ______.
+ Click here for ETHICS BOX #1
+ Click here for Chapter 2 XLS worksheets (not required, but helpful on ratio calculations).
+ Click here for => Calculations Review Handout for Exam I. (only study guide)
Study concepts, too, for items not excluded. Especially focus on interpreting calculated numbers.
- Click here for helpful handout on calculating Operating Cash Flow
+ Click here for => Exam 1 Tables Cover Sheet (first part of cover sheets)
Exam 1 Ratios Formulas Cover Sheet (second part of cover sheets)
+ Click here for extra help on DuPont=> DuPont System Handout
+ Greater Understanding of DuPont and How Companies Use It
+ Get the DuPont Template for course project (do one for each of the 3 years for course project)
+ Statement of Cash Flows Handout (not on exam; use as part of liquidity analysis on course project)
+ Help on how to develop and interpret a Cash Budget
same item, in PDF format: develop & interpret a Cash Budget
+ Example of financial ratios table (not for exam, but for individual part of the course project)
+ (optional reading) Role of CFO (from Motley Fool)
+ Excel #1 is available above, due ___ at the beginning of class.
The second exam is on Wed. 2/27, and includes calculations and interpretations
from Chaps. 4 and 5 as well as the two ethics boxes assigned for these two chapters.
Ecclesiastes 11:2 (NIV) & Principle of Diversification.
Exam Items:
* Here is the Study & Review Guide for Exam 2.
* HW Problem 4-45 using HP 10BII for Car Loan Payment
* Formulas Cover Sheet that you will be provided with at the 2nd exam.
* BONUS ARTICLE on Socially Responsible Mutual Funds
* Ethics Box for Chapter 5 => What About Moral Risk?Other Unit II Materials:
* Click here for HP-10BII learning modules from HP (ZIP download, 2.8 MB): HP 10-B Learning Modules Zip File.
* Click here for basic time value of money learning module from HP for the 10BII (included in the above Zip file).
* Click here for Chapter 4 handout on using HP 10BII to do semi-annual, quarterly, continuous compounding.
* Click here for Chapter 5 assignment and std. dev. helps.
The third exam, covering Chaps. 6-7, is on Wed. 4/7.
* Here is the Study & Review Guide for Exam 3. Note: Do focus on the stock calculations handout and the bond table
in the new edition of the textbook.
* Also, here is the formulas cover sheet you will be provided at the 3rd exam. And the bond table cover sheet.
* Make sure you have studied the handout on reading the stock table (below),
and know how to do all of the calculations. Also, review the handout on bond value
calculations (below) and practice YTM calculations on your calculator.
* Ethics boxes on pp. 247, 289.
* Handout on Reading the Stock and Bond Tables (covered on Exam 3):
- Reading the Stock Table (left click to view and then print)
- Note: also study the bond table exhibit in your text for questions on that
(covered in class)
- More info on stock market and reading stock pages (BUT NOT ON EXAM)
- NEW: Reading the Bond Table* Handout on Bond Value Calculation using HP 10-BII (for Chap. 6, covered on Exam 3):
- Calculating the Value and YTM of a Bond using semi-annual interest.
- Note: to do YTM, you enter the bond's price with a [+/-] then press the I/YR key to get YTM.
EXCEL #2 Assignment:
See
above under Announcements (Item #4) for worksheet and
instructions.
In the part (c),
if you put X or Y, you are saying
that the company should invest in that project (X or Y).
If it should do neither, put "neither."
See page
361 of your text on how to do
IRR in Excel. (TI-83 users, see handout below on how
to
do keystrokes to check your IRR using your TI-83)
The
FINAL EXAM covers
Chaps. 8-9, all ethics boxes in 8 and
9,
and capital structure
bonus articles (see below).
It is on Fri. 4/25, 10:00 a.m. - 12:00
noon (Bring calculator.)
* Study Guide for Final Exam. NOTE: STUDY CONCEPTS, TOO, especially Chap. 9 handout.
* Handouts covered on final exam:
=> Bonus question article for the final exam => Minor League Baseball & Debt
=> Second bonus question article => Baseball & Debt
* Extra Practice problem, P8-21
* Explanation of extra practice problem Problem 8-17 part (a)
* Explanation of Problem 8-14 Year 6 OCI
* Handout on Chapter 9 (important!)
* How-to Guidesheet on Using TI-83 to do NPV and IRR
* Formulas Sheet for Final Exam