need help with the today value year 30 and year 50

8 percent interest rate

Home File insert Formulas Data View Page Layout Review Help TI Caliber - 12 - A A == 23 Wap Port General Insert Delete For Paste B E E Merge & Center $ - % 6891 Conditional Formats Cell Formatting Table - Styles Styles Ceas Chipboard Font Algsent Number 314 f Year 50 D G H 18 b. 19 20 today 21 Suppose your friend has just inherited a large sum of money. Rather than making equal annual payments, she has decided to make one lump sum deposit today to cover her retirement needs. What amount does she have to deposit today? Lump sum deposited $87,813.12 PV Today Year 30 Year 50 Suppose your friend's employer will contribute to the account each year as part of the company's profit sharing plan. In addition, your friend expects a distribution from a family trust several years from now. What amount must she deposit annually now to be able to make the desired withdrawals at Employer's annual contribution: $ Years until trust fund distribution: 20 Amount of trust fund distribution: 25,000 1,500 22 C 21 24 25 26 27 28 S 29 30 31 Value of employer's contribution at retiremer $169,924.82 PVANN Value of trust fund at retirement: $251,566.42 FV TODAY TODAY YEAR 30 YEAR 30 YEAR 20 Amount to save each year now $11,520.90 PM TODAY YEAR 30 32 33 34 Number Styles pboard 5 Font Alignment 4 Year 50 A B D This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She hast retirement and retirement spending goals: $ Years until retirement: Amount to withdraw each year: Years to withdraw in retirement: Interest rate: 30 90,000 20 8% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make eq deposits into her account for her retirement fund. What amount will she need at her retirement date? 4 5 Needed at retirement date: $883,633 27 PV Ann Today YEAR 30 Year 50 It she starts making these deposits in one year and makes her last deposit on the day she retires, what amount must she deposit ann make the desired withdrawals at retirement? Amount to save each year: 57,800.21 PMT Today Year 30 Year 50 60 17 TB Suppose your friend has just inherited a large sum of money Rather than making equal annual payments, she has decided to make o Sheet1 Number pboard Alignment Styles Font 4 Year 50 A B D This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She hast retirement and retirement spending goals: Years until retirement: Amount to withdraw each year: Years to withdraw in retirement: Interest rate: 30 90,000 20 8% 3 4 5 Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make eq deposits into her account for her retirement fund. What amount will she need at her retirement date? Needed at retirement date: $883,633.27 PV Ann Today YEAR 30 Year 50 It she starts making these deposits in one year and makes her last deposit on the day she retires, what amount must she deposit ann make the desired withdrawals at retirement? Amount to save each year: $7,800.21 PMT Today Year 30 6 17 18 Year 50 Suppose your friend has just inherited a larre sum of money, Rather than makine equal annual payments, she has decided to make o Sheet1 Excel is a tool for solving problems, but with many time value of money problems, you may still need to dr- This is a classic retirement problem. A triend is celebrating her birthday and wants to start saving tor her a retirement and retirement spending goals: $ Years until retirement: Amount to withdraw each year: Years to withdraw in retirement: Interest rate: 30 90,000 20 8% $ Because your friend is planning ahead, the first withdrawal will not take place until one year after deposits into her account for her retirement fund. What amount will she need at her retirement de Needed at retirement date: $883,633.27 PV Ann Today YEAR 30 It she starts making these deposits in one year and makes her last deposit on the day she retires