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
Analyze organizational processes as well as procedures in a variety of business settings. For the second part, presume that you are either using offshore manufacturing or have
Suppose consumer spending responds more to changes in income in a downturn than in an expansion. Would this make the size of the multiplier in a downturn equal to, larger t
After a troublesome time with a new manager, an employee who had always had highly positive reviews returned from vacation to find that her desk had been cleared out, all of
Describe an element of organizational culture - either from your current place of employment, a previous place of employment, or from an organization with which you are fami
Analysis based on the attached case study titled, China and Russia Are Snubbing American Chicken, New York Times (2011). Your analysis will include responses to the following
In approximately 2-3 pages utilizing access to annual reports, describe FED EX's overview including its business, Market position, size, relevance, history and prospects.
Research how qualitative research is used in your field. Write an essay that describes how qualitative research tools can be used to aid in decision making within your field
Why is it necessary for Disney to build brand awareness in China and other emerging markets? Do you agree with Disney's decision to pursue a localization approach in emerging