ou observe in 2. An investor has a principal amount of $P. If he er Year desires a payout (return) of 0.1P each year, how many 10% years will it take to deplete an account that earns 8% per year? 0.1P = P(A/P, 8%, N), SO N ~= 21 years. A payout duration table can be constructed for select payout percentages and compound interest rates. Complete the following table. (Note: table entries are years.) Summarize your conclusions about the pattern observed in the table. ( spreadsheet that calculates PW. FW. AW. IRR, and ERR for the ARR = 20% per year. Does your recommendation change if the MARRwhen she is 60. Comment on the pattern you observe in the table. (5.4) 2. Interest Rate per Year de 4% 6% 8% 10% ye Payout per Year 10% 20.9 pe ( of principal) 205% 0. A pa ye ob 3. Refer to Example 5-13. Create a single spreadsheet that calc proposed investment. Assume that e = MARR = 20% per year