Question: please show the excel reference Problem #3: Currently you have $127,000 (to be entered into cell Bl] in your account. You can earn a rate

 please show the excel reference Problem #3: Currently you have $127,000

please show the excel reference

Problem #3: Currently you have $127,000 (to be entered into cell Bl] in your account. You can earn a rate of 8.17% per year [to be entered into cell B3] on your account, and plan to withdraw $15897.64 at the end of each year [to be entered into cell B2). B A 1 Present Value 2 Annual Withdrawal 3 Annual Rate 4 5 Number of Years 6 (a) How long it will take you in years) to exhaust your account (cell B5]? Use the NPER function. (b) What is the correct formula (using 16 characters or less) that should be placed in cell B5? Problem #3(a): Answer correct to 2 decimals Problem #3(b)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!