— Jason Fried, CEO of Basecamp
Accounting and the Time Value of Money (Part M)
by
Charles Lamson
Factor Table Solution for Solving Present Value of Ordinary Annuity Problems. Table 7A.5 presents the factors for solving present value of ordinary annuity problems. Equation 7.14 solves present value of ordinary annuity problems using the factors in Table 7A.5.
Refer to the factor that is in the row for the number of compounding periods and the column for the interest rate per compounding period. For example, referring to Exhibit 7.12, the factor associated with four periods and a 2% interest rate is 3.80773. EXAMPLE 7.22 Present Value of an Ordinary Annuity: Table Approach Spreadsheet Solution to Solve the Present Value of Ordinary Annuity Problems. To solve the present value of ordinary annuity problems with a spreadsheet application such as Microsoft Excel, input the following variables into a spreadsheet cell: = PV(I/Y,N,PMT,FV,type) For the present value of an ordinary annuity, do not import a variable into the fifth position because if it is omitted, it is assumed to be zero. because the type defaults to zero, do not include the last variable when the payment occurs at the end of each period. Financial Calculator Solution for Value of Ordinary Annuity Problems. Finally, present value of an ordinary annuity problems can be solved using a financial calculator. To solve the problem in Example 7.23, enter the following keystrokes. The calculator shows the present value of the annuity is $(124,622.10). These keystrokes correspond to an inflow of $10,000 for 20 compounding periods at a 5% interest rate per compounding period. Note that the calculator defaults to “end mode” for an ordinary annuity because the cash flows occur at the end of each period. *GORDON, RAEDY, SANNELLA, 2019, INTERMEDIATE ACCOUNTING, 2ND ED., PP. 341-342* end |
No comments:
Post a Comment