— Robert Iger, CEO of Disney
Accounting and the Time Value of Money (Part S)
by
Charles Lamson
Solving for the Payment Amount. Finally, problems may require solving for the amount of the payment.
We solve for the payment amount, PMT, using the PMT function in a spreadsheet cell as follows: = PMT(I/Y,N,PV,FV,type) All variables are previously defined. To solve the problem in Example 7.29, enter the following amounts in each cell. The spreadsheet provides the solution $(24,999.95). To solve the problem in Example 7.29 with a financial calculator, enter the following keystrokes. The calculator provides the payment amount of $( 24,999.95). These keystrokes correspond to an annuity with 10 payments at a 4% interest rate per compounding period and a present value of $202,772. *GORDON, RAEDY, SANNELLA, 2019, INTERMEDIATE ACCOUNTING, 2ND ED., PP. 350-351* |
No comments:
Post a Comment