Question: please solve on excel and show formula for final answer. thanks A . B D 1 PV 2 Rate 3 NPER present value interest rate

please solve on excel and show formula for final answer. thanks

A . B D 1 PV 2 Rate 3 NPER present value interest rate number of periods payment per period future value beginning of period (1) or end (0) 4 PMT 5 FV 6 Type 7 8 9 10 11 Mike is hoping to spend 18 months on a Greek island programming the great new computer game (and tasting a little ouzo). Mike figures he will need $3,000 per month to live and $800 at the end of the period for transportation home. How much money would Mike need to deposit initially in an account paying 6% interest per year to be able to withdraw $3,000 per month for 18 moths and have $800 left at the end? - From Gips, Ch. 14, p. 273 12 13 14 15

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!

please help ASAP show formulas as well please . thumbs up for all correct answers. If you plan on only answering one question please dont answer. a. Future Values = FV = PV X (1+r)" Present Value...

Future Value Present Value Rate Number of periods Payment NPV for cashflows Time Value of Money Formulas =FV (rate, nper, pmt, [pv]. [type])-PV (rate, nper, pmt, [fv], [type]) = RATE (nper, pmt, pv,...

1. Midnight Hour Inc. has declared a $6.30 per share dividend. Suppose capital gains are not taxed, but dividends are taxed at 25%. New IRS regulations require that taxes be witheld at the time the...

Year Project A Project B 0 -$14,500 -$9,800 1 8,500 4,700 2 6,800 4,200 3 2,800 4,100 Chapter 7 problem 1b 1b. Suppose the company uses the NPV rule to rank these two projects. Which project should...

1. Calculating Returns Suppose a stock had an initial price of $73 per share , paid a dividend of $1.20 per share during the year and had an ending share price of $82. Compute the percentage total...

Please Solve in Excel and show functions and how you did it please. a. These retirement calculations require the user to provide information. 1. For cell B5, use the Data Validation tool found in the...

Unit 2 ? MBA6016 - Jul 11 2016 to Aug 19 2016 - Section 103 Assignment SubmissionYou are required to use the textbook problems template in the Resources to complete the problems. This Excel document...

Please Solve using Excel and Show the functions using the cells please Garca and Martinez manufacture widgets and currently have $8 million in taxable income. The company is considering an expansion,...

Accounting Exam. There are 30 questions of filling out balance sheets or cash flows. I wanted to ask this question in the advanced question tab, but I no longer have access to it. I don't have a clue...

Please solve in excel and show calculations. From the information provided prepare the following monthly schedules/statements for the first quarter of 2024 in Excel. The Excel workbook will include...

BU Curriculum Corporation issued $800,000 of 9% bonds on September 1, 2021, due on September 1, 2026. The interest is to be paid twice a year on March 1 and September 1. The bonds were sold to yield...

Prove that if E R is connected, then Eo is also connected. Show that this is false if R is replaced by R2.

EE. Todos los equivalentes de efectivo, en su reconocimiento inicial, deben valuarse a su valor razonable. Seleccione una: a. Falso b. Verdadero

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...