INPUTS
Coupon Rate
Face Amount
Maturity
YTM
Annual or Semi-Annual
0.085
1000
10
0.073
Annual
Coupon Rate
0.085
Face Amount
1000
Maturity
10
YTM
0.073
Annual or Semi-Annual Semi-Annual
Data Table For Bond Price vs. Yield to Maturity
Bond Price
Year
Cash Fl
In cell d12.d16 write a formula that will calculate the salesperson's commission based on their level of sales
In addition to straight commission, salespersons get $500 for each year of service
Sales Commission Structure
Sales >=
$0
$1,000,000
$2,000,000
Net income (loss) by year
$ 350.00
$ 300.00
$ 250.00
$ 200.00
$ 150.00
Net income (loss)
Net Income in T housands of $
$ 100.00
$ 50.00
$1989
1990
1991
$ (50.00)
$ (100.00)
Year
1992
1993
1993 Sales by Product
Other; 17%
Beer and wine; 9%
Gasoline; 54%
Di
rate
Year
Cash Flow
10%
0
1
2
3
4
5
-1000
200
300
350
400
500
-1000 181.81818 247.93388 262.96018 273.20538 310.46066
Year of Interest 1
Year of Interest 2
What is the Present Value of the Year 3 CF?
$262.96
$262.96
What is the value of the year 1 CF in Y