On the cities worksheet, click cell e13. depending on the city, you will either take a shuttle to/from the airport or rent a car. insert an if function that compares to see if yes or no is located in the rental car? column for a city. if the city contains no, display the value in cell f2. if the city contains yes, display the value in the rental car total (f4). copy the function from cell e13 and use the paste formulas option to copy the function to the range e14: e18 without removing the border in cell e18.

Cash flows during the first year of operations for the harman-kardon consulting company were as follows: cash collected from customers, $360,000; cash paid for rent, $44,000; cash paid to employees for services rendered during the year, $124,000; cash paid for utilities, $54,000.in addition, you determine that customers owed the company $64,000 at the end of the year and no bad debts were anticipated. also, the company owed the gas and electric company $2,400 at year-end, and the rent payment was for a two-year period.calculate accrual net income for the year.