Linda will make month-end deposits of 2,000 for 6 years staring in one month. She earns...

Linda will make month-end deposits of 2,000 for 6 years staring in one month. She earns an interest rate of 4.4% p.a. compounded monthly for the first 2 years and 8.1% p.a. compounded monthly thereafter. How much will she have in 6 years? Correct your answer to the nearest cent without any units. (Do not use "$" or "," in your answer. e.g. 12345.67)

Solutions

Expert Solution

Solution.>

The correct answer is $182,098.18

I have solved this question in Excel. The formula used are written along with the values. If you still have any doubt, kindly ask in the comment section.

Firstly we have to find the amount Linda must have after 2 years at 4.4% p.a. compounded monthly. Hence we calculate the FV after two years as shown below.

Then we have to find the amount he must after 4 years at 8.1% p.a. compounded monthly. Hence the FV calculated above will now becomes the Present Value in this case.

The formula used in excel is = FV(Rate/12,NPER*12,-PMT,-PV)

It has been shown in the excel below.

Note: Give it a thumbs up if it helps! Thanks in advance!

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A young executive deposits $300 at the end of each month for 6 years into an...

A young executive deposits $300 at the end of each month for 6 years into an account that earns 6% compounded monthly. How much is in the account after the 6 years? (Round your answer to the nearest cent). $ The executive then changes the deposits in order to have a total of $400,000 after 25 total years. What should be the revised monthly payment in order to meet the $400,000 goal? (Round your answer to the nearest cent). $...

A person deposits $60 at the end of each month in an account which earns 12.5%...

A person deposits $60 at the end of each month in an account which earns 12.5% compounded monthly for 17 years. The person then stops making the deposits, but allows the money to remain in the bank earning the same interest for 5 more years. a. Find the value of this account at the end of 22 years. $ b. State the total amount of interest earned on this account. $

At the end of every year you deposit $2,000 into an account that earns 6% interest...

At the end of every year you deposit $2,000 into an account that earns 6% interest per year. What will be the balance in your account immediately after the 30th deposit?

You make deposits at the end of each month into an account earning interest at a...

You make deposits at the end of each month into an account earning interest at a rate of 6%/year compounded monthly. Your deposits will be $2000/month in the first year, $2200/month in the second year, $2420/month in the third year, $2662 in the fourth year, and so on. How much will be in your account at the end of 40 years? No Excel answers please.

An engineer deposits $2,000 per month for four years at a rate of 24% per year,...

An engineer deposits $2,000 per month for four years at a rate of 24% per year, compounded semiannually. How much will he be able to withdraw 10 years after his last deposit ?

A young executive deposits $100 at the end of each month for 5 years into an...

A young executive deposits $100 at the end of each month for 5 years into an account that earns 6% compounded monthly. How much is in the account after the 5 years? (Round your answer to the nearest cent). $ The executive then changes the deposits in order to have a total of $400,000 after 25 total years. What should be the revised monthly payment in order to meet the $400,000 goal? (Round your answer to the nearest cent). $ ...

Raj deposits 50 into a fund at the end of each month for 5 years. The...

Raj deposits 50 into a fund at the end of each month for 5 years. The fund pays interest at an annual effective rate of i. The total amount of interest earned during the last month of year 5 is 13. Calculate the accumulated amount in Raj's account at the end of year 5 A) 3325 B) 3350 C) 3375 D) 3400 E) 3425

You will make deposits of $1,000 at the end of each year for 40 years in...

You will make deposits of $1,000 at the end of each year for 40 years in your investment account. After the 40th deposit, you will immediately withdraw all money from the account to buy a retirement annuity for 35 years with equal annual payments (paid at year-end) from a life insurance company. If the annual rate of return over the entire period (75 years) is 5%, how much is the annual payment from the insurance company? The amount of your...

3. Jose deposits $150 at the end of each month into an account that pays 6%...

3. Jose deposits $150 at the end of each month into an account that pays 6% interest compounded monthly . After 8 years of deposits, what is the account balance?

Suppose that Meghan earns $2,000 this month, and $2,200 next month with a utility function over...

Suppose that Meghan earns $2,000 this month, and $2,200 next month with a utility function over consumption in these two periods given by U(C1, C2) = C1C2, where MUC1 = C2 and MUC2 = C1. Suppose that the deposit interest rate is rL = 1%, while the credit interest rate is rB = 2% + x%, where x is 4. a) Draw a graph with Meghan’s budget constraint for consumption in this month vs. next month. b) Will Meghan borrow...

Subjects