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 <\/p>\n

Part 1: Use the formula I = PRT to calculate how much interest you earn in the first year <\/p>\n

I = interest <\/p>\n

P = Principal (starting with $5,000) <\/p>\n

R = Rate of interest (9%) <\/p>\n

T = Time (1 year, in this case) <\/p>\n

At the end of the first year, you will have the original Principal ($5000), plus the Interest (your calculation) <\/p>\n

Add them together. <\/p>\n

At the beginning of the next year, their sum is what you have as your starting Principal <\/p>\n

I = PRT <\/p>\n

Interest Principal Rate Time End of Year <\/p>\n

Year 1 $450 $5,000 9% 1 $5,450 <\/p>\n

Year 2 $491 $5,450 9% 1 $5,941 <\/p>\n

Year 3 <\/p>\n

Year 4. . . <\/p>\n

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

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

start of each year (What\u00e2\u20ac\u2122s the final amount in Yr 25?) <\/p>\n

Use different fonts, shade the boxes, and jazz it up so it looks professional!! <\/p>\n

*** You will have three worksheets in your Workbook when you are complete. Save as: “Watching Money Grow” <\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/130886"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=130886"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/130886\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=130886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=130886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=130886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}