Name Date FINANCE 365 - FALL 2023 HOMEWORK 4 - SETTLEMENT STATEMENT SEND EXCEL WORKSHEET (not...

Transcribed Image Text:

Name Date FINANCE 365 - FALL 2023 HOMEWORK 4 - SETTLEMENT STATEMENT SEND EXCEL WORKSHEET (not a pdf) TO KMATTES@SFSU.EDU yellow hard entry grey use formula Total entries 32. Possible score of 16 points - 1/2 point for each correct entry. 5 point bonus for getting all TOTAL numbers correct. Note: Use 30/360 days Settlement Statement Buyer Seller Debits Credits Debits Credits Purchase Price Deposit Buyer's new bank loan Loan Origination fee Loan Discount points Appraisal Cost Credit report Document preparation fee Prepaid Interest on new loan Reserve account for new loan Homeowner's Ins. premium (1st year) Seller Carryback 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 transfer tax Owner's title insurance Lender's title insurance Pest inspection Escrow fee Recording fee Balance due from buyer Balance due to seller TOTAL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 these numbers must match these numbers must match Name Date FINANCE 365 - FALL 2023 HOMEWORK 4 - SETTLEMENT STATEMENT SEND EXCEL WORKSHEET (not a pdf) TO KMATTES@SFSU.EDU yellow hard entry grey use formula Total entries 32. Possible score of 16 points - 1/2 point for each correct entry. 5 point bonus for getting all TOTAL numbers correct. Note: Use 30/360 days Settlement Statement Buyer Seller Debits Credits Debits Credits Purchase Price Deposit Buyer's new bank loan Loan Origination fee Loan Discount points Appraisal Cost Credit report Document preparation fee Prepaid Interest on new loan Reserve account for new loan Homeowner's Ins. premium (1st year) Seller Carryback 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 transfer tax Owner's title insurance Lender's title insurance Pest inspection Escrow fee Recording fee Balance due from buyer Balance due to seller TOTAL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 these numbers must match these numbers must match