Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Explain the factors that determine the degree of decentralisation

Answered: 1 week ago

Question

What Is acidity?

Answered: 1 week ago

Question

Explain the principles of delegation

Answered: 1 week ago

Question

State the importance of motivation

Answered: 1 week ago

Question

Discuss the various steps involved in the process of planning

Answered: 1 week ago