Answers
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
NEED HELP WITH FINANCIAL CALCULATOR, LET ME KNOW
BOND - Microsoft Excel (Product Activation Failed) Add-Ins File Home Insert Page Layout Formulas Data Review View - 2x % Cut Calibri Dr General Wrap Text Merge Merge & Center - Center BI U SF $ % % , 4:0 .00 :.: Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Σ AutoSum : A Fill Sort & 2 Clear Filter Editing -11AA = = = D- DA Font fax AQ AR Find & Select Alignment Number Cells E Copy Paste Format Painter Clipboard AR66 AO 47 48 > AP - AS AT AU AV AW AX AY AZ BA 49 FV COUPON LIFE YTM 1000 80 20 7% 50 51 52 53 54 55 (a) VALUE OF BOND $ 1,105.94 EXCEL =PV(AS51, AS50,-AS49,-AS48) (b)(0) IF YTM INCREASES TO VALUE OF BOND 11% $ 761.10 EXCEL=PV(AS55, AS50,-AS49,-AS48) 56 57 58 (b)(ii) 6% IF YTM DECREASES TO VALUE OF BOND $ 1,229.40 EXCEL = PV(AS58, AS50,-AS49,-AS48) (c) WHEN THE YTM = 11% : BOND IS TRADING AT A DISCOUNT AS YTM > COUPON RATE. SO IT IS A DISCOUNT BOND WHEN THE YTM = 6%: BOND IS TRADING AT A PREMIUM AS YTM< COUPON RATE. SO IT IS A PREMIUM BOND 60 61 62 63 64 65 66 AS THE LIFE IS HIGHER, THE BONDS HAVE HIGHER INTEREST RATE RISK COMPARED TO LOWER MATURITY BONDS 67 ► Sheet2 AFN BANKING NOTE 51 53 CLEAN PRICE S10 BIDDING, UNDERWRITING EUAC AW LIFE LP, IP, MRP, INFLATION WARRANT refund S5 0 0 YIELD SPOT ferences S4 80 S6 120% Rea S E O * 10 ENG 20-11-2019
BOND - Microsoft Excel (Product Activation Failed) Add-Ins File Home Insert Page Layout Formulas Data Review View - 2x % Cut Calibri Dr General Σ AutoSum : A Fill 2 Sort & Wrap Text Merge Merge & Center - Center m Find & -11AA = = = B- A Font C E Copy Paste Format Painter Clipboard B I U SF 4:0 .00 .
.
Insert Delete Format $ -% % Number Conditional Format Formatting as Table Styles Cell Styles 2 Clear Filter Editing Select Alignment Cells AV69 AP I AQ AR AS AT AU AV AW AX AY AZ BA BB 5 67 68 69 70 71 1000 LIFE IS NOW 15 YEARS FV COUPON LIFE YTM 80 15 7% (d) VALUE OF BOND $ 1,091.08 EXCEL =PV(AS72, AS71,-AS70,-AS69) 73 74 75 76 77 78 79 80 81 IF YTM INCREASES TO VALUE OF BOND 11% $ 784.27 EXCEL =PV(AS76, AS71,-AS70,-AS69) IF YTM DECREASES TO VALUE OF BOND 6% $ 1,194.24 EXCEL = PV(AS79, AS71,-AS70,-AS69) 82 (e) WHEN THE YTM = 11% : BOND IS TRADING AT A DISCOUNT AS YTM > COUPON RATE. SO IT IS A DISCOUNT BOND WHEN THE YTM = 6% : BOND IS TRADING AT A PREMIUM AS YTM< COUPON RATE. SO IT IS A PREMIUM BOND 83 84 85 86 07 AS THE LIFE IS LOWER, THE BONDS HAVE LOWER INTEREST RATE RISK COMPARED TO HIGHER MATURITY BONDS WE CAN SEE 2 RESULTS, THE PRICE CHANGE IS SMALLER IN CASE OF LOWER MATURITY BONDS ► Sheet2 AFN BANKING NOTE 51 53 CLEAN PRICE S10 BIDDING, UNDERWRITING EUAC AW LIFE LP, IP, MRP, INFLATION WARRANT refund S5 YIELD SPOT ferences S4 90 Rea S6 O LI O 120% Ka 40 ENG 20-11-2019 ...Bag
Similar Solved Questions
1 answer
Problem la Points (20) Draw the process tree for the program shown below. #include<sys/types.h> #include<stdio.h> #include<unistd.h>...
Problem la Points (20) Draw the process tree for the program shown below. #include<sys/types.h> #include<stdio.h> #include<unistd.h> int value = 5; int main() pid_t pid; pid = forko; if(pid ==0) { */ Child Process */ forkO; value += 15; return 0; else if (pid > 0) {/* Parent pro...
1 answer
Newman Corp. sold a machine with an orginal cost of $50,000 and a basis of $20,000...
Newman Corp. sold a machine with an orginal cost of $50,000 and a basis of $20,000 for $14,000. What is the nature of the gain or loss? Explain....
1 answer
A number of streets in a large city make up a perfect 8-by-8 grid. The street...
A number of streets in a large city make up a perfect 8-by-8 grid. The street corners occur at integer lattice points (2,y), where I and y are integers between 0 and 8 (including 0 and 8). Any given street corner , y) is connected to (-1,y), (+1, y), (Oy - 1), and (2,4 + 1) by streets (assuming that...
1 answer
A company has launched a new product. This company is a reputed company with 50% market...
A company has launched a new product. This company is a reputed company with 50% market share of similar range of products. The competitors also enter with their new products equivalent to your new product. Based on earlier experience you initially estimated that, your market share of the new produc...
1 answer
Incorrect Mark 0.00 out of 0.30 P Flag question What reagents would be used for the...
Incorrect Mark 0.00 out of 0.30 P Flag question What reagents would be used for the following transformation? Select one: Select one: A) h / Pd- Caso - Pb ; 2) CHUCO,H (CH₂ CL ; 3) anhydrous HBr - 8.1) Na/NHz / EtoH; 2) Brz i H₂O x . :) *, /Pd-Caso - Pb ; 2) CH,CO,H /ch,q, ; ?) anky drou...
1 answer
Question 5 Company XYZ had the following accounts in its financial statements during the year: cash,...
Question 5 Company XYZ had the following accounts in its financial statements during the year: cash, common stock, marketable securities, unearned rent revenue, available-for-sale debt securities, prepaid utilities expense, sales revenue, accumulated other comprehensive income, retained earnings, tr...
1 answer
2. (1O pts) A flat bar of an annealed metal, whose strain-hardening behavior is expressed by σ 800 (10) es N m2, originally 25 mm in thickness. By a series of tw o consecutive reductions the initial...
2. (1O pts) A flat bar of an annealed metal, whose strain-hardening behavior is expressed by σ 800 (10) es N m2, originally 25 mm in thickness. By a series of tw o consecutive reductions the initial thickness is reduced to 20 and 15 mm respectively under plane strain condition (the width of th...
1 answer
17. Use the following information to calculate for the year ended December 31, 2020 (a) net...
17. Use the following information to calculate for the year ended December 31, 2020 (a) net income (net loss), (b) ending retained earnings, and (c) total assets. A. Net income ( net loss) Depreciation expense Other operating expenses Patent Accounts receivable Prepaid Rent Retained earnings (beginn...
1 answer
Draw the structure corresponding to the name. Be sure to indicate any charges on ions. Sodium...
Draw the structure corresponding to the name. Be sure to indicate any charges on ions. Sodium hexanoate Draw the products of the acid-base reaction. Be sure to indicate any charges on ions. Draw the products that form when the ester is treated with H^O and NaOH. Differentiate products by greater or ...
1 answer
Which of the following sections of the CAFR is/are audited? Multiple Choice Introductory section. Financial section....
Which of the following sections of the CAFR is/are audited? Multiple Choice Introductory section. Financial section. Statistical section. All of the choices are correct....
1 answer
Question 4 (1 point) What is the probability associated with a return that lies in the...
Question 4 (1 point) What is the probability associated with a return that lies in the upper (right side) tail when the mean plus two standard deviations is graphed? 1) 5.0 percent 2) 1.0 percent 3) 0.05 percent 4) 0.5 percent 5) 2.5 percent...
1 answer
The Richmond Corporation uses the weighted-average method in its process costing system. The company has only...
The Richmond Corporation uses the weighted-average method in its process costing system. The company has only a single processing department. The company's ending work in process inventory on August 31 consisted of 20,600 units. The units in the ending work in process inventory were 100% complet...
1 answer
I am stuck in this problem, can someone help What is the profntability index ratio for the incremental analysis between...
I am stuck in this problem, can someone help What is the profntability index ratio for the incremental analysis between the two projects and which project would be chosen if only one of the two projects could be selected Capital 1,500,000 $1,400,000 Investment Project Life 30 30 Annual Benefits $26...
1 answer
4. Use R1 = 975 k12 and R2 = 25 k22, determine R3 so that ILED...
4. Use R1 = 975 k12 and R2 = 25 k22, determine R3 so that ILED = 20 mA. LED1 + 1 YE R2 Figure 4: Constant current source using operational amplifier and BJT We were unable to transcribe this image...
1 answer
Required information [The following information applies to the questions displayed below.) Project A requires a $365,000...
Required information [The following information applies to the questions displayed below.) Project A requires a $365,000 initial investment for new machinery with a five-year life and a salvage value of $37,500. The company uses straight-line depreciation. Project A is expected to yield annual net i...
1 answer
What does it mean when the financial leverage of the company goes up? Is it good...
What does it mean when the financial leverage of the company goes up? Is it good or bad for the company?...
1 answer
Please provide the major organic product(s) of the reaction as described. Account for all stereochemistry requirements...
Please provide the major organic product(s) of the reaction as described. Account for all stereochemistry requirements for reaction and products. 1) NaH, DMF, -78 C d) CI 2) NaOH e) Br OH 1...