This spreadsheet was created to track the money different employees earned in bonuses. The creator used numbers and formulas to make the document efficient so that it could change as the bonus amounts changed.

What is most likely appears in the formula bar when B6 is selected?
A $total
B $112
C=MAX(B2:B5)
D =AVERAGE(B2:B5)

Suppose someone wants to sell a piece of land for cash. the selling of a piece of land represents turning

Bond x is noncallable and has 20 years to maturity, a 7% annual coupon, and a $1,000 par value. your required return on bond x is 10%; if you buy it, you plan to hold it for 5 years. you (and the market) have expectations that in 5 years, the yield to maturity on a 15-year bond with similar risk will be 9.5%. how much should you be willing to pay for bond x today? (hint: you will need to know how much the bond will be worth at the end of 5 years.) do not round intermediate calculations. round your answer to the nearest cent.

Connors academy reported inventory in the 2017 year-end balance sheet, using the fifo method, as $154,000. in 2018, the company decided to change its inventory method to lifo. if the company had used the lifo method in 2017, the company estimates that ending inventory would have been in the range $130,000-$135,000. what adjustment would connors make for this change in inventory method?