Reference no: EM132638436
Please show the calculations using EXCEL
1. Suppose a State of Texas bond will pay $2,000 ten years from now. If the going interest rate on these 10-year bonds is 0.5%, how much is the bond worth today?
2. Suppose you have $1,000 and plan to purchase a 10-year certificate of deposit (CD) that pays 1.0% annual interest, compounded annually. How much will you have when the CD matures?
3. Suppose you have $1,000 and plan to purchase a 10-year certificate of deposit (CD) that pays 1.0% annual interest, compounded quarterly. How much will you have when the CD matures?
(Hint: To incorporate the compounding effect, you need to convert the annual interest rate into the quarterly interest rate, and convert years into quarters to get correct answer).
4. Suppose you have $1,000 and plan to purchase a 10-year certificate of deposit (CD) that pays 1.0% annual interest, compounded monthly. How much will you have when the CD matures?
(Hint: To incorporate the compounding effect, you need to convert the annual interest rate into the monthly interest rate, and convert years into months to get correct answer).
5. Suppose you have $1,000 and plan to purchase a 10-year certificate of deposit (CD) that pays 1.0% annual interest, compounded daily. How much will you have when the CD matures?
(Hint: To incorporate the compounding effect, you need to convert the annual interest rate into the daily interest rate, and convert years into days to get correct answer).
6. Suppose the U.S. Treasury offers to sell you a bond for $900.00. No payments will be made until the bond matures 10 years from now, at which time it will be redeemed for $1,000. What interest rate would you earn if you bought this bond at the offer price?
|
Calculate the cost per equivalent unit of conversion
: Alpha Company, on March 1, 2017 has a beginning Work in Process inventory of zero. Calculate the cost per equivalent unit of conversion
|
|
How to calculate tolerable misstatement
: How to calculate tolerable misstatement if planning materiality is 15,217,068 and materiality for the financial statements
|
|
Risk and costs of compromised data integrity breaches
: Discuss the risk and costs of compromised data integrity breaches. Focus on integrity not confidentiality. Look at military, education, science, medicine,
|
|
Explain the concept behind Homestake disclosure
: What is the significance of Homestake's disclosure of "Current taxes" of $26,349 and "Deferred taxes" of $(39,436)
|
|
Convert the annual interest rate
: Suppose a State of Texas bond will pay $2,000 ten years from now. If the going interest rate on these 10-year bonds is 0.5%,
|
|
Introduction to security protocols
: Introduction to security protocols that will help reduce the risk of a security incident we are going to study security incidents.
|
|
Industry experts believe blockchain is technology
: Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years.
|
|
Journalize the March transactions
: March 10 Purchased golf equipment for $5,380 from Grouper Corp., payable in 30 days. Journalize the March transactions
|
|
Describe the organization environment
: Describe the organization's environment, and evaluate its preparedness for virtualization. Explain Microsoft (or another product) licensing for virtualized
|