Exp25_Excel_Ch02_HOE - Townsend Mortgage Company | Textbook Assignments | Complete Solution

Exp25_Excel_Ch02_HOE - Townsend Mortgage Company | Textbook Assignments | Complete Solution

Contact us:

WhatsApp: +92 3419083851
Email: myitlab34@gmail.com

WhatsApp Direct link for Chat:
http://bit.ly/3V3fR2G

Exp25_Excel_Ch02_HOE - Townsend Mortgage Company

Project Description:
You are an assistant to Yui Matheson, a mortgage broker at the Townsend Mortgage Company. Yui spends days reviewing mortgage rates and trends, meeting with clients, and preparing paperwork. Yui relies on your expertise in using Excel to help analyze mortgage data. Today, Yui provided you with sample mortgage data: loan number, house cost, down payment, mortgage rate, and the length of the loan in years. She asked you to perform some basic calculations so that the output provided by her system can be checked to verify that it is calculating results correctly. You have also been tasked with calculating the amount financed, the periodic interest rate, the total number of payment periods, the percentage of the house cost financed, and the payoff year for each loan. In addition, you will calculate totals, averages, and other basic statistics. Furthermore, Yui asked you to complete another worksheet that uses functions to look up interest rates from a separate table, calculate the monthly payments, and determine how much (if any) the borrower will have to pay for private mortgage insurance (PMI).

Steps to Perform:
Step Instructions Points Possible
1 Complete Hands-On Exercise Step 2.1.1a in the eText. 0
2 Complete Hands-On Exercise Step 2.1.1b-g in the eText. 8
3 Complete Hands-On Exercise Step 2.1.2a-g in the eText. 8
4 Complete Hands-On Exercise Step 2.1.3a-f in the eText. 8
5 Complete Hands-On Exercise Step 2.2.1a-f in the eText. 4
6 Complete Hands-On Exercise Step 2.2.2a-d in the eText. 4
7 Complete Hands-On Exercise Step 2.2.3a-e in the eText. 4
8 Complete Hands-On Exercise Step 2.2.4a-g in the eText.
24
9 Complete Hands-On Exercise Step 2.2.5a-d in the eText. 10
10 Complete Hands-On Exercise Step 2.3.1a-k in the eText.
10
11 Complete Hands-On Exercise Step 2.3.2a-h in the eText. 10
12 Complete Hands-On Exercise Step 2.3.3a-g in the eText. 10