To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training. In cell L2, enter a formula using the IF and AND functions, as well as structured references to determine if Adam Moriarty can be a bunk leader. a. The logical test in the IF function should determine if the staff member’s Service Years is greater than 4 AND the staff member’s Leadership Training status is "Yes". Remember to use a structured reference to the Service Years and the Leadership Training columns. b. The function should return the text Yes if a staff member meets both of those criteria. c. The function should return the text No if a staff member meets none or only one of those criteria.

You wish to buy a cabin in 15 years. today, the cabin costs $150,000. you believe the price of the cabin will inflate at 4% annually. you want to invest a single amount of money (lump sum) today and have the money grow to equal the future purchase price of the cabin 15 years from now. if you can earn 10% annually on your investments, how much do you need to invest now, in order to be able to purchase the cabin?

Dahlia enterprises needs someone to supply it with 127,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. it will cost you $940,000 to install the equipment necessary to start production; you’ll depreciate this cost straight-line to zero over the project’s life. you estimate that in five years, this equipment can be salvaged for $77,000. your fixed production costs will be $332,000 per year, and your variable production costs should be $11.00 per carton. you also need an initial investment in net working capital of $82,000. if your tax rate is 30 percent and your required return is 11 percent on your investment, what bid price should you submit? (do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))

Beck company had the following accounts and balances at the end of the year. what is net income or net loss for the year? cash $ 74 comma 000 accounts payable $12,000 common stock $21,000 dividends $12,000 operating expenses $ 13 comma 000 accounts receivable $ 49 comma 000 inventory $ 47 comma 000 longminusterm notes payable $33,000 revenues $ 91 comma 000 salaries payable $ 30 comma 000