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:
**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. Also, once completed, go to Print, Print Area, and Set Print Area after highlighting the entire worksheet (including your answer to the question at the bottom of the page). 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 two pages -- your numbers and your cell formulas printouts -- on Monday 2/20 at the beginning of class.
(See below for how to get cell formulas to print.)Help! I don't know how to do cell formulas in Excel => do the tutorial
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 Monday 2/20 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 values and cell formulas (use CTRL ~, with the tilde character
just above the ESC key) numbers, and turn in both.** Helpful "handout" on Excel #2 => Handout of Instructions on Excel #2
** Right-Click (Save Target As) here to download: ->______________(hold down CTRL and press F5 key if you don’t see linked file)
Since this is revised from Prob. 9-10, 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 worksheet which you will modify, click above; the completed worksheet (print out values and cell formulas)
is due at the final exam, Mon. 4/23 @ 10 a.m.
(5) EXAMS:
See Course Schedule/Game Plan (link at top of this page).
* UNIT I:
Chapters 1-3:
The first exam is on Monday, 2/6, and is over Chapters 1-3, Principle of Financial Planning, and three of the four assigned ethics boxes in this unit.
+ 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.
- What does Luke 14:28 imply about our view of liquidity and financial planning?
- Click here for helpful handout on calculating Operating Cash Flow
+ Click here for => Exam 1 Tables Cover Sheet (first part of cover sheets)
and here for => 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 (see Announcements section), and due 2/18 (see Game Plan), at the beginning of class.
The second exam is on Wednesday, 2/29, 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 (note: Spr 11 bonus is on Andrew Haines presentation)
* 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 (note: also do ST 5-1 for the homework assignment).
The third exam, covering Chaps. 6-7, is on Wednesday,
3/28.
* 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, as well as 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 covered on this exam are found on pp. 247, 289.
* What does Proverbs 22:3 imply about our view of risk?
* 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 and the Reading the Bond Table handout linked below
for questions on that (covered in class)
- Extra info on stock market and reading stock pages (BUT NOT ON EXAM)
- Reading the Bond Table
- Recent bond quotes* 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:
Due at the final exam (bring printouts of values and cell formulas).
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 Mon. 4/23 at 10-12 (Bring calculator and
Excel #2 to turn in, with cell formulas.)
* Study Guide for Final Exam. NOTE: STUDY CONCEPTS, TOO, especially Chap. 9 handout.
* What does Proverbs 22:7b imply about our view of debt?
* 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
*OPTIONAL READINGS ON INITIAL INVESTMENT:
*Public financing and cost overrun (Initial Investment way off)
*Reducing Scope of Project to fit Initial Investment constraint
=> Return to www.johnzietlow.com