Question

In: Finance

You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn...

You have $100,000 in an account that earns 2% APR (Compounded monthly)
You want to earn a higher rate of return and therefore are considering two alternative investments. You will put your $100,000 in one of the two new accounts.
Investment 1 will pay you $860 per month for starting next month 120 months.
Investment 2 will pay you $2,600 per month for starting next month 40 months.

Which account should you choose and how much does it increase your net worth?

Group of answer choices

Choose Investment 2 it increases your net worth by $528

Choose Investment 1 it increases your net worth by $544

Choose Investment 2 it increases your net worth by $508

Choose Investment 2 it increases your net worth by $547

Solutions

Expert Solution

APR for account = 2% p.a. compounded monthly

Monthly rate = APR / 12 = (2% /12)

Now we will calculate change in net worth because of investments

Calculating change in Net worth under Investment 1

Investment Amount = 100000

Change in Net worth = Sum of Present value of monthly cash inflows received from investment - Investment Amount

where monthly cash inflow = $860 and no of months = 120

We can find the sum of present value of monthly cash inflows received from investment by using PV function in excel

Formula to be used in excel: =PV(rate,nper,-pmt)

Using PV function in excel, we get Sum of present value of monthly cash inflows = $93464.59

Change in Net worth = 93464.59 - 100000 = - $6535.41 = 6535 (rounded to nearest whole dollar)

Hence If investment 1 is undertaken, then Net worth decreases by $6535

Calculating change in Net worth under Investment 2

Investment Amount = 100000

Change in Net worth = Sum of Present value of monthly cash inflows received from investment - Investment Amount

where monthly cash inflow = $2600 and no of months = 40

We can find the sum of present value of monthly cash inflows received from investment by using PV function in excel

Formula to be used in excel: =PV(rate,nper,-pmt)

Using PV function in excel, we get Sum of present value of monthly cash inflows = $100528.11

Change in Net worth = 100528.11 - 100000 = 528.11 = $528 (rounded to nearest whole dollar)

Hence If investment 2 is undertaken, then Net worth increases by $528

So investment 2 should be chosen as it increases net worth by $528

Answer: Choose Investment 2 it increases your net worth by $528


Related Solutions

You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn...
You have $100,000 in an account that earns 2% APR (Compounded monthly) You want to earn a higher rate of return and therefore are considering two alternative investments. You will put your $100,000 in one of the two new accounts. Investment 1 will pay you $860 per month for starting next month 120 months. Investment 2 will pay you $2,600 per month for starting next month 40 months. Which account should you choose and how much does it increase your...
If you invest $1,632 today and in years 1, 2 and 3 in an account that earns 4.28% APR (compounded annually), how much will you have in the account in 17 years?
 If you invest $1,632 today and in years 1, 2 and 3 in an account that earns 4.28% APR (compounded annually), how much will you have in the account in 17 years?  
a. You have saved up for retirement in an annuity account. This account earns a return of 7% on annual basis but compounded monthly.
  a. You have saved up for retirement in an annuity account. This account earns a return of 7% on annual basis but compounded monthly. You are due to retire in 6 years from now. You will receive monthly payments of $2,400 at the end of each month after retiring, for 15 years. How much have you saved up in this account today? b. Two banks are competing to give a loan to you for $150,000 with 30-year term to...
A) You invest RM10,000 today into retirement account. You expect to earn 11% compounded monthly, on...
A) You invest RM10,000 today into retirement account. You expect to earn 11% compounded monthly, on your money for the next 25 years. After that, you want to be more conservative, so only expect to earn 7%, compounded semiannually. How much money will you have in your account when you retire 40 years from now, assuming that this is the only deposit you make into account? B) Assume that you just won the Open Golf Championship. Your prize can be...
You have found three investment choices for a one-year deposit 11.7 % APR compounded monthly, 11.7 % APR compounded annually, and 10 8% APR compounded daily
You have found three investment choices for a one-year deposit 11.7 % APR compounded monthly, 11.7 % APR compounded annually, and 10 8% APR compounded daily. Compute the EAR for each investment choice (Assume that there are 365 days in the year) (Note Be careful not to round any intermediate steps less than six decimal places) The EAR for the first investment choice is% (Round to three decimal places) The EAR for the second investment choice is % (Round to three decimal...
A bank offers a retirement annuity that earns 4% APR, compounded monthly. Each person wants to...
A bank offers a retirement annuity that earns 4% APR, compounded monthly. Each person wants to have at least $200,000 in the account when they retire. For each retirement plan described, determine: the monthly deposit, the total length of time they spent investing, the amount in their account at the end of the investing time, the total amount of money they invested, and the total amount of interest they earned. Round monthly deposits up to the cents place and other...
If you invest $5,000 in months 2 and 3 in an account that earns 2.00% APR,...
If you invest $5,000 in months 2 and 3 in an account that earns 2.00% APR, compounded monthly, , how much can you withdraw (equal amounts) in months 5 and 6 ?
You invest $1,190,000 into a retirement account and earn 9.00% per year, compounded monthly. At retirement...
You invest $1,190,000 into a retirement account and earn 9.00% per year, compounded monthly. At retirement your account balance is $5,430,000. Over how many years did you make this investment? PLEASE ANSWER WITH EXCEL
You invest $10,000 today into a retirement account. You expect to earn 11 percent, compounded monthly,...
You invest $10,000 today into a retirement account. You expect to earn 11 percent, compounded monthly, on your money for the next 25 years. After that, you want to be more conservative, so only expect to earn 7 percent, compounded semi-annually. How much money will you have in your account when you retire 40 years from now, assuming that this is the only deposit you make into the account? A. $443,908 B. $397,062 C. $441,387 D. $483,928 E. $433,590
Calculus 2 question. Please explain clearly. A bank account earns 5% interest compounded monthly. Suppose that...
Calculus 2 question. Please explain clearly. A bank account earns 5% interest compounded monthly. Suppose that $1,000 is initially deposited into the account, but that $10 is withdrawn each month. a) Show that the amount in the account after n months is An=(1+0.05/12)An-1-10; A0=1000 b) How much money will be in the account after 1year? c) Suppose that instead of $10, a fixed amount of d dollars is withdrawn each month from the account. Find a value of d such...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT