1. Calculate the monthly payment for a home loan of $650,000 financed at 7.5% over 15...

Transcribed Image Text:

1. Calculate the monthly payment for a home loan of $650,000 financed at 7.5% over 15 years. 2. Calculate the monthly payment for a home loan in San Francisco of $1,500,000 financed at 8% over 30 years. Note: the buyer will only finance 80% of the purchase price and make a down payment of 20%. 3. Calculate the future value of $15,000 invested for 15 years assuming an annual interest rate of 8%, compounded monthly. 4. Calculate the future value of $1,000 invested for 5 years assuming an annual interest rate of 8%. 5. Calculate the future value of an ordinary annuity of $500 paid monthly for 15 years, assuming an annual earnings rate of 12%. 6. Calculate the annual interest rate that a bank must pay on a Certificate of Deposit if a client deposited $1,000 and withdrew $10,000 in 25 years. Assuming the interest is compounded on a monthly basis. 7. Calculate the present value of $1,000,000 to be received in 20 years assuming an annual interest rate of 5%, compounded monthly. 8. Calculate the present value of $50,000 to be received in 15 years assuming an annual interest rate of 6%. 9. Calculate the present value of an annuity of $100,000 received annually that begins today and continues for 8 years, assuming a discount rate of 11.5%. 10. Calculate the present value of an annuity of $10,000 received quarterly that begins today and continues for 16 years, assuming a discount rate of 10%. 11. Calculate the present value of an ordinary annuity of $4,000 received annually for 5 years, assuming a discount rate of 10%. 12. Calculate the number of months it will take $50,000 to grow to $5,000,000 assuming an annual interest rate of %, compounded monthly. Present Value (PV) Payment Future Value Annual Rate Periods (W/M/Qtr/ Mode (PMT) (FV) (0) (N) Annual) (End/Begin) 1. Calculate the monthly payment for a home loan of $650,000 financed at 7.5% over 15 years. 2. Calculate the monthly payment for a home loan in San Francisco of $1,500,000 financed at 8% over 30 years. Note: the buyer will only finance 80% of the purchase price and make a down payment of 20%. 3. Calculate the future value of $15,000 invested for 15 years assuming an annual interest rate of 8%, compounded monthly. 4. Calculate the future value of $1,000 invested for 5 years assuming an annual interest rate of 8%. 5. Calculate the future value of an ordinary annuity of $500 paid monthly for 15 years, assuming an annual earnings rate of 12%. 6. Calculate the annual interest rate that a bank must pay on a Certificate of Deposit if a client deposited $1,000 and withdrew $10,000 in 25 years. Assuming the interest is compounded on a monthly basis. 7. Calculate the present value of $1,000,000 to be received in 20 years assuming an annual interest rate of 5%, compounded monthly. 8. Calculate the present value of $50,000 to be received in 15 years assuming an annual interest rate of 6%. 9. Calculate the present value of an annuity of $100,000 received annually that begins today and continues for 8 years, assuming a discount rate of 11.5%. 10. Calculate the present value of an annuity of $10,000 received quarterly that begins today and continues for 16 years, assuming a discount rate of 10%. 11. Calculate the present value of an ordinary annuity of $4,000 received annually for 5 years, assuming a discount rate of 10%. 12. Calculate the number of months it will take $50,000 to grow to $5,000,000 assuming an annual interest rate of %, compounded monthly. Present Value (PV) Payment Future Value Annual Rate Periods (W/M/Qtr/ Mode (PMT) (FV) (0) (N) Annual) (End/Begin)

Answer rating: 100% (QA)

1 To calculate the monthly payment for a home loan of 650000 financed at 75 over 15 years you can use the PMT Payment function in financial calculators or spreadsheet software The formula is PMTrate n... View the full answer