prompt information:
excel sheet to fill out
the data is in the prompt. this is the instructions to help solve the proprations. thanks!
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 62%. 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 buyer's 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 buyer's 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 homeowner's insurance. The first payment on the Clearwater loan will be due on May 1. The buyer is purchasing a three-year homeowner's insurance policy for $990, with the first year's premium (S330) to be prepaid at closing, that will be handled through escrow. This year's 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 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 seller's 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 owner's title insurance policy is $1,080; the premium for the lender's 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 buyer's recording costs will be $35; the seller's recording costs will be $19. Hint: first calculate how the purchase price of $575,000 will be paid. There is a 1" mortgage, a 2nd mortgage and a down payment, of which the good faith deposit is a portion. Nam yellow and any Total tries 32 Possible some of 16 points. 12 point for each corect entry point bons for ping all TOTAL numbers comert Note: Use 300 days Settlement Statement Buyer Seller 1 Debits Credits Debit Credits Purchase Price Deposit Buyer's new hankan Origination for Discount points Appraisal Credit report Document preparation fee Prepaid Interest on new loan Reserve account for new loan Homeowner's ins premium (Ist year) Seller Financing Payoff seller's first loan Prorated interest for seller's first loan Reserve account for seller's first loan Payoff of seller's home equity loan Prorated interest for seller's equity loan Property taxes Sales commission: listing broker Sales commission selling broker Documentary transfertas Owner's title insurance Lander's title insurance Pest inspection Escrow fee Recording fee Balance due from buyer Balance due to seller TOTAL 0.00 000 $0.00 $0.00 $0.00 these numbers mu ch these numbers musta these are amounts charged to buyer there are amount paid to buyer these are amounts charged to seller there are puid teller hargers in com B, C, D and E PROPRATIONS STEPS: 1. Find the amount to be prorated 2. Convert it to an annual amount 3. Calculate the "per diem rate by dividing by 360 (use 4 decimal points) (Note: in real life you would use 365 days) 4. If prorating a monthly amount use 30 days for all months 5. Determine the number of days applicable to each party a. When counting days within a month use a 30 day month b. The buyer pays for the closing date 6. Multiply the per diem rate by the number of days to determine the amount 7. Determine whether it is a debit or credit to which party 8. Enter the amount into the appropriate cell DO NOT enter information into a cell that is not yellow or gray. Special situations: Mortgage interest is paid in arrears Mortgage principal is paid in advance Rents are paid in advance Property taxes are paid on a fiscal year basis 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 62%. 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 buyer's 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 buyer's 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 homeowner's insurance. The first payment on the Clearwater loan will be due on May 1. The buyer is purchasing a three-year homeowner's insurance policy for $990, with the first year's premium (S330) to be prepaid at closing, that will be handled through escrow. This year's 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 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 seller's 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 owner's title insurance policy is $1,080; the premium for the lender's 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 buyer's recording costs will be $35; the seller's recording costs will be $19. Hint: first calculate how the purchase price of $575,000 will be paid. There is a 1" mortgage, a 2nd mortgage and a down payment, of which the good faith deposit is a portion. Nam yellow and any Total tries 32 Possible some of 16 points. 12 point for each corect entry point bons for ping all TOTAL numbers comert Note: Use 300 days Settlement Statement Buyer Seller 1 Debits Credits Debit Credits Purchase Price Deposit Buyer's new hankan Origination for Discount points Appraisal Credit report Document preparation fee Prepaid Interest on new loan Reserve account for new loan Homeowner's ins premium (Ist year) Seller Financing Payoff seller's first loan Prorated interest for seller's first loan Reserve account for seller's first loan Payoff of seller's home equity loan Prorated interest for seller's equity loan Property taxes Sales commission: listing broker Sales commission selling broker Documentary transfertas Owner's title insurance Lander's title insurance Pest inspection Escrow fee Recording fee Balance due from buyer Balance due to seller TOTAL 0.00 000 $0.00 $0.00 $0.00 these numbers mu ch these numbers musta these are amounts charged to buyer there are amount paid to buyer these are amounts charged to seller there are puid teller hargers in com B, C, D and E PROPRATIONS STEPS: 1. Find the amount to be prorated 2. Convert it to an annual amount 3. Calculate the "per diem rate by dividing by 360 (use 4 decimal points) (Note: in real life you would use 365 days) 4. If prorating a monthly amount use 30 days for all months 5. Determine the number of days applicable to each party a. When counting days within a month use a 30 day month b. The buyer pays for the closing date 6. Multiply the per diem rate by the number of days to determine the amount 7. Determine whether it is a debit or credit to which party 8. Enter the amount into the appropriate cell DO NOT enter information into a cell that is not yellow or gray. Special situations: Mortgage interest is paid in arrears Mortgage principal is paid in advance Rents are paid in advance Property taxes are paid on a fiscal year basis
