Rosa invests $3000 in an account with an APR of 4% and annual compounding. Julian invests $2500 in an account with an APR for 5% an annual compounding a) Create a table in Excel with the first column years and the second column Rosas account and the third column Julian’s account. Carry out the table for at least 20 years b) Use the table to determine the balance on each account after 5 years and 20 years c) Determine, for each account at 5 and 20 years, the amount of the balance that is interest? d) After how many years will Julian have more money than Rosa

Rosa invests $3000 in an account with an APR of 4% and annual compounding. Julian invests $2500 in an account with an APR for 5% an annual compounding a) Create a table in Excel with the first column years and the second column Rosas account and the third column Julian’s account. Carry out the table for at least 20 years b) Use the table to determine the balance on each account after 5 years and 20 years c) Determine, for each account at 5 and 20 years, the amount of the balance that is interest? d) After how many years will Julian have more money than Rosa

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Related questions

Q: You are given $2000 and told to invest in one of the following accounts. Which account will give you…

A: Formula of compounded investment: A=P1+rnnt where A= Ending Amount P=Principal Amount r=Interest…

Q: A person donated OMR 6420 to a college with the provision that a scholarship is paid at the end of…

A: When the interest is compounded, then the formula used is A=P1+rnnt , where, A is the final amount,…

Q: 4% compounded semi-annually. Find the APY.

A: Recall the following fact.

Q: A savings account deposit $2000 is to earn 3.5% compounded quarterly. Assuming there are no deposit…

Q: How an aclount in the account in 8 years Assume the account. earns 6% interest CompoyAced monthly…

Q: Find the final amount of money in an account if $3,900$3,900 is deposited at 7%7% interest…

Q: Find the principal if the interest is 18,000 with a rate of 9% at term of 4 years.

A: Given: Rate of interest (r) = 9 % Simple interest (SI) = 18,000 Time…

Q: Four thousand dollars is deposited in a savings account at 7% interest compounded quarterly. Find…

Q: Assume that Bob deposited $3,000 per year in a bank account. Since the bank offered a compound…

A: As per the question we are given the principal deposited after each year as $3,000 ; the annual…

Q: 14 How much must be deposited in an account paying 7 percent if interest of $100 is to be eamed in…

Q: Alice charged $800 worth of merchandise one year ago on her credit card, which has an APR of 12%…

A: It has an APR of 12% compounded monthly. She made 12 monthly payments of $20, at the end of each…

Q: If the present worth of a company is 3000$ with interest rate of 9% for 6 years, the EUAC of the…

A: Given: Present value = $ 3000 Interest rate = 9% Number of periods n = 6 years

Q: If $1800 is deposited in anaccount that pays 2.7% annual interest compounded monthly, what amount…

A: P=$1800r=2.7%=2.7100=0.027t=9n=12

Q: If the balance of an account (which earns interest monthly) is $65,238.17 at the beginning of the…

A: Given amount at the biginning of the current compound period is $64,238.17 Interest earned in…

Q: %3D 3 72 2 O Option 3 O Option 1 n+1 3. Ontion A MIN 2/3

A: To find : ∑i = n∞ 13i = ?

Q: P1,420 is invested in an account which earns 8% interest compounded annually, which will be the…

A: We have to find the balance at the end of 17 years.

Q: Sarge invested $10,000 per year in his RRSP each year for 20 years. If interest is 496 compounded…

A: Given problem:- Sarge invested $10,000 per year in his RRSP each year for 20 years. If interest is…

Q: Find the final amount of money in an account if $8,100 is deposited at 6.5% interest compounded…

Q: A man deposits $18,000 at the beginning of each year for 8 years in an account paying 6% compounded…

A: Compound interest is a type of interest that is calculated not only on the initial principal amount,…

Question

Rosa invests $3000 in an account with an APR of 4% and annual compounding.
Julian invests $2500 in an account with an APR for 5% an annual compounding

a) Create a table in Excel with the first column years and the second column
Rosas account and the third column Julian’s account. Carry out the table
for at least 20 years

b) Use the table to determine the balance on each account after 5 years and
20 years

c) Determine, for each account at 5 and 20 years, the amount of the balance
that is interest?

d) After how many years will Julian have more money than Rosa

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Khairy invested RM7 000 for 4 years 7 months at a simple interest of 7% per annum for the first two years and 8% per annum for the ensuing period(balance period).Find the amount of the investment at the end of the investment period. RM7 426.67 RM8 426.67 RM10 426.67 RM9 426.67 O O O O
d. After one year, ________% of the information is remembered.(Round to one decimal place as needed.)
Please help: A savings plan James begins a savings plan in which he deposits $100 at the beginning of each month into an account that earns 9% interest annually or, equivalently, 0.75% per month. To be clear, on the first day of each month, the bank adds 0.75% of the current balance as interest, and then James deposits $100. Let Bn be the balance in the account after the nth payment, where Bn = $0. Write the first five terms of the sequence {Bn}. Find a recurrence relation that generates the sequence {Bn}. How many months are needed to reach a balance of $5000?
If $800,000 is invested at simple interest at a rate of 6%, calculate the total amount after 5 years
Find the final amount of money in an account if $8,400$8,400 is deposited at 6.5%6.5% interest compounded quarterly (every 3 months) and the money is left for 77 years.
Find the balance in the account after the given period. $2000 principal earning 3% compounded annually, 5 years. The balance after 5 years will be:
The tree farm deposits $1,300 at the end of each month into an account paying 1.51% ordinary interest compounded monthly. What is the value of the account at the end of 7 years and 143 days? Do not round.
If $5000 is invested at 5.95 percent APR compounded daily and no other de- posits are made, what will the value of the account be after seven years? A B $ 131,309.10 D $ 7,493.36 с $7,582.96 $320,873.46