BVL Chapter 4 HW Due 9.7.11

# BVL Chapter 4 HW Due 9.7.11 - 64 A Guide to Microsoft Excel...

This preview shows pages 1–2. Sign up to view the full content.

64 A Guide to Microsoft Excel 2007for Scientists and Engineers Problems The function NPER can be used to compute how many periods needed for a certain scenario, and PMT gives the size of deposit for another scenario. The function to compute how is being applied to pay interest is IPMT, while PPMT tells much is used to payoff the principal. The syntax for RATE compute the needed rate for a certain financial scenario) RATE(nper, pmt, pv, fv, type, guess). The last argument may strange. Look at the financial equation above and you will see cannot be solved explicitly for rate. Excel needs to perform iterative routine to get an answer. Generally we can omit guess argument. If the successive results of RATE do not to within 0.0000001 after 20 iterations, RATE returns the #N error value. Under these circumstances, we can try to assist by giving a guess at the answer. 1. *When you have tabulated data and no function but need differential, the following formula may be used. Forward dy =:: Y 1 - Yo dx h Backward --~--j- dy Yo - Y-I dt h dx 2h The voltage drop (V) across an inductance (L) is given by V =L di dt In Figure 4.12 the central difference formula is used interior points, and the forward and backward formulas

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

BVL Chapter 4 HW Due 9.7.11 - 64 A Guide to Microsoft Excel...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online