Develop a single spreadsheet that allows you to calculate the (P|A1, i%, j%,n), (F|A1,i% j%, n), and

Question:

Develop a single spreadsheet that allows you to calculate the (P|A1, i%, j%,n), (F|A1,i% j%, n), and (A/A1 i%, j%,n) factors. For each cell where the calculation is performed, place above it a small "control panel" that allows you to enter whatever numbers you need to perform the calculation. For example, for the (P/A i%, j%, n) factor, your control panel must include i, j, and n. Test the first two factors using i = 7 percent, j = 5 percent, and n = 10 against the tables in Appendix A to ensure they work right. Then, using A = $1,000, i = 7 percent, and j = 5 percent, calculate A using the third factor and check it against (P|A i%, j%,n)*(A|P i%,n). Keep this handy. It will be useful to you.


image text in transcribed

image text in transcribed

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Principles Of Engineering Economic Analysis

ISBN: 9781118163832

6th Edition

Authors: John A. White, Kenneth E. Case, David B. Pratt

Question Posted: