((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.

Renaldo scanlon is a financial consultant. he earns $30 per hour and works 32.5 hours a week. what is his straight-time pay?

The struter partnership has total partners’ equity of $510,000, which is made up of main, capital, $400,000, and frist, capital, $110,000. the partners share net income and loss in a ratio of 80% to main and 20% to frist. on november 1, adison is admitted to the partnership and given a 15% interest in equity and a 15% share in any income and loss. prepare journal entries to record the admission of adison for a 15% interest in the equity and a 15% share in any income and loss under the following independent assumptions. (1) record the admission of adison with an investment of $90,000 for a 15% interest in the equity and a 15% share in any income and loss. (2) record the admission of adison with an investment of $120,000 for a 15% interest in the equity and a 15% share in any income and loss. (3) record the admission of adison with an investment of $80,000 for a 15% interest in the equity and a 15% share in any income and loss.

Verizon communications, inc., provides the following footnote relating to its leasing activities in its 10-k report. the aggregate minimum rental commitments under noncancelable leases for the periods shown at december 31, 2010, are as follows: years (dollars in millions) capital leases operatingleases 2011 $97 $1,898 2012 74 1,720 2013 70 1,471 2014 54 1,255 2015 42 1,012 thereafter 81 5,277 total minimum 418 $ 12,633 rental commitments less interest and (86) executory costs present value of 332 minimum lease payments less current (75) installments long-term obligation $257 at december 31, 2010 (a) confirm that verizon capitalized its capital leases using a rate of 7.4 %. (b) compute the present value of verizon's operating leases, assuming an 7.4% discount rate and rounding the remaining lease term to 3 decimal places. (use a financial calculator or excel to compute. do not round until your final answers. round each answer to the nearest whole number.)