Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please need it as soon as possible. Thank you! Annuity Factor: PV(rate,nper,pmt,fv,type) Annuity Factor: PV(rate,nper,pmt,fv,type) B C D G H Make Your Own Present Value

Please need it as soon as possible. Thank you!

image text in transcribed
Annuity Factor: PV(rate,nper,pmt,fv,type) Annuity Factor: PV(rate,nper,pmt,fv,type) B C D G H Make Your Own Present Value Table Our objective is to prepare two present value tables: PV of a lump sum, and PV of an annuity. Excel has many present value functions, although you can also get great results just using formulas. PV OF $1.00 =1/(1+r)^n Use this formula for PV of $1.00 Format for 4 digits PRESENT VALUE OF $1.00 Periods 4.00% 5% 6% 8% 10% 12% 0.9615 0.9246 AWN 0.8890 0.8548 1. Put a heading on your PV table--Present Value of $1.00 (the lump sum table) 2. Choose what interest rates you want. 3. You can enter periods 1 and 2; select both with a mouse; drag fill handle down the page. 4. The formula in D 14 is: =1/(1+$D$13)^C 14 The formula in D 15 is: =1/(1+$D$13)^C15 The formula in D 16 is: =1/(1+$D$13)^C 16 PRESENT VALUE OF A SERIES OF $1.00 CASH FLOWS Periods 4.00% 4% 6% 8% 10% 12% 0.9615 1.8861 AWN - 2.7751 3.6299 In Cell D29 =PV($D$28,C29,-1) Note: the "minus one" makes the table value a positive number. It would be a good idea to compare your tables with these check figures: 4% 5% 6% 8% 4% 5% 6% 8% 0.9615 0.9524 0.9434 0.9259 0.9615 ).9524 0.9434 0.9259 0.9246 0.9070 0.8900 0.8573 1.8861 1.8594 1.8334 1.7833 0.8890 0.8638 0.8396 ).7938 2.7751 2.7232 2.6730 2.5771 0.8548 0.8227 0.7921 0.7350 3.6299 3.5460 3.4651 3.3121 0.8219 0.7835 0.7473 0.6806 4.4518 4.3295 4.2124 3.9927 45 You can choose whatever range of interest rates interests you. This is 46 particularly helpful if you are testing the sensitivity of a loan payment with 47 respect to an anticipated interest rate, for example

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting The Cornerstone Of Business Decision Making

Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

8th Edition

0357715349, 978-0357715345

More Books

Students also viewed these Accounting questions