Use the drop-down menu to complete the steps for using the Goal Seek feature. 1. Go to the
Formulas
tab.

2. In the
group, select
from the drop-down What-If Analysis menu.

3. Specify the cell that contains the formula to solve and enter the desired result.

4. Specify the
that contains the value to adjust.

5. Click OK.

Amanda rice has just arranged to purchase a $640,000 vacation home in the bahamas with a 20 percent down payment. the mortgage has a 7 percent apr compounded monthly and calls for equal monthly payments over the next 30 years. her first payment will be due one month from now. however, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of year 8. there were no other transaction costs or finance charges. how much will amanda’s balloon payment be in eight years

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:

Richardson hired j. c. flood company, a plumbing contractor, to correct a stoppage in the sewer line of her house. the plumbing company's 'snake' device, used to clear the line leading to the main sewer, became caught in the underground line. to release it, the company excavated a portion of the sewer line in richardson's backyard. in the process, the company discovered numerous leaks in a rusty, defective water pipe that ran parallel with the sewer line. to meet public regulations, the water pipe, of a type no longer approved for such service, had to be replaced either then or later, when the yard would have to be excavated again. the plumbing company proceeded to repair the water pipe. though richardson inspected the company's work daily and did not express any objection to the extra work involved in replacing the water pipe, she refused to pay any part of the total bill after the company completed the entire operation. j. c. flood company then sued richardson for the costs of labor and material it had furnished. (c) for what, if anything, should richardson be liable? explain."