Real Estate Assignment

Anonymous
timer Asked: Oct 10th, 2018
account_balance_wallet $10

Question Description

The time has come for you to purchase a home. After years of saving you are ready to find the home of your dreams. You have a down payment and now wish to develop an amortization schedule so you can plan your payments. Interest rates are low but may soon be rising. Because you are not sure how long it will take to find just the right home, you wish to examine several different payment plans. You hope to pay off the loan in 20 years.

Develop a worksheet that will show the monthly payment as well as the beginning balance for each year of the loan, the ending balance each year of the loan, the annual cost of the loan, and the annual interest paid for each year of the loan.

Choose a home from www.riliving.com. Enter in the price of the home and what you will be paying for the home. Insert a picture of your home on your spreadsheet.

Unformatted Attachment Preview

The time has come for you to purchase a home. After years of saving you are ready to find the home of your dreams. You have a down payment and now wish to develop an amortization schedule so you can plan your payments. Interest rates are low but may soon be rising. Because you are not sure how long it will take to find just the right home, you wish to examine several different payment plans. You hope to pay off the loan in 20 years. Develop a worksheet that will show the monthly payment as well as the beginning balance for each year of the loan, the ending balance each year of the loan, the annual cost of the loan, and the annual interest paid for each year of the loan. Choose a home from www.riliving.com. Enter in the price of the home and what you will be paying for the home. Insert a picture of your home on your spreadsheet. Perform the following tasks: 1. Enter the worksheet title, Home Loan Schedule, in cell A1. Merge and center cell A1 across the range A1:E1. Change the font type to Bookman Old Style, the font color to red, and the background to yellow. 2. Enter the following labels: B2 = Principal; B3 = Rate; B4 = Years; B5 = Payment; D5 = per month; A6 = Year; B6 = Beginning Balance; C6 = Ending Balance; D6 = Total Paid; E6 = Interest. Change the font color to blue, except for cell D5. 3. Enter the =Now() function in cell E2 to display the current date and format as illustrated in Figure E4A-1. 4. Enter the principal amount of your home (What you paid for it) in cell C2. Format to currency format with no decimal places. 5. Enter the interest rate that you obtained based on your credit score (explain)in cell C3. 6. Enter the number of years you got your loan for in cell C4 for the number of years. 7. Enter the function =PMT in cell C5 to calculate the monthly payment on a loan of 450,000 (cell C2) at 7.2% (cell C3) for 20 years (cell C4). Use the fill handle to fill the range A7:A26 with the numbers 1 - 20. 8. 9. Enter the formula =C2 in cell B7 to reference the principal, which is the beginning balance for year 1. Enter =C7 in B8 10. Enter the =PV function in cell C7 to determine the ending balance for year 1. The formula is =PV($C$3/12,12*($C$4-A7),-$C$5) autofill the range from B8 straight down to number of years. Autofill the row straight down in row C. 11. Enter the formula =$C$5 * 12 in cell D7 to determine the annual amount paid on the loan. 12. Enter the formula = D7 - (B7 - C7) in cell E7 to calculate the amount of interest paid for the year. 13. Copy the =PV function entered in cell C7 to the range C8:C26. 14. Copy the formula in cell D7 to the range D8:D26. 15. Copy the formula in cell E7 to the range E8:E26. If all is done properly, the value in cell 20 should be zero. 16. Use the =SUM function in cells D27 and E27 to sum the payment and interest amounts. 17. Format all cells with designs of your choice. 18. Enter your name in cell A40. In the cells directly beneath your name, enter your course identification, computer lab assignment (Lab Test A – Excel Project 4), date, and instructor name. 19. Rename the Sheet 1 tab to Home Loan. 20. Save the workbook using the file name Yourname - Excel Project 4 - Lab Test A, where Yourname is your last name. 21. Upload the sheet to ULEARN and Present to your Class Next week. ...
Purchase answer to see full attachment

Tutor Answer

SkilledTutorZiss
School: Carnegie Mellon University

Hey, buddy. please do the following18. Enter your name in cell A40.In...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors