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.

The table shows the demand and supply schedules for magazines. complete the following sentences. the equilibrium price of a magazine is $ 4 and the equilibrium quantity is 150 magazines a week. price (dollars per magazine) quantity demanded quantity supplied (magazines per week) 3.00 160 138 3.50 155 144 4.00 150 150 4.50 145 156 5.00 140 161 now a fall in the price of a newspaper decreases the quantity demanded by 11 magazines a week at each price. at the original equilibrium price, a occurs. to return to equilibrium, the price of a magazine a. surplus; rises b. shortage; rises c. shortage; falls d. surplus; falls as the market returns to equilibrium, the quantity demanded and the quantity supplied a. decreases; increases b. decreases; decreases c. increases; decreases d. increases; increases the new equilibrium price is $ nothing a magazine.

Suppose that xtel currently is selling at $40 per share. you buy 500 shares using $15,000 of your own money, borrowing the remainder of the purchase price from your broker. the rate on the margin loan is 8%. a. what is the percentage increase in the net worth of your brokerage account if the price of xtel immediately changes to (a) $44; (b) $40; (c) $36? (leave no cells blank - be certain to enter "0" wherever required. negative values should be indicated by a minus sign. round your answers to 2 decimal places.) b. if the maintenance margin is 25%, how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.) c. how would your answer to requirement 2 would change if you had financed the initial purchase with only $10,000 of your own money? (round your answer to 2 decimal places.) d. what is the rate of return on your margined position (assuming again that you invest $15,000 of your own money) if xtel is selling after one year at (a) $44; (b) $40; (c) $36? (negative values should be indicated by a minus sign. round your answers to 2 decimal places.) e. continue to assume that a year has passed. how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.)

Advanced enterprises reports year-end information from 2018 as follows: sales (160,250 units) $968,000 cost of goods sold 641,000 gross margin 327,000 operating expenses 263,000 operating income $64,000 advanced is developing the 2019 budget. in 2019 the company would like to increase selling prices by 14.5%, and as a result expects a decrease in sales volume of 9%. all other operating expenses are expected to remain constant. assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. should advanced increase the selling price in 2019?