Question: Please do in Excel and show which formulas you used, thank you!! Maria just won the lottery and opted to take unending yearly payments. The

Please do in Excel and show which formulas you used, thank you!!

Maria just won the lottery and opted to take unending yearly payments. The first payment will be $50,000 in one year from today. Determine the value of those payments today if the discount rate is 7.9% per year.

A) $632,911

B) $625,925

C) $691,006

D) $648,409

E) $650,000

F) None of the above

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 do in Excel and show which formulas you used, thank you!! Maria just won the lottery and opted to take unending yearly payments. The first payment will be $50,000 in one year from today....

Can someone please create an excel sheet with the answers to Part 1, 2 and 3 (I have attached what I believe are correct answers for part 1 and 2 to save you time), So mainly need part 3 (Calculating...

PLEASE DO THIS IN EXCEL AND LIST THE FORMULAS YOU USED!! Use an Excel function to calculate the monthly payment for a 15-year loan with a principal amount of $250,000, and an annual interest rate of...

1. Prepare a budgeted schedule of cost of goods manufactured and sold for the year 20x1 Hint: In the budget, actual and applied overhead will be equal.), a budgeted income statement for 20x1 (Ignore...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

practice case i need help with. just need the 3 steps. Bookkeeping for a small business organization Case: Bob fix-it-all - August 2021 By Zihao (Emily) Xu Bob I just retired in his early 50's and...

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

1. What is the symbol used for intersection? A. U D. E . . 2. What is the complement of ? C.U A. { } . (1} D. {0} 3. What is the meaning of "the difference of P and Q"? A. The set of elements in P...

Question Compilation Status QUESTION 1 A population has an average of 150,000 with a standard deviation of 27,000. A random sample of 81 items is chosen. What is the standard error? QUESTION 2 A...

IT 5 TOn 2 3 dots My Shelf / Br Classes in C . . Help Save 8 Exit Submit Adrian is a college professor earning $ 9 9 , 2 0 0 and has a sole proprietor consulting practice that earned $ 2 8 , 0 0 0...

Question 2 What do you think will happen when the balloon is moved closer to the wall? Negatively Neutral wall charged balloon A. Some positive charges in the wall will move towards the balloon B....

(LO 8-3) Which would you predict would have more positive sentiment in a 10-K, the financial statements or the MD&A (management discussion and analysis) of the financial statements? More positive...

(LO 8-2) Determining how sensitive a stocks intrinsic value to assumptions and estimates made would be an example of _____ analytics. a. diagnostic b. predictive c. descriptive d. prescriptive

(LO 8-2) In which stage of the IMPACT model (introduced in Chapter 1) would the use of sparklines fit? a. Track outcomes b. Communicate insights c. Address and refine results d. Perform test plan