You are an assistant to Erica Matheson, a mortgage broker at the Townsend Mortgage Company. Erica…


You are an attendant to Erica Matheson, a hypothecation broker at the Townsend Hypothecation Company. Erica spends her days reviewing hypothecation reproves and trends, meeting after a while clients, and preparing paperwork. She relies on your expertise in using Excel to aid criticise hypothecation postulates. Today, Erica supposing you after a while illustration hypothecation postulates: hypothecation estimate, seed absorb, down acquittal, hypothecation rate, and the protraction of the hypothecation in years. She asked you to accomplish some basic calculations so that she can repress the output supposing by her arrangement to verify if it is guarded results appropriately. She wants you to estimate the amount financed, the interrupted concern reprove, the whole estimate of acquittal periods, the percent of the seed absorb that is financed, and the payoff year for each hypothecation. In abstracted, you allure estimate wholes, averages, and other basic statistics. Furthermore, she has asked you to full another worksheet that uses functions to behold up concern reproves from a separeprove consultation, estimate the monthly acquittals, and state how fur (if any) the borrower allure entertain to pay for special hypothecation prophylactic (PMI).