CompoundInterestandPopulationModelingAssignment

a) If you invest $5 and will receive $8 next year, what is your simple return? b) If you invest $5 and will receive $8 next year, what is your holding rate of return for each month? What is average monthly rate of return?

Suppose you save $2,800 ayear for 43 years into an investment account that earns 8.5% return, how much will you have at the end of the periods? Formula? Excel Function?

Suppose you buy a home and finance $285,000 at $2,243.17 per month for 30 years. What is the amount of interest paid? (Round your answer to the nearest cent

Suppose you save $4,000 per year at the end of each year for 30 years and earn 5% interest per year. How much will you have at the end of 30 years? Suppose you save $2,000 per year at the beginning of each year for 15 years and earn 7.49% interest per year. How much will you have at the end of 15 years?NOTE: DONOT SOLVE ON EXCEL

Suppose you invest $200 a month for 6 years into an account earning 9% compounded monthly. After 6 years, you leave the money, without making additional deposits, in the account for another 20 years. How much will you have in the end? $ Suppose instead you didn't invest anything for the first 6 years, then deposited $200 a month for 20 years into an account earning 9% compounded monthly. How much will you have in the end?

3. If you invest $2000 now, and receive 3 yearly payments of $100 each year plus $2500 in the 3rd year, a. what is the Internal Rate of Return (IRR) b. Interpret your results

Suppose you invest $2,000 today and receive $11,000 in five years. a. What is the internal rate of return (IRR) of this opportunity? b. Suppose another investment opportunity also requires $2,000 upfront, but pays an equal amount at the end of each year for the next five years. If this investment has the same IRR as the first one, what is the amount you will receive each year?

Suppose you invest $160 a month for 5 years into an account earning 9% compounded monthly. After 5 years, you leave the money, without making additional deposits, in the account for another 21 years. How much will you have in the end?$CorrectSuppose instead you didn't invest anything for the first 5 years, then deposited $160 a month for 21 years into an account earning 9% compounded monthly. How much will you have in the end?

If you invest $56,000 today in an account that pays 8.3% a year, how much will you have in 31 years?Formula?Excel Function?

Reference attached image.

You are trying to decide how much to save for retirement. Assume you plan to save $4,000 per year with the first investment made one year from now. You think you can earn 10.5% per year on your investments and you plan to retire in 36 years, immediately after making your last $4,000 investment. a. How much will you have in your retirement account on the day you retire? b. If, instead of investing $4,000 per year, you wanted to make one lump-sum investment today for your retirement that will result in the same retirement saving, how much would that lump sum need to be? c. If you hope to live for 28 years in retirement, how much can you withdraw every year in retirement (starting one year after retirement) so that you will just exhaust your savings with the 28th withdrawal (assume your savings will continue to earn 10.5% in retirement)? d. If, instead, you decide to withdraw $270,000 per year in retirement (again with the first withdrawal one year after retiring), how many years will it…

You want to receive $5000 per month for 20 years in real dollars in an account when you retire in 35 years. The first monthly payment to be received 1 month after you retire. The nominal return on your investment is 9.94 percent and the inflation rate is 3.2 percent. What is the real amount you must deposit each year for 35 years to achieve your goal? Pls do using Excel

You are currently investing your money in a bank account which has a nominal annual rate of 7 percent, compounded monthly.  How many years will it take for you to double your money? m Nper (or N) =n*m Rate (or I/Y)=i/m PV PMT FV   Identify variables and use excel