Question

$5.00 AUTOMATIC CALCULATIONS IN EXCEL

Found in Business: Finance
Chapter 1, # 0
Posted by :
 
Q:

GIVEN THE REQUIRED INFORMATION:

CALCULATE

1. YIELD TO MATURITY (YTM) OF THE BOND

2. CURRENT PRICE OF THE BOND

3. INTEREST RATE OF THE BOND 

 

EXPLANATION: I AM HERE PROVIDING A EXCEL SHEET THAT HAS PREPARED BY ME AND IT INCLUDES AUTOMATIC CALCULATIONS FOR THE CALCULATION OF AFORESAID REQUIREMENTS IN DIFFERENT QUESTIONS. YOU JUST HAVE TO INSERT THE REQUIRED INFORMATION IN THE CELLS AND YOU WILL AUTOMATICALLY GET THE DESIRED RESULT AMONG 3 OF THE ABOVE..

THANKS... YOU WILL DEFINITELY APPRECIATE MY WORK.....

FOR ANY QUERY OR FURTHER ASSISTANCE FEEL FREE TO CONTACT ME....................

 

Tutorial
 
$5.00
AUTOMATIC CALCULATIONS IN EXCEL
  • This tutorial hasn't been purchased yet.
  • Posted on Jun. 29, 2012 at 09:52:16AM
A:
Preview: ...     ...

The full tutorial is about 12 words long plus attachments.

attachmentlogo

Attachments:
BOND VALUATIONS - YTM, CURRENT PRICE, COUPON RATE.xlsx (15K)