I Don T Understand Questions Need To Us The Pv And Fv Functions In Excel Should

I don’t understand,

questions need to us the PV and FV functions in Excel.  Should be able to see the formulas in the “bar” at the top of the spreadsheet. 

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Place an Order

1)   If I deposit $11,000 in a bank account that pays interest of 2%, compounded annually, how much will I have in the account after 10 years?

2)   If I deposit $11,000 in a bank account that pays simple interest of 2%, how much will I have in the account after 10 years?

3)   How would you explain the difference in the answers to the previous two problems, given that both banks pay interest at the same rate?  Be specific.

Get Assignment Writing Help

Our experts are ready to complete your assignment, course work. essay, test, dissertation, research paper, quiz

Get Started

4)   If you deposited $775 at 12% interest, what would you end up with at the end of 12 years if it was compounded annually?

5)   What would the present value be of $1,000 to be received 8 years from now discounted back at 3%?

6)   Craig, who recently sold his Porsche, placed $10,000 in a savings account paying annual compound interest of 6%

a)    Calculate the amount of money that will have accrued if he leaves the money in the bank for 1, 5 and 15 years.

b)   Calculate the amount of money that will have accrued if the interest rate changed to 7.5% and paid only simple interest for 1, 5 and 15 years.

c)    After your calculations did compound or simple interest gain more money in years 1, 5, 15?

7)   Nolan Arenado hit 37 homeruns for the Colorado Rockies in 2017. If his homerun output grew at a rate of 12% per year, what would it be over each of the following 5 years?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online

"Do you have an upcoming essay or assignment due?

Get any topic done in as little as 6 hours

If yes Order Similar Paper

All of our assignments are originally produced, unique, and free of plagiarism.

Stuck with a Question?

Get it solved from our top experts within 8 hrs!

Ask Your Question Now!

"Are you looking for a similar assignment? if yes, we are ready to help"

Order New Solution

You will get 100% plagiarism free and professional written paper.