Question: Need help writing correct formula in excel. Should be getting answer provided below. 2. Your aunt told you that she will give you $10,000 five

Need help writing correct formula in excel. Should be getting answer provided below.

below. 2. Your aunt told you that she will give you $10,000

2. Your aunt told you that she will give you $10,000 five years from now. If the current interest rate for an investment is 6.5% per year and interest is compounded quarterly, what is the current value of that money? (Hint: Use the PV function) Numeric Answers to Exercises (you have to write the formulas to calculate the numbers)

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!

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. QUESTION 1 The law requires that contract terms be clear and unambiguous. If one of the parties to the contract does not read the written terms, which one of the following statements is false? a...

Just need help with A,B, and C table 1 is the table with the yellow highlights The Chicken or The Egg: Hatching a New and Innovative Product Robert Rankin Texas A&M Commerce Martin Stuebs Baylor...

Case Questions: Would you decide to hatch Chicken Sensations? Put yourself in Vickis shoes. Prepare an analysis that will guide PFVCs decision on whether to launch Chicken Sensations. 1. Economic...

The Chicken or The Egg. THE CHALLENGE Parson Foods Vegetable Company (PFVC) is a newly created, wholly owned subsidiary of Parson Foods, one of the oldest and largest fluid milk processors in the...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

MULTIPLE CHOICE 1 Using the recurrence relation t0 = 8, tn+1 = tn + 9, the sixth term would be: A 2 15 B 17 C 23 D 53 E 62 A canoe costs $40 to hire for the first day and $30 for each extra day. If...

Nextflix Selection and recruitment case study Analysis Meme 2) Case Analysis Paper (15) Students will read and analyse study redd disseminated by Professor Howell. Based on the case assigned, each...

please see the first page and thd article after: Read the Christian Business Faculty Association (CBFA) case study (When the Golden Rule Yield No Gold-you do not need to read the "Suggested Teaching...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

Use the option price calculator that can be found at www.numa.com, or another option price calculator, to test the sensitivity of option values to changes in the key input variables. Use the data...

Distinguish between the terms errors and fraud. What is the auditor's responsibility for finding each?

The break-even chart and the unit profit graph intend to show the sameinformation but seem to differ. How?

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Describe the job youd like to be doing five years from now.

4 Should Su be responsible for making any changes in her communication with her doctor?

So what disadvantages have you witnessed? (specific)