Select cell F9 and use Goal Seek Analysis to determine the loan amount in the Aggressive Expansion scenario based on a monthly payment of $12,000. In the Goal Seek calculations, set the value of cell F9 to -12,000 and select cell F4 (Total Loan Amount) as the changing cell. Keep the outcome of the Goal Seek Analysis as the value of cell F4.

John is a 45-year-old manager who enjoys playing basketball in his spare time with his teenage sons and their friends. at work he finds that he is better able to solve problems that come up because of his many years of experience, but while on the court, he finds he is not as good keeping track of the ball while worrying about the other players. john's experience is:

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

Bakery has bought 250 pounds of muffin dough. they want to make waffles or muffins in half-dozen packs out of it. half a dozen of muffins requires 1 lb of dough and a pack of waffles uses 3/4 lb of dough. it take bakers 6 minutes to make a half-dozen of waffles and 3 minutes to make a half-dozen of muffins. their profit will be $1.50 on each pack of waffles and $2.00 on each pack of muffins. how many of each should they make to maximize profit, if they have just 20 hours to do everything?