In: Finance
which of the following statements is TRUE about excel?
A. We can lock in cells by placing an exclamation point in front of the cells column and row
B.The first symbol to enter when entering a formula is the division sign
C. Bond prices are to be entered with a negative sign while par values are to be entered with a positive sign
D.The "PMT" function can be used to find the price of a bond
TRUE statements about excel is bond prices are to be entered with a negative sign while par values are to be entered with a positive sign
Therefore correct answer is option: Bond prices are to be entered with a negative sign while par values are to be entered with a positive sign
Generally the cash inflow is entered with positive sign and cash outflow entered with negative sign as bond prices is considered as cash out flow therefore it is to be entered with a negative sign while par values are the maturity amount received as cash inflow therefore to be entered with a positive sign.
Other statements are not true about excel -
· We can lock in cells by placing an $ sign in front of the cells column and row not exclamation point
· The first symbol to enter when entering a formula is the equal to (=) sign not division sign
· The "PV" function can be used to find the price of a bond and “PMT” function can be used to find the coupon payment amount of a bond