Mission Statement

The Rant's mission is to offer information that is useful in business administration, economics, finance, accounting, and everyday life.

Saturday, September 23, 2023

Accounting: The Language of Business - Vol. 2 (Intermediate: Part 103)


“There’s nothing wrong with staying small. You can do big things with a small team.”
— 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.


Click to enlarge.


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

Accounting: The Language of Business - Vol. 2 (Intermediate: Part 145)

2 Corinthians 8:21 "Money should be handled in such a way that is defensible against any accusation" Short-Term Operating Assets: ...