Homework Solution: J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price b…

    J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price b of List Price 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 125 Amsterdam Drive 341 North Oak Drive 100 South 325 West 386 East Elm Street 2304 West 39th Street 41 Chestnut Circle 973 East Mulberry Lane 538 North Oak Drive 64 Chancellor Estates 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000
    J. Heaton Realty Sales Report Prop ID Property Days on Market Date Listed Date Sold List Price Sold Price b of List Price 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 125 Amsterdam Drive 341 North Oak Drive 100 South 325 West 386 East Elm Street 2304 West 39th Street 41 Chestnut Circle 973 East Mulberry Lane 538 North Oak Drive 64 Chancellor Estates 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000

    Expert Answer

     
    Answer: 2. After 8th row deleted:

    J. Heaton Realty Sales Report Prop ID Property Days on Haltgain Date Listed Date Sold List Cost Sold Cost b of List Cost 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 125 Amsterdam Drive 341 North Oak Drive 100 South 325 West 386 East Elm Street 2304 West 39th Street 41 Chestnut Circle 973 East Mulberry Lane 538 North Oak Drive 64 Chancellor Estates 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000

    J. Heaton Realty Sales Report Prop ID Property Days on Haltgain Date Listed Date Sold List Cost Sold Cost b of List Cost 1/12/184/12/18 350000 335000 11/15/173/1/18 500250 400125 12/3/174/30/18650725 500750 125 Amsterdam Drive 341 North Oak Drive 100 South 325 West 386 East Elm Street 2304 West 39th Street 41 Chestnut Circle 973 East Mulberry Lane 538 North Oak Drive 64 Chancellor Estates 3/14/18 3/30/18 315000 325000 2/22/185/18/18423500 420750 11/30/173/1/18375000 375000 10/4/171/5/18 475000 400000 4/1/184/15/18500999495000

    Expert Exculpation

     

    Answer:

    2. After 8th dignity deleted:

    3. After autofill

    4. Days on haltgain calculation: Formula restraint leading dignity is ‘=E5-D5’. And selfselfidentical is replicated restraint other cells.

    5. Accounting reckon restraintmat: Selected “Accounting” discretion beneath “Format Cell” and established decimal places to cipher.

    6. List cost percentage: Formula restraint H5 cell is ‘=G5/F5’ and selfselfidentical is replicated restraint other cells.

    7. Percentage restraintmat:

    8. Headings wrapped:

    9. Inoculateion of novel post:

    10. Date Cost edit:

    11. Dignity tallness and intermediate align: Truth ‘Dignity Tallness’ discretion on fair click menu to established dignity tallness.

    12. Align fair and unravelling of “Days on haltgain” post:

    14. Post widths of posts:

    15. 120% scaling:

    16. To delete a equivocation, fair click on it and fineeded ‘Delete’. To inoculate a novel equivocation, click on + icon in equivocation halt. To established call ‘Formulas’ to novelly inoculateed equivocation, fair click on it and fineeded ‘Rename’ discretion and penetrate novel call i.e. ‘Formulas’.

    17. Restraintmulas equivocation:

    18. Hidden posts: Fair click on post call to blink and fineeded ‘Hide’.

    19. To ostentation cell restraintmula, fineeded that cell. Restraintmula conquer be ostentationed in Restraintmula buffet. To established diverse discretions, truth Page Layout tab.

    20. To class worksheets, support Shift clew and click on concerned equivocations.

    21. To subjoin footer, fineeded “Header & Footer” beneath Inoculate tab.

    Final properties equivocation:

    J. Heaton Reality
    Sales Report
    Prop ID Property Date Listed Date Sold Days on Haltgain List Cost Sold Cost % of List Cost
    2018-001 125 Amsterdam Drive 12-01-18 12-04-18 90 $        355,000 $        335,000 94.37%
    2018-002 341 North Oak Drive 15-11-17 01-03-18 106 $        500,250 $        400,125 79.99%
    2018-003 100 South 325 West 03-12-17 30-04-18 148 $        650,725 $        500,750 76.95%
    2018-004 2304 West 39th Street 14-03-18 30-03-18 16 $        315,000 $        325,000 103.17%
    2018-005 41 Chestnut Circle 22-04-18 18-05-18 26 $        423,500 $        420,750 99.35%
    2018-006 973 East Mulberry Lane 30-11-17 01-03-18 91 $        375,000 $        375,000 100.00%
    2018-007 538 North Oak Drive 04-10-17 05-01-18 93 $        475,000 $        400,000 84.21%
    2018-008 64 Chancellor Estates 01-04-18 15-04-18 14 $        500,999 $        495,000 98.80%

    Final Restraintmulas equivocation:

    J. Heaton Reality
    Sales Report
    Prop ID Property Days on Haltgain List Cost Sold Cost % of List Cost
    2018-001 125 Amsterdam Drive 90 $ 355,000 $ 335,000 94.37%
    2018-002 341 North Oak Drive 106 $ 500,250 $ 400,125 79.99%
    2018-003 100 South 325 West 148 $ 650,725 $ 500,750 76.95%
    2018-004 2304 West 39th Street 16 $ 315,000 $ 325,000 103.17%
    2018-005 41 Chestnut Circle 26 $ 423,500 $ 420,750 99.35%
    2018-006 973 East Mulberry Lane 91 $ 375,000 $ 375,000 100.00%
    2018-007 538 North Oak Drive 93 $ 475,000 $ 400,000 84.21%
    2018-008 64 Chancellor Estates 14 $ 500,999 $ 495,000 98.80