Question: Show answer using spreadsheet formulas to solve a. How much will you have in 20 years if you invest $3000 now with an APR of

Show answer using spreadsheet formulas to solve

a. How much will you have in 20 years if you invest $3000 now with an APR of 4% and it is compounded monthly?

b. A friend lends you $600 for 2 years at 4% simple interest per year. How much will you pay them back at the end of the loan?

c. How much would you need to deposit now in order to have $100,000 in 25 years at 10.5% compounded monthly?

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 Mathematics Questions!

Q:

please show how you are calculating Example Problem - How to Show Your Work Teresa wants to invest $2500 per year for 20 years at 6% compounded annually. How much will Teresa have after 20 years?...

Q:

Solve ALL problems using a financial calculator; please do not use annuity formulas. Please show all work!!! A.) Iris Vang contributes $5,000 to her Individual Retirement Account (IRA) at the END of...

Q:

Good Morning Dr.Ramsey Please assist me with my discussion this week ( min 150 words). Advanced Time Value of Money An advertised monthly lending rate of 0.9% is about 11% per year. This difference...

Q:

HellonDr.Ramsey Can you assist me with my discussion please, Min 150 words due Friday. Basic Time Value of Money It is a common fact that many lottery winners are ?broke? sooner than later. If you...

Q:

Question 2 Your firm agrees to a contract where you will be paid $50,000 in 9-months when a project is completed. If the discount rate is 6% APR compounded monthly, what is the present value of the...

Q:

2.3 Savings Plans 1. Suppose you want to have $400,000 for retirement in 30 years. Your account earns 10% interest. How much would you need to deposit in the account each month? 2. You deposit $4000...

Q:

3 This assignment covers material from Units 8 to 9 in the Mathematics 244 Study Guide. It is due after Unit 9 in the Study Guide is completed. Total Marks = 100 Business Mathematics 1. What is the...

Q:

Summary of Key Formulas A copy of this summary of Key Formulas will be attached to exams. On assignments and exams show all your work. This allows the marker to assess partial marks. Show the...

Q:

1. You deposit $2000 in an account earning 6% interest compounded continuously . How much will you have in the account in 15 years? Round your answer to the nearest cent. 2. Suppose you want to have...

Q:

Question 1 Not yet answered Points out of 4.00 Flag question Question text You are 25 years old. If you deposit $3,000 in an IRA at the end of each year for 30 years, how much will the account be...

Q:

Apply the provisions of some of the common codes for accountants in the United States. The following are the scenarios you will use to complete this assignment: Eduardo Sanchez, CIA, Audit Manager...

Q:

How did the Emancipation Proclamation, northern military successes, and actions by the slaves themselves combine to finally end slavery?

Q:

Sources of unsystematic risk include which of the following? A firms financing decisions. A firms operations. Fluctuating market prices. Group of answer choices 1 and 2 . 1 and 3 . 2 and 3 . All of...

Q:

Based on the observation that the hammer does not reach full cock, what part is the likely cause of the failure, according to the course text?