HW 4 Baker Street Settlement Statement F19.docx - HW 4 \u2013 Fall 2019 Baker Street Settlement Statement Using Excel(no handwritten forms fill out the

HW 4 Baker Street Settlement Statement F19.docx - HW 4...

This preview shows page 1 - 2 out of 2 pages.

HW 4 – Fall 2019 Baker Street Settlement StatementUsing Excel (no handwritten forms) fill out the settlement statement form for the transaction described below. The various closing costs will be allocated between the parties in the customary way unless otherwise noted. Use a 360-day year and 30-day month for your prorations. Round dollar amounts to four decimal places for each step in your calculations. (Digits from 1 through 4 should be rounded down; digits from 5 through 9 should be rounded up.) DO NOT change anything else in the worksheet. DO NOT fiil in any white cells. The gray cells require formulas, and the yellow cells require numbers provided in the case.The house at 314 Baker Street, in Los Angeles County, sells on January 28 for $575,000. Theoffer that the seller accepts is accompanied by a $10,000 good faith deposit. The purchaseagreement calls for the buyer to make a 10% down payment and obtain an 80%, 30-yearconventional loan with an annual interest rate not to exceed 6½%.
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '11
  • Staff

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture