Teaching 23-year-olds in an MBA programme strikes me as largely a waste of time. They lack the background of experience. You can teach them skills - accounting and what have you - but you can't teach them management.
Accounting and the Time Value of Money (Part K)
by
Charles Lamson
Spreadsheet Solution to Calculate the Future Value of an Ordinary Annuity. To calculate the future value of an ordinary annuity using a spreadsheet application such as Microsoft Excel, input the following variables into a spreadsheet cell:
= FV(I/Y, N,PMT,PV,type) For the future value of an ordinary annuity, do not input a variable into the fifth position, because 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 the Future Value of an Ordinary Annuity. Finally, we solve for the future value of an ordinary annuity using a financial calculator. To solve the problem in Example 7.17 enter the following keystrokes. Note that the default mode for the calculator is “ end mode,” or it is set to compute an ordinary annuity with cash flows occurring at the end of each period. These keystrokes correspond to an outflow of $100,000 for 16 compounding periods at a 3% interest rate per compounding period. From the calculator, Manoli will have $2,015,688.13. *GORDON, RAEDY, SANNELLA, 2019, INTERMEDIATE ACCOUNTING, 2ND ED., PP. 334-335+ end |
No comments:
Post a Comment