((EXCEL)) I am having a hard time figuring out the correct formula to this question. If anyone could help out, I'd really appreciate it! Brett assigns each client a rating of A, B, or C depending on the number of days an invoice is overdue. Display this information using a nested IF function as follows:
In cell I6, insert a formula using an IF function to test whether the days overdue (cell G6) are less than 1 and displays a rating of "A" if the condition is true.
The next condition uses another IF function to test whether the days overdue (cell G6) are less than 30 and displays a rating of "B" if the condition is true.
Display a rating of "C" if the conditions are false.
Use the Fill Handle to fill the range I7:I15 with the formula in cell I6, filling the range without formatting.

Telecom co. enters into a two-year contract with a customer to provide wireless service (voice and data) for $40 per month. to induce customers, telecom co. provides a free phone. telecom co. normally sells the phone on a stand-alone basis for $200. telecom co. also charges the customer a one-time activation fee of $35.which of the following is true? a) there are two distinct performance obligations: the voice service and the data service b) the free phone constitutes as a marketing expense c) the activation fee is a separate performance obligationd) there are two distinct performance obligations: the wireless services and the phone

What is considered to be a significant disadvantage of owning

Benning manufacturing company is negotiating with a customer for the lease of a large machine manufactured by benning. the machine has a cash price of $980,000. benning wants to be reimbursed for financing the machine at a 9% annual interest rate. (fv of $1, pv of $1, fva of $1, pva of $1, fvad of $1 and pvad of $1) (use appropriate factor(s) from the tables provided.) required: 1. determine the required lease payment if the lease agreement calls for 10 equal annual payments beginning immediately. 2. determine the required lease payment if the first of 10 annual payments will be made one year from the date of the agreement. 3. determine the required lease payment if the first of 10 annual payments will be made immediately and benning will be able to sell the machine to another customer for $68,000 at the end of the 10-year lease.