Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

please show the excel

Problem #3: Currently you have $127,000 (to be entered into cell B1) 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): 14.23 Answer correct to 2 decimals Problem #3(b): 1=NPER(B3,-B2,B1) Just Save Submit Problem #3 for Grading Problem #3 Attempt #1 Attempt #2 Your Answer: 3(a) 14.23 3(a) 3(b) =NPER(B3,-B2,B1) 3(b) Your Mark: 3(a) 0/1X 3(a) 3(b) 1/1 3(b) Attempt #3 3(a) 3(b) 3(a) 3(b) Attempt #4 3(a) 3(b) 3(a) 3(b) Attempt #5 3(a) 3(b) 3(a) 3(b)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Issues In Finance

Authors: Simon Grima, Frank Bezzina, Inna Romanova

1st Edition

1786359073, 978-1786359070

More Books

Students also viewed these Finance questions

Question

7. Why are good manners necessary for good business?

Answered: 1 week ago