create a spreadsheet 2

Create a spreadsheet that calculates how much money an account would grow to in 25 years if you put $5000 into it and it grew at 9% interest each year. Show the interest you earn each year and the total at the end of a given year

Part 1: Use the formula I = PRT to calculate how much interest you earn in the first year

I = interest

P = Principal (starting with $5,000)

R = Rate of interest (9%)

T = Time (1 year, in this case)

At the end of the first year, you will have the original Principal ($5000), plus the Interest (your calculation)

Add them together.

At the beginning of the next year, their sum is what you have as your starting Principal

I = PRT

Interest Principal Rate Time End of Year

Year 1 $450 $5,000 9% 1 $5,450

Year 2 $491 $5,450 9% 1 $5,941

Year 3

Year 4. . .

Part 2: Create a new sheet. What happens if you earn 12% starting in Year 11? (What is the final amount in year 25?)

Part 3: Create a third sheet. What happens if you earn 9% each year, but in Year 6, you start adding $1000 at the

start of each year (What’s the final amount in Yr 25?)

Use different fonts, shade the boxes, and jazz it up so it looks professional!!

*** You will have three worksheets in your Workbook when you are complete. Save as: “Watching Money Grow”

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post create a spreadsheet 2 appeared first on Quality Nursing Writers.

 

"Is this question part of your assignment? We Can Help!"

Essay Writing Service