Please answer!!!!!!!!!!!!!!!

A B C D E F G Input Area Output Area 2 Sale Price $ 300,000.00 Sale Price $ 300,000.00 3 Realtor Commision Rate 6% Commission $ 300,000.06 4 Closing Costs Rate 7% Closing Costs 18,000.00 5 Annual Property Taxes $ 2,000.00 Title Policy Insurance 950.00 6 Months to Prorate Taxes 6 Prorated Property Taxes 12,000.00 7 Months in a Year 12 Est Existing Mortgage Payoff 100000 Est Existing Mortgage Payoff $ 100,000.00 Total Est Deductions 430,950.06 9 Estimated Net Proceeds $ 730,950.06A B C D E F G H J. Heaton Realty 2 Sales Report WU Property Days on Market Date Listed Date Sold List Price Sold Price & of List Price 5 125 Amsterdam Drive 2016-01-12 350000 335000 6 341 North Oak Drive 2015-11-15 500250 400125 7 50 Macaw Crescent 2015-12-03 650725 500750 386 East Elm Street 2016-03-01 9 122 Saline Creek Way 2016-03-14 315000 325000 10 41 Chestnut Circle 2016-02-22 423500 420750 11 973 East Mulberry Lane 2015-11-30 375000 375000 12 538 North Oak Drive 2015-10-04 475000 400000 13 64 Chancellor Estates 2016-04-01 500999 495000 14 15A B C D 1 Royalty Statement N 3 Period Ending: 4 Author: Jacobs 5 6 Hardback Paperback 7 Units Sold Gross Units Sold 1500 12492 9 No. of Returns 324 200 10 Percent Returned 11 12 Pricing 13 Retail Price 25 5.95 14 Price to Bookstore 15 Net Retail Sales 16 17 Royalty Information 18 Royalty Rates D.0725 0.1 19 Royalty to Author 20 Royalty per Book 21A B C D E F G H Ashley's Tip Distribution Tuesday, March 1, 2016 11:00 a.m. - 1:30 p.m. Customer Subtotal and Tip Tip Rates Tip Amounts Customer Food Drinks Tip Left Total Recei Bartender Assistant Bartender Assistant My Net Tip W N H 35 6.75 E 42.5 8.45 10 100.18 10.25 25 10 38.75 6.75 7 11 51.37 8.45 12 12 16.25 5.25 3.5 13 12.95 6.75 14 65.81 8.45 14 15 112.45 25.25 30 16 10 35.13 6.75 17 11 62.1 12.95 14 18 12 84.34 12.95 20 19 13 12.25 20 14 25.45 6.75 5.5 21 15 75.12 13.5 20 22 16 40.44 10.25 8.85 23 17 13.87 2 24 18 24.75 3.5 6 25 19 67.33 9.75 15 26 20 42.44 6.75 12 27 28 Notes: (1) The bartender gets a 15%% tip based on the total drink order for each customer. 29 (2) The server assistant gets 10% of the total tip left by the customer. 310