Question
Using Excel (no handwritten forms) fill out the settlement statement form for the transaction described below. The various closing costs will be allocated between the
Using 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. The
offer that the seller accepts is accompanied by a $10,000 good faith deposit. The purchase
agreement calls for the buyer to make a 10% down payment and obtain an 80%, 30-year
conventional loan with an annual interest rate not to exceed 6%.
The seller agrees to accept a five-year straight note secured by a deed of trust for the balance of the purchase price; the interest rate on this seller second will be 8%. The seller will also pay up to $4,000 toward any discount points charged by the buyers lender. The closing is to take place on March 14.
The buyer obtains the necessary loan commitment from Clearwater Bank. The appraised value
of the property is $580,000. The terms of the commitment include an 80% loan for 30 years
at 6% annual interest, a 1% origination fee, and two discount points. (Remember that the
seller has agreed to pay for a portion of the discount points.)
The appraisal fee is $400, the credit report costs $45, and the bank is charging a $200 document preparation fee. Prepaid interest on the buyers loan will also have to be paid at closing, to cover interest accruing from the closing date through the end of the month.
At closing, Clearwater Bank will require a reserve account deposit of $742.20, which is enough
to cover three months worth of property taxes and homeowners insurance. The first payment
on the Clearwater loan will be due on May 1.
The buyer is purchasing a three-year homeowners insurance policy for $990, with the first
years premium ($330) to be prepaid at closing; that will be handled through escrow. This years
property taxes are $2,640. The seller has paid the first installment, but not the second.
Liens against the property that the seller will pay off at closing include a first deed of trust that
will have a balance of $398,571.47 after the March 1 payment is made, and a home equity
loan that will have a balance of $13,425.35 after the March 1 payment is made.
The first lienholder instructs the escrow officer to collect prorated interest, if any, equal to $48.21 per day. The home equity lender advises the escrow officer that $3.14 in interest per day will be due on the home improvement loan. Interest on both loans will be charged up to and including the day of closing. The balance in the sellers reserve account for the first loan, $251.50, will be refunded at closing.
The 6% brokerage commission is to be shared 50/50 between the listing broker and the
selling broker; the documentary transfer tax is 55 cents per $500 of value; the premium for
the owners title insurance policy is $1,080; the premium for the lenders title policy is $365;
the pest inspection fee is $230, and the buyer has agreed to pay that; and the escrow fee, to
be divided evenly between the parties, is $600. The buyers recording costs will be $35; the
sellers recording costs will be $19.
CAN I PLEASE GET FORMULAS FOR THE ENTRIES THAT ARE quoted as "need this" . NUMBERS DO NOT HELP, I NEED THE FORMULAS AS WELL. thanks :)
Buyer | Seller | |||
Debits | Credits | Debits | Credits | |
Purchase Price | 575,000.00 | 575,000.00 | ||
Deposit | 10,000.00 | |||
Buyer's new bank loan | need this | |||
Origination fee | need this | |||
Discount points | need this | 4,000.00 | ||
Appraisal | 400.00 | |||
Credit report | 45.00 | |||
Document preparation fee | 200.00 | |||
Prepaid Interest on new loan | need this | |||
Reserve account for new loan | 742.20 | |||
Homeowner's ins. premium (1st year) | 330.00 | |||
Seller Financing | need this | need this | ||
Payoff seller's first loan | 398,571.47 | |||
Prorated interest for seller's first loan | need this | |||
Reserve account for seller's first loan | 251.50 | |||
Payoff of seller's home equity loan | 13,425.35 | |||
Prorated interest for seller's equity loan | need this | |||
Property taxes | need this | |||
Sales commission: listing broker | need this | |||
Sales commission: selling broker | need this | |||
Documentary transfer tax | need this | |||
Owner's title insurance | 1,080.00 | |||
Lender's title insurance | 365.00 | |||
Pest inspection | 230.00 | |||
Escrow fee | 300.00 | 0.00 | ||
Recording fee | 35.00 | 39.00 | ||
Balance due from buyer | 567,647.20 | |||
Balance due to seller | 158,135.68 | |||
TOTAL | $577,647.20 | $577,647.20 | $575,251.50 | $575,251.50 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started