Determine how much $1,000 deposited in a savings account paying 8% (compounded annually) will be worth after 5 years.
Excel hint: FV(rate, nper, pmt = 0, pv, fv, type) = ??
answer 1.469
Question 12.5 / 2.5 pts
_____ is interest that is paid not only on the principal, but also on any interest earned but not withdrawn during earlier periods.
compound interest
basic interest
future interest
simple interest
Question 22.5 / 2.5 pts
Finding the discounted current value of $1,000 to be received at the end of each of the next 5 years requires calculating the
present value of an annuity due
future value of an annuity due
present value of an annuity
future value of an annuity
Question 32.5 / 2.5 pts
An annuity due is one in which
payments or receipts occur forever.
payments or receipts occur at the beginning of each period.
payments or receipts occur at the end of each period.
cash flows occur continuously.
Question 42.5 / 2.5 pts
If the present value of a given sum is equal to its future value, then
the discount rate must be low
none of the answers is correct
the discount rate must be zero
the discount rate must be very high
Question 52.5 / 2.5 pts
The more frequent the compounding the
lesser the future value
greater the effective interest rate
greater the amount deposited
greater the present value
Question 62.5 / 2.5 pts
Determine how much $1,000 deposited in a savings account paying 8% (compounded annually) will be worth after 5 years.
Excel hint: FV(rate, nper, pmt = 0, pv, fv, type) = ??
$784
$1,400
$1,469
$5,526
The next two questions will be based on the following information.
Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum for the entire period of time.
Question 72.5 / 2.5 pts
Determine the value of pension at the age of 60 for all payments during age 61 - 80?
Excel hint: PV(rate, nper, pmt, fv = 0, type = 0) = ??
112,839.09
312,839.09
500,000.00
212,839.09
Question 82.5 / 2.5 pts
Determine the size of the annual deposits that must be made by Mr. Moore from age 35 till 60 to achieve the future value of pension (at age 60.)
Excel hint: Pmt(rate, nper, pv, fv, type = 0) = ??
$23,449
$2,164
$212,850
$8,514
Question 92.5 / 2.5 pts
You sold 100 shares of stock today for $30 per share that you paid $20 for 6 years ago. Determine the average annual rate of return on your investment, assuming the stock paid no dividends.
Excel hint: Rate(nper, pmt =0, pv, fv, type = 0, guess = 0.05) = ??
25%
150%
7%
8.33%
Question 102.5 / 2.5 pts
The Florida lottery agrees to pay the winner $250,000 at the end of each year for the next 20 years. What is the future value of this lottery if you plan to put each payment in an account earning 9 percent?
$12.79 million
$2.28 million
$5.00 million
$14.32 million
Question 112.5 / 2.5 pts
Many IRA fund managers argue that investors should invest at the beginning of the year rather than at the end. What is the difference to an investor who invests $2,000 per year at 11 percent over a 30 year period?
Excel hint:
Type = 0; ordinary annuity
Type = 1: annuity due
$54,244
There is no difference
$36,189
$43,785
Question 122.5 / 2.5 pts
New Jersey Mutual has offered you a single premium annuity that will pay you $12,000 per year (end of year) for the next 15 years. If you must pay $109,296 today for this annuity, what is your expected rate of return?
8%
7%
10%
9%
Question 132.5 / 2.5 pts
Designs Now is opening a showcase office to display and sell its computer designed poster art. Designs expects cash flows to be $120,000 in the first year, $180,000 in the second year, $240,000 in the third year. If Designs uses 11 percent as its discount rate, what is the present value of the cash flows?
$429,686
$457,620
$424,820
$456,758
IncorrectQuestion 140 / 2.5 pts
What is the present value of $1,000 received 2 years from today if the nominal interest rate is 9% (annual percentage rate) and compounded monthly?
Excel hint:
1) PV(rate, nper, pmt = 0, fv, type = 0)
2) Difference between APR and periodic discount rate
$836
$833
$914
$842
Question 152.5 / 2.5 pts
Which of the following statements is/are correct?
I. At 6% interest, the present value of: $400 for the first year, $600 for the second year, and $800 for the third year is $1,603.00.
II. The future value of the following mixed cash flow stream (if it is from an annuity due at 6% interest):$400 for the first year, $600 for the second year, and $800 for the third year is $1,999 (rounded).
Neither statement I nor II is correct.
Only statement I is correct.
Both statements I and II are correct.
Only statement II is correct.
Question 162.5 / 2.5 pts
Jenny Genius wants to purchase a new car. She knows that she can afford to pay $250 per month and that her bank will charge her 8% interest on the car loan. She intends to pay off the car in five years. Interest will be compounded monthly. Of the following, which is the most expensive vehicle in her price range that she could consider?
A Malibu selling for $12,320
A Celica selling for $17,500
A Civic selling for $14,670
A Taurus selling for $11,900
Amortized loan: The next three questions will be based on the following information.
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment.
How much is the annual total loan payment?
How much interest is paid in the first year?
How much total interest is paid over the life of the loan?
Excel hint:
Question 172.5 / 2.5 pts
For the above loan, how much interest is paid in the first year?
7500
8000
10000
9000
Question 182.5 / 2.5 pts
For the above loan, how much is the annual payment?
38803
33333
39803
48903
Question 192.5 / 2.5 pts
For the above loan, how much is the total interest paid over three years?
16410
16900
26410
26941
Question 202.5 / 2.5 pts
The yield-to-maturity of a bond with a finite maturity date is a function of all of the following variables except:
the current price
the required rate of return on the bond
the uniform annual interest payments
the maturity value
Question 212.5 / 2.5 pts
Which of the following statements concerning preferred stocks is true?
Preferred stock dividends per share are normally increased as the earnings of the firm increase.
Preferred dividends per share are usually not cut or suspended unless the firm is faced with serious financial problems.
The par value of a stock is always the same as the initial selling price.
Preferred stockholders have a prior claim on the income and assets of the firm as compared to the claims of lenders.
Question 222.5 / 2.5 pts
Potential sellers of an asset can be represented as a ___ schedule showing the ___ prices at which they are willing to sell given quantities of the asset.
supply, minimum
supply, average
supply, maximum
demand, maximum
Question 232.5 / 2.5 pts
When the required rate of return is ____ the coupon rate, the bond will sell at a discount.
equal to
the same as
less than
Question 12.5 / 2.5 pts
_____ is interest that is paid not only on the principal, but also on any interest earned but not withdrawn during earlier periods.
compound interest
basic interest
future interest
simple interest
Question 22.5 / 2.5 pts
Finding the discounted current value of $1,000 to be received at the end of each of the next 5 years requires calculating the
present value of an annuity due
future value of an annuity due
present value of an annuity
future value of an annuity
Question 32.5 / 2.5 pts
An annuity due is one in which
payments or receipts occur forever.
payments or receipts occur at the beginning of each period.
payments or receipts occur at the end of each period.
cash flows occur continuously.
Question 42.5 / 2.5 pts
If the present value of a given sum is equal to its future value, then
the discount rate must be low
none of the answers is correct
the discount rate must be zero
the discount rate must be very high
Question 52.5 / 2.5 pts
The more frequent the compounding the
lesser the future value
greater the effective interest rate
greater the amount deposited
greater the present value
Question 62.5 / 2.5 pts
Determine how much $1,000 deposited in a savings account paying 8% (compounded annually) will be worth after 5 years.
Excel hint: FV(rate, nper, pmt = 0, pv, fv, type) = ??
$784
$1,400
$1,469
$5,526
The next two questions will be based on the following information.
Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum for the entire period of time.
Question 72.5 / 2.5 pts
Determine the value of pension at the age of 60 for all payments during age 61 - 80?
Excel hint: PV(rate, nper, pmt, fv = 0, type = 0) = ??
112,839.09
312,839.09
500,000.00
212,839.09
Question 82.5 / 2.5 pts
Determine the size of the annual deposits that must be made by Mr. Moore from age 35 till 60 to achieve the future value of pension (at age 60.)
Excel hint: Pmt(rate, nper, pv, fv, type = 0) = ??
$23,449
$2,164
$212,850
$8,514
Question 92.5 / 2.5 pts
You sold 100 shares of stock today for $30 per share that you paid $20 for 6 years ago. Determine the average annual rate of return on your investment, assuming the stock paid no dividends.
Excel hint: Rate(nper, pmt =0, pv, fv, type = 0, guess = 0.05) = ??
25%
150%
7%
8.33%
Question 102.5 / 2.5 pts
The Florida lottery agrees to pay the winner $250,000 at the end of each year for the next 20 years. What is the future value of this lottery if you plan to put each payment in an account earning 9 percent?
$12.79 million
$2.28 million
$5.00 million
$14.32 million
Question 112.5 / 2.5 pts
Many IRA fund managers argue that investors should invest at the beginning of the year rather than at the end. What is the difference to an investor who invests $2,000 per year at 11 percent over a 30 year period?
Excel hint:
Type = 0; ordinary annuity
Type = 1: annuity due
$54,244
There is no difference
$36,189
$43,785
Question 122.5 / 2.5 pts
New Jersey Mutual has offered you a single premium annuity that will pay you $12,000 per year (end of year) for the next 15 years. If you must pay $109,296 today for this annuity, what is your expected rate of return?
8%
7%
10%
9%
Question 132.5 / 2.5 pts
Designs Now is opening a showcase office to display and sell its computer designed poster art. Designs expects cash flows to be $120,000 in the first year, $180,000 in the second year, $240,000 in the third year. If Designs uses 11 percent as its discount rate, what is the present value of the cash flows?
$429,686
$457,620
$424,820
$456,758
IncorrectQuestion 140 / 2.5 pts
What is the present value of $1,000 received 2 years from today if the nominal interest rate is 9% (annual percentage rate) and compounded monthly?
Excel hint:
1) PV(rate, nper, pmt = 0, fv, type = 0)
2) Difference between APR and periodic discount rate
$836
$833
$914
$842
Question 152.5 / 2.5 pts
Which of the following statements is/are correct?
I. At 6% interest, the present value of: $400 for the first year, $600 for the second year, and $800 for the third year is $1,603.00.
II. The future value of the following mixed cash flow stream (if it is from an annuity due at 6% interest):$400 for the first year, $600 for the second year, and $800 for the third year is $1,999 (rounded).
Neither statement I nor II is correct.
Only statement I is correct.
Both statements I and II are correct.
Only statement II is correct.
Question 162.5 / 2.5 pts
Jenny Genius wants to purchase a new car. She knows that she can afford to pay $250 per month and that her bank will charge her 8% interest on the car loan. She intends to pay off the car in five years. Interest will be compounded monthly. Of the following, which is the most expensive vehicle in her price range that she could consider?
A Malibu selling for $12,320
A Celica selling for $17,500
A Civic selling for $14,670
A Taurus selling for $11,900
Amortized loan: The next three questions will be based on the following information.
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment.
How much is the annual total loan payment?
How much interest is paid in the first year?
How much total interest is paid over the life of the loan?
Excel hint:
Question 172.5 / 2.5 pts
For the above loan, how much interest is paid in the first year?
7500
8000
10000
9000
Question 182.5 / 2.5 pts
For the above loan, how much is the annual payment?
38803
33333
39803
48903
Question 192.5 / 2.5 pts
For the above loan, how much is the total interest paid over three years?
16410
16900
26410
26941
Question 202.5 / 2.5 pts
The yield-to-maturity of a bond with a finite maturity date is a function of all of the following variables except:
the current price
the required rate of return on the bond
the uniform annual interest payments
the maturity value
Question 212.5 / 2.5 pts
Which of the following statements concerning preferred stocks is true?
Preferred stock dividends per share are normally increased as the earnings of the firm increase.
Preferred dividends per share are usually not cut or suspended unless the firm is faced with serious financial problems.
The par value of a stock is always the same as the initial selling price.
Preferred stockholders have a prior claim on the income and assets of the firm as compared to the claims of lenders.
Question 222.5 / 2.5 pts
Potential sellers of an asset can be represented as a ___ schedule showing the ___ prices at which they are willing to sell given quantities of the asset.
supply, minimum
supply, average
supply, maximum
demand, maximum
Question 232.5 / 2.5 pts
When the required rate of return is ____ the coupon rate, the bond will sell at a discount.
equal to
the same as
less than
Question 1
2.5 / 2.5 pts
_____ is interest that is paid not only on the principal, but also on any interest earned but not withdrawn during earlier periods.
compound interest
basic interest
future interest
simple interest
Question 22.5 / 2.5 pts
Finding the discounted current value of $1,000 to be received at the end of each of the next 5 years requires calculating the
present value of an annuity due
future value of an annuity due
present value of an annuity
future value of an annuity
Question 32.5 / 2.5 pts
An annuity due is one in which
payments or receipts occur forever.
payments or receipts occur at the beginning of each period.
payments or receipts occur at the end of each period.
cash flows occur continuously.
Question 42.5 / 2.5 pts
If the present value of a given sum is equal to its future value, then
the discount rate must be low
none of the answers is correct
the discount rate must be zero
the discount rate must be very high
Question 52.5 / 2.5 pts
The more frequent the compounding the
lesser the future value
greater the effective interest rate
greater the amount deposited
greater the present value
Question 62.5 / 2.5 pts
Determine how much $1,000 deposited in a savings account paying 8% (compounded annually) will be worth after 5 years.
Excel hint: FV(rate, nper, pmt = 0, pv, fv, type) = ??
$784
$1,400
$1,469
$5,526
The next two questions will be based on the following information.
Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum for the entire period of time.
Question 72.5 / 2.5 pts
Determine the value of pension at the age of 60 for all payments during age 61 - 80?
Excel hint: PV(rate, nper, pmt, fv = 0, type = 0) = ??
112,839.09
312,839.09
500,000.00
212,839.09
Question 82.5 / 2.5 pts
Determine the size of the annual deposits that must be made by Mr. Moore from age 35 till 60 to achieve the future value of pension (at age 60.)
Excel hint: Pmt(rate, nper, pv, fv, type = 0) = ??
$23,449
$2,164
$212,850
$8,514
Question 92.5 / 2.5 pts
You sold 100 shares of stock today for $30 per share that you paid $20 for 6 years ago. Determine the average annual rate of return on your investment, assuming the stock paid no dividends.
Excel hint: Rate(nper, pmt =0, pv, fv, type = 0, guess = 0.05) = ??
25%
150%
7%
8.33%
Question 102.5 / 2.5 pts
The Florida lottery agrees to pay the winner $250,000 at the end of each year for the next 20 years. What is the future value of this lottery if you plan to put each payment in an account earning 9 percent?
$12.79 million
$2.28 million
$5.00 million
$14.32 million
Question 112.5 / 2.5 pts
Many IRA fund managers argue that investors should invest at the beginning of the year rather than at the end. What is the difference to an investor who invests $2,000 per year at 11 percent over a 30 year period?
Excel hint:
Type = 0; ordinary annuity
Type = 1: annuity due
$54,244
There is no difference
$36,189
$43,785
Question 122.5 / 2.5 pts
New Jersey Mutual has offered you a single premium annuity that will pay you $12,000 per year (end of year) for the next 15 years. If you must pay $109,296 today for this annuity, what is your expected rate of return?
8%
7%
10%
9%
Question 132.5 / 2.5 pts
Designs Now is opening a showcase office to display and sell its computer designed poster art. Designs expects cash flows to be $120,000 in the first year, $180,000 in the second year, $240,000 in the third year. If Designs uses 11 percent as its discount rate, what is the present value of the cash flows?
$429,686
$457,620
$424,820
$456,758
IncorrectQuestion 140 / 2.5 pts
What is the present value of $1,000 received 2 years from today if the nominal interest rate is 9% (annual percentage rate) and compounded monthly?
Excel hint:
1) PV(rate, nper, pmt = 0, fv, type = 0)
2) Difference between APR and periodic discount rate
$836
$833
$914
$842
Question 152.5 / 2.5 pts
Which of the following statements is/are correct?
I. At 6% interest, the present value of: $400 for the first year, $600 for the second year, and $800 for the third year is $1,603.00.
II. The future value of the following mixed cash flow stream (if it is from an annuity due at 6% interest):$400 for the first year, $600 for the second year, and $800 for the third year is $1,999 (rounded).
Neither statement I nor II is correct.
Only statement I is correct.
Both statements I and II are correct.
Only statement II is correct.
Question 162.5 / 2.5 pts
Jenny Genius wants to purchase a new car. She knows that she can afford to pay $250 per month and that her bank will charge her 8% interest on the car loan. She intends to pay off the car in five years. Interest will be compounded monthly. Of the following, which is the most expensive vehicle in her price range that she could consider?
A Malibu selling for $12,320
A Celica selling for $17,500
A Civic selling for $14,670
A Taurus selling for $11,900
Amortized loan: The next three questions will be based on the following information.
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment.
How much is the annual total loan payment?
How much interest is paid in the first year?
How much total interest is paid over the life of the loan?
Excel hint:
Question 172.5 / 2.5 pts
For the above loan, how much interest is paid in the first year?
7500
8000
10000
9000
Question 182.5 / 2.5 pts
For the above loan, how much is the annual payment?
38803
33333
39803
48903
Question 192.5 / 2.5 pts
For the above loan, how much is the total interest paid over three years?
16410
16900
26410
26941
Question 202.5 / 2.5 pts
The yield-to-maturity of a bond with a finite maturity date is a function of all of the following variables except:
the current price
the required rate of return on the bond
the uniform annual interest payments
the maturity value
Question 212.5 / 2.5 pts
Which of the following statements concerning preferred stocks is true?
Preferred stock dividends per share are normally increased as the earnings of the firm increase.
Preferred dividends per share are usually not cut or suspended unless the firm is faced with serious financial problems.
The par value of a stock is always the same as the initial selling price.
Preferred stockholders have a prior claim on the income and assets of the firm as compared to the claims of lenders.
Question 222.5 / 2.5 pts
Potential sellers of an asset can be represented as a ___ schedule showing the ___ prices at which they are willing to sell given quantities of the asset.
supply, minimum
supply, average
supply, maximum
demand, maximum
Question 232.5 / 2.5 pts
When the required rate of return is ____ the coupon rate, the bond will sell at a discount.
equal to
the same as
less than
Question 1
2.5 / 2.5 pts
_____ is interest that is paid not only on the principal, but also on any interest earned but not withdrawn during earlier periods.
compound interest
basic interest
future interest
simple interest
Question 22.5 / 2.5 pts
Finding the discounted current value of $1,000 to be received at the end of each of the next 5 years requires calculating the
present value of an annuity due
future value of an annuity due
present value of an annuity
future value of an annuity
Question 32.5 / 2.5 pts
An annuity due is one in which
payments or receipts occur forever.
payments or receipts occur at the beginning of each period.
payments or receipts occur at the end of each period.
cash flows occur continuously.
Question 42.5 / 2.5 pts
If the present value of a given sum is equal to its future value, then
the discount rate must be low
none of the answers is correct
the discount rate must be zero
the discount rate must be very high
Question 52.5 / 2.5 pts
The more frequent the compounding the
lesser the future value
greater the effective interest rate
greater the amount deposited
greater the present value
Question 62.5 / 2.5 pts
Determine how much $1,000 deposited in a savings account paying 8% (compounded annually) will be worth after 5 years.
Excel hint: FV(rate, nper, pmt = 0, pv, fv, type) = ??
$784
$1,400
$1,469
$5,526
The next two questions will be based on the following information.
Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum for the entire period of time.
Question 72.5 / 2.5 pts
Determine the value of pension at the age of 60 for all payments during age 61 - 80?
Excel hint: PV(rate, nper, pmt, fv = 0, type = 0) = ??
112,839.09
312,839.09
500,000.00
212,839.09
Question 82.5 / 2.5 pts
Determine the size of the annual deposits that must be made by Mr. Moore from age 35 till 60 to achieve the future value of pension (at age 60.)
Excel hint: Pmt(rate, nper, pv, fv, type = 0) = ??
$23,449
$2,164
$212,850
$8,514
Question 92.5 / 2.5 pts
You sold 100 shares of stock today for $30 per share that you paid $20 for 6 years ago. Determine the average annual rate of return on your investment, assuming the stock paid no dividends.
Excel hint: Rate(nper, pmt =0, pv, fv, type = 0, guess = 0.05) = ??
25%
150%
7%
8.33%
Question 102.5 / 2.5 pts
The Florida lottery agrees to pay the winner $250,000 at the end of each year for the next 20 years. What is the future value of this lottery if you plan to put each payment in an account earning 9 percent?
$12.79 million
$2.28 million
$5.00 million
$14.32 million
Question 112.5 / 2.5 pts
Many IRA fund managers argue that investors should invest at the beginning of the year rather than at the end. What is the difference to an investor who invests $2,000 per year at 11 percent over a 30 year period?
Excel hint:
Type = 0; ordinary annuity
Type = 1: annuity due
$54,244
There is no difference
$36,189
$43,785
Question 122.5 / 2.5 pts
New Jersey Mutual has offered you a single premium annuity that will pay you $12,000 per year (end of year) for the next 15 years. If you must pay $109,296 today for this annuity, what is your expected rate of return?
8%
7%
10%
9%
Question 132.5 / 2.5 pts
Designs Now is opening a showcase office to display and sell its computer designed poster art. Designs expects cash flows to be $120,000 in the first year, $180,000 in the second year, $240,000 in the third year. If Designs uses 11 percent as its discount rate, what is the present value of the cash flows?
$429,686
$457,620
$424,820
$456,758
IncorrectQuestion 140 / 2.5 pts
What is the present value of $1,000 received 2 years from today if the nominal interest rate is 9% (annual percentage rate) and compounded monthly?
Excel hint:
1) PV(rate, nper, pmt = 0, fv, type = 0)
2) Difference between APR and periodic discount rate
$836
$833
$914
$842
Question 152.5 / 2.5 pts
Which of the following statements is/are correct?
I. At 6% interest, the present value of: $400 for the first year, $600 for the second year, and $800 for the third year is $1,603.00.
II. The future value of the following mixed cash flow stream (if it is from an annuity due at 6% interest):$400 for the first year, $600 for the second year, and $800 for the third year is $1,999 (rounded).
Neither statement I nor II is correct.
Only statement I is correct.
Both statements I and II are correct.
Only statement II is correct.
Question 162.5 / 2.5 pts
Jenny Genius wants to purchase a new car. She knows that she can afford to pay $250 per month and that her bank will charge her 8% interest on the car loan. She intends to pay off the car in five years. Interest will be compounded monthly. Of the following, which is the most expensive vehicle in her price range that she could consider?
A Malibu selling for $12,320
A Celica selling for $17,500
A Civic selling for $14,670
A Taurus selling for $11,900
Amortized loan: The next three questions will be based on the following information.
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment.
How much is the annual total loan payment?
How much interest is paid in the first year?
How much total interest is paid over the life of the loan?
Excel hint:
Question 172.5 / 2.5 pts
For the above loan, how much interest is paid in the first year?
7500
8000
10000
9000
Question 182.5 / 2.5 pts
For the above loan, how much is the annual payment?
38803
33333
39803
48903
Question 192.5 / 2.5 pts
For the above loan, how much is the total interest paid over three years?
16410
16900
26410
26941
Question 202.5 / 2.5 pts
The yield-to-maturity of a bond with a finite maturity date is a function of all of the following variables except:
the current price
the required rate of return on the bond
the uniform annual interest payments
the maturity value
Question 212.5 / 2.5 pts
Which of the following statements concerning preferred stocks is true?
Preferred stock dividends per share are normally increased as the earnings of the firm increase.
Preferred dividends per share are usually not cut or suspended unless the firm is faced with serious financial problems.
The par value of a stock is always the same as the initial selling price.
Preferred stockholders have a prior claim on the income and assets of the firm as compared to the claims of lenders.
Question 222.5 / 2.5 pts
Potential sellers of an asset can be represented as a ___ schedule showing the ___ prices at which they are willing to sell given quantities of the asset.
supply, minimum
supply, average
supply, maximum
demand, maximum
Question 232.5 / 2.5 pts
When the required rate of return is ____ the coupon rate, the bond will sell at a discount.
equal to
the same as
less than
Question 1
2.5 / 2.5 pts
_____ is interest that is paid not only on the principal, but also on any interest earned but not withdrawn during earlier periods.
compound interest
basic interest
future interest
simple interest
Question 22.5 / 2.5 pts
Finding the discounted current value of $1,000 to be received at the end of each of the next 5 years requires calculating the
present value of an annuity due
future value of an annuity due
present value of an annuity
future value of an annuity
Question 32.5 / 2.5 pts
An annuity due is one in which
payments or receipts occur forever.
payments or receipts occur at the beginning of each period.
payments or receipts occur at the end of each period.
cash flows occur continuously.
Question 42.5 / 2.5 pts
If the present value of a given sum is equal to its future value, then
the discount rate must be low
none of the answers is correct
the discount rate must be zero
the discount rate must be very high
Question 52.5 / 2.5 pts
The more frequent the compounding the
lesser the future value
greater the effective interest rate
greater the amount deposited
greater the present value
Question 62.5 / 2.5 pts
Determine how much $1,000 deposited in a savings account paying 8% (compounded annually) will be worth after 5 years.
Excel hint: FV(rate, nper, pmt = 0, pv, fv, type) = ??
$784
$1,400
$1,469
$5,526
The next two questions will be based on the following information.
Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum for the entire period of time.
Question 72.5 / 2.5 pts
Determine the value of pension at the age of 60 for all payments during age 61 - 80?
Excel hint: PV(rate, nper, pmt, fv = 0, type = 0) = ??
112,839.09
312,839.09
500,000.00
212,839.09
Question 82.5 / 2.5 pts
Determine the size of the annual deposits that must be made by Mr. Moore from age 35 till 60 to achieve the future value of pension (at age 60.)
Excel hint: Pmt(rate, nper, pv, fv, type = 0) = ??
$23,449
$2,164
$212,850
$8,514
Question 92.5 / 2.5 pts
You sold 100 shares of stock today for $30 per share that you paid $20 for 6 years ago. Determine the average annual rate of return on your investment, assuming the stock paid no dividends.
Excel hint: Rate(nper, pmt =0, pv, fv, type = 0, guess = 0.05) = ??
25%
150%
7%
8.33%
Question 102.5 / 2.5 pts
The Florida lottery agrees to pay the winner $250,000 at the end of each year for the next 20 years. What is the future value of this lottery if you plan to put each payment in an account earning 9 percent?
$12.79 million
$2.28 million
$5.00 million
$14.32 million
Question 112.5 / 2.5 pts
Many IRA fund managers argue that investors should invest at the beginning of the year rather than at the end. What is the difference to an investor who invests $2,000 per year at 11 percent over a 30 year period?
Excel hint:
Type = 0; ordinary annuity
Type = 1: annuity due
$54,244
There is no difference
$36,189
$43,785
Question 122.5 / 2.5 pts
New Jersey Mutual has offered you a single premium annuity that will pay you $12,000 per year (end of year) for the next 15 years. If you must pay $109,296 today for this annuity, what is your expected rate of return?
8%
7%
10%
9%
Question 132.5 / 2.5 pts
Designs Now is opening a showcase office to display and sell its computer designed poster art. Designs expects cash flows to be $120,000 in the first year, $180,000 in the second year, $240,000 in the third year. If Designs uses 11 percent as its discount rate, what is the present value of the cash flows?
$429,686
$457,620
$424,820
$456,758
IncorrectQuestion 140 / 2.5 pts
What is the present value of $1,000 received 2 years from today if the nominal interest rate is 9% (annual percentage rate) and compounded monthly?
Excel hint:
1) PV(rate, nper, pmt = 0, fv, type = 0)
2) Difference between APR and periodic discount rate
$836
$833
$914
$842
Question 152.5 / 2.5 pts
Which of the following statements is/are correct?
I. At 6% interest, the present value of: $400 for the first year, $600 for the second year, and $800 for the third year is $1,603.00.
II. The future value of the following mixed cash flow stream (if it is from an annuity due at 6% interest):$400 for the first year, $600 for the second year, and $800 for the third year is $1,999 (rounded).
Neither statement I nor II is correct.
Only statement I is correct.
Both statements I and II are correct.
Only statement II is correct.
Question 162.5 / 2.5 pts
Jenny Genius wants to purchase a new car. She knows that she can afford to pay $250 per month and that her bank will charge her 8% interest on the car loan. She intends to pay off the car in five years. Interest will be compounded monthly. Of the following, which is the most expensive vehicle in her price range that she could consider?
A Malibu selling for $12,320
A Celica selling for $17,500
A Civic selling for $14,670
A Taurus selling for $11,900
Amortized loan: The next three questions will be based on the following information.
Prepare an amortization schedule for a three-year loan of $100,000. The interest rate is 8% per year, and the loan calls for equal annual payment.
How much is the annual total loan payment?
How much interest is paid in the first year?
How much total interest is paid over the life of the loan?
Excel hint:
Question 172.5 / 2.5 pts
For the above loan, how much interest is paid in the first year?
7500
8000
10000
9000
Question 182.5 / 2.5 pts
For the above loan, how much is the annual payment?
38803
33333
39803
48903
Question 192.5 / 2.5 pts
For the above loan, how much is the total interest paid over three years?
16410
16900
26410
26941
Question 202.5 / 2.5 pts
The yield-to-maturity of a bond with a finite maturity date is a function of all of the following variables except:
the current price
the required rate of return on the bond
the uniform annual interest payments
the maturity value
Question 212.5 / 2.5 pts
Which of the following statements concerning preferred stocks is true?
Preferred stock dividends per share are normally increased as the earnings of the firm increase.
Preferred dividends per share are usually not cut or suspended unless the firm is faced with serious financial problems.
The par value of a stock is always the same as the initial selling price.
Preferred stockholders have a prior claim on the income and assets of the firm as compared to the claims of lenders.
Question 222.5 / 2.5 pts
Potential sellers of an asset can be represented as a ___ schedule showing the ___ prices at which they are willing to sell given quantities of the asset.
supply, minimum
supply, average
supply, maximum
demand, maximum
Question 232.5 / 2.5 pts
When the required rate of return is ____ the coupon rate, the bond will sell at a discount.
equal to
the same as
less than
1. If we place $7,654 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 8.5 years? PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE! Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of...
If you deposit $1,067 per month into a savings account that pays an annual rate of 4.7 percent, compounded monthly, how much will you have in the account after 31 years? Show using Excel Functions. Nper Rate PV FV PMT
What is the present value of $929 to be received in 13.5 years from today if our discount rate is 3.5 percent? PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE! Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of each period only....
If you bought a stock for $53 dollars and could sell it 16 years later for three times what you originally paid. What was your return on owning this stock? PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE! Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is...
Use the PMT function in Excel to compute the monthly payment on a $328000 business loan at an annual interest rate of 7.15% over 20 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type) Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($)
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
A) If you delay saving by 5 years, what would the interest rate (APR) need to be for you to hit the target amount ($349,881.67)? Use excel RATE function and show values for arguments (nper, pmt, pv, fv, type, guess).. B) Convert that APR to an EAR. Use excel EFFECT function and show values for arguments (nominal_rate, npery) C) Amount you need in your account at retirement in order to spend $5000 each period? Use excel PV function and show...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...