Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the current monthly rents by the remaining months on each lease. Use the range names Rents and Leases.

Neon light company of kansas city ships lamps and lighting appliances throughout the country. ms. neon has determined that through the establishment of local collection centers around the country, she can speed up the collection of payments by one and one-half days. furthermore, the cash management department of her bank has indicated to her that she can defer her payments on her accounts by one-half day without affecting suppliers. the bank has a remote disbursement center in florida. a. if neon light company has $2.90 million per day in collections and $1.18 million per day in disbursements, how many dollars will the cash management system free up?

Grey company holds an overdue note receivable of $800,000 plus recorded accrued interest of $64,000. the effective interest rate is 8%. as the result of a court-imposed settlement on december 31, year 3, grey agreed to the following restructuring arrangement: reduced the principal obligation to $600,000.forgave the $64,000 accrued interest.extended the maturity date to december 31, year 5.annual interest of $40,000 is to be paid to grey on december 31, year 4 and year 5. the present value of the interest and principal payments to be received by grey company discounted for two years at 8% is $585,734. grey does not elect the fair value option for reporting the debt modification. on december 31, year 3, grey would recognize a valuation allowance for impaired loans of

Russell's is considering purchasing $697,400 of equipment for a four-year project. the equipment falls in the five-year macrs class with annual percentages of .2, .32, .192, .1152, .1152, and .0576 for years 1 to 6, respectively. at the end of the project the equipment can be sold for an estimated $135,000. the required return is 13.2 percent and the tax rate is 23 percent. what is the amount of the aftertax salvage value of the equipment assuming no bonus depreciation is taken