Construct a spreadsheet to solve current price of bonds for Karman Company
Not what you're looking for?
Spreadsheet Assignment
Karman Company has two different bonds currently outstanding. Both bonds have a par value of $26,500 and a maturity of 19 years. The required return on both bonds is 10 percent, compounded semiannually.
Bond M makes no payments for the first 7 years, then pays $1,600 every six months over the subsequent 4 years, and finally pays $2,100 every six months over the last 8 years.
Bond N is a zero coupon bond and makes no coupon payments over the life of the bond. The bond's only cash flow is the payment of principal or par value at maturity.
Construct a spreadsheet that solves for the current price of both of these bonds.
The spreadsheet needs to be designed so that any one of the input variables can easily be changed by one cell entry. Further, if any variable entry is changed in value, the resulting price should automatically be calculated by the spreadsheet. For example, there should be a cell to enter the par value and when the numerical entry in that cell is changed a new bond price will automatically calculate and display.
Your spreadsheet must include:
? at least 2 different types of number format
? at least 2 different colors for cell highlighting
? all calculations or computations must be done by and within the spreadsheet
? all formulated cell calculations must use cell references (any input numbers must be first listed or entered in another cell)
? use at least 2 built-in formulas or functions (fx), e.g., =sum(D3:F3), =count(A3:A9), etc.
Purchase this Solution
Solution Summary
The solution constructs a spreadsheet to price bonds for Karmans Company.
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Lean your Process
This quiz will help you understand the basic concepts of Lean.