Determine the required down payment percentage and apr
Course:- Business Management
Reference No.:- EM13768897

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Business Management

Project Description

As a financial consultant, you work with people who are planning to buy a new house. You want to create a worksheet containing variable data (the price of the house, down payment, date of the first payment, and borrower's credit rating) and constants (property tax rate, years, and number of payments in one year). Borrowers pay 0.5% private mortgage insurance (PMI) of the loan amount if they do not make at least a 20% down payment. A borrower's credit rating determines the required down payment percentage and APR. For example, a person with an excellent credit rating may make only a 5% down payment with a 3.25% APR loan. A per-son with a fair credit rating will make a 15% down payment and have a higher APR at 5.25%. Your worksheet needs to perform various calculations. The filled cells in column F indicate cells containing formulas, not values.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Business Management) Materials
The Foley Company, a manufacturer of soybean harvesters, has for years sold a substantial number of machine sin Brazil. However, a Brazilian firm has begun to manufacture th
If exported from the US, would the recommended products and services require adaptation to the local market - Would producing the product locally made the product or service m
For connecting modem a computer, a computer must be equipped with a port that conforms to the RR-32 standard of the electronic industries association of America. What do the
What benefits can be expected by your company if small businesses are considered in the subcontract solicitation process? To what extent will adding these requirements mean a
a. What is the goal of cash management and why do firms hold cash? b. What is meant by the terms precautionary and speculative balances? c. What are some specific advantages f
1. Consider the role of culture when motivating employees. Describe some differences that can gain employee trust in at least three countries. Each country should be located
Think of writing this research essay as participating a debate.  You are required to choose one (1) of the following three statements (Topics 1, 2 or 3) and argue either in
1. How can ?rms maximize the opportunities offered when foreign governments act as facilitators of involvement? 2. How can ?rms minimize the inconvenience to their inte