BVL Chapter 4 HW Due 9.7.11

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online