Develop a single spreadsheet that allows you to calculate any of the P|A, A|P F|A, or A|F
Question:
Develop a single spreadsheet that allows you to calculate any of the P|A, A|P F|A, or A|F 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 F|A factor, your control panel must include i and n. Test each of your factors against the tables in Appendix A to ensure they work right. Keep this handy. It will be useful to you.
Transcribed Image Text:
Appendix A TABLE A-a-1 Uniform Series Given P Single Sums To Find F To Find P Given F To Find F To Find A To Find P To Find A Given A Given F n (FP i%,n) (PF i%,n) (FA,i%,n) (A|Fi%,n) Given A (PA,i%.n) Given P (A|P i%,n) Gradient Series To Find P Given G (P|Gi%,n) To Find A Given G (A|Gi%,n) 1 1.00250 0.99751 1.00000 1.00000 0.99751 1.00250 0.00000 0.00000 2 1.00501 0.99502 2.00250 0.49938 1.99252 0.50188 0.99502 0.49938 3 1.00752 0.99254 3.00751 0.33250 2.98506 0.33500 2.98009 0.99834 4 1.01004 0.99006 4.01503 0.24906 3.97512 0.25156 5.95028 1.49688. 5 1.01256 0.98759 5.02506 0.19900 4.96272 0.20150 9.90065 1.99501 6 1.01509 0.98513 6.03763 0.16563 5.94785 0.16813 14.82630 2.49272 7 1.01763 0.98267 7.05272 0.14179 6.93052 0.14429 20.72235 2.99001 8 1.02018 0.98022 8.07035 0.12391 7.91074 0.12641 27.58391 3.48689 9 1.02273 0.97778 9.09053 0.11000 8.88852 0.11250 35.40614 3.98335 10 1.02528 0.97534 10.11325 0.09888 9.86386 0.10138 44.18420 4.47940 11 1.02785 0.97291 11.13854 0.08978 10.83677 0.09228 53.91328 4.97503 12 1.03042 0.97048 12.16638 0.08219 11.80725 0.08469 64.58858 5.47025 13 1.03299 0.96806 13.19680 0.07578 12.77532 0.07828 76.20532 5.96504 14 1.03557 0.96565 14.22979 0.07028 13.74096 0.07278 88.75874 6.45943 15 1.03816 0.96324 15.26537 0.06551 14.70420 0.06801 102.24409 6.95339 16 1.04076 0.96084 16.30353 0.06134 15.66504 0.06384 116.65666 7.44694 17. 1.04336 0.95844 17.34429 0.05766 16.62348 0.06016 131.99172 7.94008 18 1.04597 0.95605 18.38765 0.05438 17.57953 0.05688 148.24459 8.43279 19 1.04858 0.95367 19.43362 0.05146 18.53320 0.05396 165.41059 8.92510 20 1.05121 0.95129 20.48220 0.04882 19.48449 0.05132 183.48508 9.41698 21 1.05383 0.94892 21.53341 0.04644 20.43340 0.04894 202.46341 9.90845 22 1.05647 0.94655 22.58724 0.04427 21.37995 0.04677 222.34096 10.39951 23 1.05911 0.94419 23.64371 0.04229 22.32414 0.04479 243.11313 10.89014 24 1.06176 0.94184 24.70282 0.04048 23.26598 0.04298 264.77534 11.38036 25 1.06441 0.93949 25.76457 0.03881 24.20547 0.04131 287.32301 11.87017 26 1.06707 0.93714 26.82899 0.03727 25.14261 0.03977 310.75160 12.35956 27 1.06974 0.93481 27.89606 0.03585 26.07742 0.03835 335.05657 12.84853 28 1.07241 0.93248 28.96580 0.03452 27.00989 0.03702 360.23340 13.33709 29 1.07510 0.93015 30.03821 0.03329 27.94004 0.03579 386.27760 13.82523 30 1.07778 0.92783 31.11331 0.03214 28.86787 0.03464 413.18468 14.31296
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (QA)
Answered By
Jehal Shah
I believe everyone should try to be strong at logic and have good reading habit. Because If you possess these two skills, no matter what difficult situation is, you will definitely find a perfect solution out of it. While logical ability gives you to understand complex problems and concepts quite easily, reading habit gives you an open mind and holistic approach to see much bigger picture.
So guys, I always try to explain any concept keeping these two points in my mind. So that you will never forget any more importantly get bored.
Last but not the least, I am finance enthusiast. Big fan of Warren buffet for long term focus investing approach. On the same side derivatives is the segment I possess expertise.
If you have any finacne related doubt, do reach me out.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Principles Of Engineering Economic Analysis
ISBN: 9781118163832
6th Edition
Authors: John A. White, Kenneth E. Case, David B. Pratt
Question Posted:
Students also viewed these Business questions
-
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...
-
Develop a single spreadsheet that allows you to calculate the P|G, F|G, and A|G factors. For each cell where the calculation is performed, place above it a small control panel that allows you to...
-
Develop a single spreadsheet that allows you to calculate F|P and P|F factors. For each cell where the calculation is performed, place above it a small control panel that allows you to enter whatever...
-
Timetrics 2016 survey of insurance professionals explores the use of technology in the industry. The file Technologies contains the responses to the question that asked what technologies these...
-
The investments of Harlon Enterprises included the following cost and fair value amounts ($ in millions): Harlon accounts for its equity investment portfolio at fair value through net income. Harlon...
-
Describe how self-management impacts the communication process.
-
FOB shipping point means that transportation charges are paid by the seller. True/False
-
The bank portion of the bank reconciliation for Horsman Company at October 31, 2012, is shown here and on the next page. The adjusted cash balance per bank agreed with the cash balance per books at...
-
helpasap How much interent dooe an ATT Lld. bond pay annually, given the following information? \( \$ 1000 \) par valuo, maturily Dec 22, 2023, semi - anmual coupon 7.75 percent. prioe \( \$ 10550...
-
If you borrow \($40\),000 at 9 percent annual compound interest and pay it back with 7 equal annual payments, what will be the size of each payment if the first payment occurs 1 year after borrowing...
-
The manager at a Sherwin-Williams store has decided to purchase a new \($30\),000 paint-mixing machine with hi-tech instrumentation for matching color and other components. The machine may be paid...
-
George has $5000 to invest in a mutual fund. The expected return on mutual fund A is 15% and the expected return on mutual fund B is 10%. Should George pick mutual fund A or fund B?
-
Assume the following open economy C 300 +0.80(Y-125) I=150 G=250 X=115 M = 125+.05Y a. Determine (solve for) the equilibrium level of income or GDP (Y). b. Determine the impact on income of a 50...
-
I have an case analysis for Carolinas health care system: Consumer Analytics. This is for post graduate level assignment. ri problems, possible solutions, Recommendations and Outcomes is the...
-
How does the concept of deviance evolve within different cultural and social contexts, and what role do societal institutions, such as law enforcement and the criminal justice system, play in...
-
a) Download the same day high-frequency historical data for BTC and ETH by using yfinance . (It can be any day between 1 st Dec 2022 and 31 st Dec 2022, make sure you have the same length of the...
-
Healthcare Reimbursement 1. What are some health reimbursement issues and includes an accurate and detailed explanation of the key aspects of the topic? 2. What's an in-depth analysis that...
-
The following comparative income statement information was provided by AMR Corp., the parent company of American Airlines for the years ended December 31, 2004 and 2003. 1. Provide a vertical...
-
According to a New York Times columnist, The estate tax affects a surprisingly small number of people. In 2003, . . . just 1.25 percent of all deaths resulted in taxable estates, with most of them...
-
Select all that apply The Handbook defines three different types of contributions: (select all that apply) Multiple select question. Restricted contributions Unrestricted contributions Endowment...
-
A NFPO has the following options for reporting net assets invested in capital assets Multiple select question. Disclose it in the notes to the statements Disclose it in the Management Discussion &...
-
Information found on any one of the major financial statements . Group of answer choices comes exclusively (only) from one of the other major financial statements is provided to a company by the IRS...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App