For the last piece of this project, you will prepare a HUD-1

For the last piece of this project, you will prepare a HUD-1.
For the last piece of this project, you will prepare a HUD-1 Settlement Sheet. Do not use an official form. Use only the Excel workbook thatis provided. Excel is used, as all students have access to it in theirMS Office program provided by Rasmussen. It also allows you to reviewformulas and use them to create automatic totaling and subtotaling. TheHud-1 direction link is provided for your information, to comprehendwhat you are doing. You will be making changes to the Hud-1 A K page(sheet) and the L page (sheet) only. There is another page in some Hud-1sheets for estimates, but you are not using that extra page. In a lawoffice, you may need to retype your results onto an Adobe pdf file, butdo not do that for this project, please. You will change some costs in sheet L, add some amounts in Jand K and type in some formulas in J and K. After the changes, youshould see all the correct totals and subtotals. You will fill ingeneral information in A I. Here is the link to the Excel sheet you use:StudentAssignmentversion_of_Module08RealEstateProject_Excel_Hud1 Additional information about HUD-1 settlement statements can be found here:Official Instructions Prepare the settlement statement with the following information: Do L first. You need those numbers to complete parts J and K. The borrower amounts to pay in L will be typed on the secondcolumn from the left and the seller amounts to pay will be typed on thefar right column. In an Excel sheet, use column B for borrower amountsand totals and C for seller amounts and totals. Carefully distinguish between Excel numbering (B12, B15) fromthe Hud-1 numbering, 801 in the borrower s column and 804 in theborrower s column. Using Excel makes it easier to pinpoint where totype, but of course you should also familiarize yourself with the Hud-1system. Part L: Settlement ChargesChange B12 to $250. (Note that Excel sheet cell B12 is in row 801 in the borrower s column in the Hud-1 form)Change B15 to $375. (Excel cell B15 is in row 804 in the borrower s column)Change B31 to $3,000 (1003 borrower s column)Change B50 to $110 (1202 borrower s column)Change C53 to $250 (1205 seller s column)Part J: Summary of Borrower s Transaction (fill in only what is given here)The columns used are different. You are now using C for borrower s amounts. Excel sheet C49, borrower column #211: Type $2,000 for real estate tax adjustment.Excel sheet C58 #220: Type this formula in the cell =SUM(C38:C57)#301: This will be the same as 120#302: This will be the same as 220Excel sheet C62 #303: Type this formula in the cell =SUM(C60-C61)Your total for C62 #303 should be $1,835 If it is not,recheck all your formulas and changes to dollar amounts. You arerequired to use formulas, not just type in totals and subtotals. Part K: Summary of Seller s Transaction. You are using Excel column I for seller s amounts.Excel sheet I49 #511: Type $2,000 for real estate tax adjustment. #520: Add up lines 501-519 Type this formula in the cell =SUM(I38:I57, )#601: This will be the same as line 420#602: This will be the same as line 520Excel sheet I62 #603: Type in this formula: =SUM(I60-I61)Your total for I62 #603 should be $197,750. If that isnot what you got, check your formulas and changes to dollaramounts. You are required to use formulas, not just type intotals and subtotals. A. I:Number 1: This is a conventional loan (Conv. Ins.).Numbers 6-8: Do not worry about the file number, loan number or mortgage insurance case number.Part D Borrower: You are the borrower.Part E Sellers: Dudley J. and Jayne M. Smith, 1987 Ford Street, your city or town, your state your zip codePart F Lender: First Star State Bank, 973 Main Street, (your city or town), (your state) (your zip code)Part G: Address of propertyPart H: First Star State Bank Place of settlement is their locationPart I: Today s date
For the last piece of this project, you will prepare a HUD-1