Question: in excel A 10 -year bond with a face value of $6000 is going to be purchased by you. Interest payments on the bond will

in excel

A 10 -year bond with a face value of $6000 is going to be purchased by you. Interest payments on the bond will be made to you by the bond issuer every quarter for ten years based on a nominal annual interest rate of 6.00% compounded monthly. At the end of the ten years the bond issuer will also pay back the original face value of the bond. Which of the formulas below gives the correct effective interest rate? Explain your choice by identifying all the variables used in the effective interest rate general formula: (a) (1+4.06)31 (b) (1+4.06)121 (c) [1+120.06)31 (d) (1+12.06)31 (e) (1+120.06)41 (f) (1+3.06)121 (e) (1+12.06)1201 (h) (1+4.06)401 (i) (1+3.06)41 Next, develop a cash flow table in MS Excel for this bond purchase. Identify the correct time period units to use in the cash flow table, the total number of time periods, and the correct dollar amounts for your cash inflows and outflows at each time period. Then develop a cash flow diagram in MS Excel using the cash flow table with a stacked column chart. A 10 -year bond with a face value of $6000 is going to be purchased by you. Interest payments on the bond will be made to you by the bond issuer every quarter for ten years based on a nominal annual interest rate of 6.00% compounded monthly. At the end of the ten years the bond issuer will also pay back the original face value of the bond. Which of the formulas below gives the correct effective interest rate? Explain your choice by identifying all the variables used in the effective interest rate general formula: (a) (1+4.06)31 (b) (1+4.06)121 (c) [1+120.06)31 (d) (1+12.06)31 (e) (1+120.06)41 (f) (1+3.06)121 (e) (1+12.06)1201 (h) (1+4.06)401 (i) (1+3.06)41 Next, develop a cash flow table in MS Excel for this bond purchase. Identify the correct time period units to use in the cash flow table, the total number of time periods, and the correct dollar amounts for your cash inflows and outflows at each time period. Then develop a cash flow diagram in MS Excel using the cash flow table with a stacked column chart

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Data Window 100% GO *** Fri 9:07 pm Q Excel File Edit View Insert Format Tools AutoSave HESU- OFF Help FINC Assign 1 ashriya .xls - Compatibility Mode Tell me Q Home Insert Draw Page Layout Formulas...

please can you help for these bond and loan problem Solve all of the following problems with Excel. Please use formulas in excel to solve. (10 pts) Problem 1 (10 pts) (a) Assume monthly car payments...

should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an...

el explanation for this problem olve all of the following problems with Excel. Please use formulas in excel to solve. (10 pts) Problem 1 (10 pts) (a) Assume monthly car payments of $500 per month for...

Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1....

Suppose you have $850 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? Suppose a State of California...

Please use excel to solve the problem. Show any formulas/functions used, please! Thank you! Solve all the following problems with Excel. Please use formulas in excel to solve. (10 pts) Problem 1 (10...

Assume for simplicity that these payments continue for 20 years and then cease. The interest rate is 4% . You plan to cover this obligation by investing in 5- and20-year maturity Treasury strips.(a)...

:Please answer all questions. 35. Valerie Smith is attempting to construct a bond portfolio with a duration of 9 years. She has $500,000 to invest and is considering allocating it between two zero...

Consider the following scenario involving Big Z Inc., an automotive products wholesaler. Big Z Inc. wants to create an analytical database (data warehouse) to analyze its order quantities. The two...

Refer to the Journal of the American Law and Economics Association (Vol. 3, 2001) study of appeals of federal civil trials, presented in Exercise. A breakdown of the 678 civil cases that were...

2.82 For married couples living in a certain suburb, the probability that the husband will vote on a bond referendum is 0.2, the probability that the wife will vote on the referendum is 0.28, and the...

Your instructor tells the class to put away their laptop computers. While she is making this statement, she raises her voice, looks angry, and uses direct eye contact. She is using nonverbal...

4. To what extent do you think measures of a countrys wellbeing should be included when comparing the performance of countries? Should there be something like the balanced scorecard, discussed in...

2. In your opinion do you think that measures of social performance should be considered when deciding managers pay? If so what measures should be used?

2. Obtain a copy of the safety policy for either your college or your workplace. a. Use this to identify the roles of various people in the organisation in relation to health and safety. b. Use the...