Question: please answer the questions above using excel formulas** You need $150,000 in 18 years for your daughter's eductation. If you can earn 6% per year,

please answer the questions above using excel formulas** You need $150,000 in 18 years for your daughter's eductation. If you can earn 6%

please answer the questions above using excel formulas**

You need $150,000 in 18 years for your daughter's eductation. If you can earn 6% per year, how much do you need to invest today? What are you looking for? FV = NPER = RATE = Use the PV formula: PV(rate,nper,pmt,fv) Compute PV = You have $10,000 to invest. You will need the money in 5 years and you expect to earn 8% per year. How much will you have in 5 years. What are you looking for? PV = NPER = RATE = Use the FV formula: FV(rate,nper,pmt,pv) Compute FV = (Notice that the spreadsheet has the same sign convention as the calculators with positive inflows and negative outflows.) Note that the payment is 0, so a 0 is interested in the appropriate place in the formula

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!

A B D E G H 1 K L M N o Q R S T U V w 1 2. 3 4 Use Excel functions (not calculator inputs) to solve each of the following. A) Advising Lucy and Ricky. Lucy and Ricky want advice from your financial...

Use Excel functions (not calculator inputs) to solve each of the following. A) Advising Lucy and Ricky. Lucy and Ricky want advice from your financial advising firm. They have provided the following...

A) Advising Lucy and Ricky. Lucy and Ricky want advice from your financial advising firm. They have provided the following information. They graduated from university four years ago and they have...

I. Rule of 72 Use the Rule of 72 to answer Questions 1-4. Remember to show all steps in your work, not just the answer. 1. You invest $5,000 for 12 years and earn 6% per year. What is your...

I need help with the problem on page 4 of the Excel file. It's an options problem. Please answer the questions, including the embedded formulas and brief rationale you used to get the answer. Answer...

Need assistance with Home work. Attached is the questions Farida Chapter 5 1. Old Time Savings Bank pays 3% interest on its savings accounts. If you deposit $2,700 in the bank and leave it there (Do...

Please answer the questions with excel and upload excel screenshots. Also please use excel built in functions to solve pmt instead of using standard formulas (pmt=pv*r/(1-1+r)^-n). Please provide me...

Please answer the questions with excel and upload excel screenshots. Also please use excel built in functions to solve pmt, pv, fv and so on instead of using standard formulas. If possible, please...

Hello please answer to the following question. good luck 29. Annuities. You can buy a car that is advertised for $24,000 on the following terms: (a) pay $24,000 and receive a $2,000 rebate from the...

I have an excel assignment and wanted to see if someone could help me with it. Complete the tasks contained on the following worksheets. Name your workbook: Last Name Excel assignment Submit the...

One classic application of correlation involves the association between the temperature and the number of times a cricket chirps in a minute. Listed below are the numbers of chirps in 1 min and the...

David Corporation issued 100,000 shares of $20 par value, cumulative, 8% preferred stock on January 1, 2011, for $2,100,000. In December 2013, David declared its first dividend of $500,000....

When auditing historical financial statements, an auditor must have a thorough understanding of the client and its environment. This knowledge should include the client's accounting personnel ,...

The best example of an independent demand item at a sandwich shop is: slices of cheese slices of sandwich bread slices of tomatoes None of these choices All of these choices an assembled sandwich

in-depth interviews with people from different departments in an organisation is: a A longitudinal study. b A structured study. c A quantitative study. d A qualitative study.

Issues of data credibility and transferability are particularly relevant to: a Experiments. b Cross-sectional research. c Case study research. d Positivism.

To what extent will it be possible for you and those with whom you work to be able to distinguish between your role as a researcher and your usual work role? What steps might you take to maintain...